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:
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:
You can compare the results by product to identify the best selling product and where is the hot area.
This is an “area-wise” view with product-wise breakdown. You can identify strategic potential area and which product may fit the market.
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.