Monthly Archives: April 2020

April 29, 2020

You can never create a successful data Visualization with this data

Pivot Table Friendly data

Source: (The Humanitarian Data Exchange)

This looks like a great set of data at one glance. Every detail seems to be there. But if you wish to create a data visualization project with the data, you will surely fail. 

This is because the data is not in Pivot Table friendly layout. 

What Pivot Table friendly layout has got to do with Data Visualization?

You see, Pivot Table was designed for basic data visualization. Those who were successful in creating a Pivot Table did in in less than 3 minutes. Most of them did not know that they were using Pivot Table friendly data and therefore managed to do it for some but not others. The first experience was not replicated.

Others failed not because they are bad with data. It's because the data they were using was not in Pivot Table friendly format. Therefore, they failed to create one. ‚Äč

Here's how a Pivot Table friendly layout looked like.

Pivot Table Friendly Layout

To be be able to create a successful Pivot Table or Data Visualization Project all the time, you need to know first what is a Pivot Table friendly layout before you jumped into data visualization. That's where I can be of help to you. If you wish to be successful in creating a report whether it is in Pivot Table or for Data Visualization, you need to attend our course. It is happening on 19& 20 May 2020, 9am to 5pm (SGT), online. Drop me a text for more details.

April 16, 2020

What is Sales Data?


Our estate has a chat group to buy fresh seafood. The salesperson will deliver the stuff to our estate without delivery fees. This week, there is one group buy. When she tally the orders, I saw the order was written on a piece of paper. There is nothing wrong in writing the details on a piece of paper. It is still a sales record, hence, it is still a database. The problem with this approach is that when she needs to collect money from the customers, she will need to re-organize the orders all over again, this time by customers. 

A simple spreadsheet could have captured the details nicely. And if it is a shared worksheet, customers could still amend their orders on their own up to the order closing time. If she has used Excel, she could have pivoted the data and easily summarize the data by products/customers or by customers/products/total amount and avoid duplicate work.

This is just a group buy for one estate. If she has many such cases, she would have saved tons of time sorting out the orders. And over time, she could have created a long records to identify the product preference of customers in each estate and improve her product offering to each estate. 

Without the proper tools, she has wasted time and opportunity to serve her customers better and grow her sales exponentially.

What is a sales database?

Sales database is a record of sales activities. In its simplest form, it tells business owners and sales managers how many units of each products is sold and at what price.

But knowing these 2 column of information is not sufficient to grow the business. It is important to know who the products are sold to, on which day, the size, colour, location (if you have more than one sales locations), salesman who handled the sales. By gathering these information over time, business can offer more products that meet the customers preference and increase their sales over time. For small business owners who do not wish to spend extra on a sales system, Excel is a good tool to create the sales database and level the playing field with the big boys.