Discover how to navigate this intuitive tool and get to grips with Power BI’s Data, Model, and Report views. You’ll load multiple datasets in the Data view, build a data model to understand the relationships between your tables in Model view, and create your first bar graph and interactive map visualization in Report view. You’ll also practice using Power Query Editor to prep your data for analysis.

Introduction to Power BI

The essentials of Power BI

Getting started!

Loading existing reports

Your first visualization

Add a card

Slicers and Tables

Slicers

More columns

Table

Data Analyst in Power BI track

Getting Started with Power BI

In this chapter, you'll learn how to shape and transform your data before the data analysis using Power Query Editor.

Transforming data

Cleaning data

Power Query Editor

Transform before load

Field aggregation

Transforming and formatting columns

Transforming columns

Formatting currency

Making maps with geographic data

Transforming Data

It’s time to power-up your business intelligence skills! Through hands-on exercises, you’ll learn how to change and format a wide range of visualizations, before moving on to sorting data and creating hierarchies—making it possible for you to drill into your reports. 

Visualization options

Choosing the right visual

Making changes

Changing visuals

Editing properties

Sorting and more formatting

Sorting data

Using the slicer

Making it look good

Visualizing Data

In the final chapter, you’ll discover how to filter the information in your reports by location and control how these filters interconnect and interact with other visuals in your report.

Drilling down and filtering

Working with hierarchies

The underlying data and hierarchies

Looking at the data

Creating a hierarchy

Filters

Adding a filter

Turning off interactions

Applying advanced filtering

Congratulations!

Filtering

Navigation Cheatsheet

DataCamp vs. Local Experience

Exercises and Datasets

Course Glossary: Introduction to Power BI

Gain a 360° overview of exploring and using Power BI to build impactful reports. In this course, you’ll go from zero to hero as you discover how to use this popular business intelligence platform through hands-on exercises. Before diving into creating visualizations using Power BI's drag-and-drop functionality, you’ll first learn how to confidently load and transform data using Power Query and the importance of data models. You’ll also learn to drill down into reports and make your reports fully interactive. You've got the power!

The videos contain live transcripts, which can be accessed by clicking "Show transcript" at the bottom left of the videos.

The course glossary can be found on the right in the resources section.

To obtain CPE credits you need to complete the course and reach a score of 70% on the qualified assessment. You can navigate to the assessment by clicking on the CPE credits callout on the right.

<h2>A Thorough Introduction to Power BI</h2>
In this 3-hour course, you’ll gain a 360° overview of the Power BI basics and learn how to use the tool to build impactful reports. In this course, you’ll go from zero to hero as you discover how to use this popular business intelligence platform through hands-on exercises. 

Before diving into creating visualizations using Power BI's drag-and-drop functionality, you’ll first learn how to confidently load and transform data using Power Query and the importance of data models. You’ll also learn to drill down into reports and make your reports fully interactive.

<h2>Learn the Power BI Basics</h2>
You’ll start by looking at some of the fundamentals of Power BI, getting to grips with Data, Model, and Report views. You’ll learn to load data sets, build a data model, and discover how to shape and transform your data with Power Query Editor. 

As you progress through the course, you’ll have access to hands-on exercises that can hone your skills. You’ll look at various visualizations, sort different data types, and learn to drill deeper into your reports. 

<h2>Create Powerful Data Visualizations</h2>
Once you've covered Power BI in general, you can dig into its options for data visualization. Learn to choose the right visual for your dataset and type, how to make changes to follow visualization best practices and tell a strong story with your data, and learn to sort and format your data for clearer storytelling. 

Gain a comprehensive introduction to Power BI essentials, including how to load and transform data, create visualizations, and create reports.

Master the Power BI basics and learn to use the data visualization software to build impactful reports.

Data Analyst in Power BI

Power BI Fundamentals

Curriculum Manager, DataCamp

What is the Data Analyst in Power BI track?

Exam PL-300: Microsoft Power BI Data Analyst

Let's practice!

https://s3.amazonaws.com/assets.datacamp.com/production/course_24388/subtitles/course_24388_9d029192d179296909fc04a0f871d4b9.vtt

Getting Started with Power BI - Data Analyst in Power BI track

Data Analyst in Power BI track

Create Your Free Account