Data Analysis & Business Intelligence Learning Path
Key information
Upcoming sessions
Would you like to schedule this training on a specific date? Contact us by email or via the contact form.
Description of the training: Data Analysis & Business Intelligence Learning Path
This Data Analysis & Business Intelligence Learning Path is an intensive programme that takes you from raw data all the way to a decision-support dashboard, using modern Excel and Power BI. Over five thoroughly practical days, you will learn to import and transform your data with Power Query, model it effectively, analyse it with Excel and PivotTables, then design interactive Power BI reports enriched with DAX measures. By the end, you will have mastered the entire data analysis chain and be able to produce reliable, professional dashboards independently.
Complementary courses: to go further, also discover Power Query & ETL Training Course, Power Pivot Training Course and Power BI Expert DAX Training Course.
Good to know
The sessions are guaranteed from the first registration (except in cases of force majeure).
A preliminary interview takes place between the participant and/or a company contact in order to fully take into account the participant’s profile (level, needs, professional context, challenges, etc.).
Assessment: during the course, the trainer assesses participants’ learning progress through quizzes, role-play and practical exercises. Participants receive a certificate of completion at the end of the course.
This training course is part of our Power Platform Training Courses catalogue. Explore all our Power Platform courses to automate, analyse and build your business applications without code.
Objectives of the training: Data Analysis & Business Intelligence Learning Path
By the end of the learning path, participants will be able to:
- import and transform data with Power Query;
- design a reliable data model;
- analyse with Excel and PivotTables;
- create interactive reports with Power BI;
- write DAX measures and build dashboards;
- master the entire data analysis chain.
Prerequisites of the training: Data Analysis & Business Intelligence Learning Path
To follow this learning path under the best conditions, it is recommended to be proficient with the basics of Excel (formulas, PivotTables). No prior knowledge of Power Query, Power Pivot or Power BI is required. Because every participant is unique, a personalised interview is held beforehand in order to adapt the pace and practical cases to your context.
Detailed programme of the training: Data Analysis & Business Intelligence Learning Path
Preparing and transforming data (Power Query)
Modelling data
Analysing with Excel and PivotTables
Creating Power BI reports
DAX measures and business-intelligence dashboards
The highlights of this learning path
FAQ
Who is the Data Analysis & Business Intelligence Learning Path for?
It is aimed at anyone wishing to acquire a complete skill set in data analysis, from Excel to Power BI: analysts, management controllers, research officers and aspiring data analysts. A good grasp of the Excel basics is recommended.
Which tools are covered in this learning path?
The learning path covers Power Query (data preparation), data modelling, Excel’s PivotTables, Power BI Desktop and the DAX language. It thus covers the entire data analysis and Business Intelligence chain.
Do you already need to know Power BI or Power Query?
No. The learning path starts from the basics of Power Query, modelling and Power BI. Only a good command of the Excel fundamentals (formulas, PivotTables) is recommended to make the most of it.
How long does the Data Analysis & Business Intelligence Learning Path last?
The learning path lasts 5 days, i.e. 35 hours. Sessions are guaranteed from the first registration and take place in a small group of 1 to 3 participants. The programme can be customised and organised at your premises.
Is this learning path eligible for CPF or OPCO funding?
This learning path is funded directly by the company and is not eligible for CPF. Depending on your situation, funding by your OPCO may be considered: contact us to explore the funding options suited to your project.
.elementor-accordion .elementor-tab-title .elementor-accordion-icon{margin-right:10px}.elementor-accordion .elementor-tab-title .elementor-accordion-icon + a,.elementor-accordion .elementor-tab-title .elementor-accordion-title{padding-left:4px}