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.
Duration
2 days
Schedule
9h to 16h
Regular fee
$1,035
Preferential fee
A preferential rate is offered to public institutions, to members of certain professional organizations as well as to companies that do a certain amount of business with Technologia. To know more, please read the "Registration and rates" section on our FAQ page. Please note that preferential rates are not available for online training courses. Discounts cannot be combined with other offers.
$930
Objectives of the training
To provide the knowledge and skills required to use the advanced features of Power BI using the Python language.Targeted audience
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.Trainers
Course architecture
Training eligible for SCALE AI grants
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.
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)
- 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)
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).
- 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)
- 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
- Advanced DAX functions (Measures, etc.)
- The best tricks with DAX (displaying minimums and maximums, etc.)
- Advanced visualizations
If you have any questions about registration, cancellation, schedules, language of instruction, etc. you will find answers in our FAQ.
Training Notes
Public sessions are not considered by Scale AI for grant funding. Only customized versions of these trainings are.
If you are interested in developing your skills with DAX, please consider the Power BI: Optimizing Data Models with DAX course (MS426)
Private or personalized training
If you have more than 8 people to sign up for a particular course, it can be delivered as a private session right at your offices. Contact us for more details.
Request a quoteDuration
2 days
Schedule
9h to 16h
Regular fee
$1,035
Preferential fee
A preferential rate is offered to public institutions, to members of certain professional organizations as well as to companies that do a certain amount of business with Technologia. To know more, please read the "Registration and rates" section on our FAQ page. Please note that preferential rates are not available for online training courses. Discounts cannot be combined with other offers.
$930
Private or personalized training
If you have more than 8 people to sign up for a particular course, it can be delivered as a private session right at your offices. Contact us for more details.
Request a quote