Marks and Spencer, a successful company, popular among millions of customers around the world, offers high quality stylish fashion, cosmetics and delicious food.
The company history began over a century ago; today M&S operates over 1,000 stores in more than 45 countries and is ranked among the UK’s leading retailers. The company appreciates the importance of quality, value, service, innovation and trust and honors these principles in all activities.
The heart of the system is a data warehouse that consolidates data from the primary warehouse and POS system. Above there are OLAP cubes created along with dozens of business reports. A reporting portal is used by over 300 unique users who generate hundreds of daily requirements.
The Project for M&S was awarded in the 14th edition of Microsoft Awards; a competition for the best implementation of IT solutions for customers in the Czech Republic in 2012 in the field of Data Management and Business Intelligence.
For the project we used:
- Data Warehousing
- Business Intelligence
- OLAP analysis
“ Almost everyone knows the brand of Marks and Spencer, it was therefore very interesting to peek under the hood of this successful international brand and help them implement a key reporting project.”
Luboš Bednář (Project Manager)
“For me personally, our project for M&S is one of the most interesting ones. It combines the technical challenges (tables with billions of records and hundreds of GB of data) with commercial issues (which customers to send discount offers to, how to hold minimum stocks with high availability). I also enjoy the frequent contact with the parent organization in London.”
Radim Hampel (Technical Director)
For the project we have developed:
- Merchandising, Logistics, Controlling, Allocation, Loyalty
- Broad portfolio of business reports
- Delivery of selected reports
- Customer segmentation
- Rating of promotions
- Accounting and controlling reports
- Anti-fraud reports
- The effectiveness of a loyalty program