Turning numbers and words into knowledge

Debbie Mayo-Smith


Since 2002 I’ve been talking about the importance of databases. From the outside looking in, that is.

Aside from knowing how to work with data in Excel, I have remained uneducated about where data is put to bed at night.

I guess you could say I was focused on the Goldilocks is happy to lie in the baby bear's bed of Excel, Access, static websites and few users theory.

So when I was engaged by Microsoft this week as a speaker for the SME track of their Business Intelligence Summit, you can imagine how bemused my husband was.

Steve is a chief information officer, and I would be the first to agree with him about how "untechnical"  I am. Understanding all that Big Data, SQL server, ERP technology is second nature to him.

But I have not been asked to present on this subject before.

I have been busy researching, looking to understand and find stories about when Goldilocks moves to the mid-sized bed – when better business intelligence is needed and Excel, Access (and comparable software) is no longer sufficient.

The problem is, everywhere I’ve been looking I have found the explanations are too technical. So thank goodness for Steve. His explanation was superb. Pure. Simple. Understandable.

"Why have a computer? Why use Excel? Why keep a list of customers and sales? It’s simply numbers and names. Data."

It is when you can work with the data, visualise it, query part or all of it, that it stops being data and transforms into  information and knowledge.

You can then base your business decisions on this knowledge rather than guesswork.

Here is an example. Let’s say you run a website with an online store. You can look through the data that you have accumulating with visits.

Data is that you have 1000 unique visitors and you also know their operating system. 

Information is that, based on their operating system, 61% accessed it through iOS (iPad and Iphones).

Knowledge is there are certain aspects of your shopping site that don’t render well, or at all, on these devices.

This knowledge enables you to you to make a decision to make the necessary changes. Fast!

While you can handle doing this for 1000 unique visitors in an excel spread sheet, imagine doing it for 10,000 or more.

Since most people are visually oriented, this data is best illustrated graphically, which vividly illustrates the distribution of operating systems.

This is business intelligence, and Business Intelligence software is geared towards allowing you to get to the information – and make decisions – quickly and easily.

It is not just huge companies. Business intelligence can be used by any growing business to spot trends, make decisions and manage costs using real-time data.


Debbie’s personal invitation:

If you are interested in learning how your business can better capture and use your data to improve your business results, why not consider attending the Microsoft Business Insights Summit (it’s complimentary) in Wellington on December 4 and Auckland on December 5.

Find out more now.

Debbie Mayo-Smith works with companies that want more effective staff and management

Check debbie@debbiespeaks.co.nz

Got a question about this story? Leave it in Comments & Questions below.

This article is tagged with the following keywords. Find out more about MyNBR Tags

Comments & Questions

Commenter icon key: Subscriber Verified

Post New comment or question

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.

NZ Market Snapshot


Sym Price Change
USD 0.7259 -0.0030 -0.41%
AUD 0.9155 0.0001 0.01%
EUR 0.6134 0.0021 0.34%
GBP 0.5403 0.0006 0.11%
HKD 5.6725 -0.0194 -0.34%
JPY 80.9570 -0.9770 -1.19%


Commodity Price Change Time
Gold Index 1293.3 6.130 2017-09-22T00:
Oil Brent 56.4 0.420 2017-09-22T00:
Oil Nymex 50.7 0.110 2017-09-22T00:
Silver Index 16.9 -0.034 2017-09-22T00:


Symbol Open High Last %
NZX 50 7819.4 7870.9 7814.8 0.70%
NASDAQ 6401.4 6429.5 6422.7 0.07%
DAX 12573.4 12633.1 12592.4 0.02%
DJI 22334.1 22364.3 22359.2 -0.04%
FTSE 7310.6 7312.4 7310.6 -0.13%
HKSE 27851.5 27851.5 27880.5 -1.36%
NI225 20439.4 20454.3 20296.5 0.50%
ASX 5682.1 5710.4 5682.1 0.03%