Quantium Virtual Experience Program – Task 3

📌 Project Overview

This project was completed as part of the Quantium Data Analytics Virtual Experience Program on Forage.

Task 3 focuses on transforming analytical findings from Task 1 (Customer Analytics) and Task 2 (Experimentation & Uplift Testing) into a professional business presentation for the client.

The project follows Quantium's Pyramid Principle Framework to communicate insights, recommendations, and commercial outcomes in a concise and client-friendly manner.

---

🎯 Business Objective

The objective of this project is to:

• Analyse customer purchasing behaviour
• Identify high-value customer segments
• Summarise trial store performance
• Translate analytics into business insights
• Present actionable commercial recommendations
• Deliver a professional client presentation

---

📊 Dataset

• QVI_transaction_data.xlsx
• QVI_purchase_behaviour.csv
• QVI_data.csv

---

🛠️ Tools & Technologies

• Python
• Pandas
• NumPy
• Matplotlib
• SciPy
• Microsoft PowerPoint
• Git & GitHub

---

📁 Project Structure

Quantium_Task_3_Analytics_and_Commercial_Application/

│── data/
│   ├── QVI_transaction_data.xlsx
│   ├── QVI_purchase_behaviour.csv
│   └── QVI_data.csv
│
│── notebooks/
│   └── Task3_Analytics_and_Commercial_Application.ipynb
│
│── output/
│   ├── charts/
│   ├── presentation/
│   └── reports/
│
│── presentation/
│   └── Task 3 - presentation guide_BRAND.pptx
│
├── README.md
├── requirements.txt
├── LICENSE
└── .gitignore

---

📈 Generated Visualizations

1️⃣ Total Sales by Lifestage

---

2️⃣ Total Sales by Premium Customer

---

3️⃣ Sales by Lifestage and Premium Customer

---

4️⃣ Trial vs Control Store Sales

---

5️⃣ Trial vs Control Store Transactions

---

6️⃣ Trial vs Control Store Customers

---

📊 Key Insights

• Mainstream – Young Singles/Couples generated the highest chip sales.
• Budget customers contributed significantly to category revenue.
• Trial Stores 77 and 88 demonstrated positive sales uplift.
• Store 86 showed comparatively lower improvement.
• Customer segmentation revealed clear opportunities for targeted marketing.
• Trial activities showed positive commercial impact in selected stores.

---

📑 Deliverables

• Python Notebook
• PowerPoint Presentation
• PDF Report
• Business Charts
• Client Cover Email

---

👤 Author

Syed Ubedullah Basha

LinkedIn

https://www.linkedin.com/in/syed-ubedullah-basha

GitHub

https://github.com/syed-ubedullah

---

⭐ Acknowledgement

This project was completed as part of the Quantium Data Analytics Virtual Experience Program on Forage.

The project demonstrates practical skills in:

• Data Analytics
• Customer Analytics
• Commercial Storytelling
• Business Presentation
• Data Visualization
• Client Reporting