High Level Design
Overview
Like most businesses, retail banks are constantly looking for ways to improve their revenue. Hence, these organizations measure their various sources of relative income in order to see which products or services have room to grow.
Goals
Increase revenue.
Objectives
Identify revenue growth potential.
KPI Architecture
| Objective | KPI’s | Measures | Data source |
| Identify revenue growth potential
|
Total Amount | sum([Transaction Amount]) | Fact_Transactions |
| Relative Income per Customer Type | sum([Transaction Amount]) | Fact_Transactions,
DimCustomerAccount |
|
| Income by quarter | sum([Transaction Amount]) | Fact_Transactions,
DimDate |
|
| Income by Category | sum([Transaction Amount]) | Fact_Transactions,
DimCategory |
|
| Income per State | sum([Transaction Amount]) | Fact_Transactions,
DimCustomerAccount |
|
| Mortgage performance | sum([Transaction Amount]), Filtering only mortgages subcategory | Fact_Transactions,
DimCategory |
|
| Credit Loan performance | sum([Transaction Amount]), Filtering only credit loan subcategory | Fact_Transactions,
DimCategory |
Data Modeling (Elasticube Design)
Data Connectors
