Who is this training for?
Anyone who wants to acquire the skills necessary to develop real comfort in manipulating data with Power BI.
Training objectives
- Gain knowledge about Power BI software
- Distinguish between different types of data
- Identify the differences between a report and a dashboard
- Import data into Power BI • Write formulas using DAX language
- Distribute a report or the dashboard
Summary
Today, data analysis becomes extremely important when it's time to make good decisions. Interpreting your data then becomes a must. Microsoft's Power BI software allows you to organize and visually present data. It is highly recommended that you have access to Power BI Desktop to take this training. If this is not your case, our teams will be able to provide you with the necessary equipment for the smooth running of the training, at no additional cost.
Course outline
Chapter 1: Learn about data analytics
- Overview of data analytics
- Roles and responsibilities in the analytics chain
- Tasks of a data analyst
Chapter 2: Get started building with Power BI
- Use Power BI
- The different components of Power BI
- Learn about and use the Power BI service
Chapter 3: Get data in Power BI
- Get data from files
- Get data from databases
- Get data Online Services
- Understand the constraints of data connections
- Select a storage mode
Chapter 4: Adapt the data model with DAX
- Learn about DAX
- Use the CALCULATE function
- Use relationships effectively
- Add measures to the data model
Chapter 5: Create reports in Power BI
- Use visualizations in your reports
- Add visualization elements to reports
- Choose an efficient visualization
- Format and set up visualizations
Chapter 6: Create dashboards in Power BI
- Create dashboards
- Set up data alerts
- Explore data by asking questions
- Add a dashboard theme
- Pin a report to a dashboard
Chapter 7: Create workspaces in Power BI
- Share a report or dashboard
- Embed a report in Teams
- Monitor usage and performance
Approach and methodology
Pedagogy based on examples and demonstrations.
Prerequisites
- Have access to the Power BI service (Pro License) or equivalent content.
- Power BI app installed on the desktop or equivalent content.
Recommendations
Have advanced knowledge of Excel
