Complete Guide to Power BI for Data Analysts by Microsoft Press

1. Getting Started with Power BI

• Learning objectives
• Understand the data lifecycle
• Understand the Power BI environment
• Understand Power BI licensing
• Understand Power BI release cycles
• Set up your environment
• Explore data source settings
• Introduce our business scenario

2. Importing and Transforming Data Using Power Query Editor

• Learning objectives
• Power Query Editor overview
• Import United States sales data
• Import customer data
• Import sales territory data
• Import product data
• Import product rollup data
• Merge the product and product rollup queries
• Import the other countries' sales data
• Append sale queries
• Create columns
• Model loading and cleanup
• Organize and document Power Query

3. Enhancing the Data Model: The Basics

• Learning objectives
• Navigate the Power Bi Desktop
• Understanding Dimensional Modeling
• Create relationships and manage settings
• Modify column properties
• Create a column group
• Create hierarchies
• Optimize relationships
• Discuss data model cleanup

4. Enhancing the Data Model: DAX Basics

• Learning objectives
• Understand DAX
• Create basic DAX expressions
• Use logical expressions in DAX
• Comprehensive create calculated columns and measures: Part one
• Comprehensive create calculated columns and measures: Part two
• Comprehensive create calculated columns and measures: Part three
• Use the FILTER function
• Use the ALL function

5. Enhancing the Data Model: DAX Time Intelligence

• Learning objectives
• Build a date table
• Disable the auto date/time setting
• Designate a date table
• Build relationship between order date and sales
• Basic time intelligence functions
• Use the CALCULATE function

6. Enhancing the Data Model: Quick Measures

• Learning objectives
• Use quick measures

7. Building Desktop Visualizations: The Basics

• Learning objectives
• Navigate the Power Bi Desktop report view
• Create a clustered column chart
• Create a stacked bar chart
• Create a line chart
• Create a KPI visual
• Create a card visual
• Create slicers

8. Building Desktop Visualizations: Next Level

• Learning objectives
• Add a canvas background
• Apply a theme
• Adjust existing visuals
• Create a custom tooltip
• Explore drill through
• Apply conditional formatting to a visual
• Build an order date hierarchy
• Enable a drill-down on a visual
• Edit interactions between visuals
• Use the selection pane
• Use the Bookmarks pane
• Explore the filter pane
• Explore the structure of a .pbix file

9. Using the Power BI service: Reading View

• Learning objectives
• Publish to the Power BI service
• Explore the Power BI service
• Create and use bookmarks
• Share reports

10. Using the Power BI Service Next Level

• Learning objectives
• Create a new report using an existing dataset
• Build a dashboard
• Configure the dashboard
• Set an alert
• Use the Q&A dialog

11. Implementing Security and Access

• Learning objectives
• Create row-level security (RLS) roles
• Validate RLS roles using Power BI Desktop
• Assign and validate roles in the Power BI service

12. Summary

• Summary