The great conference hall fell silent when the CFO stepped up to the front of the room. He hadnâ€™t called the whole IT team together since he had taken that position three years before. The rumors and speculation of why he was doing this brought out everyoneâ€™s fears and excitement, not to mention creativity. There was even a rumor that he was going to leave the company and teach sky diving. â€œThereâ€™s less risk in sky diving,â€ he often remarked.
â€œAll of you know Iâ€™m the first person to encourage good Business Intelligence projects that can save us money or give us a competitive edge, but our track record with BI projects indicates that the cost simply isnâ€™t justified in most cases. In fact, our track record is abysmal!
The soon-to-be sky diver turned on the projector. â€œHere we are. This is the bottom line.â€
Last quarter we approved twelve projects, and only one has been completedâ€¦ three months later. We canâ€™t pretend any longer, and itâ€™s my job to say this.These are all projects that theoretically could save us hundreds of thousands of dollars, but the data preparation is so complex and time consuming that that by the time weâ€™re ready for the analytics, business drivers have shifted, which means that the data requirements have changed. Iâ€™m seriously tempted to get us out of the BI business.
â€œI expect everyone in IT to put some thought into this. My door is open, so bring me a solution.â€
After the meeting, Marvin-the Millennial was already in the CFOâ€™s office waiting for him.
â€œHi, Iâ€™m Marvin. Fairly new here, but I have the answer. Remember Terri, the Data Warehouse architect, whoâ€¦um..sort of disappeared a couple of months ago?â€ CFO nods, â€œVery smart but, I must say, a little odd.â€
“Well, her legacy is a couple of huge data warehouses that, as you know, sir, constitute the official repositories for all BI and BA dashboards. If I may be so bold, I believe these are the root cause of the long implementation times. Since Terri left, I have been working with Enterprise Enabler, which is a data virtualization technology.â€
“And what might that be?â€ interrupted CFO.
â€œWell, basically, instead of building ETL scripts and moving all the data into the Data Warehouse, you just grab the data from the original sources, live, with Enterprise Enabler resolving the BI queries on the fly and returning the data exactly the way it would if the data were physically stored in a database. You can avoid that whole classic data prep exercise and all the associated risk. On top of that, you can bring live data instead of data that is stale.â€
â€œThis whole story sounds like fiction to me. What if some of the data comes from systems like from SAP instead of relational databases. That must require custom coding?â€
â€œNo â€“ Out of the box.â€
â€œOnline data feeds?â€
â€œOut of the box.â€
â€œIOT, Big Data, flat filesâ€¦â€
â€œSame, same, same. Everything is configured from a single extensible platform, and the data relationships across these totally different sources are associated as easily as making a relationship across tables in a regular database. And by the way, these Virtual Data models can be used as Master Data definitions.
â€œYou are not going to believe this, but yesterday I made a slide just like yours showing the data prep time with Enterprise Enabler.â€ Marvin unfolded his dog-eared slide on the table in front CFO.
â€œCome. Iâ€™ll show you what Iâ€™ve been working on. Iâ€™ve configured several virtual data models and set up various analytics dashboards using Tableau, Spotfire, and Power BI. Oh, and thereâ€™s another really cool thing! I can write back to the sources or take other actions from the dashboard based on decisions I conclude from playing around with the analytics.â€
â€œOk, Marvin, how are we going to get everyone trained on Enterprise Enabler?”
“They can start with www.quant-ict.nl”
“We are going to scrap any more Data Warehouse projects unless we need to capture the data for historic reasons. This will bring an important competitive advantage (unless our competitors discover Enterprise Enabler, too.)
“Guess sky diving will have to wait. Letâ€™s get this show on the road!â€
Source: Blog: Pamela Zsabo, Stonebond Enterprise