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
                                            
                                                ()