BI for Start Ups, Business Intelligence, Data Nerds, Learning New Things

3 first steps into becoming a Business Intelligence resource

BI - Books to start with
BI recommended beginners reading

Note that I did not write Data Scientist or Business Intelligence Expert. This is because this post is meant for those who plan to join the field with no former experience.

To become a Data Scientist or Business Intelligence Expert, you have to learn the basics of handling data first.

Here comes a starters list:

  1. You need to understand the basic business metrics and KPIsWhat data is currently used for.

Check basic KPIs for different branches and learn to the intended purpose of the measurements. Most data collected today is used for Descriptive analysis, i.e. looking back at what has happened. To start the journey towards BI and data expertise, you need to understand the basics of BI today. Some suggested books are in the above image – BI recommended beginners reading.

2. Next step is to understand how the data you are collecting today will be used in the future. This will give you invaluable insight into what data you need and how the solutions need to be designed to deal with future analysis needs.

Descriptive vs Predictive analysisIn any career, you need to be strategic. All businesses want to utilize their data for strategic actions and competitive advantage. A big part of this understanding how customers will or may act in the future. Based on customer behaviour today, what will they need in, say – one year, two years etc.

Descriptive vs Predictive analysis 23. Learn the basic techniques and methodologies of handling, processing and analyzing data.

Most of these are well described in Kimball’s Data Warehouse tool kit which has been invaluable for me. I still re-visit it, when a difficult problem arises and I have forgotten exactly how the syntax or logic should be. SQL and data modelling techniques are globally useful and a good base to build you data expertise on. Please refer to the above image – BI recommended beginners reading.  Additionally, there are numerous online resources so you are spoiled for choice! Just find something that works for you in the learning process and keep learning.

Feel free to make contact with questions or input! And leave comments with your own suggestions below.

Thanks! /Linda

Advertisements
BI for Start Ups, Business Intelligence, Data Nerds

Business Intelligence as a Way of Life

In my opinion, the essence of Business Intelligence (BI) is not the what but the why. You have heard that before, so it will annoy you to hear such a cliché, especially concerning as serious a matter as BI.

Bear with me, please.

Of course, BI is different for different businesses depending on the level of maturity, the market share and the revenue. Mature, well established businesses probably need BI for the complex purpose of keeping the customers they already have and where plausible, for attracting new customers. It is called Improved Sales.

New businesses need BI for the sole purpose of establishing a presence in a new, probably unknown, and probably occupied market. What we now call BI has existed in many formats from as long as time is ancient. Market Research for instance:

  • What do you want to sell? What needs selling?
  • Is there a Buyer? Is there a need? Why do you think there is a need?
  • Does what you want to sell already exist? If yes, how much of it exists? Why do you want to sell it anyway? If no, why isn’t any other clever bugger selling it?
  • Location? Have you found a perfect location? Why is it perfect?
  • How about the competition? What do you plan to do differently? Why do you want to do anything different?

You see the whys? It is a step by step progression from what to why of course, but the most actionable knowledge comes when you have the answer to the question Why.

Here is a breakdown of my theory: Say you ask for a report of the potential customers in the vicinity of your new business venture. Say that after a lot of research and consideration, you decide that your new business venture should be Selling Beautiful Handmade Wallets. You will be designing the best wallets at home and and retailing them in a small Online store in a back alley behind the online garage in the city called Online Nowhere.

  1. Number of potential customers = 1,4 customers
  2. Promising Buyers = Married Women
  3. Expected Revenue = 10,2
  4. Currency = SEK

You even get an example customer:

  1. Customer Number = SE4321 (Swedish Customer)
  2. Customer Name = Lim Pan
  3. Customer Payment method = Credit Card
  4. Customer Address = 43 Trinity Stockholm
  5. Customer Gender = Female
  6. Customer Age = 37.5
  7. Customer First Order = 12th June 2014
  8. Customer Most Recent Order = 12th June 2017
  9. Customer Average Order Amount = 557
  10. Customer Currency = SEK
  11. Customer Marital Status = Married
  12. Customer Family = Two Children

Imagine you get the above simplified report including the detailed information on a specific customer, what catches your attention? Is it the average amount, the date of birth, the gender or the payment method? The more urgent question is, Why do you want to know anything at all about a specific customer? Is it for marketing, is it for Service improvement or is it for analysis of customer behavior?

What is Service improvement for you?

I would like to suggest that the best way to utilize BI in this case is to find out:

  1. Why you entrust your life to a wallet?
  2. Why would anyone want your beautiful wallets?

Don’t get insulted, they are beautiful wallets! But, there are multitudes of ugly wallets that do the job! So, is it that your beautiful wallets function better than the ugly ones? Is it possible that your beautiful wallets are cheaper or pricier than the ugly ones? Why is that good? Is it good for you or for the intended customer?

SMART
From http://www.houseofhunt.com

Data says that the potential customer pays with a credit card. Why Credit Card?

Could the potential customer be persuaded to pay by other means?

Why is the potential wallet buyer a woman? Do women use wallets?

Data says, there are 1,4 potential customers in Nowhere. Why 1,4?

How many people live in Nowhere? Why don’t the space occupants need wallets?

Why the best wallets in the world? Why not cats and dogs? Why not hair pins?

Why retail? Why a small Online store in a back alley behind the online garage in the city called Online Nowhere? Why not a big wholesale beside Best Priced Wallets Online?

If you cannot gather enough data or enough gossip to answer most of these questions, and more, you can kindly be accused of gambling.

With BI, you do not always have to have a huge complex databases, the latest BI tool, or a team of BI experts running around their tails recreating age old KPIs to send out age old reports.

BI is a way of life.

It is the self preserving choice to not jump on any train without asking where it is going.

The cool-headed decision to not spend a dime without checking how many dimes you have left.

The safety precaution of not walking a dark alley alone.

The SMART goal that needs a background, a baseline, an investment, a commitment and a future.