Course Outline
1. From Data to Business Decisions
• The role of data analysis in decision-making
• From business questions to metrics and KPIs
• Raw data, information, and insights
• 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. Organizing and Modeling Data
• Why a single table is not always sufficient
• Organizing data for analysis
• Creating the data model
• Relationships between tables
• Fundamental principles for building a clear and efficient model
4. Analyzing Data with Power Pivot and DAX
• Using Power Pivot for data analysis
• Selecting relevant metrics for the question being analyzed
• 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
• Choosing the right visualization for the information analyzed
• Organizing information and visual hierarchy
• Dashboard layout and logical structuring
• Adding context: evolution, objectives, comparisons, and benchmarks
• Interactive dashboards and automatic updates
• Interpreting results and formulating business conclusions
Requirements
This course is intended for:
- Public sector employees responsible for managing reports and operational data.
- Supervisors and managers involved in administrative and programmatic decision-making.
- Specialists from Finance, Human Resources, Procurement, Operations, and Support divisions.
- Professionals requiring the ability to interpret, analyze, and communicate data-driven findings.
- Users without formal technical training seeking to enhance their analytical capabilities for government operations.
Recommended Prerequisites
- Basic proficiency in Microsoft Excel.
- Experience working with structured tables, reports, or administrative datasets.
- No prior programming knowledge is 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)
Equipped with examples