Develop Dynamic Reports with Microsoft Power BI (DP-605)

Take this 1-day Microsoft Power BI course, Develop dynamic reports with Microsoft Power BI (DP-605), and learn to harness the power of Power BI to transform and load data, define semantic model relationships and calculations, create interactive visuals, and distribute reports seamlessly. Develop Dynamic Reports with Microsoft Power BI (DP-605) Benefits In this course, you will learn how to: Gain proficiency in retrieving data from diverse sources.  Learn advanced techniques for cleaning and transforming data.  Master the art of semantic modeling for optimized report performance.  Enhance report visualization skills for effective data communication.  Acquire expertise in report filtering and workspace management for streamlined report distribution.  Training Prerequisites Basic understanding of Data Analytics and Power BI Develop dynamic reports with Microsoft Power BI (DP-605) Training Outline Get Data in Power BI Get Data from Files  Get Data from Relational Data Sources  Create Dynamic Reports with Parameters  Get Data from a NoSQL Database  Get Data from Online Services  Select a Storage Mode  Get Data from Azure Analysis Services  Fix Performance Issues  Resolve Data Import Errors  Exercise - Prepare Data in Power BI Desktop  Check Your Knowledge  Clean, Transform, and Load Data in Power BI Shape the Initial Data  Simplify the Data Structure  Evaluate and Change Column Data Types  Combine Multiple Tables into a Single Table  Profile Data in Power BI  Use Advanced Editor to Modify M Code  Exercise - Load Data in Power BI Desktop  Check Your Knowledge  Design a Semantic Model in Power BI Work with Tables  Create a Date Table  Work with Dimensions  Define Data Granularity  Work with Relationships and Cardinality  Resolve Modeling Challenges  Exercise - Model Data in Power BI Desktop  Check Your Knowledge  Add Measures to Power BI Desktop Models Create Simple Measures  Create Compound Measures  Create Quick Measures  Compare Calculated Columns with Measures  Check Your Knowledge  Exercise - Create DAX Calculations in Power BI Desktop  Add Calculated Tables and Columns to Power BI Desktop Models Create Calculated Columns  Learn about Row Context  Choose a Technique to Add a Column  Check Your Knowledge  Design Power BI Reports Design the Analytical Report Layout  Design Visually Appealing Reports  Report Objects  Select Report Visuals  Select Report Visuals to Suit the Report Layout  Format and Configure Visualizations  Work with Key Performance Indicators  Exercise - Design a Report in Power BI Desktop  Check Your Knowledge  Configure Power BI Report Filters Introduction to Designing Reports for Filtering  Apply Filters to the Report Structure  Apply Filters with Slicers  Design Reports with Advanced Filtering Techniques  Consumption-Time Filtering  Select Report Filter Techniques  Case Study - Configure Report Filters Based on Feedback  Check Your Knowledge  Create and Manage Workspaces in Power BI Distribute a Report or Dashboard  Monitor Usage and Performance  Recommend a Development Life Cycle Strategy  Troubleshoot Data by Viewing Its Lineage  Configure Data Protection  Check Your Knowledge  Manage Semantic Models in Power BI Use a Power BI Gateway to Connect to On-Premises Data Sources  Configure a Semantic Model Scheduled Refresh  Configure Incremental Refresh Settings  Manage and Promote Semantic Models  Troubleshoot Service Connectivity  Boost Performance with Query Caching (Premium)  Check Your Knowledge