MoreCorp is the parent company under which MoreGolf and MoreCycle are housed. The Group is better known for its key retail brands; The Pro Shop and Cyclelab. The Groups aim is to be a diversified specialist retailer of choice, serving several key categories where deep retail skills afford a clear and sustainable competitive position. MoreCorp continually seek to leverage their retail expertise into big box, category killer retail offerings which appeal to higher LSM customers. The organisation has aggressively expanded its retail competencies across numerous sectors in South Africa and evolved into a dynamic entity with stores both online and on the high street.
Thanks to its rapid growth and development, MoreCorp's reporting and data structure needed to shift from an older installation to one which would allow for faster access to information, deep analytical capabilities and rapidly refreshed management reporting dashboards. MoreCorp opted to work with EnterpriseWorx (EWX) to develop and implement an innovative QlikView solution with powerful functionality and long-term capability.
"Our legacy system was essentially a power-pivot table which operated off our database," explains Bryden Rose, Planning Manager, MoreCorp Group. "It served the needs of the business at the time of implementation as we were still in a fairly infant stage in our reporting requirements, however as the business and the environment in which the business operated in changed the business saw there was a need for an enhanced view of reporting and a faster solution which encapsulated a richer scope for analysis and business intelligence."
For MoreCorp, the old reporting system had a number of issues which impacted on performance. It had limitations in terms of speed of delivery, flexibility, security and most of all lacked user-friendliness for users at various levels in the organisation. Employees who did not have any Excel proficiency struggled to find the data and use it effectively and this impacted on data input and analysis across all levels of the business.
"MoreCorp's structure across merchandising, operations and sourcing departments meant that everybody was using the old tool," says Rose. "The head-office staff were proficient with Excel, but at a store level, where users were slightly less proficient on Excel, staff struggled. In addition, we needed to find new ways of handling data security, reporting and analysis."
Jonathan van der Berg, Business Intelligence Executive, EnterpriseWorx (EWX) adds: "The main challenge was the time taken for employees at MoreCorp to produce the required reports which were used to drive business decisions. This lengthy process resulted in the business not trusting in the accuracy of the data and this then impacted on the decisions which needed to be made."
MoreCorp worked with EWX as they had provided them with the initial solution five to six years previously and they knew they could rely on them to provide a seamless implementation which met specific needs.
"Our initial engagement with MoreCorp was around report optimisation and the development of specific additional reports using Microsoft Reporting Services," says Van der Berg. "This was then followed by the development of their data warehouse with the idea of building a new reporting solution on top of that. And the rest, as they say, is history."
EWX facilitated and guided the process of implementing QlikView throughout the business. The final product allowed for faster access to data, exception reporting dashboards and detailed analysis-style grids with the ability to change required selections as and when required. This meant that decision making within the business became a lot faster and more accurate.
"Our first run through of the project saw us trying to keep the Excel look and feel for the solution, running alongside the older system and using similar layouts and data," says Rose. "User acceptance was at an absolute zero and a year into the project we had to relook it. EWX had advised us that this is not the way QlikView was meant to be used and we had to recognise that what we had created was just not serving the business's needs."
The result was that the previous model had to