Category Archives for "General"

March 30, 2020

Free Online Training on Data Visualization with Power BI


What is Data Visualization?

Data Visualization is to present your data in pictures. It makes complex data more accessible, understandable and usable. In today's context, data visualization has an added element of interactivity, where you interact with the picture for more details.

Who need Data Visualization?

People who use Data Visualization includes but not limited to business planning, sales and marketing, finance, logistics, healthcare, human resources, and politics. Contrary to normal perception, creating data visualization is not limited to experts. Anyone can create a data visualization, even with a small dataset.   

In this training, I am going to share with you can create data visualization with a small dataset to track the spread of COVID-19 in the different countries.

Who should attend this training?

This training is for these groups of people:

Business Planning Professionals - evaluate the viability of the plans proposed for the company

Marketing Professionals - evaluate the effectiveness of their marketing campaigns

Sales Professionals - identifies the top selling products in your area or your customers.

Finance Professionals - identify the profitability of the customers, goods and services.

Logistics Professionals - Tracking the supply of goods and services from multiple locations

Human Resources - tracking the recruitment and retention of good quality employees. 

Learning and Development professionals - identify the staffs who needs to be equipped with data visualization skills.

Why Covid-19 data?

We use Covid-19 data for the training because you do not have to put in extra effort to understand the numbers and it is real data which do not require any sanitization. It is also a simple set of data to use to learn about data visualization.

How is the online training conducted?

We have designed the online training by progressively introduce functions that are easy to implement and add on new functionality as we progress into the training. 

Outline of the online training

  1. Quick Orientation to Zoom
  2. How the training will be conducted?
  3. Layout of the COVID-19 data
  4. Creating the COVID-19 Data Visualization
  5. Questions and Answers
  6. What have you learnt from the training?
  7. What most trainers will not tell you about Data Visualization
  8. What is I2MAP Framekwork and why it is important.

Outcome of the training

At the end of the one hour training, you will be able to complete the data visualization shown below:

Details of the online training

Online Training on Data Visualization

Register for the FREE online training below: 

March 19, 2020

My nightmare in budgeting


I walked into the M1 (MobileOne Pte Ltd) Office. It was 8.30am. Like everyone else, it was a normal daily routine. But for us in the business planning team, our working hours did not end at 5.30pm. We started to work on the budget from 5.30pm. It was like another part-time job but without additional pay. We would work till midnight before we headed home. By the time we reached home, our families were asleep. When we left for work the next day, they were still sleeping. This routine would continue for a month, 7 days a week.

That was the time when we used the traditional way to budgeting. We would link up all the cost center templates in one file and had a master template to add up all the numbers. Knowing that the management needed to see the breakdown for major expenses, we would start to link those costs together in advance so that we did not have to work longer hours later. But there were new items they would want to see. Sometimes, what we prepared in advanced were not used because the focus would change. So we would have done some "redundant" templates and had to create new ones on the fly.

Even though I had left M1, I did not stop exploring solution to shorten this exercise which still existed today. I wanted to help those who are not stuck in this situation. I am glad that I had found a great solution for this. With the new functions in Excel called PowerQuery, PowerPivot and PowerView (Power BI), I am able to shorten the whole exercise by 90%. Instead of days to consolidate the numbers, I can single highhandedly consolidate the numbers in hours and I have no worries that the numbers would change. Everything are consolidated dynamically and updates are just a few minutes away. 

Are you still budgeting in the traditional way? Share with me your challenges in the comments. I might be able to help you.

March 18, 2020

The first simple step to master data visualization


Data visualization is the in thing now when it comes to presentation. The pictures and graphics tells a story and it is interesting to look at. Management love the graphics and the fact that they can drill down for further information. 

Most people would jump right into a data visualization course hoping to produce the same type of visualization that is shown to them. I believe majority of them experienced a steep learning curve when they attended a 3-days course on data visualization. And it is not surprising to see most of them are unable to create a data visualization when they are back in the office. That is because the data that is used in the course is perfect. When they are back in the office, their data is not perfect. 

If you are currently experiencing that, I would advise you to review the layout of your data, the first simple step to master data visualization. If you are not laying out your data in the correct manner to begin with, you can forget about the final step in data visualization that is supposed to attract bells and whistles. 


March 17, 2020

7 simple steps to master data visualization


Step 1: Layout your Data

To effectively visualize your data, you need to arrange them in the correct layout. 

Step 2: Improve data quality

Dates, Text and Numbers are treated differently when you visualize data. You can't put them into the same column. For example, price column cannot have text like FOC or NA. Dates column cannot have text like Jan. It needs to be a proper date like 1-Jan 2020.

Step 3: Master pivot Table

Pivot Table is a good tool to help you learn the basics of visualization. If you can't visualize data with Pivot Table, you can't do it with others. And most people have not master Pivot Table yet.

Step 4: Merge and Append data

Some data needs to be merged while others have to be appended. Knowing the difference between 2 will make sure that you do not corrupt the data in the process of visualization.

Step 5: Simple Dax

DAX is used to summarize data beyond the simple sum and count available in Pivot Table. Learning DAX brings you into the next level of data visualization.

Step 6: Advanced DAX

Comparing data across periods requires the use the advanced DAX formula. It will help you compute MTD, QTD, YTD with the previous periods. It can even calculate the numbers for financial year that does not start from 1 Jan.

Step 7: Visualization

Visual representations of data, making complex info easier to share and digest. Once you have master the first 6 steps, you will be able to use different tools such as Power BI, Tableau or Qlik Sense for data visualization.

March 2, 2020

3 Types of BGR you can find in Databases


The relationships in data sources are like BGR (Boy Girl Relationship). There are 3 types:

1) One boyfriend to One girlfriend

This is the easiest to manage because one record from one table is linked to another record in a second table.

2) One boyfriend to Many girlfriends OR Many boyfriends to One girlfriend

One record from one table is related to many records in a second table

3) Many boyfriends to Many girlfriends

Many records from one table are related to many records in a second table. The relationship is highly complex and should be avoid at all cost. 

February 27, 2020

3 Major Difference between Pivot Table and Power Pivot Table


1a. Pivot Table can only accept a single source of data. 

1b. Power Pivot Table can accept multiple sources of data.


2a. Pivot Table can only do simple summary such as Sum, Count, Max, Min

2b Power Pivot Table can do complex calculations

performs calculations

3a. Pivot table can only accept data from the entire source (worksheet)

3b Power Pivot Table let you pick choose the columns from source to be included in the report

pick and choose columns  from source for Power Pivot
February 26, 2020

3 core skills you will acquire in our business data training

I am conducting our most popular Excel course titled "Hidden Secrets of Data Analysis in Excel" next week on 5 & 6 March 2020. It is not a typical Excel course which just showed you how to use some popular functions and formulas in Excel.

This "Hidden Secrets" course will also impart skills on how to manage your database, a skill that is not available in most if not all Excel courses. To be able to prepare your reports, you need to have at least a basic sense of how databases worked. This will help you manage your data more efficiently, create more dynamic Pivot Table for analysis and reporting.

I will also share with you some computer skills, not those which showed you how to launch a application but at a deeper level on how you should store files and what type of files you should use. Some Dos and Don'ts that more people do not take much notice but will help you improve on your reporting. 

If you are interested to take this highly valued course, head over to our Hidden Secrets of Data Analysis in Excel course page to sign up. There is no better time to upgrade yourself and start your journey on Data Analytics than now.

February 25, 2020

3 New Ways to present a Hair Salon Sales Dropped by 50% in Excel

When it comes to creating charts in Excel, most people usually think of only one type of chart, that is, the column chart. It is the default chart in Excel. But you do not have to live with the default charts. There are changes you can make to the chart to make it better looking without you having to spend hours on it. And I am going to show you 3 of them.

1. Changing the background to a picture.

2. Changing the column count to scissors.

3. Highlighting the cause of the drop/increase in sales.  

It is better to show you how to do it in the video below than to write. Watch it and let me know if it is going to help you impress your boss with them.