I need to develop a simple Revenue dashboard as POC. The data source is a single Excel File with revenue data (Attached file).
Could someone please help me on how to start, how the dashboard would look like, what charts to use, how many tabs (based on DAR approach) etc etc. ?
Any type of suggestions, help are welcome. We can design the dashboard in any way we want. Please use the attachment to load the data and develop a dashboard.
The requirement will be like this:
The dashboard has to show the Planned Revenue vs. Actual Revenue
As of now 2 KPIs to be used: Total Revenue and Rate realization
Total Revenue ($) = Summation of (Individual Rate x Individual Billabilty Man Month (BMM))
Rate Realization ($/MM) = Total Revenue / Total BMM
These KPIs are dependent on Time. Filters to be used: Onsite Revenue, Offshore Revenue, Project Type (T&M, FPP), and Geo.
Dashboard should have the drill down functionality. Drill down functionality to SBU, Geography, Account (Customer Name) and Employee Level.
As mentioned by Kaushik, then you can't expect the community to do to all the work for you. What you ask for is more a task you should pay a consultant for doing and not something you can expect someone to do for free.
