Skip to content
Pattern - Header - Left Pattern - Header - Left

Data warehouse

Reporting mechanism to pull information from many systems from the supply chain to the customer point of sale.

Pattern - Header - Left Pattern - Header - Left
Case Study Primark Data Warehouse 800X400


Primark opened their first store in Dublin in 1969 and their 325th store in 2016. The Primark story has been one of continuing success founded on a unique combination of fast fashion and lean operations.

Industry Retail
Technology Microsoft C#, SQL Server, MDX query language, SSAS, SSRS

Key Achievements

  • Real-time view of product demand by means of ad-hoc and scheduled reports
  • Strategic decision-making made easier with improved business awareness
  • Tailored reporting on a per user basis that supports supply chain planning

The challenge

Business Need

Primark processes many millions of line items each year and their IT systems store vast amounts of associated data. With their continuing growth, Primark needed a way to generate and distribute reports that would provide important and timely information to the people who needed it. This reporting mechanism must pull information from many systems from the supply chain to the customer point of sale.

The solution

Project Details

Objectivity created a data warehouse and BI reporting application using Microsoft SQL Server Analysis and Reporting Services. At any one time, the data warehouse holds more than a billion rows of information. This warehouse receives information from many systems, processing more than 300 gigabytes of data on a daily basis. There are more than 70 reports that read data from the warehouse as well as a number of other data sources. Users can generate reports on demand or schedule regular deliveries. Objectivity worked closely with Microsoft consultants to deliver an architecture that performs as required and is also scalable to meet future demands.

The results

Business Benefits

The system delivers up to date information quickly and automatically. Report parameters allow users to customise the data to obtain exactly what they need. Smaller reports now provide more relevant information and users spend much less time both waiting, and looking, for the information they need. The system positively impacts all areas of Primark’s business with implementation effort in excess of 5 man-years.

Key achievements

  1. On demand and scheduled reports that showcases the demand for products in real time.
  2. Easier strategic decisions making - based on improved business awareness.
  3. Tailored reporting on a per user basis that supports supply chain planning.


Start your project with Objectivity

CTA Pattern - Contact - Middle

We use necessary cookies for the functionality of our website, as well as optional cookies for analytic, performance and/or marketing purposes. Collecting and reporting information via optional cookies helps us improve our website and reach out to you with information regarding our organisaton or offer. To read more or decline the use of some cookies please see our Cookie Settings.