Content
Module 1: Introduction to Data Visualization
- What is data visualization?
- Why Power BI is the best data visualization solution!
- Power BI: The cloud service
- Lab 01 – Creating a simple Power BI report
Module 2: Preparing Your Data
- Getting data from various sources
- Resolving errors during data retrieval
- Lab 02 – Import data into Power BI
Module 3: Cleansing and Transforming Data
- Power BI Desktop queries (Power Query)
- Cleansing data and transformations
- Appending and merging data
- Lab 03 – Shaping up and consolidating data
Module 4: Designing a Data Model
- Understanding M Formula language
- Experimenting with data massaging with Power Query editor window
- Working with tables and relationships
- Lab 04 – Building and evaluating table relationships
Module 5: Calculations using DAX
- Performing simple calculations to create new columns
- Creating measures
- Generating a simple pivot table report using the calculations of DAX
- Lab 05 – First steps to DAX
Module 6: Creating Power BI Reports
- Designing a report
- Enhancing the report
- Using effective visuals on the report
- Lab 06 – Creating a report with interactions and formatting
Module 7: Creating Power BI Dashboard
- How different is a dashboard to a report?
- Creating a dashboard
- Enhancing the dashboard
- Q&A features of Power BI dashboards
- Lab 07 – Creating a dashboard with Q&A capabilities