Learning the basics of Python in Power BI
1. Learning the basics of Python in Power BI
Welcome to the course! My name is Jacob Marquez; I'll be your instructor.2. Prerequisite knowledge
Before you begin, you should have at least a beginner's knowledge of Power BI and Python. Specifically, completing an introduction course on DAX in Power BI and an introduction course on data visualization using Seaborn.3. What we will be learning
Here's a glimpse of what we will be learning. For Power BI - importing and joining data with Power Query, finding missing data with Power Query, and calculating correlation coefficients. For Python - importing & joining data with pandas; finding missing data and imputation; and creating visualizations with Seaborn. If you are a Power BI user, this will be practice with entry-level python. If you are more of a Python user, this will give you an idea of how to get started with using it in Power BI.4. Getting started - downloading Python
If you want to take this course on your own computer, you need to install both Power BI Desktop and Python. You can download Power BI at powerbi dot microsoft dot com slash downloads. Installing Power BI Desktop alone is not enough; you must download and set up Python in your own environment. We have installed it for you here on DataCamp, so that's a pretty handy way to take this course! Learn more about downloading Python at python dot org slash downloads.5. Getting started - installing packages
Using Python in Power BI requires the packages pandas and matplotlib to be installed. These packages are already installed for you. The Command Line Interface, or CLI, is a great way to do this. We won't cover it here, so learn more about how to do this at packaging dot python dot org!6. Getting started - Power BI
To enable Python scripts in Power BI, navigate to "Options and settings" and "Options" under the "File" tab. In the "Python scripting" tab, you will see two dropdown menus for "home directories" and "integrated development environments" or IDE.7. Getting started - Power BI
The Python home directory should use the local installation of Python by default. If there are multiple installations, you will need to specify which to use in Power BI. For our course, there will be only one.8. Getting started - Power BI
An IDE is a single location for most coding tasks, hence the words integrated and development. Power BI will choose the default IDE for the computer or environment. Setting this option will tell Power BI which program to open when requested during Python scripting. An IDE is also useful when writing python code to use in Power BI.9. Limitations
There are some limitations to be aware of. DataFrames saved in python scripts in Power Query are temporarily saved on the computer. This can result in slow processing. Python visualizations only use 150,000 rows and less than 250 MB of data. This won't be a problem in this course, but keep it in mind for future projects. Datasets imported using Python need to be set to "Public". This may be an issue for companies with sensitive data.10. Benefits and reasons to learn...
There are great benefits of incorporating Python into Power BI! As a Power BI user, some key benefits are flexibility in data transformation, calculations, and custom visualizations. There are also many benefits of learning Power BI for current Pythonistas. A couple of big ones are faster data visualizations, flexible dashboarding capabilities, and easier options for sharing with others.11. Datasets
You'll be working with two fisheries datasets, sourced from the Food and Agricultural Organization of the United Nations. They are fished dot csv which provides the amount, in tons, of fish captured from the sea, and farmed dot csv which provides the amount, in tons, of fish produced through farming.12. Let's practice!
In the next video, we will walk through the setup, importing data, and transformation steps. Talk to you soon!Create Your Free Account
or
By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.