Commentary From the Mile High City

"Star of the conservative blogosphere" Denver Post

"The Rocky Mountain Alliance offers the best of what the blogosphere has to offer." -David Harsanyi, Denver Post
Joshua Sharf

 notify list
to receive email when this site is updated, enter your email address:
 recent posts
24 (2 entries)
Anglosphere (1 entries)
Biking (1 entries)
Blogging (35 entries)
Business (173 entries)
CFA (3 entries)
China (5 entries)
Climate Change (3 entries)
Colorado (20 entries)
Denver (12 entries)
Design (4 entries)
Economics (39 entries)
Education (6 entries)
Electoral College (1 entries)
Environmentalism (3 entries)
Europe (0 entries)
Flying (2 entries)
Foreign Affairs (1 entries)
General (89 entries)
Gun Control (2 entries)
Health Care (7 entries)
Higher Ed (7 entries)
History (8 entries)
Home Improvement (1 entries)
Illegal Immigration (35 entries)
Internet (4 entries)
Israel (57 entries)
Jewish (49 entries)
Judicial Nominations (12 entries)
Katrina (0 entries)
Literature (1 entries)
Media (37 entries)
Music (3 entries)
Photoblogging (32 entries)
Politics (152 entries)
Porkbusters (5 entries)
Radio (16 entries)
Religion (1 entries)
Reviews (8 entries)
Robed Masters (4 entries)
Science (1 entries)
Sports (9 entries)
Taxes (2 entries)
Transportation (6 entries)
Unions (1 entries)
War on Terror (180 entries)
my other blogs
Three-Letter Monte

Rocky Mtn. Alliance
Best Destiny
Daily Blogster
Geezerville USA
Mount Virtus
Night Twister
Rocky Mountain Right
Slapstick Politics
The New Conservative
Thinking Right
View from a Height

other blogs
One Big Swede
American Thinker
Meryl Yourish
NRO Corner
Little Green Footballs
No Left Turns
A Constrained Vision

business blogs
Accidental Verbosity
Assymetrical Information
Carnival of the Capitalists
Cold Springs Shops
Commodity Trader
Coyote Blog
Different River
Everyone's Illusion
Fast Company Blog
Financial Rounds
Freakonomics Blog
Management Craft
Trader Mike
Carnival of the Capitalists Submission

business data
Inst. Supply Mgmt.
St. Louis Fed Economic Data
Nat'l Bureau of Economic Research
Economic Calendar
Stock Charts

colorado blogs
Pirate Ballerina
Pagan Capitalist
Boker Tov, Boulder
Colorado Pols
Jeff Sherman

<-?Colorado BlogRing#->

sites, not blogs
Thinking Rock Press
 help israel
Israel Travel Ministry
Friends of the IDF
Volunteers for Israel
Magen David Adom
 1939 World's Fair
1939: The Lost World of the Fair
The New York World's Fair: 1939-1940
The Last Great Fair by Jeffrey Hart
Iconography of Hope (U.Va.)
Images From the '39 Fair
Tour the 1939 New York Fair
Powered by
Movable Type 3.2

« Book Review - Learning to Read Midrash | Main | Cartoons In Basra, Iraq »

Book Review - Analyzing Business Data With Excel

One more book review. This one, not so good. As always, you can read it below, or read it here.

I can't tell you how much I wanted to like this book. I've admired O'Reilly's technical books for years, and now that I've branched out into business applications, I was delighted to see that they had, too.

When I finished business school last year, one of the classes I had to take was in financial modeling, and it had a heavy Excel emphasis. We did a little bit with Macros and VBA, but the most complex model we did was nothing compared to what this book aimed for. Finally, I was going to get a chance to really gun the program up into 6th gear. Clearly, this was a book that wouldn't talk down to me.


First, even finding the spreadsheets online was a little bit of a task. The URL was only mentioned in the preface. A more prominent location would have saved me a lot of time. In fact, the data spreadsheets should be available without the code at all, just the data (in addition to the completed applications). Most people who want to learn are going to try to work through the application from the ground up.

Secondly, having an editor do just that would have helped immensely. I started on the first application (analyzing call center call volume), and couldn't figure out how the predicted values were arrived at. They weren't spreadsheet functions, just numbers next to the raw data. This pretty much stymied me right there, although I did go on to complete the application, skipping that part. Still, in a book as dense as this one is, where every piece represents a potentially useful application, leaving that much work as an exercise to the reader is unnecessary and confusing.

A minor detail: when using a workbook like this, I find it's much harder to do so if a screenshot isn't on the same page as its description. Flipping back and forth, again, in a book where every sentence matters, really slows down the process.

Finally, perhaps because of the above-mentioned problems, I found it hard to generalize from the applications presented. They seemed just a little too specific to the data.

I don't want to be too hard on O'Reilly. It's best-known for programming tutorials, and that's essentially what this book is trying to be, so the company clearly has the in-house talent to make this work. The book frankly has a lot of potential. About twice the exposition and forcing an editor to work through all the examples would make it incredibly useful. My guess is that it's about 80% of the way there. The problem is that the 20% that's missing makes all the difference.

Post a comment

(If you haven't left a comment here before, you may need to be approved by the site owner before your comment will appear. Until then, it won't appear on the entry. Thanks for waiting.)


Power, Faith, and Fantasy

Six Days of War

An Army of Davids

Learning to Read Midrash

Size Matters

Deals From Hell

A War Like No Other


A Civil War

Supreme Command

The (Mis)Behavior of Markets

The Wisdom of Crowds

Inventing Money

When Genius Failed

Blink: The Power of Thinking Without Thinking

Back in Action : An American Soldier's Story of Courage, Faith and Fortitude

How Would You Move Mt. Fuji?

Good to Great

Built to Last

Financial Fine Print

The Day the Universe Changed


The Multiple Identities of the Middle-East

The Case for Democracy

A Better War: The Unexamined Victories and Final Tragedy of America's Last Years in Vietnam

The Italians

Zakhor: Jewish History and Jewish Memory

Beyond the Verse: Talmudic Readings and Lectures

Reading Levinas/Reading Talmud