Tag Archives: Business data

[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.

Six questions to check the data utilization in your organization

1. Can you oversee your entire business performance, including outside of your view? YES/NO?

2. Can you explain the current business situations to others in an objective way? YES/NO?

3. Can you identify the root-cause of a problem(s) when happening, not just relying on what you physically see? YES/NO?

4. Can you evaluate the performance of your operations/business with appropriate indicators(KPIs)? YES/NO?

5. Can you connect the evaluation and actions in an effective and logical way? YES/NO?

6. Can you systematically respond to the changes in the markets and estimate the impact to your business, not just following your past experience? YES/NO?

The number of “YES” out of the six questions indicates your organization’s data utilization and data literacy.

What you need to consider when drilling down the data.(vol.3)

The last factor to consider when drilling down the data is “data availability“.

It seems so natural to care about its availability but it is extremely important and practical to think of it before studying what axis you apply for the drill-down.

You may be able to consider any ideal axis to break the data but you may end up with giving up the idea during the analysis. In reality you cannot obtain all the data you need, especially if you are not an analyst or do not belong to such specialized organization for analysis who can afford to procure the data from outside, you have to manage/struggle to reach required outputs only with already existing (i.e. available) data at hand.

Before you notice the fact such data does not exist at hand at the end of the analysis, you should consider whether you have the data available to apply for the axis you choose.

My suggestions at my lecture and trainings are always very practical as above. They will help you save your time and efforts when you analyze business data.

What you need to consider when drilling down the data.(vol.2)

There is always a gap between theory and reality.

A theoretically correct idea is not necessarily a right answer in reality. You may observe the same issue in the data analysis.

When you drill down or breakdown a set of data by some axis (age, area, product etc.), you may come up with lots of options of axis. Even if it is theoretically possible, I would suggest that you should make sure that the axis you select will lead to some effective action(s).

For example, if you try to categorize the sales results by the weather (sunny, rainy or cloudy), you may able to technically do it. But it would not help you determine the actions you take for sales improvement because you cannot control the weather anyway.

If you use some axis by which you drill down some data, you may consider whether the axis is actionable or not. This is extremely important from the practical viewpoints.

If you select “age” axis for your analysis, then you may reach some actionable ideas on how to improve the sales from a certain category of age( eg. 20’s).

In business, “actionable” is always a priority.

the axis.

Data analysis training for a public sector

I had a training program for one of the public sectors in Japan yesterday.

The mayor of the city has a tremendous sense of crisis on the current and future management of the city. He is eager to engage in the human skill development to improve the value and quality of the service and management.

The mayor directly asked me to support his initiative to develop the skills in the organization and it was the first step to have a basic training session.

As it was the initial session, I focused only on the very fundamental but essential topics such as:

– How to define an issue and develop hypothesis for the issue

– How to utilize basic analytical tools to describe the whole picture of the issue and identify the potential issue point(s)

I will continue my support in order for them to acquire those skills/proficiency in the organization.

I am so excited to be involved in such critical initiative and happy to contribute to the enhancement of the people.

Link to my website (in Japanese)  => http://data-story.net

Final session of “Modeling with statistics” class

It was the last session of my class today at Yokohama National University.

The final exam report was announced with the following requirements:

無題1

It was extremely wonderful experience to me and it was really fun!

My goal of this class has been how to solve real and practical issues in business, by developing a logical story with data (analysis).

I  the students enjoyed the class and will see them in the coming semester again for the class “Logical problem-solving”, in which I will talk about “Logical thinking to reach an agreement with stakeholders” !

I am so excited again. Please contact me if you need a lecture (one-day, short-term intensive or long-term) of decision science even outside of Japan.

I

From my lecture note at university #12(Modeling with statistics)

Today it was the second session for hypothetical testing.

We focused on testing a gap of two averages, which I believe is the most commonly used in practical business situations.

It was really hard to explain the concept of the statistical hypothesis testing, which is very confusing for beginners.

Concept of “Population” and “Sample” is the first one you have to understand as well as the fact that, in most cases, we are using “sample” data for data analysis.

無題

From such academic topic, we moved to a practical topic, which is the test of two average gap between two groups.

Excel (T.TEST) function helps you to minimize your calculation to reach the conclusion as long as you understand how the testing works.

無題2

For the practical use, my advice was to focus only on the determinations on “one-tailed or two-tailed distribution” and “type of the testing”, which you have to specify in the function.

無題3

Once the class understood the concept and theory, we moved to the practical exercises.

無題4

Apart from those exercises, we tested the gap of average amounts to pay for lunch between “female” and ” male” students, by using sample data of the class.

It was really fun!

Finally this is today’s take-away.

無題5

Thank you again for enjoying my class today!