PEI Media chooses TouchstoneBI and TimeXtender to support their Digital Transformation journey
PEI Media are specialist publishers & networking event providers for the Financial Services industry, focusing only on alternative asset classes. They major in private equity, real estate, private debt and infrastructure whilst also engaging with emerging new asset classes.
Formed in late 2001, their aim was to provide media coverage for those involved in Private Equity, focusing on the relationship between institutional capital and the fund managers tasked with investing this money. In 2016, with the intention of developing their operational capabilities, PEI Media appointed a new CFO and Chief Technology and Information Officer, building out the finance team and focusing on the opportunities that technology & digital innovation could bring to the organization.
Finishing robustly ahead of plan in their first year of private equity ownership, 2017 was set to be the year of Digital Enhancement at PEI Media. It brought rapid advances to the ambitious technology investment program started in 2016, which resulted in their publishing platform migrating from its legacy CMS onto WordPress, as well as the foundations being laid for a new CRM, subscription management and customer data platform.
Commercially PEI Media also moved forward, with Advertising & Sponsorship, Subscription Sales and Conferences all posting record-breaking revenue growth.
To scale the business effectively and support business growth plans through a transformation program to put data-led insight at the heart of PEI Media’s operation. Replacing legacy technology became a necessity for improved visibility of their data, ensuring robust data analysis. To achieve this, a new data warehouse platform was sought to store and manipulate the data from multiple production systems; providing operational reports, insight dashboards, analytics and ad-hoc queries using tools such as Tableau and PowerBI. The new data warehouse needed to fulfill key project goals and objectives:
- Improve data quality
- Provide one version of the truth
- Scalable, extendable & secure architecture
- Improve efficiency and save time
- Agile project delivery
- User friendly and intuitive
“We had a very specific idea of what we needed from the new Data Warehousing platform, having multiple disparate sources of data just wasn’t allowing us to react to changes in the business quickly enough, so the new solution needed to enable efficiencies of reporting and analysis”
Tony Skeggs, Chief Technology & Information Officer.
PEI Media completed a tender process which shortlisted 3 solutions and providers. Touchstone BI was selected to implement TimeXtender – a Data Warehouse Automation platform based on Microsoft SQL Server.
They needed to connect data from multiple disparate sources, including Microsoft Dynamics CRM, Microsoft Dynamics NAV, Sailthru, Google Analytics and Sidetrade with historical data from Dotmailer. This data was to be presented in reports and visualizations using Tableau. This connected data had also to be made available to BlueVenn to provide a Single Customer View.
TouchstoneBI was chosen as the implementation partner because of their proven agile methodology and impressive track record in delivering similar projects to their customers. They demonstrated during the selection process that using TimeXtender’s “point & click, drag & drop” functionality would significantly shorten the ETL (Extract, Transform and Load) process time, as well as enabling less reliance on technical specialists to deliver the benefits to PEI Media at the pace they needed.
This combination of TimeXtender’s functionality and TouchstoneBI’s product knowledge and experience gave PEI Media the confidence that the new data warehouse platform would be successfully delivered within their timescale.
PEI Media’s CTIO Tony Skeggs says “After a couple of days’ workshop trialing the software with a Touchstone BI consultant, we were able to prove connections to multiple sources, it gave us the confidence that they would deliver”
An Agile project methodology, combined with the flexible Microsoft SQL based platform enabled rapid delivery of the solution, and allowed for quick project refinement as the data discovery opened up new areas that required investigation.
Andes Loukianos, Head of Touchstone BI comments, “finding ourselves ahead of the project plan, we were able to add an extra data source, Microsoft Dynamics NAV, allowing the finance team to also benefit from the early phase of the project. We helped the PEI Media team deliver value to key stakeholders within 3 months”
Strong collaboration and a partnership approach was key to the success of this implementation. The project managers from both sides met at regular intervals to ensure the project was on track and to agree on the resources required for the ensuing work.
“We have been very impressed with the Touchstone BI consultancy team. They were able to espond to every challenge we posed, delivering the project within our tight timescale” says Sandra Ragues, PEI Media, Head of Business Insights. “This has been one of the most successful IT implementations I have been involved with, delivering on time and on budget”.
PEI Media are now reaping the benefits, enjoying vastly improved accuracy of data and performance; complex joins and transformations have been eliminated in Tableau and moved into the data warehouse allowing PEI Media to analyze data more easily, more consistently and include more information on one dashboard report without sacrificing the performance of the reports.
Tony Skeggs reflecting on the project outcome, “We have gone from a mountain of spreadsheets, labor-intensive processes and multiple interpretations of the results, to a Tableau reporting suite and a platform that delivers a Single Customer View. We are now able to provide the business with valuable insights that were either not possible before TimeXtender or took too long to generate to be useful in making better-informed decisions”
“TimeXtender has enabled me to put technology at the heart of PEI’s business, to change the way we compete and operate by providing deeper understanding and engagement with our customers”
VolkerWessels Bouw & Vastgoedontwikkeling Implements Innovative Data Warehouse Solution TimeXtender E-mergo, a specialist in business intelligence and TimeXtender® supplier, has implemented an innovative data warehouse solution at VolkerWessels Bouw &...
Colliers International Builds a Data Warehouse Without Programming Colliers International is a publicly traded international real estate consultancy that wants to offer forward-looking advice and maximize the value of real estate for real estate owners, real estate...
Cordstrap Safeguards its Data for the Future with TimeXtender Cordstrap is the global leader in products and systems to protect cargo carried by rail, ship, truck, and air. The company operates three international production centers, has over 500 employees in 22...
The Data Heart of TimeXtender is the Beating Heart of FM Group The FM Group was established in 1968 and is a company in flowers, plants, and accessories. Every day, 1700 employees in 17 countries on six continents work to deliver a wide range of fresh products to over...
TimeXtender Enables Pally Biscuits to Produce Smarter Pally Biscuits makes over three billion delicious biscuits every year. The company has been around since 1868. From its factory in the Dutch town of Nieuwegein, the biscuits find their way to more than 40...