Hello dasari sree ,
1.Goto Tools > Cockpit>Enable my cockpit
2.Administration >System Initialization>General Setting >Cockpit(Select Cockpit option)
3.Make a new Dashboard download Dashboard Design (Xcelsius) from SAP portal
4. you should download Dashboard packaging wizard from SAP portal for make new package(.zip file) in SAP .
after download tool goto >Tools>Dashboard packing wizard(Select) and use or select your xcelsius file to make new package
5.there are also same sample package in the portal so you can use directly import zip file from
6.After import dashboard by 5 step ,select widget gallery in Cockpit tab(Modules,Cockpit and Drag & relate option) then select last form dashboard ,hold and drag on the main windows center.
7.select setting option then it will list you all dashboard package which was import in 5 step.
8.Now selected dashboard which you want to show and select OK.
9.you also need IIS installation in your system.
Manvendra Singh Niranjan
there are two ways to do it one way is as described by Manvendra through cockpits and xcelusus but the software is not a free software however if u want a way that would not cost u anything so u can easily transport all the data into excel and through excel u can make ur dashboards paretoo charts bar and pie diagrams and many more