Behind every great dashboard is a clean query. I’m currently using SQL to transform raw event logs into actionable intelligence for an e-commerce build.
Key Metrics Extracted:
Traffic Quality: Identifying high-intent sources via avg_session_duration.
The client, a local or multi-location coffee shop, was experiencing a Profit Leak and Stagnant Sales Growth. Management decisions relied on gut feeling rather than verifiable performance metrics.
This project was designed to empower the marketing team of a retail store with actionable insights into customer behavior. By cleaning and transforming a complex dataset using Python and Pandas, I created a streamlined CSV source that feeds into a Power BI dashboard. This tool...