The war on analytics talent & BICC project backlog: can data estate automation be the solution?

The war on talent is affecting most industries, but none more than the IT field. It is increasingly difficult to find quality data professionals and to hold onto these talented individuals. What is worse, is that most of these professionals are spending their time and valuable expertise on hand-coding and meticulously managing data systems.

In order to win this war on talent, companies need to not only provide their employees with the latest digital tools, but also allow them to use their talent for purposeful growth, innovation, and game-changing breakthroughs, rather than tedious coding and data management.

Data is no longer a byproduct or just an accidental creation of business processes or the storage of information that is required by regulatory authorities. The term data estate reframes the narrative. Think of data as a raw resource.

Data is the new oil and data science the refinery. Enterprises – large and small – need to handle their data with the respect it deserves. Business leaders understand that data is the potential for massive business transformation and profits. They manage their data effectively, entrust it to good stewards and grow it.

Analyst research reveals that the amount of data in the world is actually doubling every two years. For many organizations this goes even faster. As data increases it becomes more complex and increasingly more difficult to access, govern, and maintain compliance.

So, companies are looking into solving their current pains, but what about in a few years? How will they keep up with their data? They want to make sure that the solution is not only able to help their current organization but also prepares for the future.


On the one side, companies have their ever-growing data sources. On the other side, there are the business analytics instruments at their disposal: dashboards, reports, predictive tools, etc.


The war on analytics talent & BICC project backlog: can data estate automation be the solution?
click to enlargeThe war on analytics talent & BICC project backlog: can data estate automation be the solution?

Figure 1 – Self-service approach to BI

Some companies begin connecting these tools directly to the data sources, either using connectors within the tool, or writing scripts to extract the data. In taking this approach each analytical tool has its own data pipeline and set of transformations. While you get quick access to your data, it becomes increasingly difficult to manage. Data silos begin to develop with limited control of data quality and security.

Then, when a business user needs more data or new data, it is common to encounter an extended delay to address connectivity to source systems and data infrastructure issues.

Patchwork of tools

Many organizations begin to see the shortcomings of the previous approach and attempt to simplify matters. They may implement a staging layer to help simplify connections and improve security.

The war on analytics talent & BICC project backlog: can data estate automation be the solution?
click to enlargeThe war on analytics talent & BICC project backlog: can data estate automation be the solution?

Figure 2 – Patchwork of tools

Then when they encounter specific difficulties or pains, they try and implement a tool to treat each symptom. A tool for extracting data, a tool for transforming, a tool for modeling, a tool for scheduling and many others.

While this approach may make individual problems easier to handle, it ends up only making the overall implementation more difficult to manage. Each tool requires an expert to maintain it and none of these tools talk to one another, so you need to orchestrate the entire operation. In addition, maintaining compliant documentation for the solution often requires the same number of hours as it does to implement. This creates a serious draw on resources and results in a backlog of IT requests and delayed access to data.

Data estate automation

Companies do not want to simply treat the symptoms. They want to address the underlying condition. To run an effective business, users can’t wait days or weeks for new data: they want instant access. And not all user’s needs are the same, power users need raw data, business users need governed data, and casual users need pre-built data models. IT management wants to oblige, but rightfully has concerns about governance, security, privacy and cost. Furthermore, organizations understand they should take advantage of deploying their data estate to the cloud. The advantages of cloud computing are numerous: saving time and money on maintaining systems, only paying for technology that you actually use, working anywhere without disruptive access delays, scalability, flexibility, and more. However, deploying a cloud management strategy that involves critical financial and operational company data or customer data may sound overwhelming. The answer to ease the journey to deploying data in the cloud is automation.

Classic data warehouse efforts typically require manual work on schemas, data, ETL processes, metadata, users and applications. Companies leveraging a public cloud service such as Microsoft Azure should look for tools to simplify and accelerate the work of delevering a data estate that adequately serves their organizations. That is important because time-to-data matters. Time-to-data is the time between when someone has an idea of a new way of using data and when the data for that idea hits the BI front-end or analytics tool being used. So, how does automation help build a modern data estate on Azure? Utilizing a modern data management platform provides a cohesive data fabric for analytics data on Azure, on-premises or in a hybrid model. No need to stitch together tools for ETL, data modeling, code management, security, and documentation. In an automated solution, scripts are automatically generated and kept up to date to reflect the correct names of sources that have changed. Measures and calculations are made once and reused throughout the entire solution and in every front-end like MS Power BI, Qlik Sense or Tableau to access the data warehouse. Automated data impact analysis and lineage bring clarity about the origin of data without IT having to answer requests by going through lines of code manually. Automatic creation of documentation keeps track of which data goes where, satisfying GDPR compliance and audit requirements. Automation frees up resources, tracks changes and keeps systems up to date, making maintenance easier. Adding new data sources is significantly faster and more flexibel. By automating repetitive manual work businesses free up employees' time, allowing them to focus their attention on critical business matters.


It is imperative that IT never is a limiting factor for an organization to become more data-driven. Instead, it should empower users to leverage all the valuable information they have already stored and to use this information as support for even more intelligent decisions. So, companies looking for a platform that is specifically designed to build and maintain a modern data discovery architecture should consider to deploy their data estate to Microsoft Azure and enable instant access to data with timeXtender’s Discovery Hub. Because this data architecture persists in the users’ environment, it provides the users with instant access to data enabling immediate analytics. The software is able to bridge the gap between business and IT by transforming IT from a gatekeeper to a shopkeeper.