Bob Pozen on Personal Productivity

Harvard Business Review printed this series of blog posts from Bob Pozen in its May issue, which focused on productivity.

He manages to touch on topics that are relevant to most every knowledge worker, including PowerPoint and business travel, but here is one of the better excerpts:

I’ve seen many executives realize what they wanted to say only after they had written a lengthy draft. That’s unfortunate. You should know where you will end up before start.

Try this: After composing an outline, write the concluding paragraph. That will tell you whether you really know where your article or memo is going.

  • Share/Save/Bookmark

No Comments

The Joy of Stats, and some less joyous stats

Hans Rosling’s The Joy of Stats is now available in its entirety on YouTube, via FlowingData:

You may recognize Rosling from his 200 Countries, 200 Years, 4 Minutes video, which has gotten a lot of press - on the Internet, at least.

This dovetails nicely with the classic How to Lie with Statistics, which I just read over Christmas. It re-sharpened my eye towards deceptive visual representations, and not a day after finishing it did I see some intellectually dishonest charts on The Heritage Foundation’s Top Ten Charts of 2010.  Their #1 is pretty egregious - see if you can guess why:

top10-percent-income-earners-60031

  • Share/Save/Bookmark

4 Comments

“BI has hit the wall”

…according to Stephen Few, in a recent keynote speech. Read more about it here.

bi-has-hit-the-wall

  • Share/Save/Bookmark

No Comments

I Am the Orson Welles of PowerPoint

From McSweeney’s Internet Tendency:

I believe that sometimes a PowerPoint demands five consecutive pages of full bleed abstract images. Just to make people feel. To get mid-level managers to loosen their ties and take off their name card necklaces. Too much logic is the death knell of any PowerPoint pursuit.

  • Share/Save/Bookmark

No Comments

Two excellent posts about *just* data versus actual analysis

I’ve had these bookmarked for a while and periodically revisit them. They are worth checking out.

Juice Analytics: Filling the gap between reporting and Reporting
Avinash Kaushik: Consultants, Analysts: Present Impactful Analysis, Insightful Reports

  • Share/Save/Bookmark

No Comments

Commenting out an entire Load or Select statement

Rather than using double slashes (//) on all lines of a Load or Select statement or opening and closing comments (/* */) before and after, typing rem comments the script until it reaches a semicolon.

For instance:

SalesFact:
LOAD Date,
    CustID,
    Amount,
    Quantity
FROM Sales.qvd (qvd);

…becomes…

rem SalesFact:
LOAD Date,
    CustID,
    Amount,
    Quantity
FROM Sales.qvd (qvd);
  • Share/Save/Bookmark

No Comments

03/31/10: SAP achieves awareness.

04/01/10: The end of life as we know it.

(Cue Terminator theme.)

sap-site

This was the page that loaded when I logged into the SAP BusinessObjects Innovation Center (formerly BusinessObjects Labs) today.

  • Share/Save/Bookmark

No Comments

Axis Group is hiring experienced QlikView consultants

QlikView Consultant (Berkeley Heights, NJ/Atlanta, GA)

We are also hiring for entry-level positions and summer internships, so please pass this along to bright, young people you know who are pursuing IT-related degrees and might have an interest in Business Intelligence and Data Warehousing.

We are hiring for other positions, as well, related to different verticals and software partners. Here is the full list.

Again, please pass this along to anybody who you think may be interested, and feel free to contact me with any questions. Thanks.

  • Share/Save/Bookmark

1 Comment

Edward Tufte on NPR’s On The Media

Minister of Information (follow link to embed of audio)

Edward Tufte is perhaps the country’s foremost evangelist for the clean, clear and rich presentation of complex information. The Obama administration’s stimulus package is flooding the economy with 787 billion dollars for employment and public works projects. Put the two together, as Obama did earlier this month when he nominated Tufte for the stimulus advisory board with the hopes that the public will have a fighting chance of understanding where the stimulus money went and what it’s doing.

  • Share/Save/Bookmark

No Comments

Bar charts vs. line charts

It may be difficult to attribute the following points to a specific source, but here are all of the guidelines I can remember off the top of my head about bar charts vs. line charts, mostly learned from Edward Tufte and Stephen Few. It’s a bit of an art, and how you represent your data depends on what exactly you are intending to find in it, so it’s difficult to write finite rules that dictate what to do. If you want to learn more, check out their books on our Reading page.

line

Line

  • When to use them: Line charts should be used only for time series (chronological) or when there is some other sequence to the dimensions on the x-axis, e.g. dates, months, sequence of stages of a project, sequence of meters along on a gas pipeline, and they should be used to detect trends and patterns, not to give people exact quantitative readings.
  • Scale: As line charts are not really intended to give people exact numbers, forcing zero scaling is not necessary and can make it considerably more difficult to detect said trends and patterns.

bar

Bar

  • When to use them: Bar charts should be used for comparing specific x-axis values, though they can certainly be used for time series, like line charts. They can also be used to display parts of a whole in favor of pie charts, in which case, the space between the bars should be reduced.
  • Orientation: Do not use vertical or diagonal text to label the axis of a bar chart. If the x-axis has longer text descriptions, use horizontal bar chart, so the text can read left-to-right, horizontally (the way we normally read).
  • Scale: As the area of bars implies volume, it can be deceptive to use dynamic scaling with bar charts (see: Lie Factor). If the differences between the data points is difficult to distinguish with forced-zero scaling, use symbols/points in favor of bars and use dynamic scaling.

Applies to both

  • Dimension order: There should be some logical order to the dimensions on the x-axis. In the case of a line chart, it should follow the chronological, process, or stage order that caused you to select a line chart in the first place. In the case of bar charts, the order should have some rhyme and reason to it: sorted by y-axis value, alphabetical, etc., depending on the content of the chart and what its intended use is, e.g. ranking, distribution.
  • Scale labels: If the numbers are already being displayed on the data points, it is redundant to label the axis with numbers, too.
  • Axis labels: If you can incorporate the metric names and dimension names into the chart title or legend, do not waste space on axis labels.
  • Share/Save/Bookmark

1 Comment