This course enables participants to acquire the skills needed to model, analyze, and visualize data with Microsoft Power BI. It covers accessing and processing data from relational and non‑relational sources, implementing security rules, and managing and deploying reports and dashboards in the Power BI service.
Objectives
The objective of this course is to enable participants to process and analyze datasets, connect to different sources, transform and visualize data with Power BI Desktop, and configure dashboards and analytical solutions in Power BI.
Is it for you ?
Data and business intelligence professionals. Individuals who develop reports that visualize data from data platform technologies that exist both in the cloud and on‑premises.
Prerequisite
Understanding of basic data concepts. Knowledge of working with relational data in the cloud. Knowledge of working with non‑relational data in the cloud. Knowledge of data analysis and visualization concepts.
Your benefits
Content
Getting Started with Microsoft Data Analytics
- Data analytics and Microsoft
- Getting started with Power BI
Lab: Getting Started with Power BI Desktop
Prepare Data in Power BI
- Get data from various data sources
Lab: Preparing Data in Power BI Desktop
See more + / -
Clean, Transform, and Load Data in Power BI
- Shaping data
- Enhancing data structure
- Data profiling
Lab: Transforming and Loading Data in Power BI Desktop
- Loading data
Design a Data Model in Power BI
- Introduction to data modeling
- Working with tables
- Dimensions and hierarchies
Lab: Data Modeling in Power BI Desktop
- Create model relationships
- Configure tables
- Review the model interface
- Create quick measures
Lab: Advanced Data Modeling in Power BI Desktop
- Configure many‑to‑many relationships
- Apply row‑level security
Create Model Calculations Using DAX in Power BI
- Introduction to DAX
- DAX context
- Advanced DAX
Lab: Advanced DAX in Power BI Desktop
- Use the CALCULATE() function to manipulate filter context
- Use Time Intelligence functions
Lab: Introduction to DAX in Power BI Desktop
- Create calculated tables
- Create calculated columns
- Create measures
Optimize Model Performance in Power BI
- Optimize model performance
- Optimize DirectQuery models
- Create and manage aggregations
Create Reports in Power BI
- Design a report
- Enhance the report
- Lab: Designing a Report in Power BI Desktop
- Create a live connection in Power BI Desktop
- Design a report
- Configure visual fields and formatting properties
- Lab: Enhancing Reports with Interaction and Formatting in Power BI Desktop
- Create and configure Sync Slicers
- Create a drillthrough page
- Apply conditional formatting
- Create and use bookmarks
Create Dashboards in Power BI
- Create a dashboard
- Real‑time dashboards
- Enhance a dashboard
- Lab: Creating a Dashboard in Power BI Service
- Create a dashboard
- Pin visuals to a dashboard
- Configure a dashboard tile alert
- Use Q&A to create a dashboard tile
Improve Report Usability and Storytelling in Power BI
- Overview of paginated reports
- Create paginated reports
Lab: Creating a Paginated Report in Power BI Desktop
- Use Power BI Report Builder
- Design a multi‑page report layout
- Define a data source
- Define a dataset
- Create a report parameter
- Export a report as a PDF
- Perform advanced analytics in Power BI
- Advanced analytics
- Gain insights with AI visuals
Lab: Data Analysis in Power BI Desktop
- Create animated scatter charts
- Use the forecasting visual
- Work with the Decomposition Tree visual
- Work with the Key Influencers visual
Manage Datasets in Power BI
- Parameters
- Datasets
- Security in Power BI
Create and Manage Workspaces in Power BI
- Create workspaces
- Share and manage resources
- Lab: Publishing and Sharing Power BI Content
- Map security principles to dataset roles
- Share a dashboard
- Publish an app
💡 Informations utiles
Our training programs are delivered in private sessions tailored to your needs—on-site at your location, virtually, or in our training rooms. Dates, schedules, language, and format are all fully customizable to fit your team. Ready to get started? Fill out the request form below to plan your training or receive a personalized proposal—our team will be happy to connect with you shortly.
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