Iowa-Liquour-Sales-Dataset-Analysis

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:

1. Performed Data profiling with Alteryx and cleaned the data with advance regex operations and transformation techniques for more refined and structured data.
2. This cleaned data is then loaded the data into two staged tables using both Alteryx and Talend.
3. 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.
4. Loaded the Dimensional Model using MySQL.
5. Created dashboards using PowerBI.