Thailand’s PDPA Law Highlights

Thailand PDPA Law was enacted in May 2019 and is going to be effective on 27 May 2020. Here are some key highlights from the EDTA workshop.

Read more

What is Business Dashboard and how we should do it?

So-called ‘Dashboards’ are heard in our analytics driven world but what exactly is dashboard and why we should do it?

Read more

Data Visualization Techniques

The easiest way to explain your data to someone else is actually to visualize it. Data Visualization could be considered as story-telling or how to tell your story to your audiences or as analysis tool to make you understand your data better.

To be able to visualize data, there is a very useful knowledge called ‘Semiology of Graphic’ which many seems to overlook and go to what chart I should use. Semiology of Graphic deals with how we can actually play with different aspects of the chart to reflex the differences in data.

Read more

Segmentation by Analytics

Segmentation is to split the market into different groups – each group with similar characteristics. Why do we do this? Because, STP or Segmentation, Targeting, Positioning will help the company select the right segment to target with right positioning. You could not sell your product or services to all people on earth.  For example, not all people will buy fruit juices, only those who concerned about health will be interested.

Read more

What are CLV and CAC?

With the raise of Data Analytics, the most common concept we have heard about from Marketing side of Data Analytics is ‘CLV’ and ‘CAC’. So, what are CLV and CAC?

Read more

brown book page

What is Data and how to derive insights and value?

Getting started with Data Analytics

Data is garage in, garage out, good data and bad data, useless data and data with value. With digitalization, data is everywhere, raw data give contexts to help derive Information. Information gives meanings to become Knowledge and Knowledge gives insights to finally become Wisdom. 

In simple words, we all probably have some data in different ways but how can we derive insights and value from Data? Before that, let’s understand the common problems of Data. 

Common problems of “Data” 

  1. Offline – Many data are in physical manual hardcopy forms
  2. Limited – Many useful and valuable data points are not collected
  3. Not integrated – Data that are available are in some files like Excel in different workstations
  4. Not usable – Data stored are also inaccurate, not logged properly or not updated
  5. Data hidden somewhere secure – Request to IT for data and reports to be generated. This often takes days or weeks and every time you need it. 

With such common data challenges, the outcome is mostly basic charts and reports that requires heavy manual work and often results that are inaccurate, incomplete and not 100% trustable.   

So, what can be done? Our 2-simple approach to get things started.

1. Set the “Data” foundation so data are available and fit for use  

  1. Convert offline data to online, in other words digitalized hardcopy forms to online whether in database, Google forms or Excel files
  2. Collect data points that are of value: Plan, design and implement data collection process that are useful
  3. Integrated and consolidate them to a database management system such as Microsoft Access or MySQL or Data Lake/Warehouse.
  4. Put in place Data Quality checks by focusing on process, monitoring, profiling and governance for Data to be trusted.
  5. Schedule and automate data pipelines, refresh and alerts so it eliminates manual request or actions and get value from data isolated sitting somewhere.  

2. Get actionable insights from trusted data

  • Operational Report – Most reports are descriptive in nature and can only tell you what has happened such as sales last week. This is also reactive and operational in nature for measuring efficiency or performance.

This is the first and important step to understanding and getting value and use from your data.

  • Advanced Reporting – As more data are available and integrated, you can explore data that are connected across multi-dimensions for analysis such as sales by locations by transaction volume and number of transactions over time.

More questions will be answered but also asked next. Reports will evolve to dashboard for exploration, benchmarking and decision-making.  

  • Actionable Insights – With multi-dimension analysis, apart from “What Happened”, you will be able to answer, “Why did it happen”. For example, why did sales drop in quarter, is it due to the products, stores, existing customers or new customers conversion. Actionable insights can now be derived, and proactive actions can be taken.

About 70% organizations are not getting value from data especially small to medium organizations and struggle with data challenges.

We believe that data can be easily unlocked and realized in today’s digitalization world.


    What is Consumer Journey & Marketing Funnel

    Not all people will purchase once they see the product, this blog explains how consumer journey through the purchase decision

    Read more

    Likert Scale : From 1-5, how much would your rate…?

    In questionnaires, it is very common to see the questionnaire asking you “From 1 to 5, how much would you rate…?” (1 is totally negative and 5 is totally positive or vice versa). 

    Read more

    Power BI Pivot & Unpivot

    ome cases, you might wonder why you couldn’t get the graph or chart you wanted from your raw data. The fact is that sometimes you might need to ‘shape’ your data before visualization. This is what PowerBI is really strong at.

    Read more