Description: This project focuses on recommending the city for Pawdacity's 14th store in Wyoming based on predicted yearly sales. The first step involves formatting and blending data from various datasets and addressing outliers. The provided information includes monthly sales data for all Pawdacity stores in 2010, NAICS data on competitor store sales, a partially parsed data file for population numbers, and demographic data for cities and counties in Wyoming.
Key Points:
- Objective: Recommend the city for Pawdacity's new store based on predicted yearly sales.
- Business Problem: Determine the optimal location for the 14th store.
- Data Sources:
1. Monthly sales data for all Pawdacity stores in 2010.
2. NAICS data on competitor store sales (total sales for 12 months).
3. Partially parsed data file for population numbers.
4. Demographic data for cities and counties in Wyoming (includes households with individuals under 18, land area, population density, and total families).
- Steps:
1. Format and blend the data from different datasets.
2. Deal with outliers to ensure data integrity.
3. Perform analysis and prediction to estimate yearly sales for potential locations.
4. Recommend the city for the new store based on predicted yearly sales.
Solution Link