Microsoft Power BI Data Analyst
e-Attendance
Please follow the steps to complete your e-attendance
- Click this link
- Get your Student ID
- Class ID: 36083
- User Guide
Prerequisite
- Course Pre-requisite
- 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
Course Outline
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
Azure Services
- Explore Azure Services here
- Deep dive through Azure Fundamentals aka.ms/HN/learnaz
Presentation Files
- PL-300 Mod0 Introduction
- PL-300 Mod1 Getting Started
- PL-300 Mod2 Get Data
- PL-300 Mod3 Clean Transform Load Data
- PL-300 Mod4 Design a Data Model
- PL-300 Mod5 Create Model Calculations
- PL-300 Mod6 Optimize Model Performance
- PL-300 Mod7 Create Reports
- PL-300 Mod8 Create Dashboards
- PL-300 Mod9 Identify Patterns and Trends
- PL-300 Mod10 Create and Manage Workspaces
- PL-300 Mod11 Manage Datasets
- PL-300 Mod12 Row-Level Security
Lab Files
You can find all Lab Files and Instructions here.
Instructions for starting Lab:
Go to https://alh.learnondemand.net.
First time users:
-
- Click the Register with Training Key button
- Input your training key in the Register with a Training Key field
- Click Register
- This opens a registration page to create a user account. Input your registration information, and then click Save
- Saving your user registration opens your enrollment
Returning users:
-
- Click the Sign In button
- Input username and password
- Click Sign in
- Logging in opens your Current Training page
- Click the Redeem Training Key link
- Input the Training Key supplied and click the Redeem Training Key button
- 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.
Practice Session ( Cyber Security Breaches Analysis )
Cyber Security Breaches Dashboard
Sample Dashboard:
Dataset & Files:
Click here ! [ Code > Download Zip ]