High Level Design

Overview

Companies often spend vast amounts of money on the products they sell, incurring expenses such as marketing, storage, manufacturing and salaries of workers. To maintain profitability, it is important to verify each product’s operational expenses (Opex) to Sales ratio is as low as possible

Dashboard Example (sample data)

Click on the image to open and interact with the dashboard:

Opex to Sales- Financial Dashboard

 

Goals

Reduce Opex to Sales ratio.

KPI Architecture

Objective KPI’s Measures Data source
Reduce Opex to Sales ratio Opex to Sales (([Total MarketingCosts]+[Total Salary_loaded_per_SubCategoryMonthly]+[Total SubCategory_StorageCost]+[Total SubCategory_ProductionCost])/[Total SubCategory_LineTotal]) MarketingCosts,

Fact_Sales

 

Total expenses ([Total MarketingCosts]+[Total Salary_loaded_per_SubCategoryMonthly]+[Total SubCategory_StorageCost]+[Total SubCategory_ProductionCost]) MarketingCosts,

Fact_Sales

 

Total Sales [Total SubCategory_LineTotal] Fact_Sales
Opex to Sales Ratio Year over Year (([Total MarketingCosts]+[Total Salary_loaded_per_SubCategoryMonthly]+[Total SubCategory_StorageCost]+[Total SubCategory_ProductionCost])/[Total SubCategory_LineTotal]) MarketingCosts,

Fact_Sales,

DimDate

 

Ratio by Category (([Total MarketingCosts]+[Total Salary_loaded_per_SubCategoryMonthly]+[Total SubCategory_StorageCost]+[Total SubCategory_ProductionCost])/[Total SubCategory_LineTotal]) MarketingCosts,

Fact_Sales,

DimCategory

5 most/least leading subcategories in sales – their ratio (([Total MarketingCosts]+[Total Salary_loaded_per_SubCategoryMonthly]+[Total SubCategory_StorageCost]+[Total SubCategory_ProductionCost])/[Total SubCategory_LineTotal]) MarketingCosts,

Fact_Sales,

DimCategory

Data Modeling (Elasticube Design)

Opex to Sales data model