Microsoft Power BI

Microsoft Power BI | Data Visualization

This course provides the facility to learn from Industry practitioners through online Power BI training and master Power BI architecture, Desktop, Service, Mobile Apps, visualizations & reports. You will work on multiple real-life projects

Enroll $1,800.00

Course curriculum

1. Course Curriculum
2. Introduction to Power BI
3. Module 1 - Quiz
4. Knowledge Check - 1
1. Data Extraction
2. Excel Data Source
3. OData Feed Source
1. Shaping and Combining Data
2. Excel Files
3. Module 3 - Assignment
1. Data Modeling
2. Global Superstore
1. Data Visualization
2. DAX Functions 1
3. DAX Functions 2
4. Adventure Works2020.xlsx
5. DAX Exercises with SUM and COUNT
1. Power BI Service
2. Creating and Managing Power BI Workspaces
1. Power BI Solution and Direct Connectivity
1. Development with Power BI
1. Power BI Advance & Power BI Premium
1. Application 1 - E-Commerce Platform
2. Application 2 - In-Store Sales
3. 1 - Implementing a Practical Project
4. 2 - Getting Data from Databases
5. Assignment 2
6. 3 - Append Queries
7. Assignment 3
8. 4 - Calculations for Append Queries
9. Assignment 4
10. 5 - Calendar with DAX
11. Assignment 5
12. 6 - Introduction to DAX
13. DAX Functions Tutorial
14. Assignment 6 & 7
15. 7 - Ratios in DAX
16. Assignment 8
17. 8 - Iterative Functions in DAX
18. Assignment 9
19. 9 - Rank Functions & Variables
20. Assignment 10
21. 10 - What-if-Analysis
22. Assignment 11
23. 11 - Creating Drill throughs
24. Assignment 12
25. Sales - Main Dashboard
1. Business Request - Mail from Andrew
2. Business Demand Overview
3. Project Submission
1. Business Requirements
2. Files to Download
3. Portfolio 2 Assignment
1. Project 1 - Sales & Product Analysis(Excel Data)
2. P1 : Task 1 - Clean and Trasform Data
3. DAX & Measures
4. P1 : Task 2 - Join Tables using DAX Expressions
5. P1 : Task 3 - Build the report
6. P1 : Task 4 - Format the report
7. Project 2 - Country Sales Data Analysis(SQL Server Database)
8. P2 : Task 1 - Connect to SQL Server Database
9. P2 : Task 2 - Create a Report
10. Project 3 - Retirement Analysis (Web Data)
11. Project 4 - End to End Solution from Scratch - Problem Statement
1. PBI Slides - Part 1
1. Power BI Quiz
1. Getting Started : Assignment - 1
2. Assignment 1 - Outcome & Supporting Document
3. Getting Started : Assignment - 2
4. Assignment 2 - Outcome & Supporting Document
5. Getting Started : Assignment - 3
6. Power Query : Assignment - 4
7. Power Query : Assignment - 5
8. Power Query : Assignment - 6
9. Advanced Power BI : Assignment - 7
10. Advanced Power BI : Assignment - 8
1. Project 1
2. Project 2
3. Project 3

About this course

$1,800.00
79 lessons
16.5 hours of video content

Discover your potential, starting today

Enroll today

Microsoft Power BI | Data Visualization

Course curriculum

MODULE 1 - INTRODUCTION TO POWER BI

MODULE 2 - DATA EXTRACTION

MODULE 3 - SHAPING AND COMBINING DATA

MODULE 4 - DATA MODELING

MODULE 5 - DATA VISUALIZATION

MODULE 6 - POWER BI SERVICE

MODULE 7 - POWER BI SOLUTION AND DIRECT CONNECTIVITY

MODULE 8 - DEVELOPMENT WITH POWER BI

MODULE 9 - POWER BI ADVANCE & POWER BI PREMIUM

BEGINNER TO ADVANCED POWERBI PROJECT

DATA ANALYST PORTFOLIO 1 - SQL TO POWER BI

DATA ANALYST PORTFOLIO 2 - SQL TO POWER BI

LEARN BY DOING

ADDITIONAL MATERIALS

QUIZ

ASSIGNMENTS

PROJECTS

About this course

Discover your potential, starting today