When to Append, Merge, Relate in Power BI Model
When to Append, Merge, Relate in Power BI Model
Microsoft Power BI
Buy now
Learn more
Getting Started
📖
View Power BI Program Brochure
Access Demo Class Recordings
☯️
Join a Live Demo Class
📆
View Power BI Academic Schedule
📅
View Power BI Upcoming Schedule
🧑💻
Install Power BI for free
2
💲
Enroll Now
Access Student Study Kit
Access Lab Datasets
Power Query - Shaping your Enterprise Data
Get Started with Power Query
1
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
Automate Daily Reports, Timesheets & Invoices using Append & Combine Option
Data Validation Steps & Basic Statistics
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
Apply Logical Transformation - On Values
Automate Look Up, Filtering & Reconciliation Process using Merge Query (SQL Joins)
Query Settings, Selective Load & Performance Troubleshooting
Work with PDF
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
Difference between Merge & Relate
Understand Relationship types, Cardinality & Cross Filter direction
Normalization vs Denormalization - Importance of modelling
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
Publish & Manage Automated Data Refresh to Semantic Model in Fabric
Control Row level Access to Reports & Data by Roles
Optimize model Performance
When to Append, Merge, Relate in Power BI Model
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
DAX Formula Ebook
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 Ebook
Visualisation II
VIDEO-VISUALIZATION II & DAX
Lab Exercise - Perform Data Analysis in Power BI
Lab Exercise - Enhance a Report in Power BI Desktop
PPT-VISUALIZATION II & DAX
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
HR Analysis Dashboard
Finance Dashboard
Operational Dashboard
Project Performance Dashboard
Sales Dashboard
Planning Dashboard
CRM Dashboard
HSE Dashboard
Analysis of Evaluation level
Teamacademy PNL Report
PowerBI Dashboards Upload
Access Sample Dashboards
2
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
1
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
Power BI Cohort - 142 Class Videos
Power BI Cohort - 144 Class Videos
Power BI Cohort - 143 Class Videos
Power BI Cohort - 145 Class Videos
1
Power Bi Cohort - 146 Class Videos
Power BI Cohort - 148 Class Videos
Power BI - Cohort 149 Class Videos
Power BI - Cohort 150 Class Videos
Power Bi - Cohort 151 Class Videos
Power BI Cohort - 152 Class Videos
Power BI Cohort - 153 Class Videos
Power BI Cohort - 154 Class Videos
Special Class Recordings
Microsoft Fabric Video
Power App and Power Automate
Dax Class Recording
Mock Test
Mock Test 1
Mock Test 2
Mock Test 3
Mock Exam Books
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
Preview unavailable
You must log in or sign up to view this lesson.
Login
Sign up
Microsoft Power BI
Buy now
Learn more
Getting Started
📖
View Power BI Program Brochure
Access Demo Class Recordings
☯️
Join a Live Demo Class
📆
View Power BI Academic Schedule
📅
View Power BI Upcoming Schedule
🧑💻
Install Power BI for free
2
💲
Enroll Now
Access Student Study Kit
Access Lab Datasets
Power Query - Shaping your Enterprise Data
Get Started with Power Query
1
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
Automate Daily Reports, Timesheets & Invoices using Append & Combine Option
Data Validation Steps & Basic Statistics
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
Apply Logical Transformation - On Values
Automate Look Up, Filtering & Reconciliation Process using Merge Query (SQL Joins)
Query Settings, Selective Load & Performance Troubleshooting
Work with PDF
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
Difference between Merge & Relate
Understand Relationship types, Cardinality & Cross Filter direction
Normalization vs Denormalization - Importance of modelling
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
Publish & Manage Automated Data Refresh to Semantic Model in Fabric
Control Row level Access to Reports & Data by Roles
Optimize model Performance
When to Append, Merge, Relate in Power BI Model
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
DAX Formula Ebook
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 Ebook
Visualisation II
VIDEO-VISUALIZATION II & DAX
Lab Exercise - Perform Data Analysis in Power BI
Lab Exercise - Enhance a Report in Power BI Desktop
PPT-VISUALIZATION II & DAX
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
HR Analysis Dashboard
Finance Dashboard
Operational Dashboard
Project Performance Dashboard
Sales Dashboard
Planning Dashboard
CRM Dashboard
HSE Dashboard
Analysis of Evaluation level
Teamacademy PNL Report
PowerBI Dashboards Upload
Access Sample Dashboards
2
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
1
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
Power BI Cohort - 142 Class Videos
Power BI Cohort - 144 Class Videos
Power BI Cohort - 143 Class Videos
Power BI Cohort - 145 Class Videos
1
Power Bi Cohort - 146 Class Videos
Power BI Cohort - 148 Class Videos
Power BI - Cohort 149 Class Videos
Power BI - Cohort 150 Class Videos
Power Bi - Cohort 151 Class Videos
Power BI Cohort - 152 Class Videos
Power BI Cohort - 153 Class Videos
Power BI Cohort - 154 Class Videos
Special Class Recordings
Microsoft Fabric Video
Power App and Power Automate
Dax Class Recording
Mock Test
Mock Test 1
Mock Test 2
Mock Test 3
Mock Exam Books
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