Data deluge: the impact of data warehouse automation
As organisations focus more than ever on data strategy, they encounter a range of opportunities to take control of the factors that influence success, as the insight available from the effective data analysis helps improve decision making and builds competitive advantage. The transformational potential of data has not been lost on business leaders, who have tasked their technical teams with harnessing its power to deliver bottom line benefits.
As a result, organisations increasingly rely on data warehouse technologies to store, manage and analyse datasets that are often growing at an accelerating rate. By offering a curated repository of data, data warehouses are valued by users who need access to the right information in a usable format.
This is distinct from other approaches such as data lakes that act as huge collections of data, ranging from raw data that has not been organised or processed, through to varying levels of curated data sets. Ideal for some of the newer use cases such as Data Science, AI and machine learning, for more traditional analytics, data lakes can, however, be unwieldy and confusing.
As a result, many organisations opt for data warehouse solutions to manage essential data in more structured environments. However, working out how to speed up the rollout and management of these practices using technologies such as automation is essential if organisations are going to minimise the time to value and succeed in the data-driven business landscape.
Focusing On Data Warehouse Automation
In practical terms, as data enters the data warehouse environment, it is cleansed, transformed, categorised and tagged – making it easier to manage, use and monitor from a compliance perspective, which is where automation comes in. The problem is that the volume and velocity of data encountered by organisations today means that manually ingesting, processing and storing it in an accessible way that also meets compliance requirements within a data warehouse is increasingly unfeasible in the modern world.
However, with businesses constantly looking to data as the source of both reports and forecasts, a data warehouse is invaluable. As a result, data warehouse automation can help accelerate data ingestion and processing to boost time to value with data-driven decision-making in a data warehouse.
For example, Data Warehouse Automation (DWA) tools orchestrate the data warehousing process end-to-end, rather than being one of many tools that solve niche problems as in the traditional data warehousing lifecycle. This means companies don’t need teams of specialists at each stage of the process with manual handoffs between them, which can often lead to miscommunication and makes it harder to get a holistic view of the process.
Instead, implementing an automated template approach allows users to add their own data sources into and model the data to suit its needs, ensuring data structures are built quickly by automating all repetitive tasks whilst keeping IT teams in full control. As explained by Gartner in a recently published report ‘Assessing the Capabilities of Data Warehouse Automation (DWA)’, “The template-driven approach for data warehouse development reduces operational and compliance risks and is a disciplined process for delivering quality data warehouses incorporating all the best practices.”
Similarly, automation can help organisations manage the increasing levels of complexity that can blight their attempts to maximise the value of their data assets. As each new innovation builds ways to access the right data at the right time, so it can increase complexity for those tasked with designing the data ecosystem, and the problem is, many data teams still rely on 90s ETL tools and hand-coding to create and control a modern data fabric. As Gartner puts it, in the ‘Assessing the Capabilities of Data Warehouse Automation (DWA), “Automating these elements’ design plays a critical and essential role in data warehouse modernization and agile data warehousing.”
Across many teams, data warehouses now also play an important role in their efforts to implement and optimise DevOps, DataOps and other Agile methodologies. But, with automation handling the complexity, data teams can focus on strategic goals, such as delivering infrastructure and/or completing projects to Agile timeframes. For instance, teams who switch to DWA more readily adopt Agile, transformative frameworks such as DevOps or DataOps, and as a result, are in a stronger position to transform the way data is available to and used by the entire organisation.
Automation can also improve the ability of businesses to increase collaboration between IT and the business and speed critical processes, such as prototyping. Employing data-driven design to enable developers to create prototypes with actual company data, for instance, can demonstrate how requirements will behave in the final data warehouse. As the Gartner report explains: “The data-driven approach focuses on organizing the data models to align them closer to source systems. Business users and developers can collectively look at the data to gather inputs and feedback before creating the model. Using an iterative approach, data warehouse developers can rapidly build several prototypes before implementing the solution that meets the business user’s requirements. The method provides flexibility for deployment as well as management of changes to the data with flexible updates.”
While organisations the world over increase their commitment to becoming data driven, those who also automate key processes across their data warehouse strategy will be well placed to see a rapid return. In doing so, the most successful will benefit from a culture where data enhances their all-round abilities to innovate and deliver on key objectives.
Simon Spring, Account Director EMEA, at WhereScape, joined the company nearly ten years ago and throughout this time has worked effectively with hundreds of organisations looking to utilise data analytics and data warehouse automation to transform their business.
Data centre job market projected to grow to 2.3mn by 2025
The data centre industry had a fairly unique 2020. At a time when most sectors - hospitality and retail in particular - saw massive layoffs and furloughs, the demand for data centre services, and as a result data centre staff, continued its meteoric rise in spite of the pandemic.
A new report from the Uptime Institute - the leading certification body for data centre design; the folks who determine whether a facility is Tier I, II, or higher - was . The is the industry’s first comprehensive breakdown of workforce needs since the start of the pandemic.
The report’s authors note two megatrends set to create potential pain points for data centre operators looking to meet staffing demands over the coming years: a historic growth in demand, coinciding with a wave of experienced data centre staff in mature markets reaching retirement - colourfully dubbed the “silver tsunami”.
Across all regions and markets around the globe, the are continuing to accelerate data centre demand. Data centres are being commissioned, designed and built at a rate never seen before in the industry.
All of these processes require staff and, while automation has been doing a lot of legwork during the pandemic (using AI to increase efficiency and reduce the number of required number of on-site staff through predictive maintenance) as well as better DCIM platforms and the more modular design approaches being championed by , the industry’s need for skilled workers is only projected to grow as the decade continues.
Taj El-Khayat, Regional Director MENA at Citrix noted last year that, “The digital transformation’s acceleration across organisations due to the pandemic has exposed skill shortages. This has especially been the case for data centre operators, requested to provide the best and most stable service while facing a drastic and sudden increase in load.”
As a result, the data centre industry is expected to spend the next five years scrambling to fill more jobs than there may be available workers.
Courtesy of the Uptime Institute
In 2019, the global data centre industry employed approximately 2mn people. By 2025, that figure is expected to rise to 2.3mn, driven largely by growth in the APAC market, but also North America and EMEA.
The silver tsunami
In the more mature data centre markets, like northern Europe and North America, the Uptime Institute has raised an additional red flag. Due to the age of the industry and the speed at which it was initially built out at the end of the 1990s with the birth of the internet, “many employees are due to retire about the same time,” notes the report, cautioning that the coming silver tsunami could cause an additional surge in staffing demands. The effect, write the report’s authors, could “last for the coming decade.”
The report notes that, in particular, technical staff are notoriously difficult to recruit for data centres. It also adds that mechanical and electrical engineers in strategy and operations roles, and all types of controls and monitoring employees, will all be needed in greater numbers over the coming years.
In order to overcome these challenges and meet unprecedented demand for digital infrastructure, Rhonda Ascierto, vice president of research at the Uptime Institute notes that the “fast-growing and dynamic” sector will “need people from all backgrounds, all over the world,” if it is to meet the coming challenges.