The Indicee Blog

Business Intelligence class needs a makeover

by Geoff Devereux on May 25th, 2010

The title of this post is an homage to Dan Meyer, a high school math teacher and TED speaker.  He argues that the traditional methodology for teaching math is fundamentally flawed.

“I sell a product to a market that doesn’t want it, but is forced by law to buy it.” – Dan Meyer

Watching his talk, I couldn’t help but draw a parallel to the way the Business Intelligence concepts and methodologies have traditionally been presented to non-techies.  Is it just a matter of complex tools?  Or is it deeper?

“The formulation of a problem is often more essential than its solution, which may be merely a matter of mathematical or experimental skill”  – Albert Einstein

Meyer references this quote by “the man”, Albert Einstein.  Can you think of how B.I. manages the formulation of data schemas, hierarchical data models, nesting, etc?  Bust open a textbook or Wikipedia, read it, then ask yourself, how engaging would this content be to someone who:

1. Lacks initiative

2. Lack perserverance

3. Lacks retention

4. Has an aversion to word data problems

5. Eagerness for formula reporting output

Meyer highlights these factors as being emblematic of his captive audience in the classroom.  I’ve made a couple of adjustments to tweak the context to that of B.I.  If you don’t agree that these factors apply equally to the vast majority of business users of B.I., please speak up.

Advances in technology are creating the ability to put the tools into the hands of the end user.  Our technology is proof of that; however, we still have some serious work to do on the owner’s manual.

For example, How would you deconstruct the process of building a data hierarchy to facilitate creation of a Data Mart?

I’ve recently started volunteering with Junior Achievement teaching business concepts to 5th graders.  You can see the attention of my little budding capitalists wax and wane throughout the session.  They haven’t yet learned to hide their expressions so when they “check out” it’s pretty obvious. But I’m glad for it.  I know exactly when I need to inject some PT Barnum into the act.

Let’s do the same for Business Intelligence.

Here’s Dan Meyer’s suggestions for fixing math education delivery.  Let’s do the same and give Business Intelligence class a makeover.

The Fix

1. Use multimedia

2. Encourage students business users intuition

3. Ask the shortest question you can

4. Let students business users build the problem

5. Be less helpful

I encourage you to watch the whole talk (below):

Enjoy!

  • Share/Bookmark

The Roots of Business Reporting Technology

by Geoff Devereux on April 15th, 2010

Last week, I wrote a guest blog post for the accounting news website Going Concern.  The post centered on an old accounting book (circa. 1968) that I happened upon in a used book store up in British Columbia’s version of Cottage Country.

Reviewing this relic got me wondering about what technology might have accompanied the practice of accounting detailed in the book.

Ready?

Here it is guys:

And:

That’s it.

But where the principles of accounting have remained substantially unchanged over the course of the intervening years, the same cannot be said for business technology.

According to the timeline provided on www.oldcalculatormuseum.com, the development of electronic calculators really only just started to take off around 1961 (you can thank the invention of the integrated circuit - the microchip).  This was BRAND NEW technology.  Previous calculator technology had been manual.


Manual Calculator; Photo: Christos Vittoratos (via Wikimedia Commons)

By the time this book was written, there were a dozen companies creating and innovating new models and the competition to capture the new market was fierce.  Casio, Sharp, Sony, Toshiba, Texas Instruments, Canon, and of course Hewlett Packard; all of these guys were battling it out.  Numerous others are buried in technology’s graveyard.

Needless to say, things have never been the same since.

Accounting and business reporting as we know it today has grown from the roots of this technological revolution.

Business technology has continued to grow by leaps and bounds since that time, but don’t be fooled into thinking there’s no room left to branch out.  The fact you are on our website leads me to believe you’re at least willing to entertain the notion of continuing innovation in business technology.  Safe to assume?

The reason behind this little trip down Memory Lane is that everyday here at Indicee, as we innovate for the future, we can’t help but bump up against the past.  Not the ancient history I’ve outlined above,  we’re confronting the incumbent technology.  We’re confronting the stuff that is likely downloaded on your machine today.

In retrospect, it’s easy to see the value an innovation like the electronic calculator brought to the workplace.  It’s easy to look back and immediately recognize how important this innovation was for business.  Had you been there at that time, you would have jumped on it!  Would you not? You would have jumped on it and tossed your old, manual calculator in the first dumpster you could find!  Right?

Yet, this sort of reaction is rarely the case when new technologies come to market, isn’t it?  When new technologies show up isn’t there normally a great deal of fear, uncertainty, and doubt (FUD)?  Isn’t there normally a great deal of resistance to change?

What’s your view?

  • Share/Bookmark

The Importance of Stories

by Geoff Devereux on December 23rd, 2009

This time of year provides tremendous illustrations of the power and importance of stories.  From the stories that constitute our most core personal beliefs of the holiday season to those that detail running the gauntlet of inclement weather and travel delays to get “home for the holidays”, we define ourselves and others by the stories we tell.

As George Akerlof and Robert Shiller discuss in their widely acclaimed book, Animal Spirits (How Human Psychology Drives The Economy, and Why It Matters for Global Capitalism),

“The human mind is built to think in terms of narratives, of sequences of events with an internal logic and dynamic that appear as a unified whole.  In turn, much of human motivation comes from living through a story of our lives, a story we tell to ourselves and that creates a framework for motivation.  Life could be just ‘one damn thing after another’ if it weren’t for such stories…. Great leaders are first and foremost creators of stories.”

Think about the stories that define your life.  How do these stories influence your perspective?  How do they influence how you see yourself?  What are the stories that resonate most strongly in your life?  What stories do you choose to relate to other people?  There’s a growing body of knowledge, that aligns with the passage above, saying these stories are fundamental to the formation of our identities.  This is a powerful thought.

Yet, traditionally in accounting and finance, stories are an afterthought.  We are taught to focus on the numbers.  We create the balance sheet, income statement, and cash flow statement in accordance with GAAP, leaving storytelling to the sales and marketing departments.  My experience has been that it’s very difficult to generate engagement through the use of the financial reports, and in retrospect, I think it’s for this reason.

There’s a reason why people say the Notes To The Financial Statements will tell you “where the bodies are buried”.  The reason is that only in The Notes do we find stories.

From a regulatory perspective, for external reporting we’re fairly hog-tied as to what we can do.  GAAP is king.  These constraints are institutionalized and provide a structural grounding for capital markets that is required for a host of reasons.

Internal reports, on the other hand, present a tremendous opportunity to begin using stories to provide context and colour to business results.  This is the area of accounting and finance where we can really affect some change NOW by bringing life to the numbers.

In the following clip, Ira Glass (son of an accountant and award winning host of This American Life on Chicago Public Radio) describes using anecdotes to convey ideas and says,

“the power of the anecdote is so great, no matter how boring the material is, if it’s in a story form where there’s an anecdote happening,  it has a momentum in and of itself… like being on a train that has a destination”

(hat tip to Presentation Zen blog for a good post on this same clip)

Ira Glass summarizes the process of telling a story as:

1. Start with an action

2. Raise a question from the beginning (the bait)

3. Answer the question

4. Repeat

5. Moment of Reflection (the “why”)

Enjoy!

  • Share/Bookmark

Defining Business Intelligence

by Geoff Devereux on December 16th, 2009

The Historical View circa 1958

The notion of intelligence is…  “the ability to apprehend the interrelationships of presented facts in such a way as to guide action towards a desired goal.”

- Hans Peter Luhn, IBM Journal, October 1958

The above quote is generally credited with coining the term Business Intelligence (B.I.).  Luhn’s vision was ambitious for his time and it’s still ambitious today.  How much of the following article do you find relevant right NOW with respect to your business reporting challenges?

The following are direct quotes from the IBM Journal Article, “A Business Intelligence System” published 1958 with my commentary added:

Information is now being generated and utilized at an ever-increasing rate because of the accelerated pace and scope of human activities and the steady rise in the average level of education. At the same time the growth of organizations and increased specialization and divisionalization have created new barriers to the flow of information. There is also a growing need for more prompt decisions at levels of responsibility far below those customary in the past. Undoubtedly the most formidable communications problem is the sheer bulk of information that has to be dealt with. In view of the present growth trends, automation appears to offer the most efficient methods for retrieval and dissemination of this information.

With respect to the volumes of data being created in 1958, I think we can safely say, you ain’t seen nothing yet.  Keep in mind that 1958 was really the primordial soup of computing and information management.  At that time, the Integrated Circuit had just been developed which would pave the way for development of computing as we know it today.  Looking back on IT in 1958, I’m thinking it consisted of a “series of tubes”.

Luhn continues:

Ideally, an automatic system is needed which can accept information in its original form, disseminate the data promptly to the proper places and furnish information on demand.

So, in 1958, the concept of “on-demand” is also christened.  A blog I follow called, Only Dead Fish, by Neil Perkins references the Greek term, Kairos, recently when discussing the importance of context.  Kairos refers to, “the right or opportune moment” or “the supreme moment”.  I think this is the best way to think about the basic need/want underpinning the concept of on-demand.  I think this is how Luhn was thinking about it too:

One of the most crucial problems in communication is that of channeling a given item of information to those who need to know it. Present methods of accomplishing this are inadequate and the general practice is to disseminate information rather broadly to be on the safe side. Since this method tends to swamp the recipients with paper, the probability of not communicating at all becomes great.

  • Share/Bookmark

Sun Tzu’s Cash Burn

by Geoff Devereux on October 23rd, 2009

– We’ll revisit the B.I. terms from last time next Tuesday and provide definitions.  Today is a fun look at historical accounting, and for a change, I’ll make reference to Indicee.  –

The Art of War, Chapter 2: Waging War

Sun Tzu said: In general, the strategy for employing the military is this”:

Sun_Tzu_thumbIf there are 1,000 4-Horse Attack Chariots, 1,000 Leather-armoured Support Chariots,
100,000 Mailed Troops, and Provisions are transported 1,000 li, then the domestic and external campaign expenses, the expenditures for advisors and guests, materials such as glue and lacquer, and providing chariots and armour will be 1,000 pieces of gold per day.

Only then can an army of 100,000 be mobilized.” *

* Sawyer’s translation

  • Share/Bookmark
Older Posts »
RSS Twitter