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

 

The Most Important 2% of Your Day

When you look at how Business Intelligence tools are marketed, you’d think that the secret to a wildly successful operation is to simply have executives sit at their desks looking at beautifully laid out dashboards, clicking here and there on charts, graphs, and gauges, drilling down, rolling up, and slicing and dicing their data. After all, that’s what the vendors of Business Intelligence systems portray in their marketing communications (and we’re guilty of using eye candy in our own materials, too).

I’m the CEO of a Business Intelligence consultancy. Organizing and presenting data in ways that enable business decisions is all that we’ve done for the 15 years since I founded Dataspace. Before that, I did it at MicroStrategy.  I’ve, even, co-authored three books on the topic.  Of all people, you might expect me to be sitting at my desk, slicing and dicing to my heart’s content. But you know what? I have a business to run. I’ve got to spend my time on attracting new clients, ensuring my team delivers flawlessly, and conduct a variety of back office functions from tracking payables and receivables to minimizing my overhead. And while we have implemented Business Intelligence tools at Dataspace to help me manage my operation, with the data collected, integrated and presented in a manner specific to my needs, I find I actually spend very little time using these systems. And typically for only two purposes: 1) to investigate a particular problem; 2) to check in once a week or so to see whether things are on track. I recently estimated how much time I spend using on these systems, and found I don’t spend more than an hour a week in them.

Do successful managers spend their days clicking around in BI systems?  I don’t think so.  Successful managers spend their time managing: making decisions and interacting with people – customers, employees, partners, suppliers, etc.  Well-designed BI systems quickly give managers a view of what’s going on – of what decisions they need to make and what conversations they need to have.  Well-designed BI systems get the answer across quickly and then get out of the way.

I’m proud that I use my system less than 2% of the time. After all, well-designed BI systems enable use of that 2% to identify the decisions that need to be made, and the conversations that need to be had with the other 98%.

Want to discuss?  Feel free to contact me at btaub@dataspace.com.– Ben

QlikView: Check it Out!

April 19, 2009 by  
Filed under All

If you check out the message boards and recent Gartner Magic Quadrants you’ll see that QlikView is the next hot thing in business intelligence. Some of our clients are using the tool and they are ecstatic. Applications are created far faster than with traditional BI tools and executive users eat it up. I can’t think of many other BI implementations where executives are eager to get on the computer.

In a stodgy BI space that is plagued by incremental upgrades and poor customer support, QlikView is BI’s battle of Midway – a point of inflection that changes the game. If you haven’t seen the tool, I urge you to check it out at www.qlikview.com. Run the demos, they give a good idea of what it can do.

So, what’s so good about QlikView? Well, once you see the tool in action you realize that it’s not about producing the next generation of pretty green bar reports. It is about giving users easy tools for rapidly slicing through data. The difference between QlikView and traditional BI tools can be summed up as follows: Traditional BI tools are for people who need reports, QlikView is for people who need answers.

In future posts I’ll talk more about what’s so great about the tool, about how it crushes the traditional BI – DW development methodology, why most companies will still need a data warehouse and why, in the end, QlikView is complementary to, not a replacement for, current BI technologies.

Want more info before then? Drop me a line at btaub@dataspace.com.