Course Outline
1. From Data to Business Decisions
• The role of data analysis in decision-making
• Translating business questions into indicators and KPIs
• Raw data, information, and insight
• The stages of the data analysis process
• Tools covered 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 data preparation and refresh processes using Power Query
3. Organising and Modelling Data
• Why a single table is not always sufficient
• Structuring data for analysis
• Creating the data model
• Relationships between tables
• Fundamental principles for building a clear and efficient model
4. Analysing Data with Power Pivot and DAX
• Using Power Pivot for data analysis
• Selecting relevant indicators for the question at hand
• Calculated columns and measures
• Understanding filter context
• Essential DAX functions for business analysis
• Calculating indicators and KPIs
5. Building a Dashboard for Decision-Making
• Moving from analysis to dashboard creation
• Selecting the appropriate visualisation for the information
• Organising information and visual hierarchy
• Layout and logical structuring of the dashboard
• Adding context: trends, objectives, comparisons, and benchmark values
• Interactive dashboards and automatic updates
• Interpreting results and formulating business conclusions
Requirements
This course is designed for:
- 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.
- Non-technical users looking to develop their data analysis competencies.
Recommended Prerequisites
- Basic knowledge of Microsoft Excel.
- Experience working with spreadsheets, reports, or business data.
- No programming knowledge required.
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.
