Microsoft Power BI Data Analyst

Launch your career as a Power BI analyst. Build job-ready skills – and must-have AI skills – for an in-demand career. Earn a credential from Microsoft. No prior experience required.

Instructor: Microsoft

Beginner Level • 3 weeks at 10 hours a week • Flexible Schedule

What You'll Learn

  • Learn to use Power BI to connect to data sources and transform them into meaningful insights.
  • Prepare Excel data for analysis in Power BI using the most common formulas and functions in a worksheet.
  • Learn to use the visualization and report capabilities of Power BI to create compelling reports and dashboards.
  • Demonstrate your new skills with a capstone project and prepare for the industry-recognized Microsoft PL-300 Certification exam.

Skills You'll Gain

Excel Formulas
Power BI
Data Analysis Expressions (DAX)
Data Storage
Data Transformation
Microsoft Excel
Dashboard
Data Presentation
Microsoft Copilot
Data Storytelling
Data-Driven Decision-Making
Data Validation

Shareable Certificate

Earn a shareable certificate to add to your LinkedIn profile

Outcomes

  • Receive professional-level training from Microsoft
  • Demonstrate your proficiency in portfolio-ready projects
  • Earn an employer-recognized certificate from Microsoft
  • Qualify for in-demand job titles: Business Intelligence Analyst, Business Data Analyst, Power BI Analyst

8 courses series

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.No prior skills are needed to be successful in this course. In this course, you’ll learn how to make use of Excel in business scenarios for data analysis. You’ll also learn how to utilize formulas and functions for data analysis.  Specifically, this course will help you gain knowledge and skills for preparing data for analysis using Microsoft Excel and take you one step closer to becoming a Microsoft Power BI Analyst.  After completing this course, you’ll be able to:  • Create data in Microsoft Excel and prepare it for data analysis.  • Make use of common formulas and functions in a worksheet.  • Prepare Excel data for analysis in Power BI using functions.

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’ll learn about the role of a data analyst and the main stages involved in the data analysis process with a focus on applying them using Microsoft Power BI. After completing this course, you’ll be able to:   • Describe how data is produced and gathered in businesses and organizations.  • Outline the role of data in creating data-driven decisions and successful business outcomes.  • Classify key stages in the data analysis process.  • Recognize the skills needed by a Power BI analyst and the tools they use.  • List the tasks performed by a Power BI Data Analyst.  • Recognize the components of Power BI.  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 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 the process of Extract, Transform and Load or ETL. You will identify how to collect data from and configure multiple sources in Power BI and prepare and clean data using Power Query. You’ll also have the opportunity to inspect and analyze ingested data to ensure data integrity. After completing this course, you’ll be able to: • Identify, explain and configure multiple data sources in Power BI • Clean and transform data using Power Query • Inspect and analyze ingested data to ensure data integrity 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 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'll learn how to use Power BI to create and maintain relationships in a data model and form a model using multiple Schemas. You'll explore the basics of DAX, Power BI's expression language, and add calculations to your model to create elements and analysis in Power BI. You'll discover how to configure the model to support Power BI features for insightful visualizations, analysis, and optimization. After completing this course you'll be able to: ● Create and maintain relationships in a data model. ● Form a model using a Star Schema ● Write calculations DAX to create elements and analysis in Power BI ● Create calculated columns and measures in a model ● Perform useful time intelligence calculations in DAX ● Optimize performance in a Power BI model 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 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 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 how to creatively design dashboards, reports and charts that are easier for the audience to use. You will learn how to create cohesive business intelligence reports and dashboards, as well as what common problems to avoid. The insights that you will gain will help you to tell compelling stories using specialist chart visualizations and visual elements such as videos, streaming data and QR Codes. After completing this course, you'll be able to: ● Create compelling and cohesive reports and dashboards ● Recognize common problems in design in Power BI Reports and Dashboards ● Produce audience focused reports and dashboards ● Work in detail with specialist chart visualizations ● Use visualizations in reports ● Add elements such as videos, streaming data and QR codes to dashboards 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 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’ll learn how to deploy and maintain assets in Power BI. Through hands-on exercises, you’ll explore the process of creating, implementing, and managing Power BI workspaces.You’ll also implement security and monitoring to protect data in organizations. At the end of the course, you will complete a capstone project to showcase all your new Power BI and data analytical skills. After completing this course, you'll be able to: ● Describe how SQL is used in enterprise data analysis. ● Create and publish an app in Power BI. ● Audit usage in Reports and Dashboard. ● Manage and refresh datasets. ● Implement dynamic reports in Power BI. ● Implement security measures and alerting in a Power BI report or dashboard. ● Establish Row Level Security in a Power BI model. 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 course forms part of the Microsoft Power BI Analyst Professional Certificate. This Professional Certificate consists of a series of courses that offer a good starting point for a career in data analysis using Microsoft Power BI.This course will help you prepare for the Microsoft PL-300 exam. In this course, you’ll refresh your knowledge of all the key areas assessed in the Microsoft-certified Exam PL-300: Microsoft Power BI Data Analyst. In addition, you will prepare for the certification exam by taking a mock exam with a similar format and content as in the Microsoft PL-300 exam. You’ll also get tips and tricks, testing strategies, useful resources, and information on how to sign up for the Microsoft PL-300 proctored exam. This course is 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. Earning a Microsoft Certification is globally recognized evidence of real-world skills. After completing this course, you'll be able to: ● Prepare the data ● Model the data ● Visualize and analyze the data ● Deploy and maintain assets

Learner Testimonials

Felipe M.
Felipe M. • Learner since 2018

To be able to take courses at my own pace and rhythm has been an amazing experience. I can learn whenever it fits my schedule and mood.

Jennifer J.
Jennifer J. • Learner since 2020

I directly applied the concepts and skills I learned from my courses to an exciting new project at work.

Larry W.
Larry W. • Learner since 2021

When I need courses on topics that my university doesn't offer, Coursera is one of the best places to go.

Chaitanya A.
Chaitanya A. • Learner since 2727

Learning isn't just about being better at your job: it's so much more than that. Coursera allows me to learn without limits.