The Situation

Board members and key Business stakeholders had a critical need to bring together data from myriad of external partners to then identity trends, patterns and insight and ultimately enable the business to make data-led decisions. This would replace opinion-led approach of which was ingrained in business legacy practices
Most of the data was generated and managed by a fragmented network of partners in 10+ markets operating the client relationship management and subscription management on behalf of the business.

The Task

The task was to develop a robust data warehouse and shape a business intelligent function.
This was supported by a GDPR compliant data governance with a the ability to activate data into the technology stack to enable automation programs.

The Action / Approach

  • Plan the data structure and data library with a coherent lexicon
  • Shape a KPIs matrix across the organisation
  • Debrief network of partners and validate feasibility
  • Build team capability and data management agency
  • Activate Data repository Planning with each partner
  • Consolidate and cleanse the data from various sources
  • Build the data warehouse on oracle database
  • Set up secured daily data feed from partners
  • Shape Business Intelligence capabilities with data analysis and insight
  • Lead workshops to enable adoption of data-centric culture in the governance of the business

The Result

The business is a leading international publishing house producing, marketing and distributing 100s of magazine collections with collectable articles from world renowned  . The magazine were sold in retail and kiosks and then managed by 3rd party subscription houses in 15+ markets with very little direct-to-consumers revenue streams
Results:
– Get direct access to 2M+ clients records and millions of transactions
– Validate coherent KPIs measurement across the business with reporting available every day (instead of sporadic monthly)
– Deliver data analysis at functional and business-wide level to root data-centric culture at every level of the organisation
– Align board members with coherent business intelligence insight
– Cut cost of partner management by 15%
– Increase sales by 30% on the portfolio of products in 15 markets
– This enable the business to activate a direct to consumers strategy

Relevant Business Perspectives

Practice