Power BI for Financial Reporting and Analysis & Essentials of Data Analytics with Power BI (Combined)
Overview of Power BI
Download Resources
1. Course Introduction
2. Course Outline
3. Downloading Power BI
4. Course Objective
5. What is Power BI?
6. Power BI vs Excel
7. Understanding the Interface of Power BI
8. Pillars of Power BI
Cleaning, Transforming and Loading Data
1. Overview of Power Query Editor
2. Effective ways to bring in your Data into Power Query Editor
3. Review of Data Sources and Importing Data into Power Query Editor
4. Investigating Data Types
5. Deleting Previous Steps
6. Filtering Columns with Data
7. Cleaning Tables and Column Names
8. Rows and Columns Transformation
9. Unpivot Columns
10. Grouping Queries
11. Duplicate and Reference Explained
12. Append and Merge Queries Explained
13. Understanding M Code
14. Significance of Date Table
Data Modeling and Relationship
1. Significance of Data Modeling and Relationships
2. Importance of Right Relationships in your Model
3. How to create a Dimension Table
4. How to create Relationships between Tables
5. Active and Inactive Relationship Explained
6. How to sort by column
Data Analysis Expression (DAX)
1. Overview of DAX
2. Primary Calculations using DAX
3. Understanding Context
4. Bedrock of DAX Calculations
1 of 4
Previous Lesson
Next Lesson
4. Course Objective
Power BI for Financial Reporting and Analysis & Essentials of Data Analytics with Power BI (Combined)
4. Course Objective
Previous Lesson
Back to Course
Next Lesson
