Færdiggjort

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

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

Se mere: sql database chart accounts report, create kudler sql database chart accounts report, excel pivot table sql database, excel 2016 data model, add pivot table to data model, powerpivot report examples, excel data model 2013, how to create a data model in excel, excel data model 2010, add pivot table to data model after creation, powerpivot connect to ssrs report, c# programming, excel, microsoft sql server, database development, data warehousing, create sql database chart accounts report, create test sql database chart accounts report, connecting excel sql database, import excel data sql database within sql

Om arbejdsgiveren:
( 10 bedømmelser ) brandon, United States

Projekt ID: #16067294

Tildelt til:

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: [login to view URL] You also can check some Flere

$22 USD / time
(34 bedømmelser)
5.2
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 Flere

$15 USD / time
(1 bedømmelse)
0.6

17 freelancere byder i gennemsnit $20/time for dette 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 Flere

$15 USD / time
(243 bedømmelser)
7.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 Flere

$26 USD / time
(79 bedømmelser)
6.6
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 Flere

$17 USD / time
(12 bedømmelser)
6.4
$22 USD / time
(64 bedømmelser)
6.2
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 Flere

$15 USD / time
(43 bedømmelser)
5.3
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 Flere

$15 USD / time
(3 bedømmelser)
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 Flere

$22 USD / time
(1 bedømmelse)
0.6
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 / time
(1 bedømmelse)
0.5
$22 USD / time
(0 bedømmelser)
0.0
daconti

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

$27 USD / time
(0 bedømmelser)
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 Flere

$16 USD / time
(0 bedømmelser)
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 Flere

$22 USD / time
(0 bedømmelser)
0.0
markselwynrubin

A proposal has not yet been provided

$27 USD / time
(0 bedømmelser)
0.0
$22 USD / time
(0 bedømmelser)
0.0
teamsana

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

$17 USD / time
(0 bedømmelser)
0.0