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.

[tresesco]

.................hi........................

Hi Madhu,

Sorry, not writing this to answer your query, but to query you one. Why have all your posts to have caption 'hi' ? I guess a meaningful heading could be better from many aspects. What do you think?

[simondachstr]

Do you want us to do your homework?

[sujeetsingh]

I will quote this a bad practise to just give a complete requirement better you try implementing your self and the ask the question where you get ill results.

I will recommend you to do by your own first.

[#5]

Thank you  tresesco for giving the suggestion  one interviewer given above data   if know please to do .

[sujeetsingh]

Tresco seems you have a sharp eyes for all stuffs by Madhu

[jagadeesh_diamo]

Hi Madhu,

Don't distress, our friends are just suggesting for your betterment, hope you understand and follow that... you can do yourself when you try for sometime. Good luck.

[MarcoWedel]

and all are still open ...