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

Cloud DBA consultant

Must be an expert in the below mentioned tasks
Database : SQL Server(mandatory) / My SQL (optional)

-DB backup & Restore
-DB performance tuning
-Identify long running queries
read more

Hourly, $10.00

Contractor FrameCAD, AutoCAD Drafti...

Our Australian based business is in demand and we are looking for experienced Contractor AutoCAD/FrameCAD detailers to start now! This is a lifestyle opportunity to work from home and set your own ho...read more

Fixed, $100.00

Conv Emissions data in GIS format f...

Looking for someone skilled qgis python fortran snd c. Also the WRF/Chem or any weather models. Need help in converting GIS emissions data to be readable in a weather model

Fixed, $200.00

Custom Excel Spreadshet VBA - Task...

Create a custom spreadsheet that will be used for task & project management.

Project tasks broken up into several categories with each category containing take and sub tasks.

Each ta...read more

Fixed, $18.00

Here are our top professional picks for you to hire

Business Intelligence Analyst
Data Science & Analytics Tableau Software Business Intelligence 
$30 /hr
India
Purchaser
Data Entry Data Processing Microsoft Excel 
$5 /hr
India
Sr Analyst
Tableau Software VBA Excel 
$25 /hr
India
Application Development
ASP.NET ASP.NET MVC sql 
$18 /hr
India
Application Developer
Java Core Java Spring 
$2 /hr
India
HTML CSS C Programming 
/hr
India
Excel VBA & Macro Developer
Excel VBA Microsoft Word Microsoft Powerpoint 
$2 /hr
India
Data entry expert / Business consultant
Data Entry Microsoft Excel Microsoft Word 
$10 /hr
South Africa
SCM Consultant
Microsoft Excel Supply Chain Management Supplier Sourcing 
$2 /hr
India
To view more profile join Toogit

Get Started