Microsoft Power BI Data Analyst

Please follow the steps to complete your e-attendance

  • Course Pre-requisite
    • Better if you have good knowledge on Azure Services : AZ-900 and PL-900
  • Get your e-books
    • Go to Skillpipe
    • Create an account 
    • Redeem your License Code (Click  for Code) and get your e-copy of the PL-300 Student Book

Module 1 Getting Started with Microsoft Data Analytics

  • Data analytics and Microsoft
  • Getting Started with Power BI

Module 2 Get Data in Power BI

  • Get Data from Various Data Sources
  • Optimize Performance
  • Resolve Data Errors

Module 3 Clean, Transform, and Load Data in Power BI

  • Data Shaping
  • Data Profiling
  • Enhance the Data Structure

Module 4 Design a Data Model in Power BI

  • Introduction to Data Modeling
  • Working with Tables
  • Dimensions and Hierarchies

Module 5 Create Model Calculations using DAX in Power BI

  • Introduction to DAX
  • Real-time Dashboards
  • Advanced DAX

Module 6 Optimize Model Performance

  • Optimize the data model for Performance
  • Optimize DirectQuery Models

Module 7 Create Reports

  • Design a Report
  • Enhance the Report

Module 8 Create Dashboards

  • Create a Dashboard
  • Real-time Dashboards
  • Enhance a Dashboard

Module 9 Perform Advanced Analytics

  • Advanced Analytics
  • Data Insights Through AI Visuals

Module 10 Create and Manage Workspaces

  • Creating Workspaces
  • Sharing and Managing Assets

Module 11 Manage Datasets in Power BI

  • Parameters
  • Datasets

Module 12 Row-level Security

  • Security in Power BI

You can find all Lab Files and Instructions here.

Instructions for starting Lab:  

Go to https://alh.learnondemand.net.

First time users:

    1. Click the Register with Training Key button
    2. Input your training key in the Register with a Training Key field
    3. Click Register
    4. This opens a registration page to create a user account. Input your registration information, and then click Save
    5. Saving your user registration opens your enrollment

Returning users:

    1. Click the Sign In button
    2. Input username and password
    3. Click Sign in
    4. Logging in opens your Current Training page
    5. Click the Redeem Training Key link
    6. Input the Training Key supplied and click the Redeem Training Key button
    7. This opens your enrollment

Please launch a test lab to check for connectivity issues and read through the instructions in the lab interface to become familiar with using it. Once class starts Launch buttons will appear beside the lab modules. For assistance anytime, click the Contact link on our website or click here https://alh.learnondemand.net/Home/Contact to go to the page now.

Delicious Pizza

Sample Dashboard:

Dataset:

Cyber Security Breaches Dashboard

Sample Dashboard:

Dataset & Files:

Click here[ Code > Download Zip ]

Last Day Feedback :

(Important for your course completion Certificate)

Microsoft Feedback :