Procurement Data Analytics using Excel and Power BI Training

Procurement, Logistics & Supply Chain · 10 Days

Course Overview

Procurement teams spend hours each month building reports by hand. Excel and Power BI can automate much of this work and turn raw purchase data into interactive dashboards that managers actually use. This ten-day practical course moves step by step from Excel analysis and Power Query through data modelling, DAX measures and professional dashboard design. Every exercise uses procurement data such as purchase orders, supplier performance and contract spend. Participants finish with a working procurement dashboard, refreshable reports and the skills to keep building on them.

Who Should Attend

  • Procurement Officers and Analysts
  • Supply Chain Analysts
  • Contract and Category Managers
  • Finance and Reporting Officers
  • Monitoring and Compliance Officers
  • Team Leaders Who Produce Procurement Reports

Learning Objectives

  • Clean and combine procurement data using Power Query
  • Use advanced Excel formulas and pivot tables
  • Build spend, supplier and contract analyses
  • Design a data model in Power BI
  • Write useful DAX measures
  • Create interactive dashboards
  • Automate recurring reports
  • Track procurement KPIs visually
  • Publish and share reports securely
  • Communicate insights to decision makers

Key Takeaways

Course Curriculum

1

Reporting Needs in Procurement

2

Excel Data Essentials

3

Pivot Tables for Spend Analysis

4

Cleaning Data with Power Query

5

Excel Dashboards

6

Getting Started with Power BI

7

Data Modelling

8

DAX Measures

9

Designing Procurement Dashboards

10

KPI Tracking and Scorecards

11

Automating Reporting

12

Sharing and Security

13

Insight and Capstone Project

Requirements

Participants should know basic Excel. A laptop is required, with Excel and Power BI Desktop installed.

Certification

Participants who complete the Procurement Data Analytics using Excel and Power BI Training receive an Ecotrio Certificate of Completion, awarded by Ecotrio Impact Growth and Development Centre (EIGDC) and recognized by employers across the region as evidence of applied, job-ready competence.

Upcoming Sessions

LocationDatesMode
Dubai, United Arab Emirates 16 Nov 2026 – 25 Nov 2026 Classroom Register →
Accra, Ghana 16 Nov 2026 – 25 Nov 2026 Classroom Register →
Kigali, Rwanda 16 Nov 2026 – 25 Nov 2026 Classroom Register →
Dar es Salaam, Tanzania 16 Nov 2026 – 25 Nov 2026 Classroom Register →
Cairo, Egypt 16 Nov 2026 – 25 Nov 2026 Classroom Register →
Cape Town, South Africa 16 Nov 2026 – 25 Nov 2026 Classroom Register →
Pretoria, South Africa 23 Nov 2026 – 02 Dec 2026 Classroom Register →
Johannesburg, South Africa 23 Nov 2026 – 02 Dec 2026 Classroom Register →
Live Virtual 23 Nov 2026 – 02 Dec 2026 Online Register →
Mombasa, Kenya 23 Nov 2026 – 02 Dec 2026 Classroom Register →
Zanzibar, Tanzania 23 Nov 2026 – 02 Dec 2026 Classroom Register →
Kampala, Uganda 23 Nov 2026 – 02 Dec 2026 Classroom Register →

Ready to Register for Procurement Data Analytics using Excel and Power BI Training?

See full pricing, exact upcoming dates across United Arab Emirates, Ghana, Rwanda, and secure your seat online in minutes.

Book This Training →