Hello – I am looking for someone with very strong DAX/PowerBI skills to help develop a custom RFP tracker. This RFP tracker is for a company in the transportation industry and entails matching the shipments that were actually executed against the shipments that were bid on by Lane, Company Name, RFP name, and RFP start/end dates.
Given the many nuances of the transportation industry and the RFP bid process, different match-logic will need to be developed for the 4 main types of lane quotes: Point-to-Point, Point-to-Region, Region-to-Point, Region-to-Region. Additionally, this project will likely require use of several bridge tables in order to create relationships between the data sets which originate from unrelated systems. These (and other nuances) will be discussed in more detail with the successful freelancer.
I have attached an Excel workbook that contains example data for both RFP bids and executed shipments. This is the only data that will be provided to develop this tracker and I am happy to answer any questions you may have around it.
For the right freelancer this is likely to be an ongoing project as there will regular updates and enhancements for the foreseeable future. This project MUST be completed in PowerBI.
Priority consideration will be given to anyone that can demonstrate experience using DAX to match complex text strings across disparate data sources or that has experience working in the transportation industry. Please put RFP as the first word in your submission to indicate you have read the entire posting.