About the Course

This Power BI training course lets you master the Microsoft Power BI tool. We provide the best training classes to help you learn Power BI architecture, Desktop, Service, and Visualize the Reports and deriving business insights. As part of this program, you will work on real world projects. Today all business enterprises and departments need extensive business insights, and Power BI puts the power in your hands You can easily work with multiple sources of data, convert it into a report, graph or data visualization of your choice By deploying Power BI, you get real time insights and deploy it faster than any other BI tool available in the market.

Introduction to Power BI

An Overview of the Workflow in Power BI Desktop Power BI Free Vs. Pro Vs. Premium

Power BI Key Components

Introducing the Different Views of the Data Model Taking a Closer Look at the Query Editor Interface

Power BI overview Concept

• Dataset

• Reports

• Dashboard

• Workspace

• Tiles

• Q&A Question box

  Good Data vs. Bad Data

• Classification of Bad Data

  Connecting Power BI Desktop to our Data Sources

• Excel , CSV, Web, PDF, MS Access, SQL Developer, Google Analytics, XML, Connecting to a folder, SharePoint Folder, JSON and many more.

  Power Query

• When to Use Power Query

• Import and analysis millions of Rows

• Best things to happened in power BI

  • Type of Connection

  • Automate your data Processing

  • Query Editor Tool

  • Pivoting and Unpivoting Columns

  • Duplicating Vs. Referencing Queries

  • Transformations

  • Editing Rows

    • First Header Row

    • Remove Top Rows

    • Filtering- Remove-Replace Techniques

  • Editing Columns

    • Remove or Keep Columns

    • Navigation to the Columns

• Formatting Data

  • Change data Type

  • Detect Data type for multiple columns

  • Remove error while loading

  • Remove null values

  • Splitting Columns

  • Delimiters

  • Delimiters positions

  • Creating a New Group for our Queries

• Others

  • Sorting

  • Performing Basic Mathematical Operations in Query Editor

  • Improving Performance and Loading Data into the Data Model

  • Columns Distribution, Quality, Profile

Understanding Append Queries

Append Queries as existing (With two or Multiple tables) Append Queries as New

Introducing the Star Schema

Joins

Fact Table Vs. Dim Table Star Schema

Dim Vs. Fact Table

Star Schema Vs. Snow Flex Schema

Outer Join Left

Right Full Anti Left Right Inner

Data Table vs. Lookup Table Primary key Vs. Foreign Key Relationship Vs. Merged Table Connecting lookup to Lookups Relationship Cardinality

Introducing and Understanding Relationships One to One Relationship

One to Many or Many to One Many to Many Relationship

Bad Cardinality Many to Many Bad Cardinality One to One Importance for Filter Direction Editing Relationships

Data Model Best Practice

Working on our Data Model Data Relationship View

Query Editor vs. Data Model

Feature of Query Editor (Structure + Prepare Data)

Data Model – Add Relationship, Add Measures (Analysis Data) Active Properties

Understanding the differences between the M-Language and DAX DAX - Basic information

Calculated Columns vs. Measures

Working in the Report View to Visualize our Results Understanding the Interface of the Report View Creating our First Visualizations

Understanding which chart to use when Editing Interactions and Adding Tooltips Adding Color Saturation

Understanding Hierarchies and Adding Drill-Down Formatting Charts and Sorting

Essential Formatting settings: Color, Data Labels, Axis, Placement, Legends, Value Table View vs. Matrix View

Conditional Formatting in Table View

Basic Charts: Line, Bar Chart, Column Chart, Tree map, Pie, Doughnut, Area

Tooltips – On hover Text

Color Saturation in Column Chart Slicers: Vertical list vs. Horizontal tiles Text Cards

Ask a Question (Natural Language) – just type what you want with specific key terms Smart Narrative

Custom Visuals

Adding Tree maps and Tables Applying different Filter Types Creating Multi-Row Cards

Understanding Combined Visualizations and Waterfalls

Conditional columns and Data Segmentation:

Conditional Columns: Writing multi-layered IF conditions

Segmentation: Use “Group By” to calculate aggregated calculation based on clusters Segmentation: Use “Binning” to categorize values into equally sized groups

Advance Visualization:

KPI & Gauge Chart Forecast, Trend-line Scatter plot – Bubble Chart Map Visuals

Key Influencer Decomposition Tree Performance Analyser Bookmarks

Advance conditional formatting on visuals Small Multiples

Custom Visuals – Downloadable Charts

Use Drill down/up feature to specify chart behavior – granular view Show/Expand next level

Filter level: Report level vs Page level vs. Visual level

Power BI Service

Introducing Power BI Service Gateway Refresh and Data Flow Understanding Gateways

Personal Gateway

Enterprise Gateway Sharing & Collaboration Tool Power BI Mobile

My Workspace Vs. App Workspace Report Reading tool in Power BI Service Pining Tiles to Dashboard

Dashboard Interface

Report Vs Dashboard Vs Application Assign Roles & Manage Permissions Analysis in Excel

Usage Metrics

Row Level Security (Static Vs Dynamic) Manage Alerts

Exploring Data with Q & A

Generate Quick Insight and lot more….