## 🎯 Challenge 01 — Objectives

**From Data Chaos to Analytical Clarity**

The first challenge in the *Grocery Retail – Driven by Data* series transforms scattered spreadsheets into a structured, queryable database.
Participants learn how **data modeling, normalization, and reproducible pipelines** turn messy operational data into a foundation for trusted analytics and machine learning.

---

### 🧭 Core Objectives

You’ll design and implement a schema that connects every part of the retail operation — from stores and vendors to products and transactions.

**Key goals:**

* **Reverse-engineer the data model.** Identify entities (stores, products, vendors, transactions) and define relationships through a conceptual ERD.
* **Normalize for scalability.** Implement a PostgreSQL schema following **3NF principles** while maintaining analytical flexibility.
* **Build reliable ETL pipelines.** Create repeatable scripts to clean, type-coerce, and load data while enforcing key constraints and referential integrity.
* **Demonstrate analytic readiness.** Prove that your schema supports meaningful business queries and simple baseline modeling (e.g., daily sales forecasting).
* **Document your logic.** Deliver clear data dictionaries, schema diagrams, and concise rationale for every modeling choice.

---

### 💡 Broader Learning Outcomes

This challenge is designed to develop the habits and mindset of **data architects and applied analysts**:

* Treat data structure as analysis — design schemas that clarify business meaning.
* Build **transparent, reproducible** ETL processes ready for automation and audit.
* Connect architecture and analytics — ensuring models rest on **stable, traceable data**.
* Prepare for **Challenge 02 (Errors → Integrity)**, where the same schema will be tested under real-world data-quality stress.