In Progress

Excel reporting with Power Pivot w/ SQL database

Hello -

I have a report (attached) 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: Excel, Excel Macros, MySQL, SQL, Visual Basic

See more: sql database chart accounts report, create kudler sql database chart accounts report, excel pivot table sql database, create sql database chart accounts report, create test sql database chart accounts report, connecting excel sql database, import excel data sql database within sql, import excel data sql database, sql database backup excel format, vbscript connect sql database export values table excel, php upload excel file sql database, vbscript update sql database excel, excel pivot table sql server, microsoft excel heidi sql database, excel sql database

About the Employer:
( 10 reviews ) brandon, United States

Project ID: #16067294

Awarded to:

rayyankabir

Well, 10 mins is a lot more for refreshing. I hope there is no issue with speed. I will optimize your task and very hopeful that will reduce 70% of your current time. I have excellent knowledge on MS Excel and SQL S More

$15 USD / hour
(1 Review)
0.6

17 freelancers are bidding on average $20/hour for this job

schoudhary1553

Greeting, I have understood your Excel reporting with Power Pivot w/ SQL database task and can do it with your 100% satisfaction. Please ping me for more discussion. I have more than 5 years of experience in Exc More

$15 USD / hour
(223 Reviews)
7.2
mmadi

HI jasonsetzer81, I have gone through your requirements for "Excel reporting with Power Pivot w/ SQL database". Iam ready to do this for you. We are a team of experience designers and developers and as per requir More

$17 USD / hour
(12 Reviews)
6.4
WebInfoSolutions

Can I check the environment and work done? I am not sure if I will be able to reuse the same code. I am surprised to see that the update takes 10 minutes. I will suggest you my final thoughts after checking the environ More

$26 USD / hour
(70 Reviews)
6.6
$22 USD / hour
(22 Reviews)
5.3
aimefx

Hi, I am expert in power query and power pivot, can create data models, can do data analysis and data visualization. check employer feedback about power pivot: [url removed, login to view] You also can check some More

$22 USD / hour
(25 Reviews)
4.7
periyannas

Hi, Nice to know your requirement. However, I will get to know more when I interact with you and go through your app. I am specialised in delivering solution in VBA Excel Macros and Sql. Hence, it would be ideal for me More

$15 USD / hour
(12 Reviews)
3.4
CHREHAN

I have almost 5+ years of experience in Business Intelligence, ETL, Database Development, Database Optimizations, Database Design and BigData. Currently at work responsible for implementing complex business of this More

$15 USD / hour
(3 Reviews)
1.5
arif758

Hi, I have gone through the project thoroughly and understood your project requirements. With years of experience and dedicated efforts, I will be glad to offer an outstanding services; if you can be kind enough to sho More

$22 USD / hour
(1 Review)
0.6
$22 USD / hour
(0 Reviews)
0.0
daconti

Very Experienced programmer with VBA/Excel/SQL and scripting knowledge. Able to manage even very complex databases.

$27 USD / hour
(0 Reviews)
0.0
BokulHossainITS

Hello, I read though your project description carefully and I will do this job 100% properly. I have more than experience about this work. I can submit your job recuire time. I am highly interest to work with you on More

$16 USD / hour
(0 Reviews)
0.0
ujjwalconcepts

Hi very warm regards from Ujjwalconcepts. I am having hands-on experience pivot table and can help you out with your project. Please do get in touch to discuss more in details. Thanks

$20 USD / hour
(0 Reviews)
0.0
Geetanjalic01

I am a first timer. Looking for an opportunity to begin with. Relevant Skills and Experience I have 7 years experience of working on sql, excel, automation. I am a working professional however this is my first time a More

$22 USD / hour
(0 Reviews)
0.0
markselwynrubin

A proposal has not yet been provided

$27 USD / hour
(0 Reviews)
0.0
$22 USD / hour
(0 Reviews)
0.0
teamsana

I have the experience and expertise to complete the project on time and within the estimated budget.

$17 USD / hour
(0 Reviews)
0.0