Data Insights with Power Bi: Intermediate to Advanced Techniques
This Power BI Intermediate-Advanced course empowers you to break the cycle of wasting time preparing data, enabling you to translate analytical results into strategic decisions.
Programme Overview
Many professionals struggle to turn raw data into meaningful insights. This Power BI Intermediate-Advanced course empowers you to break that cycle by teaching you how to connect, shape, and combine data using Power Query, and build robust data models for deeper analysis. You'll discover the power of DAX functions to create calculated columns, measures, and advanced calculations for dynamic reporting, alongside exploring advanced visualization techniques including conditional formatting, drill-through, and interactive navigation with bookmarks. By mastering these technical skills, you will gain the confidence to deliver impactful dashboards and reports that influence strategic decisions, elevating your analytics game to become a Power BI expert.
Learning Outcomes
Getting Data from various sources
Create table relationships
Use DAX functions
Create Calculated Columns
Create Measures
Adding Bookmarks
Customize filters in reports
Who Should Attend?
Power BI users seeking advanced skills.
Data analysts and business intelligence professionals.
Report creators aiming for optimized, interactive dashboards.
Professionals responsible for data-driven decision-making.
Anyone looking to enhance Power BI expertise beyond basics.
Course Outline
Day 1 (9:00 AM to 5:00 PM)
Introduction & Ice-Breaking
- Trainer introduction
- Ice-breaking session
Module 1: Getting Data into Power BI Model
- Using Text File as Data Source for Power BI
- .CSV
- .txt
- Using Excel Files as Data Source for Power BI
- Using Database as Data Source for Power BI
Module 2: Data Modeling in Power BI Desktop
- What is Data Model?
- Creating Data Model
- Create a Relationship
- Autodetect
- Manually with Manage Relationship Dialogbox
- Manually in Model View
- Edit a Relationship
- Delete a Relationship
- Active vs Inactive Relationship
- Cardinality
- Cross Filter Direction
Module 3: Shaping and Combining Data
- What is Power Query?
- Formatting Data
- Uppercase / Lowercase
- Trim and Clean
- Add Prefix / Suffix
- Extract Data
- Length
- First / Last / Range Characters
- Text Before / Between / After the Delimiter
- Shaping Data
- Data Types
- Split Column
- Merge Columns
- Replace Values
- Replace Errors
- Fill Down Null Values
- Promote a Row to Column Headers
Module 4: Advanced Visualization Settings
- Conditional Data Formatting
- Create Hierarchy
- Sort by Column
- Grouping and Binning
- Drill Down/Up
- Drill Through
- Apply Filters in Filters Pane
- Visual Filter
- Page Filter
- Report Filter
- Download Additional Visualizations in AppSource
- Report Navigation with Button and Bookmarks
Reflection & Wrap-Up
Day 2 (9:00 AM to 5:00 PM)
Module 5: Overview of DAX Functions
- What is DAX?
- Excel Functions vs. DAX Functions
- Types of DAX Functions
- Syntax of DAX Function
- Example of a DAX Function
Module 6: Advanced DAX - Calculated Columns
- What is Calculated Column?
- Creating Calculated Column
- Editing a Calculated Column
- Deleting a Calculated Column
Module 7: Advanced DAX - Measures
- What is Measures?
- Create Quick Measures
- Create Measures
- Organizing Your Measures
Module 8: Advanced DAX - Creating Calculated Tables
- What is Calculated Table?
- Create a Calculated Table
- Create Date Table
- Mark as Date Table
- Why Date Table?
Reflection & Wrap-Up