Hi

[#1]

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.

[puttemans]

Hello Madhu,

Glad to help where I can, but please be more specific in your request. Now it looks like an exam question...

Regards,

johan