According to our co-creation way, Baufest recommended a series of steps to allow for YCH BI team to make informed decisions for their journey into the new Enterprise Data Warehouse solution.
YCH BI team had developed several reports in Power BI, supporting 150 users in the last 2 years. Realizing that the existing platform could not support requirements such as intraday updates and historical information for tendency analysis and prediction capabilities, YCH IT & BI teams envisioned an Enterprise Data Warehouse solution.
With historical production and sales data readily available, the data science team could build a model to predict the probability of over/under inventory levels, proactively freeing up inventory for additional sales.
environment is proposed using schemas inside a single Azure SQL Database. Schemas include:Dimensional Layer: to unify and encapsulate business logic in a single layer optimized for intuitive data access to allow for Self Service BI in the reporting tool.
YCH now has access to 6 distinct business units’ data in a scalable, measurable, and controllable environment.
With the creation of the EDW at YCH we were able to create a single source for information eliminating the need to query multiple sources. This also enabled the business to focus on analysis rather than operational tasks to gather and cleanse data, ensuring consistency, quality controls and timeliness.