Data Analytics & Visualization
Excel, SQL, Power BI and Tableau taught as one connected skill: think with data, clean it, analyze it, and tell a story that drives a decision.
What you will learn
Thinking with data
Collecting, organizing & preparing data
Exploring data & discovering insights
Working with databases & SQL
Data visualization & dashboard design
Communicating insights & business storytelling
Analytics in the modern workplace
Curriculum
Thinking with data
Case study — A retail company uses data to identify declining sales and determine the right questions before investing in analytics tools.
Project — Create an analytics plan for a real business problem — objectives, business questions, required data, and expected outcomes.
Collecting, organizing & preparing data
Case study — A healthcare clinic prepares messy patient records for meaningful reporting.
Project — Clean and prepare a messy dataset, documenting every transformation performed.
Exploring data & discovering insights
Case study — An e-commerce company analyzes customer purchasing behaviour to improve sales.
Project — Analyze a dataset and produce a business insights report with at least five actionable recommendations.
Working with databases & SQL
Case study — A subscription-based software company investigates customer churn using SQL.
Project — Write SQL queries that answer multiple business questions and explain the insights obtained.
Data visualization & dashboard design
Case study — A marketing team develops an executive dashboard to monitor campaign performance.
Project — Design and build a professional interactive dashboard suitable for business decision-makers.
Communicating insights & business storytelling
Case study — A finance department presents quarterly performance insights to company executives.
Project — Prepare a complete executive report and presentation based on a dataset analysis.
Analytics in the modern workplace
Case study — A logistics company implements automated KPI reporting to improve operational efficiency.
Project — Design a complete analytics reporting system — KPIs, dashboard design, reporting schedule, automation opportunities, and AI integration.
Capstone
End-to-end business analytics consulting project
Act as a professional data analyst engaged by a company to solve a real business problem, taking a raw dataset through the full analyst workflow to a client-ready recommendation.
· Business problem definition
· Stakeholder requirements
· Data audit
· Data cleaning documentation
· Exploratory data analysis
· SQL analysis
· Interactive dashboard
· Executive report
· Business recommendations
· Executive presentation
· Reflection on limitations & future improvements
AI-guided learning
Our AI Mentor tracks your progress and generates custom practice prompts tailored to your industry.
Peer accountability
Join weekly sessions with fellow students across Africa to share tips and build networks.
Timmy's Tip
AI Mentor“Prompting isn't about asking, it's about designing. Give the model a role, a goal and a format, and watch the quality jump.”
