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

Account Receivables Aging Report

1. Overview of Sample Dashboard and Dataset

2. Import, transform and load data

3. Data Modeling and Relationship

4. Writing Fact Dax Measures

5. Creating Receivables Aging Table

6. Writing Dynamic Measures for Aged Receivables

7. Data Visualization

Income Statement from GL Transaction Data

1. Overview of Sample Dashboard and Dataset

2. Import Data into Power Query Editor

3. Cleaning, Transforming and Loading Data

4. Data Modeling and Relationship

5. Writing Fact Measures

6. Writing Current Year Measures

7. Writing Time Intelligence Measures

8. Data Visualization

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

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