Em Andamento

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

Habilidades: Excel, Excel Macros, MySQL, SQL, Visual Basic

Veja mais: 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

Acerca do Empregador:
( 10 comentários ) brandon, United States

ID do Projeto: #16067294

Concedido a:

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 Mais

$15 USD / hora
(1 Comentário)
0.6

17 freelancers estão ofertando em média $20/hora para esse trabalho

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 Mais

$15 USD / hora
(223 Comentários)
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 Mais

$17 USD / hora
(12 Comentários)
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 Mais

$26 USD / hora
(70 Comentários)
6.6
$22 USD / hora
(22 Comentários)
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 Mais

$22 USD / hora
(25 Comentários)
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 Mais

$15 USD / hora
(12 Comentários)
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 Mais

$15 USD / hora
(3 Comentários)
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 Mais

$22 USD / hora
(1 Comentário)
0.6
$22 USD / hora
(0 Comentários)
0.0
daconti

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

$27 USD / hora
(0 Comentários)
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 Mais

$16 USD / hora
(0 Comentários)
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 / hora
(0 Comentários)
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 Mais

$22 USD / hora
(0 Comentários)
0.0
markselwynrubin

A proposal has not yet been provided

$27 USD / hora
(0 Comentários)
0.0
$22 USD / hora
(0 Comentários)
0.0
teamsana

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

$17 USD / hora
(0 Comentários)
0.0