Build professional-quality business intelligence reports from the ground up
Blend and transform raw data into beautiful interactive dashboards
Design and implement the same B.I. tools used by professional analysts and data scientists
Showcase your skills with two full-scale course projects (with step-by-step solutions)
Understand the business intelligence workflow from end-to-end
Learn from a best-selling instructor and professional BI developer

Duration: 2 days (14 hours)

Requirements

Microsoft Power BI Desktop (free download)
This course is designed for PC/Windows users (currently not available for Mac)
Experience with Excel Power Query, Power Pivot & DAX is a plus, but not required

NOTE: This is PART 1 of a 2-Part Microsoft Power BI series:

1. Up & Running with Power BI Desktop
2. Publishing to Power BI Service
Don't forget to complete PART 2 to learn Power BI Service and take your Power BI skills to the cloud!

Request for proposal

This course is intended for Business Managers, Report Developers, Analysts, Project Managers and Team Leads.
Anyone looking for a hands-on, project-based introduction to Microsoft Power BI Desktop
Data analysts and Excel users hoping to develop advanced data modeling, dashboard design, and business intelligence skills
Aspiring data professionals looking to master the #1 business intelligence tool on the market
Students who want a comprehensive, engaging, and highly interactive approach to training
Anyone looking to pursue a career in data analysis or business intelligence

Request for proposal

POWER BI OBJECTIVE #1: Connect & Transform the Raw Data

Intro to the Power BI Query Editor
Types of Power BI Data Connectors
Basic Table Transformations
Text, Number & Date Tools
Index & Conditional Columns
Grouping & Aggregating Data
Pivoting & Unpivoting
Modifying, Merging & Appending Queries
Connecting to Folders
Defining Hierarchies & Categories
Query Editing & Power BI Best Practices

POWER BI OBJECTIVE #2: 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

Request for proposal

POWER BI OBJECTIVE #3: Add Calculated Fields with DAX

Intro to Data Analysis Expressions (DAX)
Calculated Columns vs. Measures
Row Context vs. Filter Context in Power BI
DAX Syntax & Operators
Common Power BI Functions
Basic Date & Time Formulas
Logical & Conditional Statements
Text, Math & Stats Functions
Joining Data with RELATED
CALCULATE, ALL & FILTER Functions
DAX Iterators (SUMX, AVERAGEX)
Time Intelligence Formulas
DAX & Power BI Best Practices

POWER BI OBJECTIVE #4: Design Interactive Power BI Reports

Intro to the Power BI Report View
Adding Basic Charts to Power BI Reports
Formatting & Filtering Options
Matrix Visuals
Slicers & Timelines
Cards & KPIs
Power BI Map Visuals (Basic, Fill, ArcGIS)
Treemaps, Lines, Areas & Gauges
Editing Report interactions
Adding Drillthrough Filters
Linking to Report Bookmarks
Using "What-If" Parameters
Managing & Viewing Roles
PREVIEW: Publishing to Power BI Service
Power BI Data Viz Best Practices

POWER BI OBJECTIVE #5: Publish Report

Publish Reports
Working with Cloud Data
Export Report

Request for proposal