888.4LEANBI (453-2624)

Food Production Company

Integrated Data Warehouse

Datasource worked with a number of different departments within a Food Production Company to deliver a solution for a legacy business data warehouse, provide additional analytic capabilities, and leverage a Microsoft BI solution as the primary analytics platform.

Client Background

Headquartered in Denver, Colorado, this food production company is one of the world’s largest cheese, whey, and dairy producers and has been a staple in the industry more than 60 years.

Business Focus

Datasource Consulting is assisting the client to replace a legacy reporting and analytics solution with a more modern architecture and analytic tools using Microsoft Business Intelligence and establishing an integrated Data Warehouse.

The Datasource Solution

Datasource worked with a number of different departments within the company to deliver a solution in production, and the project is 70% through core development. The goal is to completely retire the legacy business warehouse solution, provide additional analytic capabilities and leverage a Microsoft BI solution as the primary analytics platform.

Our BI experts and data analysts implemented best practice enterprise reporting and self-service analytics, which leverages an integrated data warehouse and multi-dimensional cubes. The team created access to cubes, to enable users to drag-and-drop, spot exceptions, and anomalies, and obtain quick insight into actionable analytics. To date, Datasource has delivered seven different tabular cubes, supported by DAX (data analysis expressions). All self-service data is stored in the system’s memory and is fast and responsive.

The Result

Enterprise reporting and self-service analytic capabilities were previously only within reach for a very small set of users who would then share and distribute data. The Datasource solution now enables more than 400 analysts the ability to self-serve and deep dive rich, trusted data sets. The client is very well positioned to mature their analytic capabilities from reactive to proactive and soon enough predictive.

This solution puts data into the hands of the business and aligns with Microsoft’s vision of supplying ‘BI for everyone’. We provided an environment that is not overly complex but has guard rails, enabling users and the corporation to aggressively compete on analytics and proactively address business opportunities.

Meet the experts: Schedule a call with one of our competency leads.