Course Outline
1. From data to business decisions
• The role of data analysis in the decision-making process
• From business questions to metrics and KPIs
• Raw data, information and insight
• Stages of the data analysis process
• Tools used in the course: Power Query, Data Model, Power Pivot and DAX
2. Preparing data for analysis
• Importing data from various sources
• Identifying data quality issues
• Cleaning and transforming data
• Combining and restructuring datasets
• Automating the data preparation and update process with Power Query
3. Organising and modelling data
• Why a single table is not always sufficient
• Organising data for analysis
• Creating the data model
• Relationships between tables
• Basic principles for building a clear and efficient model
4. Analysing data with Power Pivot and DAX
• Using Power Pivot for data analysis
• Selecting relevant metrics for the analysed question
• Calculated columns and measures
• Understanding filter context
• Essential DAX functions for business analysis
• Calculating metrics and KPIs
5. Building a dashboard for decisions
• From analysis to dashboard
• Selecting the right visualisation for the analysed information
• Information organisation and visual hierarchy
• Dashboard layout and logical structuring
• Adding context: evolution, objectives, comparisons and reference values
• Interactive dashboards and automatic updates
• Interpreting results and formulating business conclusions
Requirements
This course is aimed at:
- Business users working with reports and operational data.
- Team leaders and managers involved in the decision-making process.
- Specialists from Finance, Human Resources, Sales, Operations, Procurement and Support departments.
- Professionals who need to interpret, analyse and communicate data-based information.
- Users without technical training wishing to develop their data analysis competencies.
Recommended prerequisites
- Basic knowledge of Microsoft Excel usage.
- Experience working with tables, reports or business data.
- No programming knowledge required.
Custom Corporate Training
Training solutions designed exclusively for businesses.
- Customized Content: We adapt the syllabus and practical exercises to the real goals and needs of your project.
- Flexible Schedule: Dates and times adapted to your team's agenda.
- Format: Online (live), In-company (at your offices), or Hybrid.
Price per private group, online live training, starting from 3200 € + VAT*
Contact us for an exact quote and to hear our latest promotions
Testimonials (3)
Learning that the QGIS and a tool that can used by other different professionals such land survey
Bame Duncan Koko - Bentel Technologies (Pty) Ltd
Course - QGIS for Geographic Information System
How to use open satellites data for real applications
Tshering Dorji - Druk Holding and Investments
Course - Advanced Geographic Information Systems (GIS)
Hands-on examples allowed us to get an actual feel for how the program works. Good explanations and integration of theoretical concepts and how they relate to practical applications.
