Microsoft Power BI
Buy now
Learn more
Getting Started
Microsoft Power BI Program Brochure
Power BI Training Calendar
Book a free demo class for Power BI
Contact us
View Trainer Profile
Power BI Course Enrollment Procedure
Demo Class Recording
Get Started with PowerBI
Top 15 Common Business Problems
Power BI Study Kit
Lab Dataset
Install Power BI
Team Academy AI Learning Assistant
Reporting Template Guidelines
Power Query - Shaping your Enterprise Data
Get Started with Power Query
Get Data from File Sources - Excel Table, PDF Invoices & Others
Get Data from Online Sources - SharePoint, Outlook, Dynamics 365, Web APIs & Default connectors.
Get Data from Fabric Warehouse – Data Flow
Data Access, Path & Permission Settings in Power Query
Data Validation Steps & Basic Statistics
Automate Daily Reports, Timesheets & Invoices using Append & Combine Option
Prepare Summary Tables & Aggregates
Reshape your Operational Data using Pivot, Unpivot
Transform Tables & Generic Columns
Derive KPIs & Flags Using Conditional columns & Custom columns
Create a reporting workflow & Enable Process Automation using Applied steps
Automate Look Up, Filtering & Reconciliation Process using Merge Query (SQL Joins)
Apply Logical Transformation - On Values
Query Settings, Selective Load & Performance Troubleshooting
Case Study – Project Performance Reporting
Case Study – Sales Performance Reporting
Data Modelling & Relationships between entities
What is Data Modelling?
Jump Start - Connect with an existing Semantic Model
Fact Vs Dimension Table - Difference between Primary Key & Foreign Key
Naming & Sorting the Columns
Normalization vs Denormalization - Importance of modelling
Difference between Merge & Relate
Understand Relationship types, Cardinality & Cross Filter direction
Design a Consistent Star Schema in the Data Model
Lab Exercise - Design a Data Model in Power BI
Scenarios for using Snowflake Schema for Parent Child Hierarchical reporting
Design Date Dimensions for Automating Periodic Reporting - Monthly, Weekly, Daily, Year Reports
Add Bridge Tables & Handle Many-to-Many Relationships for Group of Companies or Portfolio Reporting
Create Hierarchy, Groups & Bins for Categorical Analysis
Import or Direct Query the tables from the source
Control Row level Access to Reports & Data by Roles
Publish & Manage Automated Data Refresh to Semantic Model in Fabric
Optimize model Performance
Dax Functions
Simplify Multi-Dimensional KPI Reporting Using DAX, Quick Measures, Visual Calculations & Copilot
Utilize Dax for Columns, Measures, Tables & Functions
Use DAX for Displaying Core Business Process KPIs using Quick Measures
Enhance Business Insights with DAX: Monthly, Quarterly, and Yearly Growth Metrics
Create Cross Functional KPIs Such as Fin Tech, Marketing Ops, Sales Tech
Leverage DAX for Dynamic & Real time Reporting
Apply DAX for Forecasting Future Trends Using Historical Data
Lab Exercise - Create Advanced DAX Calculations in Power BI Desktop
Lab Exercise - DAX Formulas
PL 300 - PPT - Use DAX Functions
Visualisation I
PPT- VISUALIZATION I & DAX
VIDEO-VISUALIZATION I & DAX
Lab Exercise - Create a Power BI Dashboard
Lab Exercise - Design a Report in Power BI Desktop
PL 300 - PPT - Design Power BI Reports
Visualisation II
PPT-VISUALIZATION II & DAX
VIDEO-VISUALIZATION II & DAX
Lab Exercise - Perform Data Analysis in Power BI
Lab Exercise - Enhance a Report in Power BI Desktop
PL 300 - PPT - Enhance Reports for user Experience
PL 300 - PPT - Create Dashboards
PL 300 - PPT - Perform Advanced Analytics
PL 300 - PPT - Implement Row level Security
PL 300 - PPT - Create and Manage Workspaces
Power BI Sample Dashboards
HR Analysis Dashboard
Finance Dashboard
Sales Dashboard
Operational Dashboard
Portfolio Dashboard
Project Performance Dashboard
Population Status
Planning Dashboard
Oil Rig Dashboard
Analysis of Evaluation level
CRM Dashboard
Student Performance Dashboard
PowerBI Dashboards Upload
Class Recordings
Power BI Cohort - 129 Class Videos
Power BI Cohort - 130 Class Videos
Power BI Cohort - 131 Class Videos
Power BI Cohort - 132 Class Videos
Power BI Cohort - 133 Class Videos
Power BI Cohort - 134 Class Videos
Power BI Cohort - 135 Class Videos
Power BI Cohort - 136 Class Videos
Power BI Cohort - 137 Class Videos
Mock Test
Mock Test 1
Mock Test 2
Mock Test 3
Mock Test Access
Internship Project
Apply for Internship
Products
Course
Section
Lesson
Class Video 2: Power Query and Data Set
Class Video 2: Power Query and Data Set
Microsoft Power BI
Buy now
Learn more
Getting Started
Microsoft Power BI Program Brochure
Power BI Training Calendar
Book a free demo class for Power BI
Contact us
View Trainer Profile
Power BI Course Enrollment Procedure
Demo Class Recording
Get Started with PowerBI
Top 15 Common Business Problems
Power BI Study Kit
Lab Dataset
Install Power BI
Team Academy AI Learning Assistant
Reporting Template Guidelines
Power Query - Shaping your Enterprise Data
Get Started with Power Query
Get Data from File Sources - Excel Table, PDF Invoices & Others
Get Data from Online Sources - SharePoint, Outlook, Dynamics 365, Web APIs & Default connectors.
Get Data from Fabric Warehouse – Data Flow
Data Access, Path & Permission Settings in Power Query
Data Validation Steps & Basic Statistics
Automate Daily Reports, Timesheets & Invoices using Append & Combine Option
Prepare Summary Tables & Aggregates
Reshape your Operational Data using Pivot, Unpivot
Transform Tables & Generic Columns
Derive KPIs & Flags Using Conditional columns & Custom columns
Create a reporting workflow & Enable Process Automation using Applied steps
Automate Look Up, Filtering & Reconciliation Process using Merge Query (SQL Joins)
Apply Logical Transformation - On Values
Query Settings, Selective Load & Performance Troubleshooting
Case Study – Project Performance Reporting
Case Study – Sales Performance Reporting
Data Modelling & Relationships between entities
What is Data Modelling?
Jump Start - Connect with an existing Semantic Model
Fact Vs Dimension Table - Difference between Primary Key & Foreign Key
Naming & Sorting the Columns
Normalization vs Denormalization - Importance of modelling
Difference between Merge & Relate
Understand Relationship types, Cardinality & Cross Filter direction
Design a Consistent Star Schema in the Data Model
Lab Exercise - Design a Data Model in Power BI
Scenarios for using Snowflake Schema for Parent Child Hierarchical reporting
Design Date Dimensions for Automating Periodic Reporting - Monthly, Weekly, Daily, Year Reports
Add Bridge Tables & Handle Many-to-Many Relationships for Group of Companies or Portfolio Reporting
Create Hierarchy, Groups & Bins for Categorical Analysis
Import or Direct Query the tables from the source
Control Row level Access to Reports & Data by Roles
Publish & Manage Automated Data Refresh to Semantic Model in Fabric
Optimize model Performance
Dax Functions
Simplify Multi-Dimensional KPI Reporting Using DAX, Quick Measures, Visual Calculations & Copilot
Utilize Dax for Columns, Measures, Tables & Functions
Use DAX for Displaying Core Business Process KPIs using Quick Measures
Enhance Business Insights with DAX: Monthly, Quarterly, and Yearly Growth Metrics
Create Cross Functional KPIs Such as Fin Tech, Marketing Ops, Sales Tech
Leverage DAX for Dynamic & Real time Reporting
Apply DAX for Forecasting Future Trends Using Historical Data
Lab Exercise - Create Advanced DAX Calculations in Power BI Desktop
Lab Exercise - DAX Formulas
PL 300 - PPT - Use DAX Functions
Visualisation I
PPT- VISUALIZATION I & DAX
VIDEO-VISUALIZATION I & DAX
Lab Exercise - Create a Power BI Dashboard
Lab Exercise - Design a Report in Power BI Desktop
PL 300 - PPT - Design Power BI Reports
Visualisation II
PPT-VISUALIZATION II & DAX
VIDEO-VISUALIZATION II & DAX
Lab Exercise - Perform Data Analysis in Power BI
Lab Exercise - Enhance a Report in Power BI Desktop
PL 300 - PPT - Enhance Reports for user Experience
PL 300 - PPT - Create Dashboards
PL 300 - PPT - Perform Advanced Analytics
PL 300 - PPT - Implement Row level Security
PL 300 - PPT - Create and Manage Workspaces
Power BI Sample Dashboards
HR Analysis Dashboard
Finance Dashboard
Sales Dashboard
Operational Dashboard
Portfolio Dashboard
Project Performance Dashboard
Population Status
Planning Dashboard
Oil Rig Dashboard
Analysis of Evaluation level
CRM Dashboard
Student Performance Dashboard
PowerBI Dashboards Upload
Class Recordings
Power BI Cohort - 129 Class Videos
Power BI Cohort - 130 Class Videos
Power BI Cohort - 131 Class Videos
Power BI Cohort - 132 Class Videos
Power BI Cohort - 133 Class Videos
Power BI Cohort - 134 Class Videos
Power BI Cohort - 135 Class Videos
Power BI Cohort - 136 Class Videos
Power BI Cohort - 137 Class Videos
Mock Test
Mock Test 1
Mock Test 2
Mock Test 3
Mock Test Access
Internship Project
Apply for Internship
Lesson unavailable
Please
login to your account
or
buy the course
.