How BI can help your reputation and more…

It concerns me to see several car manufacturers recalling their vehicles to carry out urgent safety repairs.

Not only is there a massive cost involved in such a process, but the impact on a firms reputation can be far higher.

A number of the manufacturers involved have previously been held in high regard. The actions taken now by these manufacturers in resolving these problems will determine future consumer buying decisions.

And this leads me to my point about BI.

If you have BI, and you have a metric which monitored problems reported by owners, wouldn’t there have been an early opportunity to spot that something was going wrong? Perhaps an ‘outlier’ on that chart or scattergram which suggested something was looking odd. Perhaps an alerter which indicated a higher percentage of faults on a particular model or range than the norm.

It’s when you start to visualise these outliers – those items which sit outside of the normal boundaries, that you should start paying attention. And I say visualise, because you won’t spot these outliers too easily on a table of values. You need a visual prompt, be it a chart or an alerter.

Another case of leveraging your BI tools to spot trends. I read somewhere, and forgive me for not providing the source, that a large Wall Street firm spotted a worrying trend in mortgage defaults in the US, long before the worst of the financial crisis took hold. It promptly decided to withdraw its exposure from that part of the market. It probably saved their firm from going under.

Business Intelligence – Hot Skill for 2010

Wondering if your Business Objects skills will hold up in 2010?

Well have a read of Jon Reed’s excellent white paper about SAP career and skills trends in 2010.

Divided into two parts, take particular note of the table in Page 9 in the second part of the white paper. But don’t jump straight to this – the whole white paper makes for interesting reading.

Enjoy!

Is Microsoft winning the BI race?

I just finished reading an interesting article written by Oudi Antebi of Panorama Software.

In it he states that the Microsoft BI path has been somewhat confusing over the past few years – what with their purchase of Proclarity, and it’s subsequent withdrawal (please bring it back!), it’s development of Performance Point Server, and it’s subsequent integration into Sharepoint. (And possibly PPS revival). This has left consumers and consultancies wondering whether to invest in the Microsoft BI stack at all.

However, Oudi points out that Microsoft may be following the pareto rule of 80/20 and trying to win the hearts of 80% of the BI population by integrating basic BI features into its Office and MOSS products. It is then happy to leave the remaining 20%, otherwise known as the power users, to use software from the likes of Panorama (shameful plug Oudi), Oracle and SAP Business Objects.

Oudi’s article is interesting on several levels.

Many of you will know that I am a fan of several BI applications – Panorama, Tableau and Qlikview. These powerful applications provide the end user with a simple GUI interface and allow you to really dig down into your data and present it in a wide variety of ways. The resulting output, I feel, is at the cutting edge of BI reporting.

Several vendors are looking at offering their wares over data you may (one day?) hold in the ‘cloud’. No doubt the cloud will grow in popularity over time and it removes the cost of purchasing and maintaining hardware on site. Google is not far behind either. It has been working on several initiatives including Google Wave and Google Squared. Google has in fact worked closely with Panorama on several projects involving its Google spreadsheet application. Google also bought the rights to the Gapminder graphical application which allows you to view you data over several dimensions over a moving time period. Fantastic product and demonstrated like no other by Ola Rosling in several conferences. I wrote about a presentation he done at TED which was unbelievable. But I digress.

The fact is that Oubi thinks that this is a race with one winner.

I disagree.

Microsoft, with its current BI stack, will not win the BI race. In fact, I don’t think there will be or can be a winner. BI means different things to different people. BI is vital to all organisations, and will one day be used by every employee at every level. From basic tabular reports, to graphs to dashboards. We are all living in an age where we are confronted by mountains of data. Data storage is growing exponentially. Simply look at the size of your home storage, and the volume of music or photos or files that you may store. How does that compare to your system of 5 years ago? And imagine the data being collected by telecoms companies, retail companies, reward schemes, etc. So any system which can aggregate that data, cleanse it and present it in a form which is accurate, timely and relevant will be of enormous value to an organisation.

There are people who prefer to see tables of data for which Excel is an excellent option. There are others who want to track metrics and KPI’s, and several applications, including Xcelsius allow you to do just that. Other people or power users may want to drill down into the underlying data, to really determine the causes of a strange number – an outlier. Several companies are offering applications on mobile devices such as the iPhone, as discussed here by Timo Elliot. Again, this advance will satisfy a small subset of the BI community.

Price also plays an important part, and this is where Microsoft will win many hearts and minds, and perhaps more importantly, the signature on the purchase order. A number of BI vendor solutions are very expensive indeed. Others are more realistically priced, and several Microsoft solutions may be used at no additional cost depending on the type of licence you hold. With Office being the predominant application on users desktops, embedding simple BI functionality into Excel is a no brainer. Perhaps an organisation is using Sharepoint as an internal document portal. Well, now you can put up some dashboards using PPS functionality.

While I think there is a big place for Microsoft in the BI world, I certainly don’t think it is going to be the ‘winner’. Smaller, more nimble BI software companies, are pushing the boundaries of what can be achieved with BI, offering us with ever more imaginative ways of viewing our data and extracting the key information we need to know. Several of the larger vendors offer organisations a strong case to use use their complete stack, from database, to ETL and data cleansing, to creating cubes/universes, reports and right through to dashboards and KPI’s. A one stop solution from one of the largest BI vendors.

These vendors are focused 100% on BI.

Not Office.

Not Windows.

Not XBox.

Just BI.

And having a laser like focus on BI will give these organisations the edge to develop the very best products on the market.

Ultimate Business Intelligence Guide

Here’s a useful website if you are interested in the more general area of BI.

This is a comprehensive site. Of particular interest to me are the following articles:

BI software: A comprehensive look at various BI software offerings

Certification : Various pages discussing BI certification paths available from Microsoft, Oracle, Business Objects and SAS

Books: The book list is quite extensive covering Data Warehousing, BOBJ, Microsoft, Oracle and Data Visualisation.

Solutions: A detailled look at the whole gamut of BI technologies.

I’ve added this to my list of bookmarks.

Gartner Magic Quadrant for Business Intelligence 2008

Gartner have produced some interesting research on the Business Intelligence market for 2008.

This is particularly interesting as a number of the larger BI pure play vendors such as Business Objects and Cognos have been purchased by some larger software vendors – notably SAP and IBM. Some of the small BI pure plays have also been snapped up – Microsoft’s purchase of ProClarity and Tibco’s purchase of Spotfire.

There is also a useful section at the bottom which lists the strengths and weaknesses of a number of the vendors which makes for some interesting reading. Have a read of the research article.

MCITP SQL Server: Business Intelligence

I need to set some personal objectives for the next six months and I’ve been considering working towards the Microsoft MCITP SQL Server: Business Intelligence certification.

This requires that I pass two exams:

  • 70-445: Microsoft SQL Server 2005 Business Intelligence – Implementation and Maintenance
  • 70-446 exam: Designing a Business Intelligence Infrastructure by Using Microsoft SQL Server 2005

Passing the 70-445 gives you the MCTS SQL Server BI certification. Passing the 70-446 gives you the MCITP. The 70-445 is a prerequisite to the 70-446.

According to the latest MCP figures, there aren’t that many MCITP BI developers out there, so this may be a challenge I’ll take on.

From the company perspective, it will be a big plus as it will earn them their third competency – Business Intelligence, and will enhance our Microsoft Gold Partner status. Hitting this milestone should also yield a good bonus at the end of the year! On a personal level, it will allow me to build on my existing BusinessObjects and Performance Point Server skills and pick up more of the Microsoft BI toolset.

I’ve worked with Microsoft SQL Server a great deal and am currently playing around with SQL Server 2008. I’ve also used most of the Microsoft BI tools as well; SSIS, SSAS (for cubes) and SSRS. Having looked through the exam preparation guides, I think I can clear these two exams in the next few months.

I don’t think I’ll take any formal classroom based training for these exams. I’d rather use my training budget on something else, possibly Crystal Reports or BusinessObjects Data Integrator. Hence, I’ll be using the MS book MCTS Self-Paced Training Kit (Exam 70-445): Microsoft® SQL Server™ 2005 Business Intelligence—Implementation and Maintenance to get me going.

Once this is out of the way, I might start looking at Sharepoint, and portals in general.

Good BI/DW websites/blogs

A list of good BI/DW websites and blogs. Worth bookmarking and regularly revisiting.

  1. Business Objects forum. Quite simply, the definitive source of answers and solutions to all your Business Objects problems.
  2. B-Eye-Network. Packed with news and articles relating to Business Intelligence.
  3. The Data Warehouse InstituteNews and reviews relating to data warehousing.
  4. DM ReviewNews and reviews relating to data warehousing.
  5. Intelligent EnterpriseNews and reviews relating to data warehousing.
  6. Ralph Kimball. Ralph also sends out a monthly newsletter with DW tips.
  7. The OLAP report. Mainly subscriber based, but there are a few free sections that may be of interest.
  8. Mark Rittman. Comprehensive postings regarding the Oracle BI suite.
  9. BI Blogs. A blog aggregator. Contains many useful articles from BI related blogs. Always something interesting to read everyday.
  10. Open Source BI. A useful site for all that is Open Source BI
Follow

Get every new post delivered to your Inbox.