Hi Anu,
You have data, (my idea) Dashboard is generally a screen shot of updates, status of processes, performance. Now the question you may ask what the person want to see who is intended to use this dashboard.
Some examples may be :
1. Knowing the customer status as per the customer selection on his purchase.
2. Showing top 5 customers who had given more business to company or shown top 5 customer whose sales are declining.
If you get clear idea what you want to present than it can be presented in graphs, tables, pivots.
So first of think of what is that your management or you want to see at a glance? Than we can talk about design.
Regards,