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.
涵盖的内容
15个视频10篇阅读材料5个作业1个讨论话题
显示有关单元内容的信息
15个视频•总计90分钟
Accessibility in reports•7分钟
Formatting and configuring visualizations•7分钟
Conditional formatting•6分钟
Working with themes•6分钟
Adding custom tooltips•7分钟
Report hierarchies•7分钟
Report drillthrough•5分钟
Sorting and filtering data in reports•7分钟
Cross-filter and cross-highlight•6分钟
Adding slicers•7分钟
Adding buttons•5分钟
Adding bookmarks•5分钟
Group and layer visuals•5分钟
DAX filter context in visualizations•6分钟
Module summary: Navigation and Accessibility•6分钟
10篇阅读材料•总计125分钟
Design best practices•10分钟
Activity: Creating an accessible report•30分钟
Activity: Improving accessibility with tooltips•10分钟
Additional resources: Designing an Accessible Report•5分钟
Activity: Sorting and filtering a report•10分钟
Additional resources: Report Navigation and Filtering•5分钟
Adding URLs•10分钟
Exercise: Creating an interactive report•30分钟
Exemplar: Creating an interactive report•10分钟
Additional resources: Interactive Report•5分钟
5个作业•总计85分钟
Knowledge check: Designing an Accessible Report•15分钟
Knowledge check: Report Navigation and Filtering•15分钟
Self-review: Creating an interactive report•10分钟
Knowledge check: Interactive Report•15分钟
Module quiz: Navigation and Accessibility•30分钟
1个讨论话题•总计10分钟
What type of reports will you create for the different types of users that you interact with?•10分钟
Bringing Data to the User
第 3 单元•小时 后完成
单元详情
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.
涵盖的内容
11个视频13篇阅读材料7个作业1个讨论话题
显示有关单元内容的信息
11个视频•总计71分钟
What is a dashboard?•6分钟
Creating a dashboard•5分钟
Improving usability in dashboards•6分钟
Limitations of pinned visuals•6分钟
Publishing reports•4分钟
Pagination and exporting reports•4分钟
Introduction to the Performance Analyzer•6分钟
Resolving performance issues in DAX•8分钟
Using variables for performance•8分钟
Using variables for troubleshooting•8分钟
Module summary: Bringing Data to the User•8分钟
13篇阅读材料•总计180分钟
Activity: Preparing a simple workspace•10分钟
Exercise: Building a dashboard•30分钟
Exemplar: Building a dashboard•10分钟
Additional resources: Creating Dashboards•5分钟
Report page properties•10分钟
Exercise: Sharing a report•30分钟
Exemplar: Sharing a report•10分钟
Activity: Analyze in Excel•10分钟
Additional resources: Sharing with Stakeholders•10分钟
Tuning report performance•10分钟
Exercise: Improving DAX performance•30分钟
Exemplar: Improving DAX performance•10分钟
Additional resources: Optimizing Reports•5分钟
7个作业•总计105分钟
Self-review: Building a dashboard•10分钟
Knowledge check: Creating Dashboards•15分钟
Self-review: Sharing a report•10分钟
Knowledge check: Sharing with Stakeholders•15分钟
Self-review: Improving DAX performance•10分钟
Knowledge check: Optimizing Reports•15分钟
Module quiz: Bringing Data to the User•30分钟
1个讨论话题•总计10分钟
How will you use Power BI to share your data effectively?•10分钟
Identifying Patterns and Trends
第 4 单元•小时 后完成
单元详情
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.
涵盖的内容
13个视频14篇阅读材料6个作业1个讨论话题
显示有关单元内容的信息
13个视频•总计79分钟
Statistical summary•7分钟
Introduction to analytics•7分钟
Group and bin data for analysis•7分钟
Histograms and Top N•7分钟
Clustering techniques•7分钟
Continuous and categorical axes•6分钟
Using the Analyze feature•6分钟
Conducting a time series analysis•6分钟
Creating reference lines•7分钟
Forecasting•6分钟
Key Influencers•5分钟
Decomposition trees•6分钟
Module summary: Identifying Patterns and Trends•4分钟
14篇阅读材料•总计185分钟
Statistics cheatsheet•10分钟
Activity: Performing an analysis•10分钟
Additional resources: Perform Analytics in Power BI•5分钟
Time series analysis•10分钟
Activity: Using the Play Axis visualization•30分钟
Error bars•10分钟
Exercise: Explaining the increase•30分钟
Exemplar: Explaining the increase•10分钟
Activity: Forecasting sales•10分钟
Additional resources: Analytical Tools in Power BI•5分钟
Q&A visualization•10分钟
Exercise: Root cause analysis•30分钟
Exemplar: Root cause analysis•10分钟
Additional resources: Working with AI Visuals•5分钟
6个作业•总计102分钟
Knowledge check: Perform Analytics in Power BI•15分钟
Self-review: Explaining the increase•12分钟
Knowledge check: Analytical Tools in Power BI•15分钟
Self-review: Root cause analysis•15分钟
Knowledge check: Working with AI Visuals•15分钟
Module quiz: Identifying Patterns and Trends•30分钟
1个讨论话题•总计10分钟
How will you use data visualization to bring your data to life?•10分钟
Final project and assessment: Data Analysis and Visualization with Power BI
第 5 单元•小时 后完成
单元详情
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.
涵盖的内容
1个视频3篇阅读材料2个作业1个讨论话题
显示有关单元内容的信息
1个视频•总计7分钟
Course recap: Data Analysis and Visualization with Power BI•7分钟
3篇阅读材料•总计50分钟
About the final project and assessment: Data Analysis and Visualization with Power BI•10分钟
Exercise: Adventure Works executive summary•30分钟
Exemplar: Adventure Works executive summary•10分钟
2个作业•总计105分钟
Self-review: Adventure Works executive summary•15分钟
Course quiz: Data Analysis and Visualization with Power BI•90分钟
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.
Do I need prior Power BI experience for this course?
No prior Power BI experience is required. The course introduces Power BI concepts and guides learners through report creation, visualization, and data analysis techniques.
When will I have access to the lectures and assignments?
To access the course materials, assignments and to earn a Certificate, you will need to purchase the Certificate experience when you enroll in a course. You can try a Free Trial instead, or apply for Financial Aid. The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.
What will I get if I subscribe to this Specialization?
When you enroll in the course, you get access to all of the courses in the Specialization, and you earn a certificate when you complete the work. Your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile.
Is financial aid available?
Yes. In select learning programs, you can apply for financial aid or a scholarship if you can’t afford the enrollment fee. If fin aid or scholarship is available for your learning program selection, you’ll find a link to apply on the description page.