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.
Dates
There are no dates currently scheduled for this course.
Interested in this course?
Suggest a date/location
Description
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.
Prerequisites
This course is suitable for anyone who has a good understanding of Microsoft Power BI and wants to develop their skills further. Presquities - 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.
Content
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
- 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
Certification
College certificate of attendance