Translate business problems into clear analytics questions.
School of Data & AIData AnalyticsIntermediateIncluded in a Professional Diploma
Data Analytics Studio
Build complete analytics projects that prove you can solve real business problems with data.
Apply Excel, SQL, Python, Power BI, analytical thinking, documentation, and storytelling to complete end-to-end projects that show your readiness for data analyst and BI analyst work.
Duration
6 weeks - 6-8 hours/week
Project
Translate business problems into clear analytics questions.
Support
Pricing and enrolment are handled through the Professional Diploma
Overview
A practical Short Course built around a visible project.
Apply Excel, SQL, Python, Power BI, and storytelling to complete end-to-end analytics projects for your portfolio.
Plan an end-to-end analytics project.
Choose the right tool for each stage of analysis.
Clean, query, analyze, visualize, and present real datasets.
Combine Excel, SQL, Python, and Power BI in practical workflows.
Build complete portfolio-ready analytics projects.
Write clear case studies and project documentation.
Present insights, recommendations, and business impact.
Improve dashboard storytelling and executive reporting skills.
Prepare analytics projects for job applications and interviews.
Course roadmap
What you will work through.
The sequence below is specific to this course. It shows the phases, modules, lessons, and page outlines that move you toward Translate business problems into clear analytics questions..
1Phase 1 - From Business Problem to Analytics PlanTeach students how to translate vague business requests into a scoped analytics brief with stakeholders, questions, KPIs, risks, assumptions, and deliverables.1 modules5 lessons1 week
Module 1: Analytics Project DiscoveryUnderstand business context, gather stakeholder requirements, define KPIs, plan analytics projects, and produce an analytics brief.5 lessons
Lesson 1: Understanding the Business ContextLearn how to understand the business problem before touching data, tools, charts, SQL, Python, or dashboards.85 minarticle6 pages
Welcome and Learning Objectives
Introduce business-context-first analytics.
8 min
The Business Problem Comes First
Explain the importance of problem understanding.
18 min
Stakeholders, Decisions and Success
Clarify the core project context.
20 min
Avoiding Analysis Without Business Purpose
Teach students how to avoid random analysis.
18 min
Scenario Walkthrough
Show how to decode a vague stakeholder request.
18 min
Exercise - Find the Real Decision
Students identify the real business decision behind a scenario.
21 min
Lesson 2: Stakeholder RequirementsLearn how to ask good stakeholder questions, clarify vague requests, separate nice-to-have items from decision-critical needs, and write analytics requirements.85 minarticle5 pages
Welcome and Learning Objectives
Introduce stakeholder requirements.
8 min
How to Ask Better Questions
Teach stakeholder questioning.
20 min
Decision-Critical vs Nice-to-Have
Teach prioritization.
18 min
Writing Analytics Requirements
Show a requirements structure.
20 min
Exercise - Convert a Vague Dashboard Request
Students convert a vague dashboard request into clear requirements.
19 min
Lesson 3: Defining Metrics and KPIsLearn how to define metrics, KPIs, leading and lagging indicators, vanity metrics, ownership, and calculation definitions.85 minarticle5 pages
Welcome and Learning Objectives
Introduce KPI definition for studio projects.
8 min
Metrics vs KPIs
Explain metric categories.
18 min
Leading, Lagging and Vanity Metrics
Teach metric judgment.
18 min
KPI Definition Template
Give a reusable KPI definition structure.
20 min
Exercise - KPI Definition Studio
Students create KPI definitions for a selected business.
21 min
Lesson 4: Analytics Project PlanningLearn how to plan analytics project scope, deliverables, timeline, data sources, risks, and assumptions.85 minarticle5 pages
Welcome and Learning Objectives
Introduce analytics project planning.
8 min
Scope and Deliverables
Teach scope control.
20 min
Timeline, Data Sources, Risks and Assumptions
Explain planning details.
22 min
One-Page Analytics Project Plan
Provide a reusable project plan structure.
18 min
Exercise - One-Page Analytics Project Plan
Students write a project plan.
17 min
Lesson 5: Mini Project 1 - Analytics BriefStudents choose one business case and produce a professional analytics brief that anchors the studio project.100 minarticle2 pages
Project Brief
Explain the project scenario and expected output.
20 min
Review Checklist
Checklist for project quality.
20 min
2Phase 2 - Data Audit, Cleaning and PreparationAudit available data, document quality issues, choose cleaning strategies, and prepare analysis-ready datasets.1 modules5 lessons1 week
Module 1: Data UnderstandingReview data sources, audit data quality, plan cleaning work, and design a reproducible preparation workflow.5 lessons
Lesson 1: Data Source ReviewReview available datasets, required tables/files, data dictionaries, source reliability, and ownership.60 minarticle3 pages
Overview and Learning Objectives
Introduce the lesson and clarify expected outcomes.
8 min
Concepts and Professional Workflow
Explain the concept through a professional analytics workflow.
30 min
Practice Activity
Apply the lesson through a guided studio activity.
22 min
Lesson 2: Data Quality AuditAudit missing values, duplicates, invalid categories, date issues, outliers, inconsistent IDs, and broken relationships.70 minarticle3 pages
Overview and Learning Objectives
Introduce the lesson and clarify expected outcomes.
8 min
Concepts and Professional Workflow
Explain the concept through a professional analytics workflow.
35 min
Practice Activity
Apply the lesson through a guided studio activity.
27 min
Lesson 3: Cleaning StrategyChoose what to clean in Excel, SQL, Python, or Power Query and document cleaning decisions.60 minarticle3 pages
Overview and Learning Objectives
Introduce the lesson and clarify expected outcomes.
8 min
Concepts and Professional Workflow
Explain the concept through a professional analytics workflow.
30 min
Practice Activity
Apply the lesson through a guided studio activity.
22 min
Lesson 4: Data Preparation WorkflowDesign raw, cleaned, analysis-ready, dashboard-ready, and reproducible data workflows.65 minarticle3 pages
Overview and Learning Objectives
Introduce the lesson and clarify expected outcomes.
8 min
Concepts and Professional Workflow
Explain the concept through a professional analytics workflow.
32 min
Practice Activity
Apply the lesson through a guided studio activity.
25 min
Lesson 5: Mini Project 2 - Data Quality and Preparation ReportProduce a data dictionary, data quality audit, cleaning plan, risk notes, and prepared analysis dataset.90 minarticle2 pages
Project Brief
Explain the project scenario and expected output.
20 min
Review Checklist
Checklist for project quality.
20 min
3Phase 3 - SQL Analytics LayerUse SQL to translate business questions into queries and create dashboard-ready reporting outputs.1 modules5 lessons1 week
Module 1: Building Reporting Datasets with SQLBuild KPI, segmentation, trend, and dashboard-ready SQL outputs.5 lessons
Lesson 1: Translating Questions into SQLTurn business questions into SQL plans before writing queries.60 minarticle3 pages
Overview and Learning Objectives
Introduce the lesson and clarify expected outcomes.
8 min
Concepts and Professional Workflow
Explain the concept through a professional analytics workflow.
30 min
Practice Activity
Apply the lesson through a guided studio activity.
22 min
Lesson 2: KPI QueriesWrite SQL queries for revenue, orders, customers, conversion, retention, churn, and growth.70 minarticle3 pages
Overview and Learning Objectives
Introduce the lesson and clarify expected outcomes.
8 min
Concepts and Professional Workflow
Explain the concept through a professional analytics workflow.
35 min
Practice Activity
Apply the lesson through a guided studio activity.
27 min
Lesson 3: Segmentation QueriesCreate customer, product, geographic, cohort, and campaign segment reports.65 minarticle3 pages
Overview and Learning Objectives
Introduce the lesson and clarify expected outcomes.
8 min
Concepts and Professional Workflow
Explain the concept through a professional analytics workflow.
32 min
Practice Activity
Apply the lesson through a guided studio activity.
25 min
Lesson 4: Dashboard-Ready SQL OutputsCreate clean reporting tables, naming conventions, reusable views, and documented query outputs.70 minarticle3 pages
Overview and Learning Objectives
Introduce the lesson and clarify expected outcomes.
8 min
Concepts and Professional Workflow
Explain the concept through a professional analytics workflow.
35 min
Practice Activity
Apply the lesson through a guided studio activity.
27 min
Lesson 5: Milestone Project 1 - SQL Reporting LayerProduce the SQL reporting layer for the studio project.110 minarticle2 pages
Project Brief
Explain the project scenario and expected output.
20 min
Review Checklist
Checklist for project quality.
20 min
4Phase 4 - Python Exploratory AnalysisUse Python to explore patterns, trends, customer/revenue behavior, operational issues, and insight statements.1 modules6 lessons1–2 weeks
Module 1: Exploratory Data Analysis with PythonUse Python notebooks for deeper analysis and evidence-based insight generation.6 lessons
Lesson 1: EDA StrategyExplore data systematically using questions, hypotheses, patterns, and group comparisons.60 minarticle3 pages
Overview and Learning Objectives
Introduce the lesson and clarify expected outcomes.
8 min
Concepts and Professional Workflow
Explain the concept through a professional analytics workflow.
30 min
Practice Activity
Apply the lesson through a guided studio activity.
22 min
Lesson 2: Customer and Revenue AnalysisAnalyze customer value, repeat customers, revenue distribution, segment behavior, and retention indicators.75 minarticle3 pages
Overview and Learning Objectives
Introduce the lesson and clarify expected outcomes.
8 min
Concepts and Professional Workflow
Explain the concept through a professional analytics workflow.
37 min
Practice Activity
Apply the lesson through a guided studio activity.
30 min
Lesson 3: Product, Campaign or Operations AnalysisAnalyze product performance, campaign performance, process bottlenecks, operational efficiency, and outliers.75 minarticle3 pages
Overview and Learning Objectives
Introduce the lesson and clarify expected outcomes.
8 min
Concepts and Professional Workflow
Explain the concept through a professional analytics workflow.
37 min
Practice Activity
Apply the lesson through a guided studio activity.
30 min
Lesson 4: Trend and Time-Based AnalysisAnalyze monthly/weekly trends, seasonality, growth rates, and rolling averages.70 minarticle3 pages
Overview and Learning Objectives
Introduce the lesson and clarify expected outcomes.
8 min
Concepts and Professional Workflow
Explain the concept through a professional analytics workflow.
35 min
Practice Activity
Apply the lesson through a guided studio activity.
27 min
Lesson 5: From Analysis to InsightTurn evidence into interpretation, limitations, business implication, and recommendation.65 minarticle3 pages
Overview and Learning Objectives
Introduce the lesson and clarify expected outcomes.
8 min
Concepts and Professional Workflow
Explain the concept through a professional analytics workflow.
32 min
Practice Activity
Apply the lesson through a guided studio activity.
25 min
Lesson 6: Milestone Project 2 - Python Insight NotebookProduce a clean Python insight notebook for the studio project.120 minarticle2 pages
Project Brief
Explain the project scenario and expected output.
20 min
Review Checklist
Checklist for project quality.
20 min
5Phase 5 - Power BI Decision DashboardPlan, build, refine, and validate a decision-focused Power BI dashboard.2 modules9 lessons1–2 weeks
Module 1: Dashboard Planning and DesignPlan dashboard purpose, wireframes, data model, measures, pages, and build sprint outputs.4 lessons
Lesson 1: Dashboard PurposeDecide executive, diagnostic, and operational dashboard pages based on audience and decisions.60 minarticle3 pages
Overview and Learning Objectives
Introduce the lesson and clarify expected outcomes.
8 min
Concepts and Professional Workflow
Explain the concept through a professional analytics workflow.
30 min
Practice Activity
Apply the lesson through a guided studio activity.
22 min
Lesson 2: Dashboard WireframingPlan layout, KPI placement, navigation, visual hierarchy, and filtering strategy.65 minarticle3 pages
Overview and Learning Objectives
Introduce the lesson and clarify expected outcomes.
8 min
Concepts and Professional Workflow
Explain the concept through a professional analytics workflow.
32 min
Practice Activity
Apply the lesson through a guided studio activity.
25 min
Lesson 3: Data Model ReviewReview fact/dimension thinking, relationships, date table, measure planning, and model documentation.70 minarticle3 pages
Overview and Learning Objectives
Introduce the lesson and clarify expected outcomes.
8 min
Concepts and Professional Workflow
Explain the concept through a professional analytics workflow.
35 min
Practice Activity
Apply the lesson through a guided studio activity.
27 min
Lesson 4: Dashboard Build SprintBuild report pages, DAX measures, filters, tooltips, drill-through, and formatting consistency.90 minarticle3 pages
Overview and Learning Objectives
Introduce the lesson and clarify expected outcomes.
8 min
Concepts and Professional Workflow
Explain the concept through a professional analytics workflow.
45 min
Practice Activity
Apply the lesson through a guided studio activity.
37 min
Module 2: Insight-Driven BIBuild executive, diagnostic, and operational dashboard pages and run dashboard QA.5 lessons
Lesson 1: Executive Summary PageBuild an executive page with KPI cards, trends, alerts, narrative, and recommended actions.75 minarticle3 pages
Overview and Learning Objectives
Introduce the lesson and clarify expected outcomes.
8 min
Concepts and Professional Workflow
Explain the concept through a professional analytics workflow.
37 min
Practice Activity
Apply the lesson through a guided studio activity.
30 min
Lesson 2: Diagnostic Analysis PagesBuild drill-down views, segmentation, root-cause investigation, and comparative analysis pages.75 minarticle3 pages
Overview and Learning Objectives
Introduce the lesson and clarify expected outcomes.
8 min
Concepts and Professional Workflow
Explain the concept through a professional analytics workflow.
37 min
Practice Activity
Apply the lesson through a guided studio activity.
30 min
Lesson 3: Operational Monitoring PageBuild monitoring workflows, exceptions, SLA tracking, and team/region performance pages.70 minarticle3 pages
Overview and Learning Objectives
Introduce the lesson and clarify expected outcomes.
8 min
Concepts and Professional Workflow
Explain the concept through a professional analytics workflow.
35 min
Practice Activity
Apply the lesson through a guided studio activity.
27 min
Lesson 4: Dashboard Review and RefinementRemove clutter, improve readability, test interactions, validate numbers, and run stakeholder review.65 minarticle3 pages
Overview and Learning Objectives
Introduce the lesson and clarify expected outcomes.
8 min
Concepts and Professional Workflow
Explain the concept through a professional analytics workflow.
32 min
Practice Activity
Apply the lesson through a guided studio activity.
25 min
Lesson 5: Milestone Project 3 - Power BI Decision DashboardProduce a decision-focused Power BI dashboard for the studio project.130 minarticle2 pages
Project Brief
Explain the project scenario and expected output.
20 min
Review Checklist
Checklist for project quality.
20 min
6Phase 6 - Communication, Presentation and Stakeholder DeliveryWrite executive insights, present findings, and prepare handover documentation.1 modules5 lessons1 week
Module 1: Data Storytelling for Business DecisionsTurn analysis into business communication and stakeholder-ready delivery.5 lessons
Lesson 1: Writing Insight StatementsDifferentiate observation, insight, recommendation, and evidence-based writing.60 minarticle3 pages
Overview and Learning Objectives
Introduce the lesson and clarify expected outcomes.
8 min
Concepts and Professional Workflow
Explain the concept through a professional analytics workflow.
30 min
Practice Activity
Apply the lesson through a guided studio activity.
22 min
Lesson 2: Executive ReportingWrite one-page summaries with key findings, risks, opportunities, recommended actions, assumptions, and limitations.70 minarticle3 pages
Overview and Learning Objectives
Introduce the lesson and clarify expected outcomes.
8 min
Concepts and Professional Workflow
Explain the concept through a professional analytics workflow.
35 min
Practice Activity
Apply the lesson through a guided studio activity.
27 min
Lesson 3: Presenting to StakeholdersPresent methodology simply, handle questions, defend assumptions, and avoid tool-heavy presentations.70 minarticle3 pages
Overview and Learning Objectives
Introduce the lesson and clarify expected outcomes.
8 min
Concepts and Professional Workflow
Explain the concept through a professional analytics workflow.
35 min
Practice Activity
Apply the lesson through a guided studio activity.
27 min
Lesson 4: Analytics HandoverCreate documentation, refresh instructions, data definitions, known limitations, and maintenance plan.60 minarticle3 pages
Overview and Learning Objectives
Introduce the lesson and clarify expected outcomes.
8 min
Concepts and Professional Workflow
Explain the concept through a professional analytics workflow.
30 min
Practice Activity
Apply the lesson through a guided studio activity.
22 min
Lesson 5: Mini Project 3 - Executive Insight PackPackage executive summary, findings, recommendations, dashboard walkthrough notes, and handover documentation.90 minarticle2 pages
Project Brief
Explain the project scenario and expected output.
20 min
Review Checklist
Checklist for project quality.
20 min
7Phase 7 - Portfolio, Interview and Career ReadinessPackage the analytics project into a credible portfolio case study and prepare for analytics interviews.1 modules4 lessons1 week
Module 1: Building an Analytics PortfolioBuild portfolio standards, case studies, GitHub packaging, and interview readiness.4 lessons
Lesson 1: Portfolio Project StandardsUnderstand credible portfolio projects, avoiding toy projects, case study structure, and showing business impact.60 minarticle3 pages
Overview and Learning Objectives
Introduce the lesson and clarify expected outcomes.
8 min
Concepts and Professional Workflow
Explain the concept through a professional analytics workflow.
30 min
Practice Activity
Apply the lesson through a guided studio activity.
22 min
Lesson 2: Writing Case StudiesWrite case studies with problem, data, method, insights, recommendations, tools, screenshots, and limitations.70 minarticle3 pages
Overview and Learning Objectives
Introduce the lesson and clarify expected outcomes.
8 min
Concepts and Professional Workflow
Explain the concept through a professional analytics workflow.
35 min
Practice Activity
Apply the lesson through a guided studio activity.
27 min
Lesson 3: GitHub and Project PackagingPackage repositories with README, data privacy, notebook cleanup, dashboard screenshots, SQL folder, and Power BI notes.70 minarticle3 pages
Overview and Learning Objectives
Introduce the lesson and clarify expected outcomes.
8 min
Concepts and Professional Workflow
Explain the concept through a professional analytics workflow.
35 min
Practice Activity
Apply the lesson through a guided studio activity.
27 min
Lesson 4: Analytics Interview PreparationPrepare to explain projects, answer SQL questions, critique dashboards, discuss business cases, and explain cleaning decisions.75 minarticle3 pages
Overview and Learning Objectives
Introduce the lesson and clarify expected outcomes.
8 min
Concepts and Professional Workflow
Explain the concept through a professional analytics workflow.
37 min
Practice Activity
Apply the lesson through a guided studio activity.
30 min
8Phase 8 - Final Capstone and GraduationComplete the end-to-end business analytics capstone and package all final portfolio assets.1 modules3 lessons1 week
Module 1: End-to-End Business Analytics CapstoneStudents act as the data analyst for a business team and deliver a complete analytics project.3 lessons
Lesson 1: Studio Project OptionsChoose a realistic analytics project option for the final capstone.60 minarticle1 pages
Choose Your Capstone Scenario
Review approved studio project options.
60 min
Lesson 2: Final Capstone - End-to-End Business Analytics CapstoneStudents define a business problem, prepare data, analyze it with SQL and Python, build a Power BI dashboard, present insights, and package the project professionally.180 minarticle2 pages
Project Brief
Explain the project scenario and expected output.
20 min
Review Checklist
Checklist for project quality.
20 min
Lesson 3: Graduation Requirements and Portfolio OutcomeClarify completion requirements and portfolio outputs.55 minarticle1 pages
Graduation Requirements
Summarize what students must complete before graduation.
55 min
Tools and skills
Build skill with the tools used in the work.
Translate business problems into clear analytics questions.Plan an end-to-end analytics project.Choose the right tool for each stage of analysis.Clean, query, analyze, visualize, and present real datasets.Combine Excel, SQL, Python, and Power BI in practical workflows.Build complete portfolio-ready analytics projects.Write clear case studies and project documentation.Present insights, recommendations, and business impact.Improve dashboard storytelling and executive reporting skills.Prepare analytics projects for job applications and interviews.
Projects and exercises
- Translate business problems into clear analytics questions.
- Structured exercises
- Portfolio practice
Resources included
- Course resources
- Project guidance
- Learners building practical tech skills
- A willingness to practice consistently
Career relevance
Data Analytics Studio supports practical career readiness.
Related Professional Diploma
View Professional DiplomaData Analytics
Become a practical data analyst who can clean, analyze, visualize, and communicate business data using Excel, SQL, Python, Power BI, and real-world analytics projects.
FAQ
Questions about this Short Course.
Short Course answers about scope, projects, support, and next steps.
It is a project-focused course where learners combine their analytics skills to solve realistic business problems from start to finish.
Related Short Courses
View all Short CoursesContinue building connected skills.
School of Data & AIData & AIBeginner to Intermediate
Excel for Data Analytics
Turn raw spreadsheets into clean analysis, useful reports, and business-ready insights.
Master the Excel skills used by data analysts to clean, organize, calculate, summarize, visualize, and report business data with confidence.
From₦50,000
6 weeks - 5–8 hours /week
Clean and organize messy spreadsheet data.
Project included
Mentor review available
School of Data & AIData AnalyticsIntermediate
Power BI for Business Intelligence
Build interactive dashboards and business reports that make performance clear.
Learn to connect, clean, model, measure, visualize, and present business data using Power BI.
From₦85,000
8 weeks - 6-8 hours/week
Connect Power BI to different data sources.
Project included
Mentor review available
School of Data & AIData AnalyticsBeginner to Intermediate
SQL for Data Analytics
Query databases, join tables, summarize records, and uncover business insights with SQL.
Learn the SQL skills data analysts use to extract, filter, join, group, and analyze data from relational databases.
From₦65,000
7 weeks - 6-8 hours/week
Understand tables, columns, rows, keys, and relationships.
Project included
Mentor review available
Related Professional Diploma
Data Engineering
Professional Diploma application
Continue through Data Analytics.
This course is included in a Professional Diploma, so tuition enrollment is handled after the diploma application flow.