Power BI Data Analyst (PL-300) 3 Days (24 hours) Microsoft Instructor-Led Training $450 per person per day
Day 1: Introduction to Power BI and Data Preparation Module 1: Discover Data Analysis Learn about the roles in data, tasks of a data analyst
Module 2: Get Started Building with Power BI Use Power BI, building blocks of Power BI, tour and use the Power BI service
Module 3: 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
Module 4: 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
Module 5: Design a Data Model in Power BI Create common data tables, configure relationships, resolve circular relationships, design star schemas
Module 6: Add Measures to Power BI Desktop Models Implicit and explicit measures create simple, compound, and quick measures, and calculate columns vs measures
Module 7: Add Calculated Tables and Columns to Power BI Desktop Models Create calculated tables and columns, define row context, use DAX calculations for date tables
Module 8: Use DAX Time Intelligence Functions in Power BI Desktop Models Define and apply time intelligence, use DAX time functions for calculations
Day 2: Data Modeling and DAX Calculations Module 9: Optimize a Model for Performance in Power BI Review performance, improve measures, reduce cardinality, optimize DirectQuery models, and manage aggregations
Module 10: Enforce Power BI Model Security Restrict access to Power BI model data, restrict access to Power BI model objects, apply good modeling practices
Module 11: Scope Report Design Requirements Identify the audience, determine report types, define user interface requirements, define user experience requirements, and explore report designs
Module 12: 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, and work with key performance indicators
Module 13: Configure Power BI Report Filters 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
Module 14: Enhance Power BI Report Designs for the User Experience Design reports to show details, design reports to highlight values, design reports that behave like apps, work with bookmarks, design reports for navigation, work with visual headers, design reports with built-in assistance, tune report performance, optimize reports for mobile use
Module 15: Perform Analytics in Power BI Explore statistical summary, identify outliers with Power BI visuals, group and bin data, apply clustering techniques, conduct time series analysis, use the Analyze feature, create what-if parameters, use specialized visuals
Module 16: Create Paginated Reports Get data, create a paginated report, work with charts on the report, publish the report
Day 3: Report Design, Analytics, and Deployment Module 17: 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
Module 18: 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)
Module 19: Create Dashboards in Power BI Configure data alerts, explore data by asking questions, review Quick insights, add a dashboard theme, pin a live report page to a dashboard, configure a real-time dashboard, set mobile view
Module 20: Implement Row-Level Security Configure row-level security with the static method, configure row-level security with the dynamic method