Microsoft Power BI
Buy now
Learn more
Getting Started
Microsoft Power BI Program Brochure
Book a free demo class for Power BI
Power BI Training Calendar
Power BI Study Kit
Install Power BI
Lab Datasets
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
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
Enhance Business Insights with DAX: Monthly, Quarterly, and Yearly Growth Metrics
Use DAX for Displaying Core Business Process KPIs using Quick Measures
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
Portfolio Dashboard
CRM Dashboard
HR Analysis Dashboard
Finance Dashboard
Operational Dashboard
Sales Dashboard
Project Performance Dashboard
Planning Dashboard
Analysis of Evaluation level
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
Power BI Cohort - 138 Class Videos
Power BI Cohort - 139 Class Videos
Power BI Cohort - 140 Class Videos
Power BI Cohort - 141 Class Videos
Mock Test
Mock Test 1
Mock Test 2
Mock Test 3
Mock Test Access
Internship Project
Apply for Internship
Power BI Case Studies & Reports
Top 15 Common Business Problems in Reporting
Case Study – Sales Performance Reporting
Case Study – Project Performance Reporting
Resource for PL 300 Exam
Enterpise Financial Analytics - Reporting Guidelines
KPI Institute for Business Analytics Reporting
Products
Course
Section
Lesson
Top 15 Common Business Problems in Reporting
Top 15 Common Business Problems in Reporting
Microsoft Power BI
Buy now
Learn more
Getting Started
Microsoft Power BI Program Brochure
Book a free demo class for Power BI
Power BI Training Calendar
Power BI Study Kit
Install Power BI
Lab Datasets
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
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
Enhance Business Insights with DAX: Monthly, Quarterly, and Yearly Growth Metrics
Use DAX for Displaying Core Business Process KPIs using Quick Measures
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
Portfolio Dashboard
CRM Dashboard
HR Analysis Dashboard
Finance Dashboard
Operational Dashboard
Sales Dashboard
Project Performance Dashboard
Planning Dashboard
Analysis of Evaluation level
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
Power BI Cohort - 138 Class Videos
Power BI Cohort - 139 Class Videos
Power BI Cohort - 140 Class Videos
Power BI Cohort - 141 Class Videos
Mock Test
Mock Test 1
Mock Test 2
Mock Test 3
Mock Test Access
Internship Project
Apply for Internship
Power BI Case Studies & Reports
Top 15 Common Business Problems in Reporting
Case Study – Sales Performance Reporting
Case Study – Project Performance Reporting
Resource for PL 300 Exam
Enterpise Financial Analytics - Reporting Guidelines
KPI Institute for Business Analytics Reporting
Lesson unavailable
Please
login to your account
or
buy the course
.
You need to
enable JavaScript
to use the communication tool powered by
OpenWidget