> Formations > Prepare and visualize data with Microsoft Power BI (Microsoft DP-605)
Course : Prepare and visualize data with Microsoft Power BI (Microsoft DP-605)Official Course DP-605
Practical course - 1d
- 7h00 - Ref. DP6
|
Download in PDF format
Share this course by email
 | Sign in and import data from various sources into Power BI. |
| Prepare and transform data with Power Query. |
| Design a data model optimized for analysis. |
| Create interactive reports and dashboards in Power BI. |
| Use Copilot and Power BI's advanced features to make data analysis easier. |
Intended audience
Professionals who want to turn data into interactive reports using Power BI.
Prerequisites
Familiarity with data and analytics concepts. Completion of the “Get Started with Microsoft Data Analytics” module (recommended). Good written English skills.
Practical details
Teaching methods
The instructor assesses the participant’s learning progress throughout the training using multiple-choice questions, role-playing exercises, hands-on activities, and other methods. The participant also completes a placement test before and after the training to validate the skills acquired.
Course schedule
1 Getting Started with Power BI and Connecting to Data
- Explore the Power BI ecosystem and its components.
- Understanding Data Flow in Power BI.
- Connect to various data sources.
- Import data from Excel, relational databases, and online services.
- Choose an appropriate storage method.
- Resolve import and performance issues.
2 Data Preparation and Modeling
- Clean, transform, and load data using Power Query.
- Correct inconsistencies and improve data quality.
- Work with columns, data types, and table structures.
- Merge and transform queries.
- Design a semantic model.
- Create relationships, hierarchies, and measures.
3 Power BI Report Creation and Design
- Design interactive and visually effective reports.
- Organize the report pages.
- Use visualizations that are appropriate for the data.
- Configure filters, segments, and interactions.
- Creating dashboards that support decision-making.
- Share and publish Power BI reports.
4 Productivity and Advanced Analytics with Copilot and Microsoft Fabric
- Use Copilot in Power BI to speed up report creation.
- Interact with data using natural language.
- Prepare the models for AI.
- Discover Microsoft Fabric and end-to-end analytics.
- Understanding how Power BI fits into the Microsoft ecosystem.
PARTICIPANTS
Professionals who want to turn data into interactive reports using Power BI.
PREREQUISITES
Familiarity with data and analytics concepts. Completion of the “Get Started with Microsoft Data Analytics” module (recommended). Good written English skills.
TRAINER QUALIFICATIONS
The experts who lead the training courses are specialists in the subjects covered. They are approved by the publisher and certified for the course. They have also been validated by our teaching teams in terms of both professional knowledge and teaching skills for each course they teach. They have at least three to ten years of experience in their field and hold or have held positions of responsibility in companies.
TERMS AND DEADLINES
Registration must be completed 24 hours before the start of the training course.
ACCESSIBILITY FOR PEOPLE WITH DISABILITIES
Do you have specific accessibility requirements? Contact Ms FOSSE, disability advisor, at the following address: psh-accueil@orsys.fr so that we can assess your request and its feasibility.
Professionals who want to turn data into interactive reports using Power BI.
PREREQUISITES
Familiarity with data and analytics concepts. Completion of the “Get Started with Microsoft Data Analytics” module (recommended). Good written English skills.
TRAINER QUALIFICATIONS
The experts who lead the training courses are specialists in the subjects covered. They are approved by the publisher and certified for the course. They have also been validated by our teaching teams in terms of both professional knowledge and teaching skills for each course they teach. They have at least three to ten years of experience in their field and hold or have held positions of responsibility in companies.
ASSESSMENT TERMS
Assessment of targeted skills prior to training.
Assessment by the participant, at the end of the training course, of the skills acquired during the training course.
Validation by the trainer of the participant's learning outcomes, specifying the tools used: multiple-choice questions, role-playing exercises, etc.
At the end of each training course, ITTCERT provides participants with a course evaluation questionnaire, which is then analysed by our teaching teams. Participants also complete an official evaluation of the publisher.
An attendance sheet for each half-day of attendance is provided at the end of the training course, along with a certificate of completion if the participant has attended the entire session.
Assessment of targeted skills prior to training.
Assessment by the participant, at the end of the training course, of the skills acquired during the training course.
Validation by the trainer of the participant's learning outcomes, specifying the tools used: multiple-choice questions, role-playing exercises, etc.
At the end of each training course, ITTCERT provides participants with a course evaluation questionnaire, which is then analysed by our teaching teams. Participants also complete an official evaluation of the publisher.
An attendance sheet for each half-day of attendance is provided at the end of the training course, along with a certificate of completion if the participant has attended the entire session.
TEACHING AIDS AND TECHNICAL RESOURCES
The teaching resources used are the publisher's official materials and practical exercises.
The teaching resources used are the publisher's official materials and practical exercises.
TERMS AND DEADLINES
Registration must be completed 24 hours before the start of the training course.
ACCESSIBILITY FOR PEOPLE WITH DISABILITIES
Do you have specific accessibility requirements? Contact Ms FOSSE, disability advisor, at the following address: psh-accueil@orsys.fr so that we can assess your request and its feasibility.
This programme is an original creation, developed by the teaching teams at ORSYS Formation. Any reproduction, representation, adaptation or use, in whole or in part, without the prior written authorisation of ORSYS, is strictly prohibited. ORSYS reserves the right to take any action necessary to protect its intellectual property rights.
Dates and locations
Select your location or opt for the remote class then choose your date.
Remote class
Dernières places
Date garantie en présentiel ou à distance
Session garantie
This programme is an original creation, developed by the teaching teams at ORSYS Formation. Any reproduction, representation, adaptation or use, in whole or in part, without the prior written authorisation of ORSYS, is strictly prohibited. ORSYS reserves the right to take any action necessary to protect its intellectual property rights.