Data Warehousing

With the flood of Business Intelligence software showcased in the last few years, coupled with budget tightening and procurement freezes, the question of what elements should be included in a Business Intelligence Solution becomes more paramount.

BI systems have been defined as being able to do everything from centralizing all of your corporate data from all of your various applications through robust (although nearly always proprietary) ETL tools to being able to provide ad hoc, on demand report developing capabilities for not only business analysts, but also for corporate executives and managers, who may not be a technically savvy as your average 9th grade high school student.

But what does a Business Intelligence tool really need to include? Well, for starters, I'd recommend looking for operating system and database independence and scalability. Sure, you're business might be using Oracle today, but when your CTO decides to cut a great deal with MS SQL Server for a much lower price, you're going to want a tool that can make that transition. And believe me, that happens more than you might think.

I'd make sure your BI tool candidate has all of the analytical tools you'll need. OLAP and MOLAP capability with the ability to develop reports against MOLAP, dimensional model, or relational models architectures are critical. Make sure you have the ability to easily develop reports that use very complex SQL aggregations, correlating sub-queries, and unions. I mean, hey, if we wanted to write SQL, we would have just called a programmer, right?

Next I'd look for something with a web based design interface, with all the bells and whistles, including GIS connectivity (or at least something that can use one of the existing GIS vendors). The days of installing client applications for design tools are past us.

Your might think that ETL would be a major requirement in this decision, but honestly, this isn't as important anymore. Most companies are using an ELT (that's not a typo) solution now where you Electronically Load, and then Transform your data. That way you can use very simplistic data replication tools, and let your database engine do all the transformation rather than doing it on the way to the databases.

The world of Business Intelligence has evolved quite a bit in recent years. The hyper competitive business market has driven the Business Intelligence industry to provide analytical information regarding trends and forecasting on the spot. More useful information is needed, and less time is available to derive it. That's why it's important to have a Business Intelligence solution in place that can give you the on-Demand features and benefits that you need.

When selecting an on-demand BI solution there are several factors to take into consideration.

* make sure your Business Intelligence solution is user friendly. Business analysts, corporate executives, and manages are not always technically proficient, so it's important that your BI tool can get them the information they need without having to train them on various technical aspects.

* make sure your BI tool is database platform, and operating system independent. Some BI tools only work with MicroSoft or Oracle, and it may not be in your companies best interest to make a change.

* make sure your BI tool comes with a centralized meta-data repository?. It's important to know who's using the tool, and how long verious reports and cubes take to run.

* make sure your BI tool offers GIS capability or compatibility with existing GIS tools. Mapping data will be a huge part of business intelligence in the future, and you don't want to miss out because your BI solution doesn't support it.

* make sure your BI tool supports complex statistical analysis. Simple straightforward counts don't always cut it, and not everyone has the time to learn SaaS BI.