Microsoft Power Bi – Advanced
Microsoft Power BI is a powerful data visualization tool that allows users to connect to, visualize and share any data, gaining deeper insights. This 2-day advanced course is designed to help attendees become expert users in Power BI.
Description
Group bookings are available and can be tailored to your needs. Courses may be delivered onsite, virtually, in person, or on campus. To arrange a private course, you can register your interest Register interest in a private course
Day 1
Connect to Power BI Connections and Data Sources
Introduction to Power BI Data Connections and Sources
Loading Data from SQL Server
Loading Data from CSV and TXT
Practical Activity - Load Data from a CSV file
Loading Data from the Web
Practical Activity - Connect to Data on the Web
Loading Excel Data from One Drive for Business
Loading Data from XML files
Loading Data from JSON
Loading Data from the Power BI Service
Build a Relational Data Model
Intro to Database Normalization
Data ("Fact") Tables vs. Lookup ("Dimension") Tables
Creating Power BI Table Relationships
"Star" vs. "Snowflake" Schemas
Active vs. Inactive Relationships
Relationship Cardinality
Connecting Multiple Data Tables
Filtering & Cross-Filtering
Hiding Fields from the Power BI Report View
Data Modeling & Power BI best Practices
Working with DataMarts
Day 2
The Power BI Query Editor
Overview and Introduction to The Query Editor
Perform Data Transformations
Introduction to Transformations
Data Transformations
Conditional IF
Cleanse Data and Parameters
Introduction to Cleanse Data
Query Editor Diagnostics
Cleansing Data Files
Parameters
Add Calculated Fields with DAX
Introduction to cover areas such as:
Meet Data Analysis Expressions (DAX)
Intro to DAX Calculated Columns
Intro to DAX Measures
Adding Columns & DAX Measures in Power BI Desktop
Implicit vs. Explicit DAX Measures
Filter Context Examples in Power BI
Step-by-Step DAX Measure Calculation
Understanding DAX Syntax & Operators
Common DAX Function Categories
Basic Date & Time Functions
Conditional & Logical Functions (IF/AND/OR)
Common Text Functions
Joining Data with RELATED
Basic Math & Stats Functions
COUNT Functions (COUNTA, DISTINCTCOUNT, COUNTROWS)
CALCULATE
CALCULATE & ALL
CALCULATE & FILTER
Iterator Functions (SUMX, RANKX)
Time Intelligence Formulas
DAX Best Practices in Power BI Desktop
Prerequisites
A good understanding of Microsoft Power BI is required.
A basic understanding of Microsoft Office 365 is recommended.
Microsoft Power BI requires a separate license in addition to Microsoft Office. Attendees will need this additional license to perform exercises on their own computers.
A stable Internet connection is required.
Having a second display is beneficial but not required.
Entry Requirements
This course is suitable for anyone who has a good understanding of Microsoft Power BI and wants to develop their skills further.