Power BI report creation. Data comes from JSON API. Excel Template provided.
£10-20 GBP
Paid on delivery
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.
Project ID: #13714455
About the project
Awarded to:
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 More
16 freelancers are bidding on average £76 for this job
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 More
We are expert in developing the power BI report, for example let me know the data set, will provide the sample.
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
Hi Luke, I have read your spec and I understand it. I am familiar with getting Data from API snd building Power BI reports.