Objectives of the training
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.Targeted audience
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.Trainers
Benefits for Participants
• Process and analyze large datasets
• Connect to data sources and perform data transformations, model data, and visualize data using Microsoft Power BI Desktop
• Configure dashboards using the Power BI service
• Configure direct connectivity with Microsoft SQL Azure and SQL Server Analysis Services (SSAS), and implement data analysis in Microsoft Excel
Course architecture
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
• Prepare data
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
Pedagogical details
Type of training
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 quotePrivate 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