Cosmetic Insights 💄 : Navigating Cosmetics Trends and Consumer Behavior

---

🛑 NOTE TO EVALUATORS & SMARTINTERNZ TEAM

I am Somapuram Uday, a final-year CST student from GPREC(A), Kurnool, enrolled in the Data Analytics with Tableau track under the SmartInternz – APSCHE Virtual Internship Program 2025.

🌀 Project Journey & Clarifications

1. Initial Project & Team (Auto-Assigned)

   • 🆔 Team ID: LTVIP2025TMID49042
   • 👤 Role: Team Leader
   • 📌 Project: Intial title “Toycraft Tales”
   • 👥 Team Members: Myself, Shaik Reshma, Shaik Sadiq Ismail, Sanda Kumar
   • ❗ Issue: All others were from GPCET including SPOC, while I belong to GPREC(A).

2. Repeated Issue Faced

   • My profile showed GPCET incorrectly instead of GPREC(A).
   • Sent 4–5 mails to SmartInternz without receiving a reply.
   • As of Today, this profile issue still persists.

3. Change in Project Allocation

   • 📩 On June 25, 2025, I was reassigned to:
     • 🆕 Team ID: LTVIP2025TMID49390
     • 🎯 Project: Cosmetic Insights: Navigating Cosmetics
     • 👤 New Team Leader: Shaik Reshma
   • ❌ However, no team member responded (old or new) via email.
   • ✅ I then discontinued the initial Toy project and fully completed the new project solo, respecting the SmartInternz portal's updated project info and timelines.

🔖 NOTE: Assignment files are stored under 1_Assignments/Somapuram_Uday/. Please consider this folder as the official submission directory.

---

📊 Project Overview

Title: Cosmetic Insights: Navigating Cosmetics Trends and Consumer Behavior
Internship Track: Data Analytics with Tableau
Goal:
To understand consumer trends, product category performance, and regional insights in the cosmetics sector using Tableau dashboards. This project provides interactive insights for better decision-making by stakeholders.

---

🧠 Technologies & Tools Used

• Tableau Public – For data visualization and interactive dashboard design
• Microsoft Excel – For preprocessing and cleaning datasets
• PDF Tools – For documentation and reporting
• Google Drive – For video demo hosting and sharing

---

🧱 Repository Structure

Cosmetic-Insights-Tableau-Project/
│
├── 1_Assignments/Somapuram_Uday/
│   ├── DA_Assignment_1_SOMAPURAM_UDAY.pdf
│   ├── DA_Assignment_2_SOMAPURAM_UDAY.pdf
│   └── DA_Assignment_3_SOMAPURAM_UDAY.pdf
│
├── 2_Ideation_Phase/
│   ├── Brainstorming.pdf
│   ├── Empathy_Map.pdf
│   └── Problem_Statement.pdf
│
├── 3_Requirement_Analysis/
│   ├── Customer_Journey_Map.pdf
│   ├── Data_Flow_Diagram.pdf
│   ├── Solution_Requirements.pdf
│   └── Technology_Stack.pdf
│
├── 4_Project_Design_Phase/
│   ├── Problem_Solution_Fit.pdf
│   ├── Proposed_Solution.pdf
│   └── Solution_Architecture.pdf
│
├── 5_Project_Planning_Phase/
│   └── Project_Planning_Template.pdf
│
├── 6_Project_Executable_Files/
│   ├── supermarket_sales.csv
│   ├── Cosmetics_Dataset.csv
│   ├── Cosmetics_Dataset.pdf
│   ├── Dashboard.twbx
│   ├── Screenshot_Dashboard.pdf
│   └── (Temp Tableau backups – optional to remove)
│       ├── ~Dashboard__12204.twbr
│       └── ~Dashboard__2568.twbr
│
├── 7_Functional_Performance_Test/
│   ├── Performance_Testing.pdf
│   └── Screenshot_Report.pdf
│
├── 8_Doc_and_Demo/
│   ├── Final_Report.pdf
│   ├── Cosmetic_Insights_Project_Presentation.pptx
│   ├── Cosmetic_Insights_Project_Presentation.pdf
│   ├── VIDEO_DEMO_LINK.pdf
│   ├── Video_Demo_Link.txt
│   ├── LINKS.pdf
│   └── Links.txt
│
├── README.md

---

📈 Tableau Public Dashboards

• Workbook: Cosmetic Insights Tableau Project
• Dashboards:
  • Dashboard 1
  • Dashboard 2
  • Dashboard 3
• Story View: Cosmetic Insights Story
• Demo Video: Watch on Google Drive

---

👨‍🎓 About Me

• Name: Somapuram Uday
• Email: [email protected]
• College: GPREC(A), Kurnool
• Branch: Computer Science and Technology (CST)
• Year: Final Year
• Internship Track: Data Analytics using Tableau

---

🙏 Acknowledgments

Special thanks to our mentors and facilitators who made this journey meaningful:

• Indraprakash Sir
• Ganesh Sir
• Mithun Sir

Your guidance and sessions have been a valuable part of this internship. 💐

⭐ Built with passion, frustration & late-night debugging ☕