What is analystlab-africa-internship?

This repository is a personal record of one person's progress through the AnalystLab Africa Data Analytics Internship, an eight week program that teaches data analytics from raw data cleaning through SQL, dashboarding, and business case studies. Each folder in the repository corresponds to a stage of the program and holds the work completed for that stage. The first stage, covering weeks one and two, focuses on data cleaning and exploratory data analysis. It works with two real datasets: a set of more than five hundred thousand e-commerce transactions and a catalog of Netflix content. The work involves handling missing values, removing duplicate entries, fixing formatting problems, and then exploring the cleaned data to build visualizations and pull out business insights. The second stage, week three, moves into SQL and database querying. It contains twenty five SQL queries written against two sample databases, a music store database called Chinook and a sample sales dataset, run in MySQL. These queries cover joins, subqueries, window functions, and techniques for making queries run more efficiently, all aimed at answering realistic business questions. So far the tools used are Python with the Pandas and Matplotlib libraries, Jupyter Notebook for writing and running the analysis, and MySQL with MySQL Workbench for the database work. The README notes that the repository will keep growing as the internship continues, with future weeks expected to cover dashboarding tools like Power BI or Tableau, further business analytics case studies, more advanced Python and time series analysis, ETL pipelines for moving and transforming data, and a final capstone project at the end of the program.