Excel reporting with Power Pivot w/ SQL database




Martin DesouzaIndia


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

Google worksheet contract system co...

I have all definition to this project. In a nuthsell we need a system to control contract execution , add products, calculate margin , reports

Fixed, $170.00

Virtual Assistant

I have ongoing tasks that need to be done to support my business, including bookkeeping, responding to emails, following up with business contacts, scheduling, possibly research for books I am recordi...read more

Fixed, $16.00

ZOHO set up

I need help setting up ZOHO - no data transfer needed. Just starting fresh. Basically just leads, accounts, sales orders and permissions. Also want some basic sales dashboards.

Fixed, $20.00

Excel with VBA

I want to design a program using Excel with VBA, for fuel consumption in construction field. The program to allow two types of users to use, admin user too control the master lists, and construction s...read more

Fixed, $200.00

PT Virtual Assistant needed

I'm looking for someone who can help me send follow up emails to customers and post periodically on Facebook. Emails are pre written, but each email will have links from dropbox attached to it for the...read more

Fixed, $16.00

Here are our top professional picks for you to hire

Accounting Data Entry Microsoft Excel 
$1 /hr
Reporting Analyst & VBA Developer
Excel VBA Microsoft Excel Excel 
$5 /hr
Powerpoint Presentation Specialist
Microsoft Powerpoint Microsoft Word Microsoft Excel 
$5 /hr
VBA developer, SQL
Excel VBA Access VBA Microsoft SQL Server 
$8 /hr
Microsoft Excel PowerPivot Excel VBA Microsoft Excel 
Production Planner
Microsoft Excel Arduino 
$0 /hr
Excel freelancer
Microsoft Excel Microsoft Office CAD 
$10 /hr
Microsoft Excel MS Office Virtual Assistant 
Microsoft Excel Excel VBA 
To view more profile join Toogit

Get Started