BI for the lone wolf

Three years ago, I spent four months in my Sicilian grandmother’s home town editing a book I had begun to hate. Time cues were sparse: church bells four times an hour, a nearby friend who dropped in for coffee once a day, and cannoli once a week. I could easily come to the end of a week without having made a single edit. So I built myself a timekeeper in FileMaker Pro.

At first, the dismal results came in every day: When I felt that I had put in a good five or six hours of steady work, the end-of-day tally—with all the breaks for email, meals, snacks, and quick walks—usually amounted to about two hours of actual work.

That’s what got me thinking. Who says one-person operations can’t use business intelligence?

I don’t want MicroStrategy to outfit my tiny office, now near San Francisco, with its latest and greatest. No, but I do want a company like Intuit, ever more interested in the one-person market, to understand that money isn’t the only data individuals should track.

Time isn’t money, it’s more important than that. Productive time is the most consistent leading indicator there is. Waste your time and you’ll have no money to track.

This is business intelligence for the lone wolf, even the herded wolf.

Sure, you can use your own FileMaker setup or any of those client-billing applications. You click this button to start a billing period and that one to end it. But that takes discipline. I don’t know about you, but I exert every ounce of mine on staying on the program. I forget to click the little button and, damn!, at what point did that consultant’s column send me into a stupor?

If there’s one thing I’d like to find under the Christmas tree, it’s an application that does personal performance analytics.

It automatically tracks and categorizes work done on the computer. Out of the office, it works on an iPhone.

It detects what time I start in the morning and what time I drift away into surfing. It knows the difference between work, goofing off or eating at my desk while I scan email.

It considers all the clues to take a guess. The little brain inside says, “Let’s see, he was clicking away at Word until 9:21…” After that point, its log shows no phone calls, no Web pages downloading, no email opened or sent. The little microphone detected less noise than usual at 9:22, so no visitors had come by. “Hmm, let’s mark it at 9:21 and see what he says.”

A more forgiving “preferences” setting might guess a few minutes later. Like a loyal assistant, it would offer its guesses for review and approval.

“Sir, I would say you had a less than productive day yesterday. Am I correct?”

“No, you fool! I was thinking!”

“How much of it was productive, sir?”

Time tracking is just the beginning. It would also let me define my own, weird key performance indicators. Did I hit my daily hurdle of contact attempts? Did I run? Did I spend enough time this week actually working?

It would scan every scrap of evidence it could get its hands on to detect patterns.

Once in a while, I issue a grand invitation to myself. Come and see the trends. Buffet served.

There, after “brief introductory remarks,” the application offers rich what-if visual analysis, Tableau-like. I see what times of day I actually produce the most words, talk the most, listen the most, field the most email. Correlate production of words and phone calls with arrival of checks. Correlate this or that individual with checks or mood.

It’s like a smart, statistics-savvy aide. The difference is that when a human aide finds you passed out from exhaustion, it brings you a glass of water. But I don’t want that. I’m a lone wolf, and I get it myself.

3 Responses to BI for the lone wolf

  1. I had similar ideas until our business started to grow. We needed a time tracking solution that the entire company could get on board with. We started using Pacific Timesheet ( last year, and it has exceeded our demands. We use it mainly for attendance and payroll time tracking, but some groups use it for light project time tracking, too. It saves us significant time to have one time tracking software for the entire organization.

    Donna Chu

  2. Joe and Donna, thanks for the links. You’re right, I’m on a Mac, but I’ll take a look at those in Parallels.

Leave a reply

Other recent posts

End of one-size-fits-all data stories

This appeared originally on the TDWI site in September behind a paywall. It’s still there, but today they’ve had the 90 days of exclusive use that I agreed to. Survey after survey reveals that about 80 percent of business users don’t use data analysis—despite all the marketing and “easy to use” tools. As if in… Continue Reading

Qlik finally set to leapfrog Tableau?

Who’s your rival? I carelessly asked a Qlik person at the company’s annual analyst reception Monday night in Miami if she hadn’t once worked for Tableau. Her revulsion was immediate. “No! Never!,” she said. We smiled. There was so much more to talk about. For one thing, how will private equity change things? Qlik wasn’t… Continue Reading

Five Tips for Better Data Stories

Originally published on September 22, 2015 in BI This Week, a TDWI publication. A “data story” sounds like such a great idea. You just mix data with storytelling and you’re done — except that most data storytellers get one thing wrong: they drown out the story with data. Such storytellers, I believe, assume that audiences… Continue Reading

Bohemian Grove a la BI

The Bohemian Grove of the BI industry convenes for the fifteenth time in just three weeks. Naturally, you ask the obvious question: Are you serious? The Grove? A summit? The answer begins with a fond recollection of the Grove. If you’ve never attended the Bohemian Grove yourself — I haven’t, though I live in the… Continue Reading