Octopus IT reaches cloud nineJun 12, 2017
The key to Octopus’s new data warehousing system is the ability to bring disparate data sources together. “With this new system,” says Carl Preston, Head of Business Intelligence, “we can draw links between sales efforts and any resulting new business created. Sales and Business Development can then know if a marketing event was successful or not.”
Octopus has been quickly moving away from its legacy, SQL-based storage system, to a more robust and flexible cloud storage platform. The new system Carl’s team has designed is primarily based on Kimball Methodology, using repositories of Data Marts to collect data from various business sectors (sales, marketing, operations, accounting, etc.) before uploading them to the warehouse. This allows faster implementation, prioritising data and including it in stages.
Key to the new structure is its Operational Data Store. “This will enable us to merge logically similar data sets and allow common reporting from all,” states Carl. “We can look at day-to-day changes and the search history of individual fields, to see what changed and when.”
Microsoft Azure is the new cloud storage service now being employed by Octopus. Carl was impressed with Azure’s utility and affordability. “We only pay a fee per megabyte of storage, so, if we ever need more server performance, you can just turn up the power.” Esau Rodriguez, a Developer at Labs, points to another advantage of cloud storage. “It allows us to take advantage of the security these big networks have, in order to protect themselves and us.”
IT at Octopus periodically holds presentations to familiarise employees with data warehousing and how it integrates with Business Intelligence. Over the next year, Carl’s team will be onboarding more Octopus businesses to the cloud-based system, including Octopus Energy and Octopus Healthcare.