Your BI vendor is working With you, not For you

In the past years I’ve had the opportunity to work on both sides of the BI vendor table, as both the consumer and the retailer. I’ve seen many projects succeed, some projects fail, and some projects that seem to surpass all expectations and all parties involved are delighted. The latter group of success stories all have one common factor: TEAMWORK

These successful BI implementations often end with kindred feelings of friendship and it all starts with the attitudes of the two parties involved. When you approach your BI vendor as a team mate it is easier to see that you both have the same goal: a smooth, successful BI implementation.

This means that both sides will need to do their due diligence. Roles are not always clearly defined and a team work attitude will encourage flexibility. Your BI vendor will not always be an expert on the content of your data, so be prepared to source internally for validation stages.

Consider the two options for communicating with your BI vendor below:

Teammate Attitude: Our data doesn’t look correct, let’s investigate to see where the problem might be.
Authoritative attitude: Your data is wrong, you need to fix it so that we can go live, this project is already behind.

The teammate attitude opens up the opportunity for further conversation. As a BI vendor I will be able to request specific examples of inaccuracies and I will feel comfortable asking for help if the data appears to be non-standard.

The authoritative attitude shuts down any potential for creative problem solving right away. The assumption behind this statement is that the BI vendor did something wrong and is aware of how to fix it. What super-techie, number-crunching, data-loving nerd would knowingly choose to display inaccurate data? Ahhh! Sounds like a nightmare for any data guru.

Remember, when you’re shopping for your BI vendor, you are shopping for a partnership, not a dine and dash vendor. The earlier you help cultivate that partnership, the smoother your BI implementation will go (assuming you pick an awesome vendor to work with).


Understanding Your Customers: The 360° View

360° Customer View
360° Customer View

Most companies have multiple systems that store various forms of their customer data. Generally business analysts or financial analysts will study this data to determine the habits of their customers. But what happens when your source systems don’t have a common key to link the customer data? You end up with only a partial view of your customers and department heads are making operating decisions based on incomplete and inaccurate customer data. The obvious solution? Find a way to link the data!

While there are multiple ways to accomplish this task, a complete business intelligence solution will provide integrated data from all source systems, a rich data warehouse, and an easy to use graphical user interface to extract and analyze the data. A 360 view of your customer means understanding what brings them to your business and what they do while they are there.

OK, so you want this for your business. You realize you aren’t using all of the data you have and your marketing campaigns are hit-or-miss. Where do you start? First you have to determine who is going to build the business logic into a data warehouse that creates a common customer key across the platforms. Because most businesses are new to BI, they don’t realize that the BI vendor and the company that deals with manipulating your data are likely not the same company.

There are several options here. If your IT department has the time, resources, and knowledge, they can be tasked with building the data warehouse. You can also contact a vendor that is independent from your BI vendor to build your data warehouse. The third option is to put all of your faith in your BI vendor and let them choose a data group that fits your data. Most BI vendors will have multiple partners and will probably be able to choose a data integration partner that is experienced in your field.

If you prefer to let your BI vendor choose a data integration partner for you, then it is time to face the challenging task of searching for a BI vendor that fits your company’s needs. There are dozens of reputable vendors to choose from. I recommend contacting 3-4 different vendors and requesting a demo of the software. Most companies are more than happy to visit your property to analyze your specific business needs and show off their cool new BI tools. Warning to my fellow data nerds out there: These demos will probably be a show-and-tell of pretty user interfaces and fancy drag and drop reporting capabilities. These presentations are designed to win over the executives and sell the product. The interesting details about the data will come later.

OK, so this is how you get started with your new business intelligence solution. It’s exciting, it’s fun, and it’s a lot of work. Stay with me and we’ll discuss finalizing a deal with your vendor, gathering business and functional requirements and who to include in the beginning stages of the project.