Excel reporting with Power Pivot w/ SQL database

Budget

$4.31HOURLY

Client

Martin DesouzaIndia

Status

AwardedJan 27, 2018
Hello -
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 Required

Excel VBA Microsoft Excel PowerPivot Microsoft Excel sql 

Project closed for bidding!



Share this project with your friends



Similar Projects

Looking for excel ninja

Hi,

I'm working with a lot of spreadsheets and reports.

I'm looking for an excel ninja who knows formulas (like vlookup) and so on.

Pay is hourly. Let me know your rate.

Fixed, $14.00

Convert raw data into readable form...

Looking for someone with database capability to convert and format a raw data file .txt file into something understandable (such as excel).

This will be an ongoing requirement, which shouldn'...read more

Fixed, $10.00

developing my personal website for...

Making my website look nice. Font, color, putting the logo..

Fixed, $9.00

Need help with data visualisation a...

We are an IT services company. We need assistance to make use of our data. Like all service companies we sell time, and it's critical we know what's happening, where our issues and inefficiencies are,...read more

Fixed, $14.00

Call our customers dealing in mobil...

We need someone to call through a list of -400 people in our directory that we believe deal in mobile products, find out if they do and then get a list of products they have to sell or need to buy and...read more

Fixed, $7.00