Analytics Roundup: Expensive cup of Joe-l
By Chris Gemignani
January 24, 2008
Find more about:
business
coffee
customer_service
humor
metrics
software
timeline
visualization
- On the Fahrenheit scale, do 0 and 100 have any special meaning
- The story of a mixed up metric.
- At Last, a $20,000 Cup of Coffee - New York Times
- Monstrous $20k coffee brewing system for fanatics, err, I mean, purists.
- Five whys - Joel on Software
- Incredible blog on system uptime, SLAs, rdiculousness of "Six 9's", black swans, and how superbly FogCreek Software handles customer service issues.
- Browser History Timeline
- Chronicle of the lives of six popular Web browsers.
Microsoft says: "BI is Really Hard to Use"
By Zach Gemignani
January 3, 2008
Find more about:
agile
bi
business
management
We don’t tend to agree with Microsoft when it comes to data analysis and presentations. In fact, we’ve even been critical of them for misrepresenting data, excessive visual “flair”, missed opportunities to improve Excel, forgetting their power users, subpar presentation tools, and wasteful slide masters.
With all these past differences, I was a little surprised to find that we do share some common ground. Check out the comments (from an article in Internet News) by Peter Klein, CFO for Microsoft’s Business Division in describing the world of business intelligence:
“I’ve talked to a lot of customers about business intelligence and the one thing that they tell me is it’s really hard to use,” said Peter Klein, during at the Credit Suisse conference.
“‘I’m not getting the value out of the investment that I made,’” Klein said customers had complained. “‘I have invested a lot in my back-end systems, and today 10 percent or less of my employees actually touch it, or get access to the data. I’ve got six different BI solutions across multiple different departments, none of which talk to each other. And they’re hard to use, so I’ve got to send people to training for two weeks to learn how to use it.
Finally, we are speaking the same language. Now, I’m curious to see what they are going to do about it.
2 comments
Jock Mackinlay said:
You have to focus on people rather than technology. After all, the business intelligence is for people to do their work and make decisions.
Wouter Brandsma said:
And that statement comes from a firm who delivers Reporting Services in Visual Studio as a serious BI tool. That application was never designed for business users, but for developers. Why not integrate the query solution of Reporting Services in Excel as a replacement for MS Query and use Excel. It is a fact that the most used function in any BI tool is "export to Excel" (Microsoft acknowledge that in their BI seminars).
Add a comment
Do you have Insurgent Data?
By Ken Hilburn
December 7, 2007
Find more about:
bi
business
There are two kinds of people in this world: those who put things into two categories and those who don’t. Maybe this isn’t the best representation of the complexities of the human race, but it does give me a cheap lead-in to compare two types of problem solutions: “high tech,” focused on tools, and “high touch,” focused on interpersonal communications.
I was reminded of these two approaches by a recent interesting article in Wired that expresses an opinion about why America’s performance in Iraq has been disappointing. The basic premise of this article is that America has entered into this engagement in a “technology networked” fashion, drowning it in technology; the more, the better.
The article suggests that the US forces would make more progress if they were to spend more time on a “socially networked” approach. For instance, instead of remote controlling a drone from 100 miles away, spend more time drinking chai with local leaders. Not the absence of technology, but the incorporation of technology into a socially based environment.
“If I know where the enemy is, I can kill it. My problem is I can’t connect with the local population.” This was a quote from one division commander. Change a couple of words and you end up with a statement that many of us would find all too familiar:
“If I know where the inefficiency is, I can fix it. My problem is I can’t connect with my data.”
Aren’t we witnessing this in spades right now in the BI space? There’s no lack of number of tools and number of features in these tools. The challenge is figuring out who the real insurgents are and how you deal with them. If you’ve been reading the Juice blog for very long, you have a pretty good feeling for how we approach what we believe is a social problem (high touch) and not a technical one (high tech).
The good news is that the US forces are changing their approach to socialize more with the Iraqi people—hopefully leading to a better Iraq. Is there good news for the BI space? We’d like to hear from you on how you’re making sure you focus enough on the social “high touch” aspects of our space. What’s your insurgent data? How can you get to know it better?
2 comments
Patrick said:
One thing I do to find the insurgents is decidely low tech. Its my Ainsley filter. I have a very bright, honest 12-year-old handy (she's also a fair to middlin' mechanic). If my reports don't pass the Ainsley filter, I'm not done.
"What does 'Prj AVL' mean, dad?"
Nothing- it means nothing, so I just type out the complete words 'Projected Available'.
"If this is supposed to tell me about new products, what are these year-to-date sales things?"
They are insurgent data points. I remove them.
I realize that not everyone has access an Ainsley filter- so I encourage you to build one. She has helped me color-code things: "Why is that yellow? I thought yellow meant caution."
She's right- if I am using colors to show meaning, red/yellow/green is OK, otherwise, use different colors to separate ideas visually.
My Ainsley filter has made be a better communicator. You need someone honest, bright, and interested. The part where she spoils dad is just icing.
Simon said:
I always thought that there were three types of people in the world. Those that understand binary and those that don't ;0)
I think this problem stems from us trying too hard to please too many masters. One of the pillars of good information is relevance, the others being accuarcy and timeliness. The problem with relevance is unlike accuracy and timeliness it can vary a great deal by audience.
If you were only ever trying to communicate with a narrow audience it would be easy to cut out noise from our output.
Add a comment
Analytics Roundup: TIps for showing, sharing, communicating
By Chris Gemignani
December 6, 2007
Find more about:
Business_Intelligence
analytics
business
charts
excel
google
graphics
graphs
powerpoint
presentation
- Developer's Guide - Google Chart API - Google Code
- Beautiful stuff, particularly the Venn diagram.
- Align Journal - BI Worst Practices
- We often see articles on BI "Best Practices" here is an article telling us what NOT to do.
- flot - Google Code
- Attractive Javascript plotting for jQuery.
- ongoing · On Communication
- Interesting blog post about how different forms of communication rank for immediacy, lifespan, and audience reached.
- The Excel Magician: 70+ Excel Tips and Shortcuts to help you make Excel Magic : Codswallop
- SlideShare
- Source for presentation ideas.
Google Presentations and the Right Tool for the Job
By Zach Gemignani
September 24, 2007
Find more about:
business
powerpoint
presentations
productivity
tools
Last week, Google released Presentations to fill out their portfolio of online, collaborative document types (they already offer text documents and spreadsheets). The Google folks were kind enough to include us in a round of beta testing a few weeks back, giving us a chance to preview this application, find bugs, and offer feedback.
If you give Google Presentations a try, you may be struck by its limitations. It doesn't offer much flexibility in creating presentations, especially when compared to Microsoft PowerPoint or Apple Keynote. The best you can do is create simple text slides on a few predefined templates. On the other hand, it offers unique capabilities you don't get with desktop applications. In particular, we were impressed with how easy it was to share a presentation live online.
I have started to wonder whether calling Google Presentations a "web-based competitor to PowerPoint" or "a PowerPoint clone" was simplistic and misguided. Lumping together software tools is a natural reaction to long lists of features and techno-terminology. Software vendors don't make it any easier to distinguish the differences when they attempt to convince us that their solution is the complete, do-everything tool to satisfy all your [presentation/data analysis/communication/networking] needs.
So, we assume our software tools fall into neat buckets. We assume the tool we are using today do everything we need "well enough." And we assume any new tool is a direct competitor to what we use. As a result, we are severely limited in what we can achieve.
For a long time, I was a fan and a heavy user of PowerPoint. It did what I needed. Perhaps I told myself that what it did was all I needed. A while ago, I had to break off this exclusive relationship.
Now, I find myself using a bunch of different tools to communicate information. On the one hand, this has made my life more complicated. There are new applications to learn and the hassle of moving documents around. But in other ways, it's easier. I use tools designed for the task at hand. And I have opened up a whole new realm of what is possible in terms of organization, polish, and audience engagement.
The table below shows the activities involved in business presentations. For each activity, I have a rough assessment of how well PowerPoint, Keynote, and Google Presentation perform. I also list the current Juice toolset.

7 comments | Show all comments only the last 5 are shown
Paul Soldera said:
We've been using Google tools quite a bit recently. They really shine when you need to collaborate remotely, but after that, the functionality really is limited - especially the spreadsheet program. I haven't tried the presentation one, but must give it a go.
The real drawback for me though, is the response time. I am so used to rapid text/data entry and menu response time that I have almost no tolerance of any perceptible delay. I think this is where ajax and other RIA apps hit a wall. Which is a pity.
Dan Keldsen said:
Nice comparison, and like Paul, I've found myself using Google tools a fair amount (why not, they're free - making experimentation so much easier than "enterprise apps").
Lag-time and some inconsistencies across the "product suite" make working with these tools a bit confusing, but using Google Docs and Spreadsheets has been very handy with some remote collaboration lately.
In your comparisons, I agree with most of your commentary, with one exception...
I'm trying to like Numbers, but while it provides beautiful charts and tables for the most part, it's limitations in color schemes, and in a number of frustrating UI interactions, is giving me heartburn. It's quirky, and on my machine (2 month old MacBookPro - the LED variation), is very slow in switching between pages/tables/charts.
Even though it has been nearly 14 years since I last used Illustrator to create charts, I'm about to ready to give it a whirl again - at least the graphical presentation is sure to be solid, although it's baffling to me that all of these tools, whether coming from a spreadsheet or "art" metaphor are still so clunky after all this time.
I guess the "Tufte-ian" revolution hasn't quite intersected with the usability movement yet, eh?
Chris Gemignani said:
I agree that Numbers is a little weird. While the basic charts are pretty good, the inspector-based manipulation is hard to get used to. The good news is an update to Numbers appeared yesterday that is supposed to address performance.
Tony Rose said:
I'm not familiar with Numbers. I will say that I almost snapped my mouse in half trying to use Google Spreadsheets and dealing with the delay. Even the slightest lag between key strokes and data entry won't work for me. Call me high-maintenance... We have a long way to go before Excel is overtaken in the corporate world.
What, no Xcelsius in the "juicebox"?
GleaM said:
I just heard yesterday the name of a web-based suite called Zoho:
http://www.zoho.com/
For what I did heard and the impression that I got from it (looks very google-like), I think it beats Google suite by far.
Just to add somo other solutions...
Regards.
rolo said:
We have set up a 46" LCD to display KPIs, and use powerpoint, but obviously it has not been the best experience.
Can anyone suggest tools for digital signage in corporate offices where a reports and analysis unit has to display, every other day, kpis, tables with data, trendlines, bar charts, etc. But in a professional way and not like a simple power point?.
Thanks in advance!
Noah Iliinsky said:
Hi Zach,
I've got to agree on your choice of the Omni tools; they really are best-of-class.
I'm curious about what you mean when you say storyboarding. Typically, I'd think of frames that define phases, with some illustration and supporting text. How does that work in OmniOutliner?
Best, Noah
Add a comment
Earlier writing


0 comments | Add a comment
said: