Standard Reporting

Project description. Standardize the warehouse operational reporting that is currently utilized by representatives of multiple external customers as well as internal operations managers, and personnel. The dataset is driven by Blue Yonder WMS and is replicated to their Snowflake DaaS solution. The solution is to create a set of standardized reports in Power BI that pulls data from Snowflake. These reports would contain all of the required data to meet all customer/operational needs. These include reports such as Shipped/Received History, and Inventory On Hand.

My role was to create the technical documentation for each report, write the initial MSQL query that would be used as a guide for the final report query, create the test scripts for the report project and execute the testing.

Included Reports

Shipped History Receipt History

Inventory on Hand

Adjustment History

Cycle Count History

Open Inbound Orders

Open Outbound Orders

Since these reports have been consolidated into a standard set instead of multiple custom reports per customer, the overall resources needed to support the customer reports has been significantly reduced while simultaneously meeting the customer(s) visibility needs.