Brewers Insight - Traceability Report

Aug 8th, 2024

Overview

The Traceability Report is a key feature of the Brewer's Insight platform, offering brewers the ability to monitor and manage the journey of resources throughout their brewery. From malt and hops to various raw materials, this tool ensures complete visibility of how these components move from suppliers to the brewery and ultimately to the customer. Effective traceability is essential for optimal beer production quality and compliance.

Tech Used

Brewer's Insight is a web application developed using Angular and ASP.NET Core.

AngularAngular
AzureAzure
TypescriptTypescript
C#C#
MSSQLMSSQL
.NET Core.NET Core

Challenges

One of the primary challenges in developing this feature was consolidating data from multiple databases to create four tab-separated tables: Materials on Hand, Materials in Production, Finished Goods, and Shipped Products. This involved establishing connections between materials and their corresponding products. Additionally, I implemented several filters to further refine the results displayed in these tables, including Batch ID, Lot Code, Material, and Supplier.