Who is this program for?

<text variant="body1">This program is for you: <text variant="body1">● If you want to switch or start a career in the field of data analytics. ● If you are interested in the field of data analytics, just beginning to work with business intelligence and data analysis solutions and services, or new to Microsoft Power BI.

What background knowledge is necessary?

You don’t need any background knowledge to take this Professional Certificate. Whether you’re just starting out or a professional in a relevant field, this program can be the right fit for you.

How long does it take to complete the Professional Certificate?

<text variant="body1">It typically takes 5 months to complete the 8 courses. But some learners may go through the content faster.

What is the main benefit of a Professional Certificate?

Whether you’re looking to start a new career or change your current one, Professional Certificates help you become job ready. Apply your new skills on hands-on projects that showcase your expertise to potential employers and earn a career credential to kickstart your new career.

What will I be able to do upon completing the Professional Certificate?

<text variant="body1">Once you have completed this Professional Certificate, you’ll have built a foundational knowledge of the key concepts and tools in Power BI and how they apply to a business environment including: <text variant="body1">• The ability to implement best practices when conducting Data Analysis. <text variant="body1">• The skills to use the visualization and report capabilities of Power BI to create compelling reports and dashboards. • The ability to provide valuable data insights that help to inform business decisions.

What does a Power BI analyst do?

Power BI Data Analysts design, develop, and deploy business analytics dashboards using Microsoft Power BI. Data analysts are essential in helping organizations gain valuable insights into the expanse of data that they have, and they work closely with others in the organization to help reveal valuable information.

Data Analyst, Business Intelligence Analyst and Power BI Analyst: What’s the Difference?

Data analysts and business intelligence analysts both help drive data-driven decision-making in their organizations. Data analysts tend to work more closely with the data itself, while business intelligence analysts tend to be more involved in using the results of data analysis to address business needs and recommend solutions. The Power BI data analyst is a combination of both of these roles. They work closely with business stakeholders to identify business requirements and collaborate with enterprise data analysts and data engineers to identify and acquire data. They also transform the data, create data models, visualize data, and share assets by using Power BI. These are all highly sort after roles.

What jobs can I get with Power BI data analytics skills?

<text variant="body1">Prepare for a career as a data analyst using Power BI. The Power BI skills you learn in this program prepare you for an entry-level role as a data analyst. An entry-level role as a data analyst is a great starting point and can be the first step towards building a career as a business intelligence analyst, data scientist or data engineer.

Will I be able to complete this course online?

This course is completely online. You can access your lessons, readings, and assignments anytime and anywhere via the web or your mobile device.

Do I need to take the courses in specific order?

<text variant="body1">We highly recommend taking the courses of each certificate program in the order they are presented. The content in the courses builds on information from earlier courses. The final course contains a practice exam that assesses your knowledge of the content covered in the previous courses. As such, it makes the most sense to take the courses in the order they are presented.

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.

Analysis and Visualization of Data with Power BI

4 days left! Save on skills that make you shine with 40% off 3 months of Coursera Plus. Save now

Analysis and Visualization of Data with Power BI

This course is part of multiple programs.

Instructor: Microsoft

7,540 already enrolled

Included with

Learn more

6 modules

Gain insight into a topic and learn the fundamentals.

24 reviews

Beginner level

Recommended experience

3 weeks to complete

at 10 hours a week

Flexible schedule

Learn at your own pace

6 modules

Gain insight into a topic and learn the fundamentals.

24 reviews

Beginner level

Recommended experience

3 weeks to complete

at 10 hours a week

Flexible schedule

Learn at your own pace

What you'll learn

How to add visualizations to reports and dashboards.
How to design accessible reports and dashboards.
How to use visualizations to perform data analysis.

Skills you'll gain

Tools you'll learn

Details to know

Shareable certificate

Add to your LinkedIn profile

Assessments

26 assignments

Taught in English

See how employees at top companies are mastering in-demand skills

Learn more about Coursera for Business

logos of Petrobras, TATA, Danone, Capgemini, P&G and L'Oreal

Build your subject-matter expertise

This course is available as part of

When you enroll in this course, you'll also be asked to select a specific program.

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

There are 6 modules in this course

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.

Module details

In this module, you'll be introduced to using visualization and reports in Microsoft Power BI to present data to stakeholders.

What's included

16 videos24 readings6 assignments2 discussion prompts

16 videosTotal 100 minutes

Course introduction5 minutes
Analysis for Business Intelligence7 minutes
What are visualizations?7 minutes
Common visualizations7 minutes
Creating a basic report7 minutes
Table visualization5 minutes
Bar and column charts7 minutes
Line and area charts7 minutes
Combo charts6 minutes
Pie and donut charts6 minutes
Treemaps6 minutes
Displaying Key Performance Indicators5 minutes
Ribbon and waterfall charts6 minutes
Funnel charts6 minutes
Scatter charts8 minutes
Module summary: Creating Reports5 minutes

24 readingsTotal 260 minutes

Course syllabus10 minutes
How to be successful in this course10 minutes
How to open an image in a new tab10 minutes
Setting up your Power BI environment10 minutes
Setting up Power BI Service10 minutes
New name for Power BI datasets10 minutes
Business intelligence cheatsheet10 minutes
How to locate your downloaded files10 minutes
Additional resources: Key concepts5 minutes
Explore business report types10 minutes
Report Editor in Power BI10 minutes
Visualizations pane10 minutes
Exercise: Create a sales report30 minutes
Exemplar: Create a sales report10 minutes
Pinning visualizations10 minutes
Additional resources: Introducing Visualizations5 minutes
Activity: Using bars, columns, and lines10 minutes
Activity: Enhance the report with brand information10 minutes
Targeted use of charts10 minutes
Additional resources: Basic Visualizations5 minutes
Exercise: Indicating business performance30 minutes
Exemplar: Indicating business performance10 minutes
Matrix visualization10 minutes
Additional resources: Specialist Visualizations5 minutes

6 assignmentsTotal 94 minutes

Self-review: Create a sales report9 minutes
Knowledge check: Introducing Visualizations15 minutes
Knowledge check: Basic Visualizations15 minutes
Self-review: Indicating business performance10 minutes
Knowledge check: Specialist Visualizations15 minutes
Module quiz: Creating Reports30 minutes

2 discussion promptsTotal 20 minutes

Discussion prompt: What do you hope to learn?10 minutes
How would visualizing data help in business scenarios?10 minutes

In this module, you will discover how to improve accessibility and user experience in reports.

What's included

15 videos10 readings5 assignments1 discussion prompt

15 videosTotal 90 minutes

Accessibility in reports7 minutes
Formatting and configuring visualizations7 minutes
Conditional formatting6 minutes
Working with themes6 minutes
Adding custom tooltips7 minutes
Report hierarchies7 minutes
Report drillthrough5 minutes
Sorting and filtering data in reports7 minutes
Cross-filter and cross-highlight6 minutes
Adding slicers7 minutes
Adding buttons5 minutes
Adding bookmarks5 minutes
Group and layer visuals5 minutes
DAX filter context in visualizations6 minutes
Module summary: Navigation and Accessibility6 minutes

10 readingsTotal 125 minutes

Design best practices10 minutes
Activity: Creating an accessible report30 minutes
Activity: Improving accessibility with tooltips10 minutes
Additional resources: Designing an Accessible Report5 minutes
Activity: Sorting and filtering a report10 minutes
Additional resources: Report Navigation and Filtering5 minutes
Adding URLs10 minutes
Exercise: Creating an interactive report30 minutes
Exemplar: Creating an interactive report10 minutes
Additional resources: Interactive Report5 minutes

5 assignmentsTotal 85 minutes

Knowledge check: Designing an Accessible Report15 minutes
Knowledge check: Report Navigation and Filtering15 minutes
Self-review: Creating an interactive report10 minutes
Knowledge check: Interactive Report15 minutes
Module quiz: Navigation and Accessibility30 minutes

1 discussion promptTotal 10 minutes

What type of reports will you create for the different types of users that you interact with?10 minutes

In this module, you'll be introduced to dashboards and how they differ from reports, as well as publishing and exporting reports.

What's included

11 videos13 readings7 assignments1 discussion prompt

11 videosTotal 71 minutes

What is a dashboard?6 minutes
Creating a dashboard5 minutes
Improving usability in dashboards6 minutes
Limitations of pinned visuals6 minutes
Publishing reports4 minutes
Pagination and exporting reports4 minutes
Introduction to the Performance Analyzer6 minutes
Resolving performance issues in DAX8 minutes
Using variables for performance8 minutes
Using variables for troubleshooting8 minutes
Module summary: Bringing Data to the User8 minutes

13 readingsTotal 180 minutes

Activity: Preparing a simple workspace10 minutes
Exercise: Building a dashboard30 minutes
Exemplar: Building a dashboard10 minutes
Additional resources: Creating Dashboards5 minutes
Report page properties10 minutes
Exercise: Sharing a report30 minutes
Exemplar: Sharing a report10 minutes
Activity: Analyze in Excel10 minutes
Additional resources: Sharing with Stakeholders10 minutes
Tuning report performance10 minutes
Exercise: Improving DAX performance30 minutes
Exemplar: Improving DAX performance10 minutes
Additional resources: Optimizing Reports5 minutes

7 assignmentsTotal 105 minutes

Self-review: Building a dashboard10 minutes
Knowledge check: Creating Dashboards15 minutes
Self-review: Sharing a report10 minutes
Knowledge check: Sharing with Stakeholders15 minutes
Self-review: Improving DAX performance10 minutes
Knowledge check: Optimizing Reports15 minutes
Module quiz: Bringing Data to the User30 minutes

1 discussion promptTotal 10 minutes

How will you use Power BI to share your data effectively?10 minutes

In this module, you'll be introduced to data analysis. You'll explore how to use visualizations and AI in Microsoft Power BI to perform an analysis of data.

What's included

13 videos14 readings6 assignments1 discussion prompt

13 videosTotal 79 minutes

Introduction to analytics7 minutes
Statistical summary7 minutes
Group and bin data for analysis7 minutes
Histograms and Top N7 minutes
Clustering techniques7 minutes
Continuous and categorical axes6 minutes
Using the Analyze feature6 minutes
Conducting a time series analysis6 minutes
Creating reference lines7 minutes
Forecasting6 minutes
Key Influencers5 minutes
Decomposition trees6 minutes
Module summary: Identifying Patterns and Trends4 minutes

14 readingsTotal 185 minutes

Statistics cheatsheet10 minutes
Activity: Performing an analysis10 minutes
Additional resources: Perform Analytics in Power BI5 minutes
Time series analysis10 minutes
Activity: Using the Play Axis visualization30 minutes
Error bars10 minutes
Exercise: Explaining the increase30 minutes
Exemplar: Explaining the increase10 minutes
Activity: Forecasting sales10 minutes
Additional resources: Analytical Tools in Power BI5 minutes
Q&A visualization10 minutes
Exercise: Root cause analysis30 minutes
Exemplar: Root cause analysis10 minutes
Additional resources: Working with AI Visuals5 minutes

6 assignmentsTotal 102 minutes

Knowledge check: Perform Analytics in Power BI15 minutes
Self-review: Explaining the increase12 minutes
Knowledge check: Analytical Tools in Power BI15 minutes
Self-review: Root cause analysis15 minutes
Knowledge check: Working with AI Visuals15 minutes
Module quiz: Identifying Patterns and Trends30 minutes

1 discussion promptTotal 10 minutes

How will you use data visualization to bring your data to life?10 minutes

What's included

1 reading

In this module, you will be assessed on the key skills covered in the Course. This module provides a summary of the course and reflects on the primary learning objectives. The module also contains the project for the course which encapsulates the learning into a practical whole.

What's included

2 videos4 readings2 assignments1 discussion prompt

2 videosTotal 12 minutes

Course recap: Data Analysis and Visualization with Power BI7 minutes
Congratulations4 minutes

4 readingsTotal 60 minutes

About the final project and assessment: Data Analysis and Visualization with Power BI10 minutes
Exercise: Adventure Works executive summary30 minutes
Exemplar: Adventure Works executive summary10 minutes
Next steps10 minutes