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.
16 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön
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, 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.