Food Industry Analysis

Customer Challenges

An Irish farmer-owned company that produces award-winning cheeses, advanced whey proteins, and flavouring systems, supplying customers in over 50 countries worldwide. In recent years, it has made significant investments in technology to enhance production capabilities, sustainability, and innovation across its global operations.

The client needed to augment their business intelligence team as they looked to update their existing Power BI / Tabular business intelligence architecture to a Power BI / Fabric environment.

Solution

Clarke Analytics augmented their existing team with a qualified data consultant to carry out the following tasks:

$

Collaborating with business users to develop and maintain Power BI reports, providing insights from enterprise applications such as D365 and CRM systems to support data-driven decision-making.

$

Converting to and maintaining Microsoft Analysis Services tabular models, transitioning from an outdated Multidimensional model and resolving complex data validation issues to ensure accurate and reliable reporting.

$

Maintaining and troubleshooted data issues in a SQL Data Warehouse, conducting analysis of ETL processes from enterprise applications to ensure accurate data integration, identify anomalies, and optimise data workflows.

$

Managing and resolving data-related tickets in JIRA, prioritizing tasks and tracking progress to meet project deadlines. Collaborated with an international team remotely, coordinating across time zones to ensure seamless communication and effective problem-solving.

Benefits

The addition of a trusted data advisor backed up by an agile data and AI consultancy.

Related Case Studies

Let's explore the art of the possible

Book a Consultation