20 Lessons learnt in 20 years of Business Intelligence and Data Warehousing (Part III)


(This one is focused on technology choices and approaches)

DW Platforms

If you want assured success and have a budget, pick Oracle. It continues to meet every need in the DW space.

If you are one of the largest organizations and are handling trillions of records, you are probably already on Teradata.

Netezza is also there. I have never tried it myself.

Some new cloud platforms are interesting, such as Snowflake. I have never tried it but I see it in cutting edge organizations.

BI technologies

Cognos is great as an enterprise reporting technology, but some other vendors are more nimble.

The leading one amongst this for visualization innovation is Tableau.

Business Objects and OBIEE are other good options for enterprise reporting.

Qlikview has its niche.

Looker seems to come up now and then as a cloud based new offering.

ETL

Informatica has the most market share and I would pick it over others for its versatility.

Ab Initio is the fastest I have ever seen.

Talend is not bad but not sure of its heavy lifting skills.

Modeling Approaches

Use Inmon for the ODS and Kimball for the Data Mart(s).

Don’t bother with SCD Type II – it is dated and not the most efficient way to track changes.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s