Problem Statement:
To create a report which showcases the On Time In Full (OTIF) status of all orders of the past two years.
GitHub
Tools and Technologies:
- Microsoft Power BI, Business Central, Azure SQL
Summary:
- This report is based on the orders from Business Central.
- Used the Data warehouse (mentioned in the portfolio) to develop this report.
- Used SQL views to fetch data from different tables and then imported them into Power BI.
- Each shipment is assessed on two criteria:
1) If the full quantity was shipped
2) If the order was shipped on the Due Date
- The report has an Allowable Window, where a Customer might be able to accept shipments up to sixty days early or late.
- Once a user has selected the Allowable Window, the rest of the report will use this window to calculate the OTIF status.
- The Trend Buttons allow users to investigate through the report without having to leave the report page and keep any applied filters.