Duration : 24-Hour Instructor-led Training

Course Curriculum

Module 1: Get Started with Microsoft Data Analytics

• Discover Data Analysis
  • Overview of Data Analysis
  • Roles in Data
  • Tasks of a Data Analyst
• Get Started Building the Power BI 
  • Use Power BI
  • Building Blocks of Power BI
  • Tour and Use the Power BI Service

Module 2: Prepare Data for Analysis with Power BI

•  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
• 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

Module 3: Model Data with Power BI

• Describe Power BI Desktop Model
  • Star Schema Design
  • Analytic Queries
  • Configure Report Visuals
• Choose a Power BI Model Framework
  • Describe Power BI Model Fundamentals
  • Determine When to Develop an Import Model
  • Determine When to Develop a DirectQuery Model
  • Determine When to Develop a Composite Model
  • Choose a Model Framework
• 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
• Write DAX Formulas for Power BI Desktop Models
  • Write DAX Formulas
  • DAX Data Types
  • Work with DAX Functions
  • Use DAX Operators
  • Use DAX Variables
• Add Measures to Power BI Desktop Models
  • Create Simple Measures
  • Create Compound Measures
  • Create Quick Measures
  • Compare Calculated Columns with Measures
  • 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
• Use DAX Time Intelligence Functions in Power BI Desktop Models
  • Use DAX Time Intelligence Functions
  • Additional Time Intelligence Calculations
  • Exercise – Create Advanced DAX Calculations in Power BI Desktop
• Optimize a Model for Performance in Power BI
  • Introduction to Performance Optimization
  • Review Performance of Measures, Relationships, and Visuals
  • Use Variables to Improve Performance and Troubleshooting
  • Reduce Cardinality
  • Optimize DirectQuery Models with Table-Level Storage
  • Create and Manage Aggregations
• Enforce Power BI model Security
  • Restrict Access to Power BI Model Data
  • Restrict Access to Power BI Model Objects
  • Apply Good Modeling Practices
  • Exercise: Enforce Model Security

Module 4: Build Power BI Visuals and Reports

• Scope Report Design Requirements
  • Identify the Audience
  • Determine Report Types
  • Define User Interface Requirements
  • Define User Experience Requirements
  • Explore Report Designs
• 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
• 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
• 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
  • Exercise – Enhance Power BI Reports
• Perform Analytics in Power BI
  • Introduction to Analytics
  • Explore Statistical Summary
  • Identify Outliers with Power BI Visuals
  • Group and Bin Data for Analysis
  • Apply Clustering Techniques
  • Conduct Time Series Analysis
  • Use the Analyze Feature
  • Create What-if Parameters
  • Use Specialized Visuals
  • Exercise – Perform Advanced Analytics with AI Visuals
• Create Paginated Reports
  • Introduction to Paginated Reports
  • Get Data
  • Create a Paginated Report
  • Work with Charts on the Report
  • Publish the Report

Module 5: Manage Workspaces and Datasets in Power BI

• 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
• 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
• 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
  • Exercise – Create a Power BI Dashboard
• Implement Row-level Security
  • Configure Row-level Security with the Static Method
  • Configure Row-level Security with the Dynamic Method
  • Exercise – Enforce Row-level Security in Power BI