Skip to main content
HomePower BI

Introduction to Python in Power BI

4.6+
13 reviews
Beginner

Learn how to use Python scripts in Power BI for data prep, visualizations, and calculating correlation coefficients.

Start Course for Free
3 hours9 videos25 exercises5,093 learnersTrophyStatement of Accomplishment

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.
Group

Training 2 or more people?

Try DataCamp for Business

Loved by learners at thousands of companies


Course Description

Customize Power BI with Python

In this introduction to Python in Power BI course, you’ll use data from an overfishing study and an online retailer to learn how to use Python scripts in Power BI for data prep, visualizations, and calculating correlation coefficients.

Build Custom Visuals

Specifically for building custom Python-based visuals, you will be utilizing the Seaborn package. By the end, you should feel a little more comfortable using Python in (and outside of) Power BI.

Power up your Toolbox

Whether you were first a Pythonista or a Power BI power user, integrating Python into Power BI is a fantastic addition to the data toolbox. This course will demonstrate that, by using the two together, you can leverage the benefits of each, choosing the best one for the task at hand.
For Business

GroupTraining 2 or more people?

Get your team access to the full DataCamp platform, including all the features.
DataCamp for BusinessFor a bespoke solution book a demo.
  1. 1

    Getting Started with Python in Power BI

    Free

    In this first chapter, you will learn the advantages and limitations of Python in Power BI as well as how to enable this capability within a workbook. You will also perform the same task using both technologies separately to build familiarity with the strengths and weaknesses of both. Power BI is a powerful tool. Python can be leveraged to make it even more powerful!

    Play Chapter Now
    Learning the basics of Python in Power BI
    50 xp
    Pros and cons of Python in Power BI
    100 xp
    Set up, import, and transform data
    50 xp
    Set up Power BI for Python
    100 xp
    Power BI: import and join
    100 xp
    Python: import and join
    100 xp
  2. 2

    Missing Data and Imputation

    Now that you're up and running with Python in Power BI, let's move on to another important data processing step - identifying missing data and imputation. In this chapter, you will identify missing data in a dataset using Python, then Power BI. You will then work through addressing missing data by leveraging imputation techniques.

    Play Chapter Now
  3. 3

    Visualizations with Seaborn in Power BI

    In this chapter, you will construct several Python-based visualizations, using the Seaborn package, in Power BI. Specifically, a line plot, pair plot, and joint plot. You will also learn how to interpret these visualizations to extract insights about the data. By this point, you will know some of the key differences between Python and Power BI in basic data processing steps. The next step is to visualize this data!

    Play Chapter Now
  4. 4

    Heatmaps and Correlation Coefficients

    In this chapter, you will continue evaluating the relationship between variables. This time, you will be doing so quantitatively by calculating the correlation coefficient. You will learn how to do this in Power BI then Python. Finally, you will leverage the power of Seaborn visualizations to create a correlation heatmap! By the time you finish the course, you'll be skilled in Power BI, Python, and data visualization techniques. Nice work!

    Play Chapter Now
For Business

GroupTraining 2 or more people?

Get your team access to the full DataCamp platform, including all the features.

datasets

DataCamp vs. Local ExperienceExercises and Datasets

collaborators

Collaborator's avatar
Carl Rosseel
Collaborator's avatar
Iason Prassides
Jacob Marquez HeadshotJacob Marquez

Data Scientist at Microsoft

Jacob H. Marquez is an insatiable learner and lifelong builder. He is a data scientist by day, answering audacious questions to support customer experience and company goals. He is a serial hobbyist by day and night: being an educator, building a coffee recommendation app, drinking coffee, writing on Medium, and amateur cycling and muay thai. He has a bachelor's in psychology and a master's in computational analytics (2024).
See More

Don’t just take our word for it

*4.6
from 13 reviews
77%
15%
8%
0%
0%
Sort by
  • Trina C.
    3 months

    Very well explained

  • Krista B.
    about 1 year

    .

  • Felipe G.
    over 1 year

    I loved this course!

  • Magdalena T.
    over 1 year

    The material was good. However, the interface was very slow and glitchy on my mac and on chrome. A lot of the python exercises would not execute properly. Also, the videos are very slow, but do not explain well where to click, rather using BI jargon for names of buttons to press. This is hard for a beginner to follow.

  • Sorin I.
    over 1 year

    Easy to follow, clear and concise, very useful. Excellent practice mode

"Very well explained"

Trina C.

"."

Krista B.

"I loved this course!"

Felipe G.

Join over 15 million learners and start Introduction to Python in Power BI today!

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.