In this project, I've skillfully blended the art of data visualization with the strategic application of data modeling to create an interactive dashboard that not only showcases my data visualization prowess but also illuminates the intricate relationships between different dimensions of sales data.
User Case:
Imagine you are a data-savvy business analyst or a sales manager entrusted with optimizing sales
performance. You need a versatile tool that not only presents sales data beautifully but also unearths
the complex relationships between various dimensions, helping you make informed decisions. This is where
our Data Visualization with Relationship Modeling Dashboard excels.
Year Filter: Users can select a specific year to focus on, enabling a holistic analysis of sales data for a particular timeframe.
Region Filter: Users can filter data by region, facilitating a detailed examination of sales by country within the selected region.
Sales and Profit Metrics by Month: Visualizations elegantly depict sales and profit margin trends over time, showcasing nuanced relationships between different months.
Quantity by Category: VA bar chart vividly illustrates the quantity of products sold in different categories, providing insights into how these quantities relate to various categories.
Profit by Category: A pie chart artistically displays the distribution of profits across product categories, elucidating the intricate relationship between category profitability.
Profit by Subcategory: A detailed breakdown of profit by subcategories reveals the subtleties of profitability relationships at the subcategory level.
Profit by Salesperson: Users can assess the performance of salespeople while discerning the connections between individual sales representatives and profitability.
Matrix with Order, Sales, Cost, Profit, and Profit Margin: A comprehensive matrix view harmonizes the relationships between order-related metrics, including sales, cost, profit, and profit margins, providing a holistic view of these interconnected dimensions.
Sales vs. Target by Month: Users can track sales against predefined targets on a monthly basis, observing how actual sales align with target goals and identifying relationships between monthly performance and targets.
