Quick intro into EDA
Exploratory Data Analysis applied on the data collected from a store on a Black Friday. First part is made in Python and the resulted table is exported and the analysis is continued in Excel.
Further let’s dive into Excel for pivot charts in order to get a better grasp of the data:
Once the store understands that 75% of their customers on the respective day are males between 18 to 45 and from this over half are between 26-35 with 1 year in the current city. And despite the strong sales from a category B city, overall Product_Category_2 had the highest popularity in every city type…the store it will be able to optimize their stock and adapt their pricing taking as a reference this information. Further more the store will be able to spend their marketing dollars better, tailor the store and merchandise more towards their core customer, and ultimately grow their business.