Microsoft Business Intelligence (MSBI) Training

Data Science, Digital M&E & AI · 10 Days

Course Overview

Microsoft Business Intelligence (MSBI) remains a widely used toolset for building end-to-end business intelligence solutions, combining ETL, data warehousing and reporting capabilities. This hands-on technical course builds practical competency across the core MSBI components, enabling participants to design, build and deploy real BI solutions.

Who Should Attend

  • Business Intelligence Developers
  • Data Analysts and Database Administrators
  • IT and Systems Developers
  • Reporting and Analytics staff
  • Data Warehouse Developers
  • MIS and Data Management Officers

Learning Objectives

  • Design and implement ETL processes using SQL Server Integration Services
  • Build and manage data warehouses using SQL Server Analysis Services
  • Design reports and dashboards using SQL Server Reporting Services
  • Build multidimensional and tabular data models
  • Optimize MSBI solution performance
  • Deploy and maintain MSBI solutions in production
  • Troubleshoot common MSBI implementation issues

Key Takeaways

Course Curriculum

1

MSBI Platform Overview

2

Introduction to SSIS

3

Building ETL Processes with SSIS

4

Advanced SSIS Techniques

5

Data Warehousing Fundamentals

6

Introduction to SSAS

7

Building Multidimensional Models

8

Building Tabular Models

9

Introduction to SSRS

10

Advanced Reporting with SSRS

11

Integrating the MSBI Stack

12

Deployment and Performance Optimization

13

Applied MSBI Project and Capstone

Requirements

Participants should have a basic working knowledge of SQL and relational databases. No prior formal certification is required.

Certification

Participants who complete the Microsoft Business Intelligence (MSBI) 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.

Frequently Asked Questions

What are the prerequisites for attending this course?

Participants should have a basic working knowledge of SQL and relational databases. No prior formal certification is required.

Will I receive a certificate upon completing the course?

Participants who complete the Microsoft Business Intelligence (MSBI) 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.

Can this training be delivered on-site for our organisation?

Yes. Ecotrio Impact Growth and Development Centre (EIGDC) offers a bespoke in-house delivery option for Microsoft Business Intelligence (MSBI), tailored to your organisation's context within Data Science, Digital M&E & AI. Contact our training team to discuss customisation, scheduling and group pricing.

Is this course available online for participants who cannot travel?

Yes. Selected cohorts of this course are available as live virtual sessions delivered over video conferencing by an experienced facilitator, with the same certificate issued on completion as the in-person format.

What will I be able to do after completing this course?

By the end of this course, you will be able to design and implement ETL processes using SQL Server Integration Services, build and manage data warehouses using SQL Server Analysis Services, design reports and dashboards using SQL Server Reporting Services, build multidimensional and tabular data models, optimize MSBI solution performance, deploy and maintain MSBI solutions in production, and troubleshoot common MSBI implementation issues. The programme is designed to be immediately applicable to your day-to-day role.

Upcoming Sessions

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

Ready to Register for Microsoft Business Intelligence (MSBI) Training?

See full pricing, exact upcoming dates across Uganda, South Africa, Kenya, and secure your seat online in minutes.

Book This Training →