Quiz – July 2011: Hunh?

Whaa? Er, Eh, mmmmmmmm, hunh?

This month's quiz tests your knowledge of various, somewhat-data-related topics. Answer correctly and win an amazing Dataspace coffee mug. Winner will be selected at random from all entries received by 30 July 2011. Good luck!
  • Crow's foot
  • No, not a crow's foot
  • Entrant Info

  • This field is for validation purposes and should be left unchanged.

 

Quiz – January 2011: Name the BI Vendor or Candy Company

January 17, 2011 by  
Filed under All, business intelligence, data warehousing, Quizzes

 

 

 

Confection... or BI Technology? Can you tell the difference?

This month’s question tests your knowledge of BI bragging rights and of candy manufacturers. Certain people, vendors or corporate divisions are traditionally associated with particular technologies. For this month’s quiz, match the BI / DW technology or confection with the person or organization most closely associated with it.

Depending on the question, multiple answers may be required.
  • Entrant Info

  • ---------------------------------------------------------

    ANSWER KEY

    It took a while for our official auditors to verify the results, but here is the official answer key to January's quiz:

    Associative database: QlikTech QlikView

    Relational OLAP: MicroStrategy

    Column oriented database: Infobright AND Vertica

    Snickers: M&M Mars

    Data warehouse appliance: Netezza

    Data modeling tools: CA ERWin and Embarcadero ER Studio

    Krackel: Hershey

    Star schema: Ralph Kimball

    Data warehousing as a formal construct: Bill Inmon

    ETL Tools: IBM DataStage, Informatica, Microsoft SSIS, AND Oracle Warehouse Builder

    Open source relational database: MySQL

    Luxe Milk: Ghirardelli

 

Quiz – November 2010: BI Industry Consolidation

October 30, 2010 by  
Filed under All, business intelligence, Quizzes

Submit the right answer and win this month’s grand prize – an amazing Dataspace coffee mug (well, our field testing has shown it to be somewhat microwave safe). The winner will be chosen at random from all correct answers submitted by November 20.

This month’s question tests your knowledge of the current BI playing field. Over the past few years we’ve seen a lot of consolidation in the BI / DW and general database space. For this month’s quiz, match the ‘legacy’ BI / DW technology or company with its current (or soon to be) owner.

HINT: Dataspace has not been acquired.

Hey, thanks to everyone who submitted answers.  Here is the answer key:

Business Objects – SAP

Crystal Reports- SAP

Sybase – SAP

DataStage – IBM

Netezza – IBM

Red Brick – IBM

Informix – IBM

TM1 – IBM

VMark – IBM

Cognos – IBM

Essbase- Oracle

Arbor Software – Oracle

Siebel Analytics – Oracle

DATAllegro – Microsoft

Panorama (OLAP DB Technology) – Microsoft

MicroStrategy – MicroStrategy

Dataspace – Dataspace

Business Intelligence: Where to turn now?

July 28, 2009 by  
Filed under All, business intelligence, management reporting

In my discussions with customers and others in the BI field I am hearing a lot of anguish about software vendors.  Many of the larger BI players have been sucked up into bigger companies and I’m hearing that these BI vendors, which were never customer-friendly to begin with, are now becoming downright customer-hostile – even with customers who have paid maintenance for the privilege of obtaining technical support.  Take a look at this article from CIO Magazine for more detail on the turmoil, and this article on Business Intelligence vendors to watch.

BI software vendors used to be grouped into the top three or four players, with open source and smaller players taking a far back-seat.  Things have changed.  Every week I’m seeing product announcements from new entrants.  Some of the tools look really good.  One I’m a big fan of, despite some limitations, is QlikView.  They’ve been around for a while, but are still relatively new compared with long-time BI players.

As consultants, we have the opportunity to work with a great group of clients, and we apply our expertise regardless of the technology they have already deployed – even if its one of the aforementioned customer service-challenged companies.  What to do, though, when a client asks us to recommend a new technology to help them rid themselves of their BI headaches, or make a new start in the field?  We’ve learned that the company behind a technology is as important to a successful implementation as the technology itself.  After all, you can get management dashboards, alerts, statistical analysis and basic reporting from virtually all of the established players.

So, who to choose?

Of course it depends on the application, but if you’re looking for enterprise-class reporting, dashboarding capability, the ability to email basic business intelligence to a broad audience, reasonable licensing models, and an independent vendor partner with a great reputation for customer service, the answer could very well be Information Builders, IBI, the creators of Focus and WebFocus.

What?  Isn’t IBI an old-line mainframe reporting solution?  That’s what I thought.  But, then I saw the technology demonstrated to one of my clients.  Is it perfect?  No.  Other major vendors like Business Objects, Cognos and MicroStrategy each have their unique advantages and disadvantages.  But, IBI really seems to ‘get it’ in two very important ways:

1) WebFocus provides flexibility but also comprehends a fact I’ve been talking about for a long time: MOST USERS DO NOT CREATE REPORTS FROM SCRATCH.  In most BI environments reports are created by IT and, perhaps, a few power users.  The vast majority of users don’t want to and don’t need to create reports from scratch.  (For more on this see my post on tying the BI tool to the user. )

2) IBI customers are genuinely happy both with the tools AND with the vendor.  As with any piece of software, tech support issues do occasionally arise, but the feedback I’ve received is that when they occur, they are given top priority.  Can you say that about your BI vendor?

We were so impressed with the research we’ve conducted, that we’re considering partnership with IBI.  If you are evaluating Business Intelligence tool sets, I recommend that you consider them.

– Ben