Lorsque vous vous inscrivez à ce cours, vous êtes également inscrit(e) à cette Spécialisation.
Apprenez de nouveaux concepts auprès d'experts du secteur
Acquérez une compréhension de base d'un sujet ou d'un outil
Développez des compétences professionnelles avec des projets pratiques
Obtenez un certificat professionnel partageable
Il y a 5 modules dans ce cours
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.
Inclus
15 vidéos20 lectures6 devoirs
Afficher les informations sur le contenu du module
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.
Inclus
15 vidéos10 lectures5 devoirs1 sujet de discussion
Afficher les informations sur le contenu du module
15 vidéos•Total 90 minutes
Accessibility in reports•7 minutes
Formatting and configuring visualizations•7 minutes
Conditional formatting•6 minutes
Working with themes•6 minutes
Adding custom tooltips•7 minutes
Report hierarchies•7 minutes
Report drillthrough•5 minutes
Sorting and filtering data in reports•7 minutes
Cross-filter and cross-highlight•6 minutes
Adding slicers•7 minutes
Adding buttons•5 minutes
Adding bookmarks•5 minutes
Group and layer visuals•5 minutes
DAX filter context in visualizations•6 minutes
Module summary: Navigation and Accessibility•6 minutes
10 lectures•Total 125 minutes
Design best practices•10 minutes
Activity: Creating an accessible report•30 minutes
Activity: Improving accessibility with tooltips•10 minutes
Additional resources: Designing an Accessible Report•5 minutes
Activity: Sorting and filtering a report•10 minutes
Additional resources: Report Navigation and Filtering•5 minutes
Adding URLs•10 minutes
Exercise: Creating an interactive report•30 minutes
Exemplar: Creating an interactive report•10 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
Module quiz: Navigation and Accessibility•30 minutes
1 sujet de discussion•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 heures à terminer
Détails du module
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.
Inclus
11 vidéos13 lectures7 devoirs1 sujet de discussion
Afficher les informations sur le contenu du module
11 vidéos•Total 71 minutes
What is a dashboard?•6 minutes
Creating a dashboard•5 minutes
Improving usability in dashboards•6 minutes
Limitations of pinned visuals•6 minutes
Publishing reports•4 minutes
Pagination and exporting reports•4 minutes
Introduction to the Performance Analyzer•6 minutes
Resolving performance issues in DAX•8 minutes
Using variables for performance•8 minutes
Using variables for troubleshooting•8 minutes
Module summary: Bringing Data to the User•8 minutes
Knowledge check: Sharing with Stakeholders•15 minutes
Self-review: Improving DAX performance•10 minutes
Knowledge check: Optimizing Reports•15 minutes
Module quiz: Bringing Data to the User•30 minutes
1 sujet de discussion•Total 10 minutes
How will you use Power BI to share your data effectively?•10 minutes
Identifying Patterns and Trends
Module 4•6 heures à terminer
Détails du module
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.
Inclus
13 vidéos14 lectures6 devoirs1 sujet de discussion
Afficher les informations sur le contenu du module
13 vidéos•Total 79 minutes
Statistical summary•7 minutes
Introduction to analytics•7 minutes
Group and bin data for analysis•7 minutes
Histograms and Top N•7 minutes
Clustering techniques•7 minutes
Continuous and categorical axes•6 minutes
Using the Analyze feature•6 minutes
Conducting a time series analysis•6 minutes
Creating reference lines•7 minutes
Forecasting•6 minutes
Key Influencers•5 minutes
Decomposition trees•6 minutes
Module summary: Identifying Patterns and Trends•4 minutes
14 lectures•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 devoirs•Total 102 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
Module quiz: Identifying Patterns and Trends•30 minutes
1 sujet de discussion•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 heures à terminer
Détails du module
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.
Inclus
1 vidéo3 lectures2 devoirs1 sujet de discussion
Afficher les informations sur le contenu du module
1 vidéo•Total 7 minutes
Course recap: Data Analysis and Visualization with Power BI•7 minutes
3 lectures•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 devoirs•Total 105 minutes
Self-review: Adventure Works executive summary•15 minutes
Course quiz: Data Analysis and Visualization with Power BI•90 minutes
1 sujet de discussion•Total 10 minutes
Reflect on learning•10 minutes
Obtenez un certificat professionnel
Ajoutez ce titre à votre profil LinkedIn, à votre curriculum vitae ou à votre CV. Partagez-le sur les médias sociaux et dans votre évaluation des performances.
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.
Pour quelles raisons les étudiants sur Coursera nous choisissent-ils pour leur carrière ?
Felipe M.
Étudiant(e) depuis 2018
’Pouvoir suivre des cours à mon rythme à été une expérience extraordinaire. Je peux apprendre chaque fois que mon emploi du temps me le permet et en fonction de mon humeur.’
Jennifer J.
Étudiant(e) depuis 2020
’J'ai directement appliqué les concepts et les compétences que j'ai appris de mes cours à un nouveau projet passionnant au travail.’
Larry W.
Étudiant(e) depuis 2021
’Lorsque j'ai besoin de cours sur des sujets que mon université ne propose pas, Coursera est l'un des meilleurs endroits où se rendre.’
Chaitanya A.
’Apprendre, ce n'est pas seulement s'améliorer dans son travail : c'est bien plus que cela. Coursera me permet d'apprendre sans limites.’
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.