I have a report that shows daily results for my restaurants, districts (7-10 restaurants per district) and total. It utilized a SQL database and Power Pivot. I need someone to do the following"
- Add/remove metrics from the report - there are 4-5 metrics i need to add that come from various files on my server
- update speed - currently the refresh is taking a very long time (10 minutes)
- automate tabs - versus pre-building tabs I would like a macro that created the tabs for districts when pushed
- fix values - some of the values for the areas/restaurants aren't correct so the formulas need to be corrected
- add a ranking tab - I would like a tab that shows the top/bottom performers for certain metrics
Please let me know what questions you have
Skills & Expertise RequiredExcel VBA
Microsoft Excel PowerPivot
Project closed for bidding!
Share this project with your friends