.png)
Getting started with Power BI
Instructor
What Will You Learn?
About This Course
Power BI is a powerful tool, but learning it doesn't have to be complicated. This course is designed specifically for beginners who want to build a strong foundation without getting overwhelmed.
Taught by a Senior Data Analyst and Microsoft Data Platform MVP, you will learn the industry "secrets" for mastering Microsoft Power BI and creates reports that drive business decisions. You won't just watch videos; you will step into the role of a BI Analyst for "Superstore," a global bicycle company.
Your mission? Take their raw data and turn it into a compelling, portfolio-ready dashboard. We skip the dry theory and focus entirely on the hands-on skills that will set you apart as a professional Power BI Analyst or developer.
What You Will Learn
The Pillars of Power BI: Understand the full workflow, from import to insights.
Data Cleaning (ETL): Master Power Query to clean and transform messy data effortlessly.
Data Modeling: Build professional Star Schemas and date tables to organize your data.
DAX Fundamentals: Write measures to calculate Sales, Profit, and Year-over-Year growth.
Dashboard Design: Move beyond default visuals. Create custom backgrounds, layouts, and headers.
Visual Storytelling: Use conditional formatting, slicers, and interactions to make data "speak."
Publishing: Finalize your report and share it with the world.
Who This Is For
Absolute beginners wanting to start the right way.
Excel users ready to level up.
Anyone tired of creating dull, uninspiring reports.
Requirements
Curriculum Overview
This course includes 4 modules, 43 lessons, and 4:00 hours of materials.
Introduction to the course
Download Datasets and Images
Introduction to Module 1
What is Microsoft Power BI
Explore Capabilities of Power BI
Microsoft Excel vs Power BI
Flow of work in Power BI
Introduction to Power Query
Pillars of Power BI
Walk through of Power Pillars
Installation of Power BI Desktop
Test your new knowledge
Project brief
Import sample data with Power Query
Introduction to data cleaning w/ Power Query
Basic Data transformation w/ Power Query
Dataset Review
Introduction to Data modeling
Introduction to DAX - Calculated Columns
Introduction to DAX - Calculated Tables
Introduction to DAX - Dates Table
Introduction to relationships
Further data cleaning w/ Power Query
Introduction to DAX - Measures
Creating measures table
Introduction to Power BI visuals - Background
Power BI visuals - Create and format visuals
Guided project- Background and layout
Guided Project - Header and Logo
Guided Project - Report Layout
Guided Project - Visualize KPIs
Guided Project - Total sales and profit by segment
Guided Project - Discount and Product analysis
Guided Project - Adding Slicers
Guided Project - Editing visual interactions
Guided Project - Top 3 ranking
Guided Project - Highlight top 3 products
Guided Project - Final Report
Guided Project - Sharing your report
Visual analytics 1
Visual analytics 2
Visual analytics 3
Course conclusion
Course Certificate
This Course Includes
Course Specifications
.png)
.png)
Send Course as Gift
Tags
Subscribe to Our Newsletter
Contact Us
.png)
.png)
Reply to Comment