[Business data visualization exercise at YNU]

This was an exercise at my biz data analysis class in Yokohama National University for the international students.

The topic of the class was “Data visualization/illustration”. After learning some basic types of graph such as bar chart, line chart, pie chart, Histogram, scatter diagram etc., they tackled the following question:

Data1
Assuming that you are required to effectively illustrate the sales results data and report your conclusion to the boss.
Data is quite simple but not easy to find an effective way to summarize the data.

 

(1) Determine your final key message to report to boss

(2) Study the best way to summarize the data to fit the message.

 

In my class, the students discuss thier own outputs on how they can improve it.

Some examples are:

Data4

You can compare the results by product to identify the best selling product and where is the hot area.

 

Data3

This is an “area-wise” view with product-wise breakdown. You can identify strategic potential area and which product may fit the market.

 

Data2

This simply shows the ratio by product type. No detail about the area but it delivers which products are selling more in a very simple way.

 

What is the answer?  No single “right answer” here. It all depends on your final message.

 

This is a good exercise to have practical “data managing” skills which will enhance your business competitiveness.

 

Would you like to try the lesson? Please contact me.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s