Complete Guide to Power BI for Data Analysts by Microsoft Press

Discover how you can use Power BI to help your organization to become more data driven.

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