In recent years, Power BI, Microsoft's business intelligence solution, has become a must-have for exploring, analyzing and visualizing data. This set of tools allows you to connect to various data sources and create interactive reports that add value to your data and help you make strategic decisions.
If you have already used a spreadsheet program (Microsoft Excel, OpenOffice Calc) or if you are already familiar with a BI tool, but would like to learn more about the opportunities offered by Power BI, this training is for you.
At the end of this training, you will be able to connect to various data sources. You will be able to create an optimized data model using the many native features of Power Query and enrich your models using the DAX language. Then you will be able to create interactive reports and share them with interested parties in complete security.
Goals
- Connect and prepare data with Power Query
- Create data models using DAX formulas
- Design interactive reports with Power BI Desktop
- Master the codes of data visualization to get your message across effectively
- Publish and share your reports with Power BI Service and Power BI Mobile
to adapt this program to your needs
or to obtain additional information,
contact us!
Teaching method
70% hands-on workPrerequisite
Basic spreadsheet skills (Microsoft Excel) are required.Targets
- Data Analyst
- Developer
- Data Scientist
- BI Professional
- Management Controller
- Manager
Evaluation
This training does not require a formal assessment of learningProgram
Introduction
- A few reminders about Business Intelligence (BI)
- Overview of data analysis
- Overview of Microsoft's BI offering
- Power BI Ecosystem
Data Preparation
- Connection to data from different data sources (Excel, CSV, database, Web)
- Importing data and/or Direct Query
- Preparation of data with Power Query
- Resolution of performance issues
Data Modelisation
- Design of a data model
- Development of a data model
- Creation of formulas with DAX
- Optimization of model performance
Data Visualisation
- Introduction à la data visualisation
- Introduction to data visualization
- Creating reports
- Discovering the different visuals
- Enriching reports
- Power BI Mobile
Data Analysis
- Enhanced reporting to highlight information
- Perform advanced analysis
Power BI service
- Creating and managing workspaces
- Navigating a report
- Sharing and security
- Dashboard management
- Setting up dataset management and dataflows
- Discover the advanced features of Power BI Service
