From Excel to Power BI

This course is part of Excel to Power BI: Data Analysis & Business Intelligence Specialization

Instructor: Keith Gibson

Access provided by Talent Beyond Boundaries

302,613 already enrolled

6 modules

Gain insight into a topic and learn the fundamentals.

1,720 reviews

Beginner level

Recommended experience

Flexible schedule

4 hours to complete

Learn at your own pace

96%

Most learners liked this course

6 modules

Gain insight into a topic and learn the fundamentals.

1,720 reviews

Beginner level

Recommended experience

Flexible schedule

4 hours to complete

Learn at your own pace

96%

Most learners liked this course

What you'll learn

Import, model and analyze data in Power BI
Build interactive Power BI dashboards
Design professional BI visuals with real world scenarios

Skills you'll gain

Tools you'll learn

Details to know

Shareable certificate

Add to your LinkedIn profile

Assessments

18 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 part of the Excel to Power BI: Data Analysis & Business Intelligence Specialization

When you enroll in this course, you'll also be enrolled in this Specialization.

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

This course teaches Power BI dashboards, data modeling, and business intelligence reporting using real-world data. Power BI may seem like a more advanced environment, but many of its tools and concepts will feel familiar to Excel users. With this foundational course, you’ll learn how to model data, create effective visualizations, and make data-driven business decisions using large volumes of data in Power BI.

We will help you build core Power BI knowledge and skills*, including: • Importing data from Excel and other locations into Power BI. • Understanding the Power BI environment and its three Views. • Building beginner-to-moderate level skills for navigating the Power BI product. • Exploring influential relationships within datasets. • Designing Power BI visuals, reports, and dashboards. • Sharing, presenting, and collaborating on dashboards in Power BI Service. * Please note that the full range of features are only available while using Microsoft Work/School accounts Who Should Take This Course: - Business students - Small business owners - Business and operations professionals - Analysts and project managers - Anyone interested in making data-driven business decisions Course duration is approximately four hours. Learning is divided into five modules, the sixth being a cumulative assessment. The curriculum design includes video lessons, interactive learning using short, how-to video tutorials, and practice opportunities using COMPLEMENTARY DATASETS. Join us as you begin your journey in Business Intelligence with Power BI. This course is designed for professionals using Microsoft 365 in a workplace environment. Some features may require a business/enterprise subscription. Please note that Microsoft 365 has different versions and subscription levels, so your interface and available features may differ depending on the plan you are using.

Welcome! Power BI is a Microsoft business intelligence (BI) tool that helps you turn data into useful insights for better business decisions. If you’re familiar with Excel, you may wonder what Power BI offers that Excel doesn’t. In simple terms, Power BI analyzes your data and turns it into interactive, shareable reports and visuals that help you identify trends, explore relationships, and make informed decisions. In this course, you’ll learn the basics of Power BI, starting with how to import and clean data, so you can ultimately work with it to explore relationships, create visuals and reports, and build dashboards to share and collaborate in Power BI Service.

What's included

12 videos4 readings3 assignments

12 videosTotal 24 minutes

Understand Power BI2 minutes
Explore Power BI Licenses3 minutes
Sign In and Out of Power BI2 minutes
Learn About Data Importation and the Table View2 minutes
Get Data into Power BI3 minutes
Overview of the Table View in Power BI3 minutes
Learn How Data Cleaning and Transformation Work in Power BI2 minutes
Access the Power Query Editor2 minutes
Apply Standard Math Operations to a Column in Power Query 2 minutes
Replace Values in a Column1 minute
Replace Errors in a Column1 minute
Manage Transformed Data in the Applied Steps List3 minutes

4 readingsTotal 8 minutes

A Note on Power BI Access and Course Contact Information2 minutes
STOP & Download a Sample Dataset1 minute
A Few Notes Regarding Power BI Interface2 minutes
Working with Data: Cleaning and Preparation3 minutes

3 assignmentsTotal 12 minutes

Jump Into the Journey: Import Your Data!5 minutes
Checkpoint: Importing, Cleaning and Transforming Data2 minutes
Jump Into the Journey: Transform and Clean Your Data5 minutes

Model your data to turn raw information into meaningful insights. Now that you’ve imported and cleaned your data, you can define relationships, track performance, and compare results to goals. In this module, you’ll learn the basics of data modeling, explore the Model View, and learn how relationships connect your data and support visualizations. You’ll also practice viewing, editing, removing, and creating relationships. Once your model is ready, you’ll move to the Report View to create visualizations such as charts, graphs, and maps. Each visual type highlights different insights, helping you communicate your data clearly.

What's included

6 videos2 readings2 assignments

6 videosTotal 13 minutes

Understand Table Relationships in Model View2 minutes
Navigate the Model View in Power BI2 minutes
View and Edit Relationships in the Model View3 minutes
Cardinality and Cross-Filter Directions in Relationships3 minutes
Edit or Remove Relationships1 minute
Add a New Relationship Between Tables and Columns2 minutes

2 readingsTotal 4 minutes

Understand the Model View in Power BI3 minutes
Creating Relationships in Model View1 minute

2 assignmentsTotal 10 minutes

Checkpoint: Model Data2 minutes
Jump Into the Journey: Practice Data Modeling8 minutes

Visualizations, or visuals, turn your data into charts, tables, and other visual representations that make insights easier to see and share. In Power BI, these visuals are created in the Report view, where you can customize them to highlight trends, compare metrics, and communicate your findings clearly. This module will introduce you to the Report view and show you how to add, format, and adjust visualizations to make your data more actionable.

What's included

7 videos2 assignments

7 videosTotal 11 minutes

Get to Know the Report View2 minutes
Overview of the Report View in Power BI2 minutes
Add a Visualization1 minute
Overview of Format Features for Visualizations2 minutes
Resize a Visualization1 minute
Delete a Visualization1 minute
Change the Visualization Type1 minute

2 assignmentsTotal 9 minutes

Checkpoint: Visualize Data 4 minutes
Jump Into the Journey: Get to Know the Report View5 minutes

Choosing the right visualization is a key step in turning data into insight. Different visuals are designed to highlight different types of information, from key metrics and trends to comparisons and relationships within your data. Understanding how and when to use each visual helps you communicate findings clearly. In this module, you’ll explore common text-based and chart-based visualizations available in Power BI. You’ll learn what these visualizations are designed to show, how to create them in the Report view, and when one visual may be more effective than another.

What's included

14 videos1 reading6 assignments

14 videosTotal 26 minutes

Understand Text Visualization Types6 minutes
Create a Card Visualization1 minute
Create a Table Visualization1 minute
Create a KPI Chart1 minute
Create a Key Influencers Chart2 minutes
Intro to Chart Visualizations2 minutes
Create a Scatter Chart2 minutes
Create a Waterfall Chart2 minutes
Create a Funnel Chart1 minute
Create a Ribbon Chart1 minute
Filters, Slicers, and Data Drilling 2 minutes
Create a Slicer1 minute
Analyze Your Visualization2 minutes
Drill Down and Drill Up in a Visualization1 minute

1 readingTotal 3 minutes

Create and Format Chart and Text Visualizations3 minutes

6 assignmentsTotal 29 minutes

Checkpoint: Text Visualizations2 minutes
Jump Into the Journey: Practice Creating Text Visualizations!7 minutes
Checkpoint: Chart Visualizations3 minutes
Jump Into the Journey: Practice Creating Chart Visualizations!7 minutes
Checkpoint: Filters, Slicers, and Data Drilling3 minutes
Jump Into the Journey: Practice Using Filters and Slicers!7 minutes

Once you are satisfied with your data, you are ready to publish it to Power BI Service, which is also known as Power BI Online. Here your data is stored in your own personal workspace that can only be accessed by you. You will also have the ability to create a dashboard, where critical metrics captured across multiple reports and datasets are displayed on a single page or canvas. But why keep all this data to yourself? Power BI Service makes sharing your data with your colleagues an easy and intuitive process!