Covert data into opportunity with Microsoft Power BI data visualization tools. Drive better business decisions by analyzing your enterprise data for insights.

Course Content

Introduction

• What is Power BI?
• Installing Power BI Desktop & Source File Connection
• Working in the Query Editor
• The Data View & Creating our First Visuals

Introducing Power BI Desktop

• Using the Attached Project Files
• Understanding the Power BI Desktop Workflow
• Exploring the Interface of the Data Model
• Understanding the Query Editor Interface
• Creating the Project File & Recommended Settings

Working in the Query Editor

• Connecting Power BI Desktop to Source Files
• Keeping & Removing Rows
• Working with Filters
• Removing Empty Rows
• Saving the Project Draft
• Appending Queries
• Working with Columns
• Replacing Values

Formatting Data & Handling Formatting Errors

• Pivoting & Unpivoting Data
• Splitting Columns
• Creating Groups & Cleaning Up our Project
• What we Achieved & How to Continue

Concept: The Star Schema

• How we Use the Star Schema in our Project

Query Duplicates vs References

• Creating the DIM-Region Table & Removing Duplicates
• Creating Tables Manually

Concept: Merging Queries

• Understanding "Join Kind"
• Merging Queries Applied
• Finishing the DIM-Region Table
• Creating the DIM-Age Table
• Understanding "Extract"
• Working with Conditional Columns
• Creating the FACT-Table
• Understanding Basic Mathematical Operations
• Performance Optimization

Understanding the Data Model: Data & Relationship View

• Understanding Relationships
• Cardinality: Many-to-One & One-to-One
• Cross Filter Direction & Many-to-Many
• Understanding Active Properties

Understanding the DAX Basics

• The DAX Syntax
• Supported DAX Data Types
• Diving Into Operators
• DAX Functions - An Overview
• Understanding the CALENDAR Function
• Applying the DAX Basics
• Understanding IF & RELATED
• Calculated Columns vs Measures
• Creating our First Measures
• Understanding CALCULATE & FILTER
• Applying CALCULATE & FILTER in Measures
• Creating Measures with Measures
• Understanding "Data Category"

Creating Visuals in the Report View

• Understanding Basic Visual Concepts
• Getting Started with Visuals & Reports
• Creating our First Visuals
• Understanding Tooltips & Interactions
• Diving Intro Hierarchies & Drill Mode
• Data Colors & Conditional Formatting
• Formatting Report Pages
• Formatting Visuals
• Working with Report Themes