Essentials of Data Analytics using Power BI

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

1 of 3

Previous Lesson

4. Course Objective

Essentials of Data Analytics using Power BI 4. Course Objective

Previous Lesson