Home > CIO Midmarket Briefings > Business intelligence strategy guide: Getting your data to talk > Execution: From the BI analyst's couch > How does transactional data lead to intelligent business intelligence?
Briefings: Business intelligence strategy guide: Getting your data to talk:
EMAIL THIS
 START   STRATEGY   EXECUTION   TOOLS AND TECHNOLOGY   
Execution: From the BI analyst's couch

<< PREVIOUS | NEXT >>: Vintage IT No More
 TIPS & NEWSLETTERS TOPICS 

THE REAL NIEL: COLUMNS FOR CIOS BY NIEL NICKOLAISEN

How does transactional data lead to intelligent business intelligence?


Niel Nickolaisen, Contributor
04.24.2008
Rating: -4.00- (out of 5)


Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us   


I admit that I got into an IT career fairly late. I was not a member of my high school's electronics club. I never subscribed to Popular Science. I never participated in any Linux forums.

And I used to think that relational databases were the foundation of computer dating.

With that caveat out of the way, it seems to me that we (now that I consider myself of member of the club) IT types have been very successful at automating transactions and gathering loads of transactional data. We spend the bulk of our time running, revising, monitoring and, in general, supporting transactional systems and the data they generate.

With all of this data available, it makes sense that someone (usually one of those pesky business users) wants us to make the data more usable. But what constitutes usable? In my opinion, data is useful if it can be turned into knowledge, and that knowledge is useful if we can use it to make better decisions. Knowledge that does not improve decision making is trivia.

Over the years I have tried different approaches for working with the business functions to pin down what it is exactly that helps people make better decisions. I have tried report libraries, self-service reporting, dashboards, consultants and mind reading. Then, one day, it occurred to me. I could unlock the door if I asked (and got answers to) two simple questions:

  • "What would you like to know?"
  • "Knowing this, what decisions can we make?"

In practice, it is not quite this simple, but these questions start a great conversation that not only provides direction to my business intelligence ...


Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us   


<< PREVIOUS | NEXT >>: Vintage IT No More
VIEW ALL IN THIS CATEGORY


RELATED CONTENT
The Real Niel: Columns for CIOs by Niel Nickolaisen
CIO: Don't attempt BPM system without mapping process flows
Application consolidation: Learning to let go of legacy systems
Virtualization's next phase: DR, BC and cloud computing
Using a gap analysis to reduce system downtime for business continuity
A CIO shares his lessons learned in project and portfolio management
A CIO explains how to make a data center outsourcing decision
How software and architecture standards drive IT business alignment
How to build a remote-site disaster recovery plan -- a CIO's advice
Virtualization project success factors from CIOs
Use cloud computing to drive IT innovation

Business intelligence (BI) for the midmarket
Microsoft focuses BI strategy on SQL Server, SharePoint, Excel
Virtualization management strategies ezine for CIOs
Pervasive BI scenarios, from search technology to the cloud
Business software guides for the midmarket: CRM, ERP, Web 2.0 and more
Information technology management e-book downloads for midmarket CIOs
How IT leaders are modernizing their business intelligence systems
Sales analytics a sweet spot for business intelligence via SaaS model
Involving users in business intelligence strategy key for success
BI SaaS: A fit for some, others not so sure
Key IT software solutions: Making smart choices in tough times

Execution: From the BI analyst's couch
Vintage IT No More
Princeton Review educates itself in business performance management
Business intelligence treats health center's woes

RELATED RESOURCES
2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems
Search Bitpipe.com for the latest white papers and business webcasts
Whatis.com, the online computer dictionary


designs, but also strengthens IT's relationship with the business.

For example, I recently helped a specialty retailer sort out what it wanted to know. This company had replaced its legacy business systems and was now swimming in transactional data. It had built an entire suite of custom reports but still did not have a better grasp on information. I customized my questions as follows:

What do you want to know about your customers? Your products? Your markets? Your operations? Your competitors? If you had really good information about your customers, products, markets, etc., how would that improve your decision making?

We started from this somewhat idealized point and defined some decisions the company would like to make. For example, as a retailer, it wanted to make more targeted marketing decisions. It wanted its print, radio, television and Internet ads to be more effective in getting customers to make buying decisions. We then worked backwards to sort through what the company needed to know in order to make such decisions (in other words, what did it want to know about its customers).

As a group, we decided that the company needed to know what triggered a buying decision. That led us to brainstorm a customer segmentation survey. After surveying several thousand customers, we identified four segments, each of which responded to a different sales pitch. Some customers bought what was new; others bought what was on sale.

With these segments in place, we then figured out ways we could capture the data that would identify these four customer types. This, in turn, back flushed, finally, into the transaction systems. What transactions did we have or did we need to identify to which segment a specific customer belonged?

We started to gather the information. The company turned the information into knowledge. This knowledge led to improved decisions about ads, store layouts, customer loyalty programs and product selection. In short, we got a more intelligent business. In parallel with that, IT looked like it was thinking beyond data. The marketing dorks and IT nerds actually found a common language and purpose.

Niel Nickolaisen is CIO and vice president of strategic planning at Headwaters Inc. in South Jordan, Utah. Write to him at nnick@headwaters.com or editor@searchcio-midmarket.com.


Rate this Tip
To rate tips, you must be a member of SearchCIO-Midmarket.com.
Register now to start rating these tips. Log in if you are already a member.




DISCLAIMER: Our Tips Exchange is a forum for you to share technical advice and expertise with your peers and to learn from other enterprise IT professionals. TechTarget provides the infrastructure to facilitate this sharing of information. However, we cannot guarantee the accuracy or validity of the material submitted. You agree that your use of the Ask The Expert services and your reliance on any questions, answers, information or other materials received through this Web site is at your own risk.



Mid-market CIO Business Solutions on Data Integrity, Unified Communications, and Virtualization
About Us  |  Contact Us  |  For Advertisers  |  For Business Partners  |  Site Index  |  RSS
SEARCH 
TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of technology-specific websites, events and online magazines.

TechTarget Corporate Web Site  |  Media Kits  |  Site Map




All Rights Reserved, Copyright 2007 - 2009, TechTarget | Read our Privacy Policy
  TechTarget - The IT Media ROI Experts