Power BI

• Overview of Power BI Desktop • Similarities to Excel Power Pivot • Similarities to Excel Power Query • Technical Options & Settings • Monthly Updates • Introduction to Facts & Dimensions

• Importing Data from various sources • Using Direct Query • Query Editor Overview • Understanding Query Design & the ETL Process • Query Building Best Practice • Understanding Applied Steps • Data Transformations • Cleaning data (covers many different methods) • Merging Datasets - Unpivoting Data • Combining Files from a Folder • Appending Datasets

• Creating Relationships • Handling Multiple Relationships with the Fact Table • Default Summarization of Fields • Custom Sorting of Columns • Data Types & Formatting • Optimizing Q&A - Creating Data Synonyms

• Adding Drill-Downs • Creating Drill-Through Reports • Using Focus Mode • Filtering Reports by Relative Dates • Viewing the Underlying Data Driving a Visualization • Customizing Report Visual Interactivity • Exporting Data from Power BI • Explain the Increase or Decrease in Visuals • How to Create Historical Categorical Trends • Build a Qty Shipped Vs Qty Sold Report

• Adding & Optimizing Tool Tips • Using the Format Painter • Visual Alignment Tips • Custom Page Sizing • Using Logos & Custom Icons • Making Enhancements with Shapes and Lines • Formatting Tips & Tricks • Best Practice Guidelines and Development Tips • Removing or Hiding Data Model Redundancies

• Understanding the Value Offering • Using Bookmarks for Presentations • How to use Bookmarks to Enhance the Visual Story • Switching Between Chart Types • Use Buttons or Images with Bookmarks • Creating a Report Menu Page with Bookmarks • Consolidating Report Views onto a Single Page

• Build a Time Example Intelligence Report • Introduction to DAX • •Understanding DAX Syntax • Implicit Vs Explicit Measures • Creating Calculated Measures & Calculated Columns • Understanding Base Measures & Metrics

- Sum, Average, Count, DistinctCount - Time Intelligence (MTD, QTD, YTD, Prior Year) - Understanding 'Calculate' and the filter context - IF, HasOneValue - Using a Safe Divide Function - UserRelationship Function - Using the Blank() Function

• Understanding the What-if Parameter Concepts • Build a What-if Analysis Report • DAX: 'GENERATESERIES' & 'SELECTEDVALUE' • Showcasing Other Use Cases

• How to Switch between Comparison Metrics • Creating Helper tables in Power BI • How to Capture Slicer Selections with DAX • Using the DAX 'SWITCH' Function • Creating Dynamic Headers

• Usage Scenarios • Mapping User IDs to the data model • DAX Functions for Returning Usernames • Adding Roles in Power BI Desktop • Assign Users to Power BI Security

• Understanding Row Level Security • Creating and Testing Security Roles • Publishing Models to the Cloud Service • Adding Users to Security Defined Roles • Basic Sharing of Dashboards & Reports • Creating App Workspaces • Collaborating on Reports

• Overview of the Data Gateway • Scheduling Data Refreshes • Refreshing On-Demand