AnalystLab Africa Data Analytics Internship

Executive summary

An eight-week data analytics internship programme delivered by AnalystLab Africa. The work progresses from data cleaning and exploratory analysis to SQL, dashboards, business case studies, advanced Python, ETL, and a final capstone, with project artefacts retained in the repository.

Business context

The programme is structured around a practical requirement: turn unfamiliar data into a documented decision-ready output. Each weekly assignment requires analysis, visual communication, clear documentation, and a public professional record of the work.

Data and preparation

Week 1–2 covered cleaning and EDA on e-commerce and Netflix data. Week 3 used Chinook and sales data for SQL. Week 4 focused on Superstore dashboards. Week 5 introduced the bank marketing case study, Week 6 Apple market analysis, Week 7 an OpenWeather ETL pipeline, and Week 8 a World Bank capstone.

Method

The published work combines Python notebooks, SQL scripts, Power BI files, written reports, and presentation material. The handbook makes the standards explicit: document cleaning decisions, define relevant KPIs, explain insights in plain language, and make recommendations that a stakeholder can act on.

Results, limits, and next step

The portfolio includes a Superstore dashboard, a bank marketing case study, Apple stock analysis, and SQL exercises that test query design and performance. It should be read as a record of applied internship work, not a single client engagement. The strongest next step is to publish each completed assignment as its own deeper case study with the source, method, visuals, findings, and constraints in one place.