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

Budget & a financial statement

Help me produce an income statement and a budget statement to show my business performance in numbers... I need it to present it to a potential investor or to get a loan from the bank to help grow my...read more

Hourly, $22.00

Manual Process automation (Excel, w...

Hi,
I would like to find the best way to automate manual processes. Currently, I have a excel spreadsheet with data (i.e.: vendors informations, products' informations) + some images (i.e.: Vendo...read more

Hourly, $24.00

Need MSBI developers

Hi,
I need MSBI developers who are good at SSIS, SSRS and SSAS for an ongoing project

Hourly, $20.00

SPSS expert needed for analyzing a...

I am doing a KAP research study and need a statistical analyzer to use spss and give detailed and consolidated report from the data for an academic paper. Graphs creation will be required too.

Fixed, $40.00

IT/WEB Developers for modifying a n...

I am looking for a developer who can complete a project which is almost 100% complete but certain aspects of the site isn't functionally working as it should. The website is set up as a platform for q...read more

Hourly, $20.00

Here are our top professional picks for you to hire

Data Analyst
Excel VBA Access VBA Microsoft SQL SSRS 
$3 /hr
India
Excel VBA - Web Scraping - tool development
Web Crawling Web Scraping Excel VBA 
$24 /hr
India
Microsoft Excel Guru with additional proficiency in Transcription, Project Management, Virtual Assistant Skills
Data Entry Transcription Musical Transcription 
/hr
India
Software engineer
Microsoft Excel PowerPivot Selenium WebDriver Apache Maven 
$3 /hr
India
Business Consultant
Microsoft Excel Excel Experts Microsoft Powerpoint 
$12 /hr
India
I am a typer.
Typing MS Office Microsoft Excel 
$7 /hr
India
Hive Microsoft Excel MS Access 
$18 /hr
India
Free Lancer
Data Entry Blog Writing Microsoft Excel 
$4 /hr
India
Electrical Design Engineet
AutoCAD Microsoft Excel Microsoft Word 
$12 /hr
India
To view more profile join Toogit

Get Started