Data Analysis and Visualization: Exercises 2, 3, and 4 Analysis

This document provides a detailed solution to a data analysis and visualization assignment, covering exercises from Chapters 9 and 11. The solution utilizes expert analytics to analyze datasets, create calculated dimensions, and generate visualizations like heatmaps, bubble graphs, and time hierarchies. The analysis includes calculating revenue and gross margins, identifying sales trends by season, country, and product, and exploring customer purchasing behavior. Furthermore, the assignment explores association rules using the Apriori algorithm, providing recommendations for product promotion. The solution also analyzes data based on a star schema, examining sales revenue by region and identifying stores with high transaction amounts. The analysis incorporates a range of visualization techniques to derive meaningful insights from the data.