Business Data Analytics & Financial Modeling Mastery with Excel & Power BI for Strategic Decision Support
Venue: Gelian Hotel, Machakos-Kenya
Date: 20th - 25th April 2026
Cost: Kshs. 86,000 / USD 850
CPD points: 10
Overview
Combine the power of Excel and Power BI to master business data analytics and financial modeling for strategic decision support. Participants will learn to extract, transform, and analyze data from multiple sources, build dynamic financial models, and create interactive dashboards that deliver insights. The curriculum covers data integration, advanced Excel modeling, Power BI data visualization, and the use of DAX for complex calculations. Through hands‑on projects with real business data, attendees will develop end‑to‑end analytical solutions that inform strategy and drive performance. This program equips analysts, finance professionals, and managers with the tools to become data‑driven decision makers.
Objectives
- Integrate Excel and Power BI for comprehensive data analytics
- Use Power Query to clean and transform data from diverse sources
- Build financial models in Excel with best practices in structure and formulas
- Create data models in Power BI and write DAX measures
- Design interactive dashboards that visualize key insights
- Perform what‑if analysis and scenario planning
- Automate data refresh and reporting processes
- Communicate analytical findings to non‑technical stakeholders
- Apply analytics to strategic business questions (pricing, profitability, forecasting)
Target Audience
- Business and financial analysts
- Data analysts and business intelligence professionals
- Finance managers and FP&A teams
- Operations and marketing analysts
- Management consultants
- Small business owners analyzing their data
- Anyone seeking to enhance their analytics toolkit
Methodology
- Hands‑on labs with Excel and Power BI
- Data transformation exercises with Power Query
- Financial modeling case studies
- Dashboard design workshops
- DAX programming sessions
- Peer review of analytical solutions
- Action learning projects applying skills to participants' data
