This project focused on leveraging data analytics to solve complex business problems and identify growth opportunities. The primary objective was to transform raw organizational data into strategic recommendations by performing exploratory data analysis, identifying key performance indicators (KPIs), and creating data-driven narratives that align with core business goals.
- SQL: Data extraction, joining tables, Pivot Tables, VLOOKUP, Cohort analysis and filtering .
- Executed exploratory data analysis using SQL and Advanced Excel to identify key customer churn drivers, resulting in a 10% increase in retention.
- Synthesized complex datasets into data-driven narratives to provide executive leadership with actionable insights for annual budgeting.
- Implemented statistical modeling techniques using SQL window functions to forecast market trends and optimize product pricing strategies.
scripts/: SQL queries used for data extraction.data/: Description of the datasets used (raw data excluded for privacy).