This course was created with the
course builder. Create your online course today.
Start now
Create your course
with
Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Become A Microsoft Power BI Data Analyst
Introduction to Microsoft Data Analytics
Microsoft Data Analytics (4:51)
What is a Data Analyst
Overview of Data Analysis (8:14)
Roles in Data Analysis (9:15)
Tasks of a Data Analyst (10:38)
Power BI Setup & Microsoft 365 Setup
What is Power BI (5:47)
What is Power BI Desktop (3:40)
Install Power BI Desktop (2:55)
Exploring Power BI Desktop Interface (5:02)
Microsoft 365 Setup (3:43)
Getting started with Microsoft 365 (4:04)
Creating a new account in Microsoft 365 (2:54)
Overview of Power BI
Power BI Overview : Part 1 (4:24)
Power BI Overview : Part 2 (4:05)
Power BI Overview : Part 3 (4:49)
Changing regional settings (1:47)
Parts of Power BI (2:57)
Building Blocks of Power BI (9:31)
Exploring Power BI Service (4:29)
The flow of work in Power BI
Update data in Power BI Service
Connect, Transform, Visualize and Publish Web Data
Connect to web data (5:07)
Clean and transform data : Part 1 (7:12)
Clean and transform data : Part 2 (9:46)
Combine data sources (7:59)
Creating Data Visuals : Part 1 (6:09)
Creating Data Visuals : Part 2 (5:23)
Publish report to Power BI Service (4:47)
Transforming data in Power BI Desktop using Power Query Editor
Connect to Microsoft Access Database File (7:10)
Power Query Editors and Queries (6:49)
Creating and managing query groups (4:35)
Renaming Queries (4:54)
Splitting Columns (7:06)
Changing data types (5:47)
Removing and reordering columns (6:54)
Duplicating and adding columns (3:32)
Creating conditional columns (6:19)
Connecting to files in a folder (7:17)
Appending queries (6:58)
Merge queries (5:35)
Query dependency view (4:33)
Transform less structured data (9:10)
Creating tables (3:48)
Query Parameters (9:28)
Model Data in Power BI Desktop
What is Data Modelling (0:42)
Creating and managing data relationships (11:54)
Creating calculated columns (10:49)
Optimizing models for reporting (11:02)
Time intelligence (4:20)
Applying filters to visuals (3:19)
Microsoft SQL Server Setup
What is SQL Server (2:57)
SQL Server Editions (4:45)
SQL Server installation requirements (4:21)
Download SQL Server (4:31)
Install SQL Server (9:43)
SQL Server Configuration Manager (8:10)
Install SQL Server Management Studio - SSMS (5:49)
Restore AdventureWorksDW2020 Database (3:41)
Get data in Power BI
Introduction
Create and save a new Power BI Desktop file (2:12)
Set Power BI Desktop Options (2:05)
Get data from relational database (5:51)
Preview SQL Server queries (10:16)
Get data from CSV files (5:08)
Get additional data from a CSV file (2:51)
Clean ,Transform and Load Data in Power BI
Introduction
Shape the initial data
Configure the Salesperson query (8:31)
Configure the SalespersonRegion query (1:50)
Configure the Product query (7:22)
Configure Reseller query (4:59)
Configure the Region query (2:41)
Configure the Sales query (5:55)
Configure the Targets query (5:50)
Configure the ColorFormats query (0:42)
Update the Product query (2:33)
Update the ColorFormats query (1:49)
Model Data in Power BI Desktop
Introduction
Create model relationships (13:20)
Configure the Product table (3:37)
Configure the Region table (2:57)
Configure the Reseller table (5:20)
Configure the Sales table (2:48)
Bulk update properties (3:08)
Review the model interface (4:40)
Create quick measures (6:37)
Create a many-to-many relationship (10:03)
Relate the Target table (1:56)
Enforce row-level security (5:14)
Introduction to DAX in Power BI Desktop
What is DAX
Create the Salesperson Calculated table (7:23)
Create the Date calculated table (3:17)
Create calculated columns (6:55)
Complete the Date table (4:40)
Mark the Date table (2:22)
Create simple Measures (16:56)
Create additional measures (11:08)
Time Intelligence and Measures in DAX
Introduction
Create a matrix visual (3:53)
Manipulate filter context (15:40)
Create a YTD measure (2:47)
Create a YoY growth measure (6:45)
Publish Power BI Desktop File (4:15)
Design a report in Power BI Desktop
Create a new file (0:42)
Create a live connection (2:13)
Design page 1 (14:11)
Design page 2 (6:57)
Design page 3 (10:00)
Publish report (1:17)
Explore the report (5:23)
Configure Sync Slicers (5:21)
Configure drill through page (6:01)
Add Conditional Formatting (4:29)
Add Bookmarks to Report (5:30)
Add Buttons to Report (4:30)
Publish Updated Report (1:53)
Explore Updated Report (2:53)
Create a Power BI dashboard (Create a sales monitoring dashboard)
Create a dashboard (7:21)
Configure an alert (0:45)
Refresh the dataset (8:28)
Perform data analysis in Power BI Desktop
Create the report (0:38)
Connect to the Sales Analysis Dataset (1:19)
Create an animated scatter chart (4:50)
Create a forecast (5:31)
Work with a decomposition tree (4:37)
Work with key influencers (5:16)
Creating Paginated Reports
What are paginated reports (0:30)
Install Power BI Report Builder (2:47)
Create a blank report (1:22)
Configure the report header (4:35)
Create a data source and dataset (6:13)
Configure the report parameter (2:29)
Add textboxes to report header region (10:11)
Add a table to the report (4:35)
Format the table data region (9:46)
Finalize the report design (11:10)
Appending queries
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock