7-Eleven operates more than 630 convenience stores across Australia and has been in operation in Australia since 1977. The company and services approximately 190 million customers every year – an average of 6 customers per second, generating sales of approximately $3.6 billion.
7-Eleven wanted to develop a cloud-based reporting solution to proactively manage their employee compliance risks and specific operational processes.
The 7-Eleven businesses’ areas of concern included:
Melbourne IT took a structured approach to evaluate and understand business and technical challenges with stakeholders across the 7-Eleven business. The approach provided extensive data validation; cleansing; and testing activities conducted over a 12-week timeframe - and was rolled out to a central group of Operations and Retail Specialists. During this process, users gained familiarity with the reporting tool and testing of data validity in a live and dynamic business environment.
Melbourne IT provided project management, Microsoft Azure architecture, data modelling, extract transform and load (ETL), and report design to support 7-Eleven throughout the engagement.
The solution involved building a Microsoft Azure data platform to securely extract data and transform it into a structure optimised for reporting and analytics, within the Microsoft Power Business Intelligence visualisation tool.
The solution architecture used included the following components:
7-Eleven’s key driver was to provide real time visibility into stores’ time and attendance activities to:
The cloud based solution Melbourne IT Group developed, enables 7-Eleven to proactively manage its’ employee compliance risk and better manage specific operational processes to identify a “whole of network” view. Removing the previous manually intensive process has not only provided a holistic view of the network but saved time, money, and risk through compliance.
7-Eleven can now make data driven business decisions for their employees and stores by utilising a dashboard with a flexible interface which can be customized as required.