CASE STUDY

MediaBoard - Data Integration
for In-Store Displays

Big Data & Analytics
Retail

Project Highlights

Scope

  • Developed a web-based dashboard to consolidate and display various data points such as surveys, sales figures, visitor numbers, and social media posts on in-store screens.
  • Integrated data feeds primarily from an Excel file, with flexible refresh times managed via a configuration file.
  • Enabled broadcasting of content across multiple channels, including in-store screens, desktop computers, and other digital platforms.

Challenges Overcome

Addressed the need for a centralised platform to display diverse data from multiple sources.

Managed real-time data updates and streamlined content delivery across different devices and locations.

Ensured seamless integration with existing data sources and technology stack.

Business Impact

The project delivered significant improvements to the client’s operations.

Content Delivery Efficiency

Real-Time Data Updates

Multi-Channel Broadcast Efficiency:

Data Accuracy

These advancements enabled the client to optimise in-store communication, enhance customer engagement, and improve overall operational efficiency.

The Client

A global retailer known for its innovative approach to in-store experiences and customer engagement.

  • Specialises in sporting goods and lifestyle products.
  • Known for leveraging technology to enhance store operations and customer experience.
  • Focuses on data-driven decision-making and improving the in-store environment with real-time information.
Retail-Client

The Problem

The organisation faced the challenge of:

  • Displaying multiple data points, such as surveys, sales figures, and social media posts, in a centralised manner across stores.
  • Managing and updating content on various screens without a streamlined system for content delivery.
  • Integrating data feeds from different sources (Excel, social media) into a single, easy-to-manage interface.

The Solution

BGTS developed a comprehensive solution to meet the organisation’s needs:

Web-Based Dashboard

Developed a single dashboard to manage and display data from various sources on in-store screens.

Flexible Data Integration

Integrated Excel-based data feeds and enabled flexible refresh times through a configuration file for real-time updates.

Multi-Channel Content Delivery

Allowed content to be broadcast across in-store screens, desktop computers, and other digital channels.

Team & Technology

Tech Stack Utilised

Frontend

  • HTML
  • JavaScript
  • CSS

Backend

  • ASP.NET MVC

Data Integration

  • Excel
  • Data APIs

Team Composition

2 backend developers

1 frontend developer

1 project manager

The Outcome

The MediaBoard system transformed how content was displayed and managed in-store.

Centralised Data Management

Displayed all key data points on a single interface.

Automated Content Updates

Real-time data updates ensured content was always relevant and up-to-date.

Enhanced User Experience

Multi-channel content delivery improved customer engagement.

Improved Operational Efficiency

Streamlined content management reduced the effort required to update and maintain in-store displays.

This solution optimised in-store communication, enhanced customer engagement, and ensured timely, accurate content delivery across various channels.