When you enroll in this course, you'll also be enrolled in this Professional Certificate.
Learn new concepts from industry experts
Gain a foundational understanding of a subject or tool
Develop job-relevant skills with hands-on projects
Earn a shareable career certificate from Microsoft
There are 5 modules in this course
This course forms part of the Microsoft Power BI Analyst Professional Certificate. This Professional Certificate consists of a series of courses that offers a good starting point for a career in data analysis using Microsoft Power BI.
In this course, you will learn report design and formatting in Power BI, which offers extraordinary visuals for building reports and dashboards. Additionally, you will learn how to use report navigation to tell a compelling, data-driven story in Power BI. You will explore how to get a statistical summary for your data and how to create and export reports in Power BI. You will also perform advanced analytics in Power BI to get deeper and more meaningful data insights.
After completing this course, you'll be able to:
● Recognize the different types of visualizations in Power BI
● Add visualizations to reports and dashboards
● Apply formatting choices to visuals
● Add useful navigation techniques to the Power BI report
● Design accessible reports and dashboards
● Use visualizations to perform data analysis
This is also a great way to prepare for the Microsoft PL-300 exam. By passing the PL-300 exam, you’ll earn the Microsoft Power BI Data Analyst certification.
This module introduces core reporting capabilities in Microsoft Power BI, focusing on selecting and building appropriate visualizations for data representation. You will learn to create, customize, and organize reports using various chart types, apply formatting, and design visuals that effectively communicate insights to stakeholders.
This module focuses on enhancing user experience by designing accessible, interactive, and easy-to-navigate reports. You will apply formatting techniques, implement filters, slicers, and drill through features, and use navigation tools like bookmarks and buttons to create intuitive and user-friendly reporting experiences.
Module quiz: Navigation and Accessibility•30 minutes
Knowledge check: Designing an Accessible Report•15 minutes
Knowledge check: Report Navigation and Filtering•15 minutes
Self-review: Creating an interactive report•10 minutes
Knowledge check: Interactive Report•15 minutes
1 discussion prompt•Total 10 minutes
What type of reports will you create for the different types of users that you interact with?•10 minutes
Bringing Data to the User
Module 3•6 hours to complete
Module details
This module explores how to deliver insights effectively through dashboards and sharing mechanisms. You will learn to design dashboards, publish and export reports, and optimize performance using tools like DAX tuning and performance analyzer, ensuring efficient and scalable data delivery to stakeholders.
Knowledge check: Sharing with Stakeholders•15 minutes
Self-review: Improving DAX performance•10 minutes
Knowledge check: Optimizing Reports•15 minutes
1 discussion prompt•Total 10 minutes
How will you use Power BI to share your data effectively?•10 minutes
Identifying Patterns and Trends
Module 4•6 hours to complete
Module details
This module introduces analytical capabilities in Power BI, enabling you to derive insights from data using statistical summaries, clustering, and time-series analysis. You will also leverage AI-powered visuals such as key influencers and decomposition trees to uncover patterns, trends, and root causes in data.
Module summary: Identifying Patterns and Trends•4 minutes
14 readings•Total 185 minutes
Statistics cheatsheet•10 minutes
Activity: Performing an analysis•10 minutes
Additional resources: Perform Analytics in Power BI•5 minutes
Time series analysis•10 minutes
Activity: Using the Play Axis visualization•30 minutes
Error bars•10 minutes
Exercise: Explaining the increase•30 minutes
Exemplar: Explaining the increase•10 minutes
Activity: Forecasting sales•10 minutes
Additional resources: Analytical Tools in Power BI•5 minutes
Q&A visualization•10 minutes
Exercise: Root cause analysis•30 minutes
Exemplar: Root cause analysis•10 minutes
Additional resources: Working with AI Visuals•5 minutes
6 assignments•Total 102 minutes
Module quiz: Identifying Patterns and Trends•30 minutes
Knowledge check: Perform Analytics in Power BI•15 minutes
Self-review: Explaining the increase•12 minutes
Knowledge check: Analytical Tools in Power BI•15 minutes
Self-review: Root cause analysis•15 minutes
Knowledge check: Working with AI Visuals•15 minutes
1 discussion prompt•Total 10 minutes
How will you use data visualization to bring your data to life?•10 minutes
Final project and assessment: Data Analysis and Visualization with Power BI
Module 5•3 hours to complete
Module details
This module consolidates learning through a comprehensive project where you design and present a complete data analysis solution. You will apply reporting, visualization, navigation, and analytical techniques to create an executive-level output, followed by a final assessment to evaluate your overall proficiency.
What's included
1 video3 readings2 assignments1 discussion prompt
Show info about module content
1 video•Total 7 minutes
Course recap: Data Analysis and Visualization with Power BI•7 minutes
3 readings•Total 50 minutes
About the final project and assessment: Data Analysis and Visualization with Power BI•10 minutes
Exercise: Adventure Works executive summary•30 minutes
Exemplar: Adventure Works executive summary•10 minutes
2 assignments•Total 105 minutes
Self-review: Adventure Works executive summary•15 minutes
Course quiz: Data Analysis and Visualization with Power BI•90 minutes
1 discussion prompt•Total 10 minutes
Reflect on learning•10 minutes
Earn a career certificate
Add this credential to your LinkedIn profile, resume, or CV. Share it on social media and in your performance review.
Instructor
Instructor ratings
Instructor ratings
We asked all learners to give feedback on our instructors based on the quality of their teaching style.
Our goal at Microsoft is to empower every individual and organization on the planet to achieve more.
In this next revolution of digital transformation, growth is being driven by technology. Our integrated cloud approach creates an unmatched platform for digital transformation. We address the real-world needs of customers by seamlessly integrating Microsoft 365, Dynamics 365, LinkedIn, GitHub, Microsoft Power Platform, and Azure to unlock business value for every organization—from large enterprises to family-run businesses. The backbone and foundation of this is Azure.
What will I actually learn in this Power BI course?
You'll learn how to turn data into clear Power BI reports and dashboards, and how to use those visuals to answer business questions. It starts with common chart types and report building, then moves into accessibility, navigation, sharing, and deeper analysis features. In the exercises, you'll create reports, add interactive filtering, and build an executive summary dashboard.
Do I need any Power BI experience before starting?
No, you don't need prior Power BI experience. The course begins with setting up Power BI Desktop and Power BI Service, then quickly moves into creating reports and visualizations. Some comfort reading charts and working with data will help, but it doesn't assume you've used the platform before.
Is this Power BI course beginner-friendly?
Yes, this is a good beginner course if you're new to Power BI and want a step-by-step introduction to visual reporting and analysis. The lessons start with common visualizations and basic report creation, then build toward dashboards, accessibility, and interactive features. If you already use Power BI regularly and mainly want deep advanced techniques, the early part may feel basic.
How long does it take to complete this course?
Plan on about 29 hours in total. At around 10 hours a week, that comes to roughly three weeks of steady work. The course includes lessons, readings, guided activities, and quizzes, so the workload mixes learning new features with practicing them.
Are there hands-on exercises or projects in this course?
Yes, there's plenty of hands-on practice, though it's mostly guided exercises rather than open-ended projects. You'll work through activities such as creating a sales report, improving report accessibility, building an interactive report, and assembling a dashboard. That format helps you apply each feature as you learn it instead of only reading about it.
What skills and topics does the course cover?
The course focuses on creating effective reports and dashboards, making them easier to navigate and share, and using Power BI's analysis tools to spot patterns in data. You'll practice choosing and formatting visuals, adding filtering and drillthrough, publishing and exporting reports, and using features like forecasting or Key Influencers to investigate trends. Overall, it gives you a rounded view of how Power BI supports both communication and analysis.
What can I actually do after finishing?
After finishing, you should be able to build a clear Power BI report or dashboard that others can explore and understand. For example, you could create a sales report with accessible formatting, interactive filtering, and views that help stakeholders drill into more detail. You'll also be able to use built-in analysis features to explain changes, spot trends, and share the results.
Is it more theory or hands-on learning?
It's best described as concept-first with guided practice. You'll spend a lot of time applying what you learn, but usually after a lesson shows you how the feature works, so it suits learners who want explanation before practice.
Why choose this course over other Power BI courses?
Choose this course if you want a beginner Power BI class that goes beyond making charts. It walks through the full reporting workflow, from designing accessible reports and dashboards to sharing them and using built-in analytics and AI visuals to investigate patterns. It's a strong fit for learners who want both report-building skills and a clearer sense of how to turn visuals into usable insights.