EKO FRESH MART PRACTICE DATA (FICTIONAL)
DMILZE EdTech - Data Analysis

Eko Fresh Mart is a made-up supermarket chain with four branches in Lagos: Yaba, Lekki, Ikeja and Surulere.
Every name, customer and number is invented for practice. Prices are in naira. Year: 2025.

FILES AND WHEN WE USE THEM
- EkoFresh_Sales_Messy_Q1_2025.xlsx   Week 2. A raw till export with real-world problems to clean.
- EkoFresh_Sales_Clean_2025.xlsx      Weeks 2, 3 and 7. Clean full-year sales plus Products, Branches and Customers.
- ekofresh.db                         Weeks 4 and 5. SQLite database. Open with DB Browser for SQLite (free).
- Week 4-5 SQL CSV files              The same five tables as CSV, for anyone using PostgreSQL.
- Week 6 Monthly Files                Monthly CSV exports, January to June. July is held back to add during class.

DATABASE TABLES
branches(branch_id, branch_name, area, opened_on, size_sqm, manager)
products(product_id, product_name, category, unit_price, unit_cost)
customers(customer_id, first_name, last_name, home_branch_id, gender, joined_on, tier)
orders(order_id, order_date, branch_id, customer_id, payment_method, channel)
order_items(line_id, order_id, product_id, quantity, unit_price, discount)
Sales for a line = quantity * unit_price * (1 - discount). Orders without a customer_id were walk-in customers.

STORIES HIDDEN IN THE DATA (for the tutor; do not share with learners until they find them)
- Sales grow through the year, with a big December peak and a quieter January.
- Fridays and Saturdays are the busiest days. Sundays are quiet.
- Lekki is the biggest branch. Surulere is the smallest but grows fastest from July.
- Prices rose about 4% in September.
- Some December lines have a 10% discount.
- About 30% of orders are walk-in customers with no customer ID.
- In the monthly files, the Sales column is renamed from April, and May has branch names in capitals.
