Introduction to Power BI Desktop

• Learn the BI interface
• Navigate the BI window
• Upload data
• Create visuals
• Column charts
• Maps
• Cards
• Create and modify reports
• Import data

Loading Data with Power BI Desktop

• Understand data sources
• Load data
• Refresh data
• Reuse recent data sources
• Pin data sources
• Understand connection security

Transforming Datasets

• Work in the query editor
• Understand applied steps
• Dataset shaping
• Rename
• Reorder
• Merge columns
• Filter data
• Text ranges
• Numeric ranges
• Date/time ranges

Text-Based Visualization

• Create tables
• Create metrics
• Create cards
• Create multi-row cards
• Enhance visuals

Charts in Power BI

• Create charts
• Pie
• Donut
• Funnel
• Waterfall
• Customize chart attributes
• Use drilldowns
• Create Bing maps
• Use geographic data
• Use gauges

Filtering Data

• Filter different data types
• Work with advanced text filters
• Understand visual levels
• Remove filters

Using Slicers

• Create slicers
• Format slicers
• Use charts as slicers

Cleansing Data

• Change data types
• Detect data types
• Replace values
• Fill down
• Group records

Data Mashup

• Duplicate columns
• Split columns
• Customize columns
• Aggregate data
• Append data
• Change data structure
• Modify/rename/delete steps
• Manage queries

Extending the Data Model with Calculated Columns

• Concatenate columns
• Build calculations across tables
• Work with If and nested If statements
• Understand and utilize DAX
• Work with measures

Enhancing your Dashboard

• Add textboxes
• Modify page background
• Add shapes
• Organize visuals on the page
• Export data from a visualization

Creating a Data Model

• Format data fields
• Apply a default summarization
• Add hierarchies
• Build relationships between tables
• Deactivate relationships
• Examine relationship options

PowerBI.com

• Publish reports
• Interact with reports
• Create dashboards
• Share dashboards
• Create new reports