This project analyzes the purchase behavior of Iowa Class "E" liquor licensees, covering detailed information about product purchases and corresponding purchase dates. The dataset contains over 24 million rows, providing a comprehensive look at liquor sales from January 1, 2012, to the present.
- The dataset encompasses purchase records of Iowa Class "E" liquor licensees, including product details and purchase timestamps.
- Time Period: January 1, 2012 – Present.
- We have employed a Dimensional Model to structure the data.
- The model includes Fact and Dimension tables, created based on the original dataset.
- This approach supports an efficient and logical structure for conducting our analysis.
- Alteryx was used to profile the data, helping us identify areas requiring cleaning and correction.
- Data accuracy and consistency were prioritized to ensure reliable analysis.
- Talend was utilized for integrating data from multiple sources into consolidated tables.
- This integration step ensures that information from various origins is merged into a unified dataset for more effective analysis.
- To visualize the analysis, Tableau was used to create interactive dashboards.
- These visualizations provide insights into sales trends, product performance, and licensee purchase behaviors over time.
Link to Tableau Data Visualization
- Data Profiling and Cleaning: Alteryx
- Data Integration: Talend
- Data Visualization: Tableau
- Data Storage and Modeling: Dimensional Model (Fact and Dimension tables)
- Expanding the analysis to include advanced predictive models for sales forecasting.
- Adding geographic analysis to identify regional sales patterns.
- Integrating external datasets to explore external factors affecting sales.
This project is licensed under the MIT License.
Feel free to explore the repository and check out the visualizations in Tableau. Any suggestions or feedback are always welcome!