High Level Design
OverviewThe 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:
- 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
Understand how much money a company makes for each dollar in sales
|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|
|#||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)