There are a couple of refrains from the IT world which are immediately recognisable: people are scarce and expensive on the one hand. Data is exploding and keeping on top of it increasingly difficult on the other. But there is a solution to both of those problems and that solution is good software tools which can scale to stay on top of the data tsunami, while also allowing skilled people to focus their attention where it matters.
You don’t really need me to point out just how much data there is and how much more is being created every day. But there are some pretty cool comparisons which provide an indication of the volumes that society is pumping out. App Developer Magazine notes that this year, more data will be created than was produced by all of humanity in the past 5,000 years. Crazy (but that’s the power of digital vs. hieroglyphics, writ large).
Hiring more developers to stay on top of exponential data growth, which you will be feeling in your business, is not the answer. It costs too much. It’s also a mug’s game, because as exponential implies, the numbers of staff members will have to keep growing.
At the same time, however, there is the necessity to bring data online and make it available to your lines of business. Competitiveness depends on it, but the volume and complexity renders the task Sisyphean, at least inasmuch as manual methods are concerned.
And so, it is to the Pareto principle we turn. With data warehousing, a good 80 percent of the coding which is required can be automated. It is rote stuff, standardised for just about every data warehousing project, and while necessary, this 80 percent is not where most of the value is created. Instead, it is in the 20 percent that the ‘special sauce’ lies, and that 20 percent is precisely where the talents, effort and concentration of developers should be focused.
Relieving them of 80 percent of the workload through software automation frees developers for the most crucial part of their task: engaging with and understanding business needs. At the end of the day, despite the data tsunami or explosion or whatever you’d like to call it, getting value from data is a very people-driven process. When the developers are free to engage with the business, to truly understand and appreciate what the problems and challenges are, that’s when the magic happens.
Bear in mind that a lot of data initiatives are exploratory in nature. That means a fast moving environment where it can be necessary to rapidly pivot to try new things or experiment. With the automation factor, pivoting is easy; the basics are taken care of, and the developer and businessperson can put their heads together to achieve the sort of chemistry which drives the ‘eureka’ moments which no-one could have anticipated.
That is when the breakthroughs occur, the great ideas which come out of synergy are born.
Developers buried in dull code are not going to achieve such outcomes. Instead, it is through the power of good software that scale is achieved and people are equipped to do what they do best.
The software which enables data warehouse automation – and therefore provides the ability to scale to meet whatever your data requirements are – is available today. It’s called WhereScape Red and it automates 80% of the build process.
It is software that intelligently and contextually auto-generates the required code to populate your desired data model, be that Data Vault, Normalised or Dimensional. And leaves your developers to focus on the stuff that gets them excited and delivers real value to the business.