Data analysis project using Python for existing company Instacart, an online grocery store that operates through an app. For purpose of this project fictive data about customers was added.
Instacart already had very good sales, but they wanted to uncover more information about their sales patterns. Initial data and exploratory analysis of some of their data was required in order to derive insights and suggest strategies for better segmentation based on the provided criteria with targeted marketing strategy. Management team wanted to target different customers with applicable marketing campaigns to see whether they have an effect on the sale of their products.
Data includes over 3 million rows of open-source real data about Instacart's
- orders
- products
- departments
This dataset was also used
And a fictive dataset made by data engineers in Career Foundry about Instacart's
Link for Data Dictionary can be found in Project Brief
For this project I used Python and this libraries
- pandas and numpy for data analysis
- seaborn and matplotlib-pyplot for data visualizations
Final report for a client was prepared in Excel.