Peruttu

Power BI report creation. Data comes from JSON API. Excel Template provided.

There are three reports in our inventory system:

- Product Availability

- Outstanding Purchase Orders by product, by date

- Outstanding Sales Quotes by product, by date

We've made an excel sheet that takes the data from those three reports.

It combines them with a series of vlookups that looks at each date and calculates stock levels on that date. The excel sheet works just fine, but we need to convert it to PowerBI, because the nested vlookups looking at each week, over 4000 items, 400 POs and 5000 Sales lines brings excels to its knees on an i5.

Instead of us copying and pasting these three reports, you must get the data from the Dear API. It isn't exactly the same as the reports but it's very similar:

[url removed, login to view]

The project structure will be:

Milestone 1 - 1% project cost - deliver a PowerBI project that pulls down a list of sales and shows it in a nice interface.

Milestone 2 - 99% project cost - deliver something that replaces the excel sheet.

Don't forget to say "Hey Luke I've read your spec and I understand it" in your proposal or first message otherwise I will probably ignore your copied and pasted bid.

Taidot: Varastonhallinta, JSON, Microsoft Office, Microsoft SQL Server, Raportin kirjoittaminen

Näytä lisää: software write mq4, software write chip epson, useful software write book, software write web specs, free software write user guide, software write edid, free software write company profile, software write websites idea, software write book images, software write books, software write protection, free software write book, software write book, excel takeoff template, best excel design template, free site template provided finerdesigncom, excel catalog template, manage workload excel workbook template, accounts payable receivable excel spreadsheet template, excel import template quickbooks

Tietoa työnantajasta:
( 1 arvostelu ) Lancaster, United Kingdom

Projektin tunnus: #13714455

Myönnetty käyttäjälle:

acronymsolutions

Hi, I am 18+ years experienced Database Programmer at CMMI-5 level company. I have 20 member team of different Technology. We are working on : RDBMS :Oracle,MySQL,PostgreSQL, MSSQL Server 7.0/2000/2008R2 and Onward Lisää

£21 GBP 1 päivässä
(2 Arvostelua)
3.8

16 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

£28 GBP 1 päivässä
(126 arvostelua)
6.4
VirtualBrainInc

Hello, Thank you for posting a project here on www.freelancer.com. I have briefly checked the description, and I can deliver as per the requirements however I need us to discuss for more clarity on the details, deadlin Lisää

£60 GBP 1 päivässä
(27 arvostelua)
5.0
AliSafder

I can start working now

£20 GBP 2 päivässä
(13 arvostelua)
4.3
ReflexiveData

Hi Thanks for posting this requirement. I have a great experience working on Power BI dashboards Please have a look on my previous work: • Liquor Industry – Brand Analysis – [login to view URL] • Medical Lisää

£20 GBP 1 päivässä
(1 arvostelu)
3.3
dakshbhutani5

Hi there , ME AND MY TEAM IS READY TO START YOUR WORK RIGHT NOW AND COMPLETE YOUR WORK WITH TIME LINE WITH A QUALITY WORK HAVE A LOOK ON MY REVIEW I have gone through your project requirement specification and a Lisää

£18 GBP 1 päivässä
(0 arvostelua)
0.0
£18 GBP 1 päivässä
(0 arvostelua)
0.0
retailsoftware

We are expert in developing the power BI report, for example let me know the data set, will provide the sample.

£18 GBP 1 päivässä
(0 arvostelua)
0.0
£38 GBP 5 päivässä
(0 arvostelua)
0.0
syreali77

Dear Sir I am a management consultant with over 8,000 hours of experience in management systems design. Expert in Business Intelligence, Systems Design, Data mining and organization, relational databases, analysi Lisää

£18 GBP 1 päivässä
(0 arvostelua)
0.0
£18 GBP 1 päivässä
(0 arvostelua)
0.0
HammamJ

I have large experience in power bi. I have made many reports and dashboard in power bi. I am new in freelancer but I am very good in data analysis specialley in power bi

£18 GBP 1 päivässä
(0 arvostelua)
0.0
divyansh0505

Hi Luke, I have read your spec and I understand it. I am familiar with getting Data from API snd building Power BI reports.

£19 GBP 30 päivässä
(0 arvostelua)
0.0
Alviner

Hi, i have read about your description very carefully.i understood what you described.i'll charge 10$ and 1 day to make it [login to view URL] don't have to pay me if i [login to view URL] faith on me.i'll make you happy. Thank you.

£10 GBP 1 päivässä
(0 arvostelua)
0.0
Sparcko

Hey Luke I've read your spec and I understand it. I've worked with Powerbi a lot. I've made sales reports and dashboards for companies and also dashboards on other projects as well. I would like an opportunity to spe Lisää

£18 GBP 1 päivässä
(0 arvostelua)
0.0
anandsabale

Hey Luke I've read your spec and I understand it. Hi - I represent SP Consulting LLP, Pune India based analytics company. We have worked on similar projects and would like to know your interest in working on long te Lisää

£694 GBP 20 päivässä
(0 arvostelua)
0.0
prakhar141991

Hey Luke I've read your spec and I understand it. Your milestone structure is not possible. It needs to be at least 25 % and 75%. Portfolio: [login to view URL] Regards Ruzivo Technology Service Lisää

£200 GBP 4 päivässä
(0 arvostelua)
0.0