This dataset contains the spirits purchase information of Iowa Class “E” liquor licensees by product and date of purchase from January 1, 2012 to present.
To Start with the Analysis:
- Performed Data profiling with Alteryx and cleaned the data with advance regex operations and transformation techniques for more refined and structured data.
- This cleaned data is then loaded the data into two staged tables using both Alteryx and Talend.
- Created Dimensional Model along with its SQL scripts using Navicat Data Modeler having sales as fact and stores,products,geography,city population,county population,Vendor and Product Category as Dimenions.
- Loaded the Dimensional Model using MySQL.
- Created dashboards using PowerBI.