Sales Analysis (TY vs LY) Cube

The data model includes views presenting key performance metrics such as total quantity, extended cost, margin, net sales, and averages per customer, product, invoice, sales representative, and country. It also calculates variances and percentage changes in these measures between the current year and the previous year. Additionally, the model visualizes data using bubble charts, bullet views, and combination charts to facilitate comparisons and trend analysis effectively.

Benefits of This Data Model

• Improved Decision-Making: The data model provides key performance metrics and variances, enabling quick evaluation of performance and making informed decisions.
• Enhanced Trend Analysis: By visualizing data using bubble charts, bullet views, and combination charts, the model facilitates effective trend analysis and comparisons.
• Efficient Performance Evaluation: With views presenting averages per customer, product, invoice, sales representative, and country, the model allows for detailed analysis and performance evaluation across various dimensions.
• Quick Target Analysis: The horizontal bullet view visualizes performance against targets with horizontal bars, allowing for quick target analysis and identification of areas that need attention.

Key Performance Indicators (KPIs)

• Calendar Month (Bubble): Represents the calendar month for the data analyzed in the report.
• Calendar Day (Bubble): Represents the calendar day for the data analyzed in the report.
• Quantity TY: Total quantity of items sold in the current year.
• Quantity LY: Total quantity of items sold in the previous year.
• Quantity Variance: The difference in quantity sold between the current year and the previous year.
• Quantity Variance %: The percentage change in quantity sold between the current year and the previous year.
• Ext. Cost TY: Total extended cost of items sold in the current year.
• Ext. Cost LY: Total extended cost of items sold in the previous year.
• Ext. Cost Variance: The difference in extended cost between the current year and the previous year.
• Ext. Cost Variance %: The percentage change in extended cost between the current year and the previous year.
• Margin TY: Total margin generated in the current year.
• Margin LY: Total margin generated in the previous year.
• Margin %: The percentage margin calculated for the sales.
• Margin Variance: The difference in margin between the current year and the previous year.
• Margin Variance %: The percentage change in margin between the current year and the previous year.
• Net Sales TY: Total net sales revenue in the current year.
• Net Sales LY: Total net sales revenue in the previous year.
• Net Sales Variance: The difference in net sales revenue between the current year and the previous year.
• Net Sales Variance %: The percentage change in net sales revenue between the current year and the previous year.
• 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, showing volatility in sales data.
• Net Sales Average: Average net sales revenue across all data points.
• Net Sales Volatility Low: Lowest value within the range of net sales volatility.
• Net Sales Volatility High: Highest value within the range of net sales volatility.
• # of Invoices TY: Total number of invoices generated in the current year.
• # of Customers TY: Total number of unique customers in the current year.
• # of Products TY: Total number of unique products sold in the current year.
• # of Salesrep TY: Total number of sales representatives in the current year.
• # of Country TY: Total number of countries included in the sales data for the current year.
• # of Invoices LY: Total number of invoices generated in the previous year.
• # of Customers LY: Total number of unique customers in the previous year.
• # of Products LY: Total number of unique products sold in the previous year.
• # of Salesrep LY: Total number of sales representatives in the previous year.
• # of Country LY: Total number of countries included in the sales data for the previous year.

Available Visualisations

View Name	Description
Main Values per Month TY vs LY (IN DEV)	Compares total sales values between current year and previous year on a monthly basis.
Key Performance Indicator View (IN DEV)	Displays key metrics to evaluate performance quickly and make informed decisions.
Combination Chart View (IN DEV)	Represents data using multiple chart types to show relationships and trends effectively.
Horizontal Bullet View (IN DEV)	Visualizes performance against targets with horizontal bars for quick analysis.
Bubble View (IN DEV)	Shows data points in bubbles to compare the size of elements effectively.
Worksheet View (IN DEV)	Organizes data in a tabular format for detailed analysis and comparisons.