What background knowledge is necessary to enroll in this course?

There is no specific background knowledge required to enroll in this course. However, basic familiarity with data concepts such as tables, columns, and basic Excel functions will be helpful. The course is designed for beginners, so no prior experience with Power BI or data analysis is necessary.

Who is this course for?

This course is ideal for beginners and professionals who want to learn how to use Power BI for data analysis, reporting, and visualization. It’s suited for business analysts, data analysts, and anyone involved in decision-making processes who needs to understand and present data insights effectively.

How long does it take to complete the course?

The course consists of 7 hours of video content, but the time required to complete it will depend on your learning pace. It’s recommended to take your time with hands-on exercises to solidify the concepts, so you can expect it to take slightly longer than the video duration.

Can I preview a course before enrolling?

Yes, you can preview the first video and view the syllabus before you enroll. You must purchase the course to access content not included in the preview.

When will I have access to the lectures and assignments?

If you decide to enroll in the course before the session start date, you will have access to all of the lecture videos and readings for the course. You’ll be able to submit assignments once the session starts.

What will I get when I enroll?

Once you enroll and your session begins, you will have access to all videos and other resources, including reading items and the course discussion forum. You’ll be able to view and submit practice assessments, and complete required graded assignments to earn a grade and a Course Certificate.

When will I receive my Course Certificate?

If you complete the course successfully, your electronic Course Certificate will be added to your Accomplishments page - from there, you can print your Course Certificate or add it to your LinkedIn profile.

Why can’t I audit this course?

This course is currently available only to learners who have paid or received financial aid, when available.

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.

Master in Microsoft Power BI Desktop and Service

Master in Microsoft Power BI Desktop and Service

Instructor: Packt - Course Instructors

Included with Coursera Plus

Learn more

7 modules

Gain insight into a topic and learn the fundamentals.

Intermediate level

Recommended experience

1 week to complete

at 10 hours a week

Flexible schedule

Learn at your own pace

7 modules

Gain insight into a topic and learn the fundamentals.

Intermediate level

Recommended experience

1 week to complete

at 10 hours a week

Flexible schedule

Learn at your own pace

What you'll learn

Understand how to connect various data sources to Power BI.
Master Power Query for cleaning and transforming data efficiently.
Create and manage complex data models and relationships in Power BI.
Design interactive, insightful reports and dashboards using Power BI.

Skills you'll gain

Details to know

Shareable certificate

Add to your LinkedIn profile

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

There are 7 modules in this course

This course features Coursera Coach!

A smarter way to learn with interactive, real-time conversations that help you test your knowledge, challenge assumptions, and deepen your understanding as you progress through the course. In this comprehensive course, you will gain a deep understanding of Microsoft Power BI and how to effectively use it for data analysis and visualization. The course covers everything from basic business intelligence concepts to more advanced topics such as data modeling, DAX functions, and creating interactive dashboards. By mastering these skills, you'll be able to make informed business decisions using powerful visualizations and data insights. The course begins with an introduction to business intelligence concepts, followed by detailed instructions on setting up and connecting Power BI with various data sources such as Excel, SQL Server, and web pages. You will then delve into Power Query for data transformation, learning how to manipulate and clean your data. As you continue, you'll explore data modeling techniques, building relationships between different data sets, and mastering DAX functions for creating calculated columns and measures. The course also covers visualization techniques, including creating tables, charts, and maps, and how to format and customize your reports for maximum impact. Finally, you'll learn how to publish and share your reports via Power BI Service, including setting up dashboards and using row-level security. This course is perfect for individuals looking to enhance their data analysis skills and gain a strong foundation in Power BI. Whether you're a business analyst, data professional, or someone looking to upskill in data visualization, this course will take you through the essential concepts and tools in Power BI. By the end of the course, you will be able to connect Power BI to multiple data sources, transform data using Power Query, build complex data models and relationships, create detailed reports and dashboards, and publish them securely using Power BI Service.

In this module, we will explore the essentials of Business Intelligence and how Microsoft Power BI empowers professionals to derive insights from data. We will break down BI concepts, data warehousing, and ETL processes in simple terms. Finally, you will get hands-on with Power BI Desktop installation, interface navigation, and connecting to multiple data sources.

What's included

5 videos1 reading

In this module, we will teach you how to connect Power BI to various data sources. You will learn how to import data from Excel, CSV files, SQL Server, and even directly from webpages. We’ll also cover how to enter data manually into Power BI Desktop, ensuring you’re ready to work with multiple data formats.

What's included

5 videos1 assignment1 plugin

5 videosTotal 17 minutes

Connect to Excel in Power BI Desktop5 minutes
Connect to CSV Files in Power BI Desktop3 minutes
Connect to SQL Server in Power BI Desktop1 minute
Connect to a Webpage from Power BI Desktop4 minutes
Enter Data Directly into Power BI Desktop3 minutes

1 assignmentTotal 15 minutes

Connecting Power BI with Different Data Sources - Assessment15 minutes

1 pluginTotal 15 minutes

Connecting Data Sources in Power BI15 minutes

In this module, we will dive deep into Power Query, the tool that allows you to prepare and transform your data before analysis. You’ll learn to clean and modify your data, perform calculations, merge queries, and create hierarchical structures. This section is designed to give you the skills to shape your data to meet your analysis needs.

What's included

10 videos1 assignment1 plugin

10 videosTotal 95 minutes

Introduction to Power Query2 minutes
Query Editor12 minutes
Text Transformations18 minutes
Number Column Calculations5 minutes
Data Type6 minutes
Date and Time Calculations13 minutes
Append Queries and Merge Queries20 minutes
Data Source Settings and Refresh Settings4 minutes
Power Query Data Formatting8 minutes
Hierarchy Creation in Power BI4 minutes

1 assignmentTotal 15 minutes

Power Query for Data Transformation - Assessment15 minutes

1 pluginTotal 15 minutes

Transforming Data in Power BI with Power Query15 minutes

In this module, we will introduce you to data modeling within Power BI. You’ll understand the importance of relationships between data tables, learn to build and manage these relationships, and explore the Snowflake Schema. By the end of this section, you’ll be able to create and optimize complex data models for analysis.

What's included

6 videos1 assignment1 plugin

6 videosTotal 33 minutes

Data Modeling Introduction3 minutes
Primary key Versus Foreign Key2 minutes
Relationship build, Edit, Delete8 minutes
Snowflake Scheme4 minutes
Active Versus Inactive relationship4 minutes
Relationship Primary Key with Multiple Foreign Keys from Different Data9 minutes

1 assignmentTotal 15 minutes

Power BI Data Modeling – Relationship View and PowerPivot - Assessment15 minutes

1 pluginTotal 15 minutes

Understanding Data Relationships in Power BI15 minutes

In this module, we will focus on DAX (Data Analysis Expressions), the powerful language behind Power BI’s calculations. You will learn how to create calculated columns, measures, and use various DAX functions to manipulate and analyze data. We’ll also cover time intelligence functions and ranking, taking your data analysis to the next level.

What's included

13 videos1 assignment1 plugin

13 videosTotal 90 minutes

Introduction to Data Analysis DAX)3 minutes
Creating Calculated Columns, Creating Measures8 minutes
DAX Date and Time Functions10 minutes
DAX Text Functions6 minutes
DAX Logical Functions13 minutes
DAX Related Function9 minutes
DAX Implicit Versus Explicit Measures3 minutes
DAX Statistical Functions1 minute
DAX Filter Functions7 minutes
DAX X-factor Functions5 minutes
DAX Time Intelligence Functions10 minutes
DAX Rank Functions5 minutes
New Table and Quick Measure5 minutes

1 assignmentTotal 15 minutes

Data Analysis DAX- Assessment15 minutes

1 pluginTotal 15 minutes

Fundamentals of DAX Syntax and Key Functions in Power BI15 minutes

In this module, we will explore the diverse visualization options available in Power BI. You’ll learn how to customize your reports using various charts, maps, KPIs, and slicers. We’ll also cover advanced features like conditional formatting and drill-through for building interactive, dynamic reports that provide deep insights.

What's included

23 videos1 assignment1 plugin

23 videosTotal 114 minutes

Introduction to Reports and Visualization Types in Power BI1 minute
Page Settings5 minutes
Getting started with color formatting and axis properties7 minutes
Customize Visualization and X-axis and Y-axis properties8 minutes
Filters in Power BI5 minutes
Slicers in Power BI6 minutes
Table and Matrix4 minutes
Conditional Formatting on Visuals4 minutes
Card and Multi-Row Card12 minutes
Treemap2 minutes
Combo Chart3 minutes
Line chart, Area chart, and Stacked area chart2 minutes
Gauge chart7 minutes
KPI5 minutes
Drill through4 minutes
Map and Filled map6 minutes
Pie chart and Doughnut charts3 minutes
Ribbon charts4 minutes
Waterfall Chart3 minutes
Funnel chart2 minutes
Import Data model to Power BI desktop2 minutes
Phone layout2 minutes
Bookmark7 minutes

1 assignmentTotal 15 minutes

Reports and Visualization Types in Power BI - Assessment15 minutes

1 pluginTotal 15 minutes

Creating and Formatting Power BI Visuals and Filters15 minutes

In this module, we will walk you through the process of publishing and sharing your reports in Power BI Service. You’ll learn how to create dashboards, analyze data in Excel, and use powerful features like usage metrics and Row-Level Security to control access. By the end of this section, you’ll have the skills to publish and manage reports effectively in Power BI Service.

What's included

17 videos3 assignments

17 videosTotal 77 minutes

Comparing Power BI Desktop and Power BI Service3 minutes
Sign in to Power BI3 minutes
Power BI Service walkthrough5 minutes
Publishing a report from Power BI Desktop to Power BI Service7 minutes
Create a Dashboard in Power BI Service5 minutes
Power BI Service Workspace UI4 minutes
Edit a Report in Power BI Service4 minutes
Power BI Report - Reading View14 minutes
Power BI Report - Usage Metrics3 minutes
Analyze in Excel4 minutes
Power BI Report - Quick Insights2 minutes
Dashboard Walkthrough2 minutes
Adding Tile in Dashboard3 minutes
Q and A4 minutes
Dataset Settings1 minute
Get More Visuals3 minutes
Row-Level Security with Power BI4 minutes

3 assignmentsTotal 90 minutes

Full Course Practice Assessment15 minutes
Power BI Publishing - Reports - Assessment15 minutes
Full Course Assessment60 minutes

Instructor

Packt - Course Instructors

Packt

986 Courses238,111 learners

Offered by

Packt

Explore more from Data Analysis

Status: Preview
Edureka
Advanced Microsoft Power BI
Course
Status: Preview
Knowledge Accelerators
From Excel to Power BI
Course
Status: Free Trial
Microsoft
Building Powerful Reports and Dashboards in Power BI
Course
Status: Free Trial
Edureka
Data Connection and Functionalities in Power BI
Course

Why people choose Coursera for their career

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.

Learner since 2020

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

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.

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

Open new doors with Coursera Plus

Unlimited access to 10,000+ world-class courses, hands-on projects, and job-ready certificate programs - all included in your subscription

Learn more

Advance your career with an online degree

Earn a degree from world-class universities - 100% online

Explore degrees

Join over 3,400 global companies that choose Coursera for Business

Upskill your employees to excel in the digital economy

Learn more

Frequently asked questions

Microsoft Power BI is a business analytics tool that helps users visualize and share insights from their data. It enables the creation of interactive reports, dashboards, and data models. Power BI is relevant because it streamlines data analysis, making it easier for businesses to derive actionable insights from complex data, empowering informed decision-making.

This course, Master in Microsoft Power BI Desktop and Service, offers a comprehensive exploration of Power BI's capabilities, including connecting to data sources, transforming data, creating data models, building reports, and sharing them via Power BI Service. It covers both Power BI Desktop for local data visualization and Power BI Service for cloud-based collaboration, making it an all-encompassing guide to mastering the tool.

After completing this course, you will be proficient in connecting various data sources to Power BI, performing data transformations with Power Query, building complex data models using DAX (Data Analysis Expressions), creating a wide range of reports and visualizations, and sharing reports via Power BI Service. You will have the skills to perform end-to-end data analysis tasks and present your findings professionally.