please see below attachments i want to
The data model should associate the following tables:
Trades – FACT table
Products – links to trade using PRODUCTCLASSID
Desk – links to trade using SALESDESKID
Exchange – links to Trade using EXCHANGEID
Sector – links to Trade using SectorID
DIMENSIONS All the dimensions such as client account, client, product, region , date etc are easily identifiable
MEASURES You must make a minimum of 5 KPI’s based on your understanding of the data. Excluding the
COUNT(ID) Number of transactions
SUM(TRADE REVENUE) Total Revenue
should be able to see the number of transactions per sales desk in a map. (Add your own coordinates)
Month to Date versus Last Year Month to Date, Month to Date versus Last Month to Date and variance
This Year to Date versus Last Year to Date and variance.