Data Analytics for Business + AI

About this course

Data Analytics for Business + AI takes professionals from raw, messy business data all the way to a decision-ready dashboard and a written recommendation leadership can act on. Over three days you work with real datasets — sales, operations, finance and customer data — learning Power Query for cleaning, dimensional modelling for structure, DAX for measures, and Power BI for visual storytelling. Layered throughout is practical AI: using Claude to explore datasets, test hypotheses and write insight narratives, and Copilot to accelerate Excel and Power BI work. The programme closes with a capstone where you deliver a full analytics story to the room, the way you would to an executive team.

Class goals

• Frame business questions that analytics can actually answer
• Clean, shape and combine messy data with Power Query — repeatably
• Design star-schema models and write reliable DAX measures
• Build Power BI dashboards that lead an executive to a decision
• Use Claude and Copilot to explore data, test hypotheses and draft insight narratives
• Present findings as a clear story with recommendations, not just charts

Course outline

• 1Analytics thinking and problem framing
• 2Data preparation and refreshable pipelines in Power Query
• 3Star-schema modelling and core DAX measures
• 4Executive dashboard design in Power BI
• 5AI-accelerated analysis with Claude and Microsoft Copilot
• 6Insight storytelling and executive communication
• 7Capstone: end-to-end analysis and presentation

Programme modules

Who should attend

• Business, operations and commercial analysts
• Finance, HR, marketing and supply chain professionals who own reporting
• Managers who commission dashboards and need to interrogate them
• Data-curious professionals moving into an analytics role
• Corporate teams standardising on Power BI

What you'll walk away with

• A cleaned, refreshable data pipeline in Power Query
• A star-schema data model with reusable DAX measures
• An executive Power BI dashboard with drill-through and bookmarks
• An AI-assisted insight report with findings and recommendations
• A capstone analytics presentation delivered to the cohort

Delivery

• 3 consecutive days, 8 hours per day, fully hands-on
• Live online or in person in Westlands, Nairobi
• Maximum 12 participants per public cohort
• Includes datasets, dashboard templates, AI prompt library and certificate
• 30 days of post-course email support on your own dashboards

Frequently asked questions