The Indicee Blog

RELEVANCE

by Geoff Devereux on November 25th, 2009

You produce operations reports every month and email them as required to your management group.

What percentage of managers actually read them?

Prove it.

The Email Marketing industry has developed sophisticated tools for measuring the success of email campaigns.  You can see who opens the email, who downloads the attachment and when they do it.  (BTW, only about one in about 12,500,000 junk mails results in a sale – 0.000008% response rate)

Have you ever considered using this technology for monitoring the performance of your reports?  What might it reveal about the usage patterns of the end users?

What sort of benefit could this information have when it’s time for the meeting to discuss the numbers?  Maybe Mr.Grumpys’ tirade would be cut short if it was known he hadn’t even read the reports.

There’s more at stake than just compliance and fear-based coercion though.  It’s about understanding what’s important so that the information being provided has meaning.  If no one is opening your reports, maybe they don’t find them useful.  Maybe that’s the real issue.

Of course, reading a report isn’t the end of the story.  It’s the beginning, the foundation.  Reports provide a focal point for management meetings.  The content and presentation of the report will influence the discussion so you want to be aware of the direction your reports send the discussion.

If your reports point to trivial matters beyond anyone’s control, they will spend time hand-wringing about trivial matters beyond anyone’s control.  If your reports point to the drivers of the business, the time is likely going to be more well-spent.

I am convinced that it’s a good idea to gather metrics on report usage.  If a manager only takes a passing glance at the numbers every three months, it’s worth asking the question, “why”?  There’s plenty of intelligence that can be gained by looking at the usage patterns; lots of possibilities to think about.  Maybe by the time the reports are available, they are already out of date.

Now what if you could measure the entire usage cycle of your reports.  In Saas applications like Salesforce.com, like ours, each user leaves a history.  Perhaps the unintended consequence of software-as-a-service, or cloud computing as it’s sometimes called, is that every second of every page view is collected and available for analysis.

Here’s an opportunity to find out exactly how your reports are being consumed.  Use this knowledge to ask specific questions of the users gaining insight as to what they believe is RELEVANT.  You’ll know it’s relevant when everyone agrees the process is worth the time and effort.

Much better than just sending an email out into the darkness, vanishing like a cry into the night, never to be seen or heard from again.

So that this:

“Hey Bob, did you get my email?”

becomes this:

“Hey Bob, I noticed that you only ever view the Revenue per Employee Report.  What is it about that report that makes it so meaningful?  What is it about that inter-relationship that provides a basis for your decision making?”

I encourage taking the academic view on this process; using it to learn, collaborate, and grow.  Rather than the disciplinary view; using it to browbeat and punish.  But hey, I can’t tell you how to live.

Enjoy.

  • Share/Bookmark

Asset or Expense: How do you account for Data Quality?

by Geoff Devereux on November 18th, 2009

Similar to my initial thoughts on my Spreadsheet Nation post, I jumped into this topic of Data Quality without really testing the waters.  In this case, I thought I could just jump in, rhyme off some platitudes about Garbage In, Garbage Out (GIGO), and go on my merry way.  Instead, what opened up to me was a vast sea and I was a fish out of water.  I was standing on shore clueless about what lay beneath the surface.

Malaspina Strait, British Columbia, Canada

Malaspina Strait, British Columbia, Canada

Data Quality really is one of those topics that tends to lurk under the surface – elusive to capture.  We are talking about “the state of completeness, validity, consistency, timeliness, and accuracy that makes data appropriate for a specific use” (definition courtesy of the Government of British Columbia).  Or if you prefer, there’s the Dragnet definition: “Just the facts”.  For accountants, we are talking about all that stuff we enter into our systems (or gets generated by other systems) that we need to access later for producing reports and analysis.  The Data Quality refers to how effectively we can gain access to and generate meaning from these volumes.

A great deal of energy tends to go into our design of ways for inputting data.  How much thought has gone into the processes designed for getting the data back out?

According to IDC, a leading technology research firm, very few companies have systems in place to make use of their data, and [they] often struggle to classify data in order to find it again.  There’s a great quote on the V3 blog from Benjamin Woo at IDC:

“The key is to take the data and make money from it”

I think that this frames the issue in language we can understand.  We incur costs for gathering, processing, and storing data.  We may even incur further costs cleansing, reworking, and managing the stores of data.  What does the data do for us?  Are we developing an asset that creates future value?  Or, are we plugging an expense?

  • Share/Bookmark

Wrapping Sage Summit in Atlanta

by Craig Todd on November 13th, 2009

Faster reporting for frustrated spreadsheet users. That was the message on the wall of our booth at Sage Summit in Atlanta this week. People would stop, stare and then tell us just exactly how frustrated they were. One woman proudly waved her arm in the air, practically jumping up and down and hollering, “That’s me! That’s me!”

demoatboothThe story was the same, time and again, regardless of location, job function or technology involved: people everywhere are wasting hours, days, weeks and even months cutting and pasting information from their applications into spreadsheets in order to analyze their businesses. Why are they doing this? Because they don’t have any other solution that is easy to use and cost effective to implement.

  • The woman waving her arm in the air runs Sales Operations. Their accounting system is not integrated to their text-file-spouting, antiquated MRP system and their forecasting application is home-grown. The result is that they manually move data around into Access databases and worst of all, cut and paste into a 64MB spreadsheet that cannot be shared with the people who need it because of its size. She has already calculated the time spent on manually mashing this data is over 50 person-days per year!
  • Manufacturer of RV’s who sells through a dealer network.  They have over 10 years of sales transactions by dealers and VIN number stored in Excel files and a separate application that tracks warranty information.  They recently implemented MAS so now they need to create reports from 3 separate systems and want to give their dealers access to reports.
  • One IT Manager receives a daily stream of EDI information from distributors about sales. This information is processed as CSV and then imported into custom tables in their accounting system. On top of this, he has written over 120 Crystal Reports files that are scheduled and emailed to support requests for information from their 50+ sales reps in the field. The reps are compensated both on their sales and sales from the distributors. He cannot get enough reports built fast enough to satisfy their requirements, as the information requests change almost daily.
  • A women from a Legal aid society said they receive hundreds of invoices every day from legal aid lawyers.  To figure out how to best spend a limited legal aid budget, she and her boss are spending hours each week
    READ MORE…

  • Share/Bookmark

Living life in the belly of the beast

by Craig Todd on November 11th, 2009
Living life in the belly of the beast
This is my 10th year of attending Sage conferences and I’ve yet to be disappointed in the content, the venue and the people involved.On occasion, they can even arrange for the excitement of a tropical storm to pass our way and lend a little credibility to the overall agenda.
Last night, we were treated to a visit to the Georgia Aquarium, the world’s largest and most engaging aquarium, accoridng to their website. What interested me most were the promises of the presence of the only whale sharks in captivity outside of Asia and the only 2 Manta rays in captivity. I was not disappointed.
The evening started in “the belly of the beast”, the Atlanta Marriot Marquis hotel. Certinaly no “beast” in the traditional sense, but a feeling of being Jonah inside the whale when one considers the interior architecture of the building and its surreal, ribcage-like appearance. I wonder if architect John Portman was perhaps a fan of HR Giger’s alien imaginings when he created the building.
From there, we were treated to the driving rains and howling winds of Tropical Storm Ida, recently blown in off the coast from her brief reign as Hurricane Ida. The 10 foot walk from cover to the bus drenched us to the bone, as though tossed through the blowhole of the whale.
Entering the Georgia Aquarium is like being transported fathoms beneath the waves. The massive glass viewing window dwarfs us landlubbers and we are awestruck by the sheer beauty of the underwater realm we are so privileged to witness. Sea creatures of all shapes and sizes drift by, apparently in slow motion, unaware of or unimpressed by our presence. In short course, out of the darkness appears the massive shape of a whale shark, flying towards the glass. A giant Manta ray appears beneath, flying low to the ground, massive mouth agape and moving softly back into the shadows.
Every turn of a corner in the aquarium held new treasures and experiences, more fantastic food and drink and great memories to be made. It seemed fitting somehow to end the evening in the company of pirates, considering we had survived a visit to the depths of Davy Jones’ Locker and returned unscathed.
So what does this have to do with reporting and analysis? Nothing. I suppose I could have made some bizarre leap to try to imagine someone at Sage using a spreadsheet to calculate attendance and food and and … never mind. That would have been a little gratuitous and frankly, we simply had a great time.

Marriot Marquis from 470 feet up!This is my 10th year of attending Sage conferences and I’ve yet to be disappointed in the content, the venue and the people involved. On occasion, they can even arrange for the excitement of a tropical storm to pass our way and lend a little credibility to the overall agenda.

Last night, we were treated to a visit to the Georgia Aquarium, the world’s largest and most engaging aquarium, according to their website. What interested me most were the promises of the presence of the only whale sharks in captivity outside of Asia and the only 2 Manta rays in captivity. I was not disappointed.

The evening started in “the belly of the beast”, the Atlanta Marriott Marquis hotel. Certainly no “beast” in the traditional sense, but a feeling of being Jonah inside the whale when one considers the interior architecture of the building and its surreal, ribcage-like appearance. I wonder if architect John Portman was perhaps a fan of HR Giger’s alien imaginings when he created the building.

From there, we were treated to the driving rains and howling winds of Tropical Storm Ida, recently blown in off the coast from her brief reign as Hurricane Ida. The 10 foot walk from cover to the bus drenched us to the bone, as though tossed through the blowhole of the whale.

Largest glass viewing wall in the worldEntering the Georgia Aquarium is like being transported fathoms beneath the waves. The massive glass viewing window dwarfs us landlubbers and we are awestruck by the sheer beauty of the underwater realm we are so privileged to witness. Sea creatures of all shapes and sizes drift by, apparently in slow motion, unaware of or unimpressed by our presence. In short course, out of the darkness appears the massive shape of a whale shark, flying towards the glass. A giant Manta ray appears beneath, flying low to the ground, massive mouth agape and moving softly back into the shadows.

Pirates!Every turn of a corner in the aquarium held new treasures and experiences, more fantastic food and drink and great memories to be made. It seemed fitting somehow to end the evening in the company of pirates, considering we had survived a visit to the depths of Davy Jones’ Locker and returned unscathed.

So what does this have to do with reporting and analysis? Nothing. I suppose I could have made some bizarre leap to try to imagine someone at Sage using a spreadsheet to calculate attendance and food and and … never mind. That would have been a little gratuitous and frankly, we simply had a great time.

  • Share/Bookmark

Bringing Design Thinking to Accounting and Finance

by Geoff Devereux on

Design thinking is a process for practical, creative resolution of problems or issues that looks for an improved future result. It is the essential ability to combine empathy, creativity and rationality to meet user needs and drive business success.

(There are number of definitions out there, but I think the above serves the purpose)

There’s a lot of Buzz around the concept of Design Thinking at the moment.  A great deal of content has been produced, but I’m not sure how much has been directed toward the accounting and finance community.  During the past 2 years for us, listening to someone talk about “radical innovation” usually entailed mostly hand-wringing and, well, … expletives.  It’s understandable to have missed some of this.

So, I’m not sure how much about the topic has filtered in.  Maybe that’s a good discussion point for the comments:

  • How much of the Design Thinking paradigm has filtered into the accounting and finance community?
  • How applicable is this school of thought to accounting and finance?
  • Do you believe there is a place for Design Thinking in accounting?

I’m interested in “jumping in” because I think there’s a natural connection between the way of thinking that underlies Design Thinking and the way of thinking underlying big parts of accounting.

  • Share/Bookmark
Older Posts »
RSS Twitter