Aderibigbe Dede

Learning Data Analytics 💻 | Excel • SQL • Tableau
Documenting my growth, one dataset at a time 📈

[Aderibigbe Dede @dede_tech]

6. Next Steps
Thinking of expanding this analysis to Tableau for dynamic dashboards and forecasting 🚀
This project reminded me how powerful Excel can be
#DataAnalytics #Excel #Kaggle #PortfolioProject #DataCommunity
@AlexAnalyst @LukeBarousse @MicrosoftExcel

[Aderibigbe Dede @dede_tech]

🚀Just wrapped up my Coffee Shop Sales Analysis Project using Excel!
Analyzed sales from 3 NYC branches
✅ Cleaned & transformed data
📊 Found that Hell’s Kitchen leads in revenue
📈 Astoria shows strongest growth
@hnginternship
#DataAnalytics #Excel #DataVisualization #Kaggle

[Aderibigbe Dede @dede_tech]

5.Recommendations
Focus promotions in June and during high-traffic hours
Leverage Astoria’s growth potential for expansion
Optimize staffing and hours in Lower Manhattan

[Aderibigbe Dede @dede_tech]

4. Key Insights
✅ Hell’s Kitchen → Highest revenue
📈 Astoria → Fastest growth
☕ Coffee → Top-selling product
🕕 June → Peak month for sales
⏰ Lower Manhattan → Low evening sales → suggested reduced hours

[Aderibigbe Dede @dede_tech]

3. Data Cleaning Process

Removed duplicates and standardized date/category formats
Added 6 new columns for deeper insights (like Revenue and sales per hour)
Ensured consistent product and location names for accuracy

[Aderibigbe Dede @dede_tech]

2. Dataset & Tools
Dataset: Coffee Shop Sales by Ahmed Abbas on Kaggle.
Tool used: Microsoft Excel only for data cleaning, analysis, and visualization.
No fancy software, just clean formulas and charts.

[Aderibigbe Dede @dede_tech]

1. About the Project
I analyzed sales from three NYC coffee shop branches - Hell’s Kitchen, Astoria, and Lower Manhattan using Excel.
The goal was to understand store performance, product trends, and time-based sales patterns. ☕📊

[Aderibigbe Dede @dede_tech]

#100payOAU
#100paycrytotour
#100paytoken
LIVE IN OAU ❤️