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

Building financial and transaction...

I need to build two models - for transactions - for subscription businesses and high ticket one off businesses that I want to import into chartmogul and other systems similar to it that are reporting...read more

Hourly, $28.00

Need to create a survey with the bo...

I need to create a survey with the bootstrap wizard. All the fields are mandatory. only the single page survey and a page to show the result. I will provide the survey page and the style. Needs to be...read more

Fixed, $75.00

Filtering 130 mil URLs

I need to filter 130 mil urls and extract the urls that contain certain key elements.
I've got the database of urls and looking for an experienced candidate who had a lot of experience in this are...read more

Fixed, $50.00

Quick Excel Sheet Job

I want an excel sheet to list all my products.

The sheet should have the following columns:

- SKU Code (Number-Character)
- Product Name (Characters)
- Perquisites (multi li...read more

Hourly, $5.00

Excel Expert

I would like to create a spreadsheet of data using google sheets. My admin will update this on a daily basis. And as it updates I would like it to that display on a Monitor/screen at all times as a...read more

Hourly, $18.00

Here are our top professional picks for you to hire

Software Developer
Microsoft Excel Excel VBA Python 
$17 /hr
India
Computer teacher with admin and data entry skills.
MS Office Copywriting Data Entry 
$3 /hr
India
Java sql HTML5 
/hr
United States
Data Analyst /Statistiican
Data Analytics Statistics Statistical Analysis 
$0 /hr
India
Web developer
HTML5 jquery CSS 
$3 /hr
India
Working professional looking for part-time freelance jobs
Microsoft Powerpoint Microsoft Excel Microsoft Word 
$0 /hr
India
hichasoft
Microsoft Excel Microsoft Word 
$10 /hr
Chile
Excel Automation, Preparing PowerPoint presentation, Reporting and analysis,
Microsoft Powerpoint Microsoft Excel Microsoft Word 
$10 /hr
India
Tableau Software Microsoft Power BI Microsoft Excel 
/hr
India
To view more profile join Toogit

Get Started