Does this reporting strategy make sense to you?
The reporting system is a critical information resource for every company. Good reports reveal problems and opportunities that bad reports hide. Good reports give managers quick insight; bad reports waste managers' time.
It's only a slight over-statement to say that the only things that managers know about their company they learned by reading their reports.
But the help-wanted message tells us that a company is looking for a "Report Writer" who...
In fact, the only thing this company needs from their "Report Writer" is skill in using the tools that generate the report.
That's like hiring screenwriters for German movies by interviewing Americans who type fast. It's like hiring a mechanic from Rome to work as a cab driver in London.
At best, that "Report Writer" will prepare online "reports" that offer graphically intensive ways to query the corporate database. They'll be a pretty version of the many binders of printouts that we used when I was a young accountant working at Hewlett-Packard. Those reports might even summarize the entire database, presenting key numbers in several really cute, 3D, multi-color speedometer gauges.
But they WON'T deliver business INTELLIGENCE to the organization!
When those knowledge workers prepare reports, they need fewer instructions from their manager; they can ask intelligent questions; they can research related topics to answer questions the manager hadn't thought to ask; they can suggest additional sources of data that the manager didn't know was available. In short, they can use their brains to help the manager succeed.
What most Excel users don't understand is how to present their information clearly. Most Excel reports, unfortunately, offer less insight than tax tables.
That's what Excel dashboard reporting is all about. Here are two short articles that address these ideas from slightly different points of view:
Today's mail also included the following note from a customer in Russia. Although his English isn't perfect, he clearly describes the problem that most Excel users have with their reporting.
My only quibble with this note is that "beautiful" is an oversimplification. Instead, I would say that Excel reports need to be quick and easy for managers to read. Giving managers attractive reports helps to achieve that goal, but other elements are just as important. I touch on this distinction in both articles, Which Business Dashboards Are Best? and Which Offers More Business Insight?.
The Excel Dashboard Digest home page provides information about ways to improve the quality of your Excel reports. Doing so will help your company make better use of smart Excel users -- like you -- who already work there.