Course Overview
This course covers the essentials of Power BI, from data connectivity and transformation using Power Query Editor and DAX, to designing and modeling data for effective reporting. Participants will learn to create interactive reports and dashboards, utilizing advanced features such as AI tools and Natural Language Queries. Additionally, the course includes deployment and management of reports, including security settings like Row-Level Security and automated data refresh.
Moyens d'évaluation :
- Quiz pré-formation de vérification des connaissances (si applicable)
- Évaluations formatives pendant la formation, à travers les travaux pratiques réalisés sur les labs à l’issue de chaque module, QCM, mises en situation…
- Complétion par chaque participant d’un questionnaire et/ou questionnaire de positionnement en amont et à l’issue de la formation pour validation de l’acquisition des compétences
Who should attend
Database Developer, Data Analyst, Business Analyst, Excel Power User
Prerequisites
Basic knowledge of SQL language, basic knowledge of data modeling
Course Objectives
At the end of this course, you should be able to:
- Understand the architecture of Power BI and its key components, including data connectivity and connectors.
- Clean, transform, and load data using Power BI's Power Query Editor and M formula language.
- Design and build effective data models, including relationships, hierarchies, and time dimensions, with an understanding of 3NF vs. Star Schema.
- Extend data models with DAX to calculate KPIs, create measures, and perform complex calculations.
- Develop interactive reports and dashboards using Power BI’s standard visuals, filters, slicers, and advanced features like bookmarks and cross-report navigation.
- Leverage AI features in Power BI, including Natural Language Queries, anomaly detection, and key influencer identification.
- Deploy, manage, and secure reports in Power BI, including setting up automated data refresh and configuring Row-Level Security (RLS).
Course Content
Overview of Power BI Architecture
- Data connection concepts
- Overview of Power BI connectors
- Introduction to connection types: Import, Direct Query, and Live Query
Data Cleaning, Transformation, and Loading in Power BI
- Overview of the Power Query Editor
- Transformation options in the Power Query Editor
- Introduction to M formula language
- Data connection and transformation with Python
- Data profiling
Designing a Data Model
- Introduction to data modeling: 3NF vs. Star Schema
- Creating relationships between tables
- Setting keys, hierarchies, and time dimensions
- Configuring table and column properties
Extending the Model with DAX
- Introduction to DAX
- Using DAX for model extension and KPI calculations
- Creating calculated columns, measures, and tables with DAX
- Introduction to DAX functions (e.g., Related, Calculate…)
Creating Reports and Dashboards
- Exploring standard visuals
- Data filtering with filters, slicers, and cascading
- Cross-report navigation with buttons and bookmarks
- Controlling the interaction between visuals
AI Features in Power BI
- Natural Language Query (NLQ) in Power BI
- Anomaly detection
- Identifying key influencers
- Decomposition tree analysis
Report Deployment and Administration
- Creating mobile reports for smartphones and tablets
- Creating paginated reports
- Deploying reports and dashboards
- Deployment on SSRS for Power BI and to the cloud
- Report administration
- Setting up automated data refresh
- Configuring Row Level Security
Anglais
Allemand
Allemagne
Moyens Pédagogiques :