Microsoft Power BI est le meilleur outil de visualisation et de publication de données (intelligence d’affaires - BI). To this tool we add the most efficient and popular language: Python, in its Anaconda ecosystem. This training will help you go further in your use of this tool (whether it is Power BI Service or Power BI Desktop) so that you master its advanced features, to access and process data (relational and non-relational). You will use Python for processing, modeling and statistical visualization of data in Power BI. You will then be able to build dynamic and shareable dashboards to help in decision making.
Objectives
To provide the knowledge and skills required to use the advanced features of Power BI using the Python language.
Is it for you ?
Users who need to create and publish reports within their organization and who wish to master the functionalities offered by Power BI with Python (rather than M and Dax which are not required for this training).
Prerequisite
Proficiency in Power BI 1 (Course MS421) or general knowledge of power bi.
Content
For this course, you can log in to your Power BI Desktop or take advantage of one of our virtual machines.
In this training you will see how to optimize your data with Power BI. You will learn how to leverage the power of Power BI and Python to connect, retrieve, transform and visualize data.
Once you understand how to build a dashboard with Python in Power BI, you'll be able to analyze data that will allow you to both track the status of your department or business, as well as make findings that will feed your future recommendations.
The combination of Python and Power BI provides the ultimate tool for connecting, analyzing, and visualizing data in depth while remaining actionable (especially for those who don't want to use M and DAX).
The tool is part of Office 365.
Python and Power BI
- Installation and configuration of Python in Anaconda (and its libraries)
- First steps with Python in Jupyter Notebook
- Installation of Python libraries (Matplotlib, Seaborn, Numpy, Pandas, Statsmodels, etc.)
- Integration of Python in Power BI (data sources and their manipulation) and scripting showcases (Python visuals)
Details + / -
Data acquisition, processing and modeling
- How to import data using Python into Power BI
- How to clean, process and model data using Python in the Power BI query editor
- Web scraping exercise (retrieving data from web pages)
- Introduction to advanced modeling (links between tables and introduction to forecasting models (e.g. forecasting exchange rates according to the price of a barrel).
Modeling
- How to visualize data using Python in Power BI.
- Marrying data tables to create a business model.
- Correcting filters with Python (instead of DAX)
Power BI and DAX
- Advanced DAX functions (Measures, etc.)
- The best tricks with DAX (displaying minimums and maximums, etc.)
- Advanced visualizations
Notes
Public sessions are not considered by Scale AI for grant funding. Only customized versions of these trainings are.
💡 Useful information
Our training sessions are offered in Montreal or Quebec City, in person or in virtual format. Dates and locations are provided when you select your session below. If you have any questions regarding registration, schedules, the language of instruction, or cancellation policies, please consult our FAQ .
Trainers
Private or personalized training
Do you have several employees interested in the same training course? Whether in person at your offices or remotely in virtual mode, we offer private training courses tailored to your team's needs. Group rates are available. Contact us for more details or request a quote online.
Request a quote