da

Stop stalling your BI project

juni 14, 2016


“We’re not ready for BI.” We hear it all the time from companies who want to implement a business intelligence solution, but feel like they don’t have the right systems or standards set in place before they can even begin. The data within their data warehouse is a mess. Or they don’t have a data warehouse at all. Company decision-makers are looking for answers, but they need time before they can get started with business intelligence. We’ve got news for you: It’s time to put an end to the delay.

Stop Stalling

If any of these reasons sound familiar to you, I’m going to debunk some common misconceptions.

1. “Our data warehouse is a mess. We need to clean the data first.”

No, you don’t. Even the most well-oiled enterprise humming away with their analytics projects and decision loops started with an incomplete, inconsistent, or otherwise flawed data warehouse. And guess what: That same company is still cleaning their data. Because I’ve got news for you, the process of data cleansing never ends. Companies just learn how to manage it more effectively.

The best way to start the data cleansing process is by first identifying what is inaccurate or missing. And the only way to identify that clearly is through a report or analysis generated from a BI platform. That’s because data quality is visual. That’s also why data cleansing with nothing but Excel on your side is dangerous. Without first understanding the BI process, it’s impossible to know what to look for in a data cleansing project to foster an environment of data optimized for analyses. 

For example, an analyst might look at the data warehouse and know there are 100,000 records to scrub, but they won’t know exactly in which way or why. But if they are given an incomplete sales report that doesn’t display revenue because the sales region was entered incorrectly or not at all, they’ll better be able to tackle those 100,000 records knowing exactly why, what, and how.

The problems must first be seen in order to be corrected. You can’t start cleaning if you don’t know what’s dirty. “Dirty data” is a position. “Missing region” is a concrete problem with an attainable solution. The moment that problem is revealed is the moment your company can start strengthening the building blocks of BI. Once the new process established by business intelligence is put into place, changes can be made along the way to continuously strengthen the data warehouse and foster an increasing number of Action Loops.

 [What’s an Action Loop? This guide tells you what they are, why they’re critical to your success, and provides instructions on establishing BI Action Loops throughout your company to foster better, faster decision making: The Better BI Strategy]


2. “We’re afraid to invest in a big project before we have the right processes put in place.” 

Traditional BI platforms required companies invest in the platform before value was delivered. But today's modern BI landscape allows for a partnership of investment and return. That’s because modern, bimodal BI solutions are designed for the type of experimentation and evolution I’ve described above, in other words, “sandbox analytics.” As I’ve written about before, a BI strategy that includes sandbox analytics is the easiest way to improve data quality with fast ROI. 

Tools like TARGIT Data Discovery module make it possible to play with data outside the data warehouse, determine its value, and then bring that data up to standards if it's found worthwhile. This allows analysts to gradually increase the quality of data along the way as data proves to be useful to the organization.  

The evolution-style strategy ensures short term ROI compared to what would typically be a massive data cleansing project. By thinking big and long term, companies can start small by investing in a tool like TARGIT Data Service that allows them to play with data inside a business intelligence platform for a fraction of the cost of a full scale solution. 

In this way, dirty data can be identified within days, not weeks or months. Once the data that is most valuable to the company has been identified for cleansing, that process can begin and guidelines and standards can be put in place across the organization to ensure data is input correctly going forward. 

Once the company has seen the value of even a small amount of BI, it’s far more likely further investment will be planned. As the BI strategy matures, an increasing amount of tools and capabilities can be added to the BI environment to spread analytics to every role throughout the entire organization.  

[Read about the three steps needed to go from the baby steps of BI to a full-fledged data-driven environment in this guide: 3 Stages of Becoming an Analytics-Driven Organization]  

3. “We don’t even have a data warehouse.”

Good news! You don’t need one! Advances in in-memory technologies and the business intelligence platforms that support them make it possible to fully utilize the power of a BI solution without investing in a data warehouse. 

In addition to fast ROI, there are other significant benefits to launching BI without the confines of a data warehouse. Work process speeds are significantly increased, as users can load data in seconds. In-memory is also generally more user-friendly than a typical data warehouse setup. It doesn’t take significant training to acquire the skills needed to work directly in the system. 

Most importantly, in-memory systems allow for near real-time experimentation with data from a variety of sources. That can be anything from Excel spreadsheets living on a desktop to big data repositories such as Hadoop. This flexibility also allows for easy scaling. Enterprises looking for the standardization of the data warehouse set up can scale upwards with their BI when the time is right. 

Time to Begin the BI Journey 



I have decades of experience of BI implementation, and I have never come across a case in which a company wasn’t surprised by the insight that was unveiled on the first day they gained real access to their data – regardless of whether or not they have access to everything they needed just yet. That means up until that point, their decisions were flawed. Every day that goes by in which decisions are made based off of hypothesis or assumptions is a lost day of making better decisions.

Share