We are a service provider to a large number of Customers. We have multiple offices and over a hundred employees. We use 4-5 different softwares. We want to create a very detailed dashboard in MS Excel that can give us an overall view of the business. Data will be sourced from these 4-5 softwares and from other excel sheets.
Points to note
1) Fairly large amounts of data - in the range of 1,00,000 rows. (This is for you to get a broad range - The actual number may differ significantly)
2) Largely unstructured data from multiple sources (At least 5)
3) This will be an long term project as we will go on reiterating the dashboard based on evolving business needs
4) You will be required to sign a Non Disclosure Agreement before we start on the project
The dashboard will capture mostly operational aspects of our business. Things we are looking to measure is average time taken to service customers, efficiency of manpower, response time of our vendors amongst other things.
While we will also capture financial aspects of the business - the primary function of the dashboard is to give us an operational snapshot of the business.
Hi, I can develop a web solution for you as i did similar for my previous clients. Keenly looking forward for your response. As a demo see the link below. [url removed, login to view]