I am looking for a developer to create a dashboard that rolls-up and aggregates data for approximately 50 data fields that are collected on a weekly basis for 8 different locations. At each location, a manager provides the data via an excel sheet on a weekly basis and is currently uploaded to a shared folder. I have attached the relevant files with instructions on how the data currently is input, how the files and data relate to each other, and what our goal is for creating a BI Dashboard. I am interested in any cost-sensitive, creative approach so that I do not have to manually aggregate these data points each week to report on each location for an enterprise view. Any approach or tool is fine - Office 365/Power BI or any other tool is fine as well. This simple project will be followed-up by several other projects.
Hi, I am an expert in Excel, Access, Powerpoint, VBA, MySQL, Google Sheet, Google Data Studio and Power BI. I can do any type of data analysis and data visualization creating pivot tables, charts, power pivot, interact Daha Fazla
Bu iş için 74 freelancer ortalamada $487 teklif veriyor
Hello, I’m an Excel/VBA expert and I would like develop your KPI dashboard. Please check my profile and contact me to discuss further details. Regards.
Hello, I am interested in your project. Please send me a message so that we can discuss in details your requirements. Looking forward to hearing from you, BR, Razvan
I can develop an Excel based (VBA macros) to consolidate the data of all 50 fields and 8 locations from different files. I can also create a KPI dashboard to analyse and present that data into gtaphical [login to view URL] ini Daha Fazla