Power BI for Financial Reporting and Analysis

Income statement Deep Dive

Download Resources

1. Overview of Sample Dashboard and Dataset

2. Importing Data into Power Query Editor

3. Cleaning, Transforming and Loading Data

4. Data Modeling and Relationship

5. Writing Fact DAX Measures

6. Writing Time Intelligence Measures

7. Creating Best Fit Visuals

8. Data Visualization

9. Dashboard Interactivity

10. Dashboard for Many ACCOUNT CODE

Financial statement Data Setup and Modeling

1. Overview of Dashboards and Dataset

2. Financial Template Explained

3. Importing Data into Power Query Editor

4. Cleaning, Transforming and Loading Data

5. Data Modeling and Relationships

Dynamic Income Statement

1. Creating Fact DAX Measures

2. Creating a Selection Table

3. Variable Explained

4. Creating Dynamic Measures

5. Dynamic Measure – Alternative Calculation

6. Creating Best Fit Visuals

7. Data Visualization

8. Dashboard Interactivity

Dynamic Balance Sheet Dashboard

1. Creating Fact DAX Measures

2. Creating a Selection Table

3. Creating Dynamic Measures

4. Dynamic Measure – Alternative Calculation

5. Creating Best Fit Visuals

6. Data Visualization

7. Dashboard Interactivity

Dynamic Cash Flow Statement Dashboard

1. Creating Fact DAX Measures

2. Creating a Selection Table

1 of 2

Previous Lesson

1. Overview of Dashboards and Dataset

Power BI for Financial Reporting and Analysis 1. Overview of Dashboards and Dataset

Previous Lesson