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 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.

• 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 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

• Big Data
• Data Architecture
• Data Centre Management
• business intelligence
• Data Analysis
• process automation
• Report Design
• Financial Reporting
• Commercial Strategy

• BI & Analytics
• Accelerated Solution Delivery