High Level Design
Overview
The Net Profit Margin KPI measures how effective your business is at generating profit on each dollar of revenue you bring in. This financial KPI is a measure of the profitability of the business and is instrumental in making long- and short-term financial decisions.Dashboard Example (sample data)
Click on the image to open and interact with the dashboard:
Goals
- Allow the CFO of the company to compare the net profit margin over time and relative to other companies in the same sector.
- Allow investors to compare the net profit margin across industries to identify the most profitable and attractive sectors and companies to invest in
Objectives
Understand how much money a company makes for each dollar in sales
KPI Architecture
| Objectives | KPIs | Measures | Data Source |
|---|---|---|---|
| Understand how much money a company makes for each dollar in sales | Net Profit Margin = (Net profit / Net Sales Revenue)*100 | Net Profit | Income Statement / fact_Financial_Data |
| Net Sales | Income Statement / fact_Financial_Data |
Data Requirements
| # | Source | Table Name | Table Details (Type, #Rows, Key field/s) |
|---|---|---|---|
| 1 | Accounting data (income statement) | fact_Financial_Data | Transaction Table |
| 2 | Accounting data (income statement) | fact_Targets | Transaction Table |
Data Modeling (Elasticube Design)
