Sales Analysis

The data model captures detailed information on sales performance, comparing current and previous years across various metrics. It includes total quantities, extended costs, margins, net sales, averages per representative, customer, product, invoice, and country. Key indicators like sales growth and profit margin are visualized through combination and bullet charts. The Bubble View illustrates metric correlation while the Worksheet View offers in-depth sales data analysis with filtering options.

Benefits of This Data Model

• Enhanced Sales Performance Analysis: The data model allows for detailed comparison of sales performance metrics between current and previous years, enabling a deeper understanding of key indicators such as margins, net sales, and quantities per representative, customer, product, invoice, and country.
• Visual Representation of Key Indicators: Through combination and bullet charts, users can easily visualize and comprehend critical metrics like sales growth and profit margins, facilitating better decision-making processes.
• Correlation Illustration: The Bubble View feature presents a clear illustration of metric correlation through bubble size and colors, providing insights into relationships between different metrics.
• Advanced Data Analysis Capabilities: The Worksheet View offers comprehensive sales data analysis with filtering and sorting options, allowing users to conduct in-depth analysis and derive actionable insights for strategic planning and optimization.

Key Performance Indicators (KPIs)

• Calendar Month (Bubble): Represents the calendar month for the data analysis.
• Calendar Day (Bubble): Represents the calendar day for the data analysis.
• Quantity TY: Total quantity sold in the current year.
• Quantity LY: Total quantity sold in the previous year.
• Quantity Variance: The difference in quantity sold between the current and previous years.
• Quantity Variance %: The percentage change in quantity sold between the current and previous years.
• Ext. Cost TY: Total extended cost in the current year.
• Ext. Cost LY: Total extended cost in the previous year.
• Ext. Cost Variance: The difference in extended cost between the current and previous years.
• Ext. Cost Variance %: The percentage change in extended cost between the current and previous years.
• Margin TY: Total margin in the current year.
• Margin LY: Total margin in the previous year.
• Margin %: The percentage margin in the current year.
• Margin Variance: The difference in margin between the current and previous years.
• Margin Variance %: The percentage change in margin between the current and previous years.
• Net Sales TY: Total net sales in the current year.
• Net Sales LY: Total net sales in the previous year.
• Net Sales Variance: The difference in net sales between the current and previous years.
• Net Sales Variance %: The percentage change in net sales between the current and previous years.
• Net Sales Per Rep TY: Average net sales per sales representative in the current year.
• Net Sales Per Rep LY: Average net sales per sales representative in the previous year.
• Net Sales Per Customer TY: Average net sales per customer in the current year.
• Net Sales Per Customer LY: Average net sales per customer in the previous year.
• Net Sales Per Product TY: Average net sales per product in the current year.
• Net Sales Per Product LY: Average net sales per product in the previous year.
• Net Sales Per Invoice TY: Average net sales per invoice in the current year.
• Net Sales Per Invoice LY: Average net sales per invoice in the previous year.
• Net Sales Per Country TY: Average net sales per country in the current year.
• Net Sales Per Country LY: Average net sales per country in the previous year.
• Net Sales Volatility (STDDEV): Standard deviation of net sales data.
• Net Sales Average: Average net sales.
• Net Sales Volatility Low: Lowest volatility in net sales.
• Net Sales Volatility High: Highest volatility in net sales.
• # of Invoices TY: Total number of invoices in the current year.
• # of Customers TY: Total number of customers in the current year.
• # of Products TY: Total number of products in the current year.
• # of Salesrep TY: Total number of sales representatives in the current year.
• # of Country TY: Total number of countries in the current year.
• # of Invoices LY: Total number of invoices in the previous year.
• # of Customers LY: Total number of customers in the previous year.
• # of Products LY: Total number of products in the previous year.
• # of Salesrep LY: Total number of sales representatives in the previous year.
• # of Country LY: Total number of countries in the previous year.

Available Visualisations

View Name	Description
Main Values per Month TY vs LY (IN DEV)	Compares total sales values between current and previous years monthly.
Key Performance Indicator View (IN DEV)	Displays KPIs such as sales growth, profit margin, and customer acquisition rate.
Combination Chart View (IN DEV)	Visualizes multiple data sets in a combination of line, bar, and pie charts.
Horizontal Bullet View (IN DEV)	Shows KPI performance against set targets using horizontal bullet graphs.
Bubble View (IN DEV)	Illustrates correlation between two metrics through bubble size and colors.
Worksheet View (IN DEV)	Provides a detailed breakdown of sales data with filtering and sorting capabilities.