DSAC 105 DSAC • Data Science, Analytics & Cyber 8 CPD Points NITA Accredited

SUPERCHARGE EXCEL & POWER BI INTEGRATION: ADVANCED DATA ARCHITECTURE, VISUALIZATION & ANALYTICAL SOLUTIONS WITH POWER QUERY, POWER PIVOT & DAX.

Transforming data into actionable intelligence requires seamless integration between analytical tools, advanced data modeling techniques, and powerful visualization capabilities. This program equips Data Analysts, Business Intelligence Professionals, Finance Managers, Monitoring...

+ Add to Google Calendar + iCal / Outlook export Register Delegates
00
DAYS
00
HOURS
00
MINUTES
00
SECONDS

Programme Overview

Transforming data into actionable intelligence requires seamless integration between analytical tools, advanced data modeling techniques, and powerful visualization capabilities. This program equips Data Analysts, Business Intelligence Professionals, Finance Managers, Monitoring and Evaluation Officers, ICT Professionals, and Decision-Makers with practical skills to integrate Excel and Power BI, leverage Power Query, Power Pivot, and DAX, and develop advanced analytical solutions that drive data-informed decision-making. Participants will gain actionable expertise to optimize data architecture, automate data preparation processes, strengthen analytical capabilities, and create powerful Excel and Power BI solutions that enhance organizational performance and business intelligence outcomes.

Key Learning Objectives Core Outcomes

✓
Excel & Power BI Integration Mastery: Learn strategies to seamlessly connect Excel and Power BI environments, enabling efficient data sharing, reporting, and business intelligence workflows.
✓
Advanced Data Architecture & Modeling: Acquire skills to design robust data models, structure datasets effectively, and utilize Power Pivot to manage complex data relationships and analytical requirements.
✓
Power Query Automation & Data Transformation: Develop approaches to extract, clean, transform, and automate data preparation processes using Power Query to improve efficiency, consistency, and data quality.
✓
Data Visualization, DAX & Analytical Solutions: Apply techniques to create interactive dashboards, develop advanced DAX calculations, generate actionable insights, and deliver impactful reports that support strategic and operational decision-making.

Curriculum Breakdown

4 Modules
Module 1
Fiduciary Responsibility, Ethical Leadership & Board Synergy
Understanding legal liabilities, statutory reporting, and governance codes.
Module 2
Applied Data Analytics & Automated Institutional Dashboards
Hands-on case studies building live queries and decision matrices.
Module 3
Risk Governance, Crisis Mitigation & Audit Readiness
Navigating regulatory inspections, internal controls, and fraud prevention.
Module 4
Executive Action Labs & Capstone Certification
Peer presentations, adoption roadmaps, and CPD certificate issuance.

Target Audience

This executive curriculum is calibrated for senior leaders and institutional executives:

Board Members & Directors Chief Executive Officers Heads of Finance & Internal Audit Public Sector Directors & PSs County Executive Committee Members Senior Managers & Strategists
Standard Investment
KES 99,850.00
+ VAT per delegate (Inclusive of conference materials, meals & CPD certification)
Dates: 16 – 20 Nov 2026
Venue: To be announced, To be announced
Division: DSAC
CPD Accreditation: 8 CPD Points
Certification: Verifiable QR Certificate
NITA Levy: Fully Reimbursable
Book / Register Delegates Request as In-House Cohort
Questions? Call 24/7 Hotline: +254 722 998105

Scan to Register

Scan QR Code to Register

Scan with your smartphone camera to immediately open the registration form on your phone.

Or fill out the form below
Instant Delegate Enrollment

Register for DSAC 105

Complete this form to reserve delegate seats. A proforma invoice and booking confirmation will be dispatched immediately.

DSAC • DSAC 105
SUPERCHARGE EXCEL & POWER BI INTEGRATION: ADVANCED DATA ARCHITECTURE, VISUALIZATION & ANALYTICAL SOLUTIONS WITH POWER QUERY, POWER PIVOT & DAX.
16 – 20 Nov 2026 • To be announced, To be announced
Tuition / Delegate KES 99,850.00
By submitting, you confirm the reservation. NITA levy reimbursable.
Home Book Contact Call