Skip to main content

Introduction to Power BI

Gain a 360° overview of how to explore and use Power BI to build impactful reports.

Start Course for Free
6 Hours19 Videos55 Exercises105,453 Learners
4350 XP

Create Your Free Account

GoogleLinkedInFacebook

or

By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA. You confirm you are at least 16 years old (13 if you are an authorized Classrooms user).

Loved by learners at thousands of companies

Course Description

Gain a 360° overview of how to explore and use 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. You’ll first learn how to confidently load and transform data using Power Query and the importance of data models, before diving into creating visualizations using Power BI’s drag-and-drop functionality. You’ll also learn how to drill-down into reports and make your reports fully interactive. Lastly, you'll level-up your skills using DAX formulas (Data Analysis Expressions) to create customized calculated columns and fields to better analyze your data. Get started now. You've got the power!

  1. 1

    Getting Started with Power BI

    Free

    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.

    Play Chapter Now
    Introduction to Power BI
    50 xp
    Features of Power BI
    50 xp
    Getting started!
    50 xp
    Loading existing reports
    100 xp
    Your first visualization
    100 xp
    Add a card
    100 xp
    Slicers and Tables
    50 xp
    Slicers
    100 xp
    More columns
    100 xp
    Table
    100 xp
    Transforming data
    50 xp
    Cleaning data
    50 xp
    Power Query Editor
    50 xp
    Transform before load
    100 xp
    Field aggregation
    100 xp
    Transforming and formatting columns
    50 xp
    Transforming columns
    100 xp
    Formatting currency
    100 xp
    Making maps with geographic data
    100 xp
  2. 2

    Visualizing 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. Lastly, 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.

    Play Chapter Now
    Visualization options
    50 xp
    Choosing the right visual
    50 xp
    Making changes
    50 xp
    Changing visuals
    100 xp
    Editing properties
    100 xp
    Sorting and more formatting
    50 xp
    Sorting data
    100 xp
    Using the slicer
    100 xp
    Making it look good
    100 xp
    Drilling down and filtering
    50 xp
    Working with hierarchies
    50 xp
    The underlying data and hierarchies
    50 xp
    Looking at the data
    100 xp
    Creating a hierarchy
    100 xp
    Filters
    50 xp
    Adding a filter
    100 xp
    Turning off interactions
    100 xp
    Applying advanced filtering
    100 xp
  3. 3

    Creating Calculations with DAX

    In this chapter, you’ll learn how to create customized calculations using Microsoft's formula language, DAX (Data Analysis Expressions). Very similar to how formulas are written in Excel, you'll learn how to create calculated columns and tables—and when you should use them. You'll then progress to writing powerful calculated measures, leveraging Power BI's Quick Measures, to create complex DAX calculations like year over year change.

    Play Chapter Now
    Introduction to DAX
    50 xp
    Calculated tables and columns
    50 xp
    Generating passwords
    100 xp
    Nested function
    100 xp
    Profit column
    100 xp
    Calculated measures
    50 xp
    Average function
    100 xp
    Product count
    100 xp
    Profit margin ratio
    100 xp
    Calculated measures and Quick Measures
    50 xp
    Calculate function and Quick Measures
    50 xp
    Calculate function
    100 xp
    Your first Quick Measure
    100 xp
    Time-based calculations
    50 xp
    CALCULATE() and dates
    100 xp
    Prior year profits
    100 xp
    Quarter over quarter change
    100 xp
    Congratulations!
    50 xp

Datasets

Exercises and Datasets

Collaborators

Ginger GrantHadrien Lacroix
Sara Billen Headshot

Sara Billen

Curriculum Manager at DataCamp

Sara is a graduate of a master's degree in Business Engineering and Marketing Analysis. Prior to working at DataCamp she worked as a Data Science consultant for a Belgian IT company. Sara is passionate about education, data science, and business and loves that she is able to combine all of these disciplines in her job as curriculum manager at DataCamp.
See More
Lis Sulmont Headshot

Lis Sulmont

Workspace Architect at DataCamp

Lis holds a Master's degree in Computer Science from McGill University with a focus on computer science education research and applied machine learning. She's passionate about teaching all things related to data and improving the accessibility of these topics.
See More

What do other learners have to say?

“I've used other sites—Coursera, Udacity, things like that—but DataCamp's been the one that I've stuck with.”

Devon Edwards Joseph
Lloyds Banking Group

“DataCamp is the top resource I recommend for learning data science.”

Louis Maiden
Harvard Business School

“DataCamp is by far my favorite website to learn from.”

Ronald Bowers
Decision Science Analytics, USAA