Would you like to make a lot of money in IT? Just sprinkle some Business Intelligence buzz words in your resume. No really. The Business Intelligence space is filled with impostors, resume inflators, and snake oil sales people. If I haven’t offended everyone yet then let me add that the Business Intelligence space is also littered with vapor ware vendors. Is it their fault? I would argue no. It all starts with strategy behind the Business Intelligence initiative a company initiates.
Let’s start by talking about how your Engineering team views Business Intelligence. Rome wasn’t built in a day, neither were your systems, and success in Business Intelligence will follow the same logic. So from day one your Business Intelligence strategy needs to be at the forefront of your engineering design. You can design the most elaborate database structure and applications that contain the most complicated business logic. But if you can’t get the data out and make sense of it then it was all a waste of time. More times than not this is the symptom I see in IT.
Another prolific problem occurs when the Business Intelligence initiatives come from the top. How many times have you heard ‘we need dashboards’ or ‘we need KPI’s’.? Your Business Intelligence team then has to go figure out what these folks want to see. Sometimes the business knows and provides you with some spreadsheet that the kid down in Finance put together from data that isn’t anywhere in your source databases. Other times it’s in an even more colorful spreadsheet that has the executives all excite, but upon further analysis you realize that the logic or data is flawed. Then you’re stuck in the precarious position of having to explain why the report that has been touted as the ‘ultimate report’ can’t be implemented. All of this is symptomatic of a Business Intelligence strategy that doesn’t provide the users with what they need, a self service method of accessing the available data and reporting on it. You need to develop a strategy to implement this, because the chances are that your Business Intelligence team is not the ‘business experts’. The kid down in Finance is. Provide him the data and the tools and let him loose.
So why do I say that the the fault lies with you and not the snake oil sales people or the vapor ware vendors? Because all they do is come in and show you the latest wiz bang gadget filled with colorful dashboards and capabilities to help you decide if and when your shoes need to be tied. The responsibility to setup a structure that takes advantage of these capabilities is yours.
Here are three simple thinks to keep in mind while trying to optimize you Business Intelligence development:
1) Get them involved in new development initiatives as early as possible.
2) Concentrate on the data structure, design and processing.
3) If you do nothing else. Concentrate on delivery mechanisms and self service tools. Your team is probably not business subject matter experts, but your end users are.
I’m by no means the master of BI so I welcome any and all additions, suggestions or comments!