Sales Analytics for New Jersey Lottery
- Extracted and transformed data from various databases by aggregating, joining multiple datasets using SQL and created analytical datasets
- Quantified the sales impact of new vending machines and jackpot signs by performing pre-post and time series analysis
- Segmented store locations using K-means and recommended ideal locations for installation of new vending machines