Been putting in the work lately and wanted to share what I built this week. Took 5,000 UberEats customer orders and turned it into something actually useful → Started by writing a Python script to generate realistic order data → cleaned it up in Excel → loaded it into PostgreSQL → wrote SQL queries to dig into the numbers → built a Tableau dashboard to tell the story visually. Some things that stood out from the data: Evening is when people order the most, if I’m running marketing I’m pushing promotions right before dinner time every single day. New York and LA are the top revenue cities by a significant margin, that’s where the budget goes first. The top 10 customers spend way more than everyone else, loyalty programs exist for a reason. High value orders tend to get better ratings too, people who spend more expect more and apparently they’re getting it. This is the kind of work I want to keep doing, taking messy data and turning it into decisions someone can actually act on. 🔗 https://lnkd.in/eqXqt-Pu Open to data analyst roles and freelance contracts, let’s connect. #DataAnalytics #SQL #Tableau #Python #PostgreSQL #Portfolio #OpenToWork
Jodson Cadet’s Post
Explore content categories
- Career
- Productivity
- Finance
- Soft Skills & Emotional Intelligence
- Project Management
- Education
- Technology
- Leadership
- Ecommerce
- User Experience
- Recruitment & HR
- Customer Experience
- Real Estate
- Marketing
- Sales
- Retail & Merchandising
- Science
- Supply Chain Management
- Future Of Work
- Consulting
- Writing
- Economics
- Artificial Intelligence
- Employee Experience
- Workplace Trends
- Fundraising
- Networking
- Corporate Social Responsibility
- Negotiation
- Communication
- Engineering
- Hospitality & Tourism
- Business Strategy
- Change Management
- Organizational Culture
- Design
- Innovation
- Event Planning
- Training & Development