Category Archives: Data analysis for daily jobs

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

How to find business insights from simple data

My business statistics class has started at Yokohama National University.

The first exercise of the class today was making a summary of the customer inquiry data at a shopping mall.

Exercise

The students (international students from 12 countries) were required to make a brief report of the data with the following consideration:

 

(1) Which category is the most critical, Gender, Age or type of shop?

(2) At which level do you need aggregate the original data to find the insights effectively?

(3) What is the conclusion rather than calculation results?

You do NOT have to rely on any advanced statistical techniques rather you can use simple tools such as TOTAL, AVERAGE, PERCENTAGE etc.

 

This is the first step for the students who want to manage business data effectively. They were really excited about the exercise.

 

Enjoy and study hard!

A good word to show the level of data aggregation.

My business statistics class started at Yokohama National Univerisy for the international students from all over the world.
Just to explain some basics for the new students, I was struggling to show the level of aggregation of data in my class.
This is a concept that you need to learn for managing data itself before studying some statsitics.
Today I found the word “granularity”.
I guess it is not that common word even for English speakers but it really fits the concept.
YCCS

Data analysis & management class: An “extremely practical” business program at university

The new semester at Yokohama National University in Japan will begin soon.

Here is an agenda of one of my programs for the international students:

      Modeling with statistics and meta-data

 

The name of the program is a bit strange against my intention but the program is designed for the students who need to make:

(i) a story-based presentation supported by quantitative information (data, data analysis)

(ii) a survey for their business plans/presentations

stat1

 

The class is composed of three parts:

 (1) Data management basics

(2) Data analysis techniques

 (3)  Application exercises (Story-making, survey arrangement)

stat2

 

So excited to start the extremely practical business program in April for the undergraduate students from all over the world!

 

 

 

How the analytical skills are required even for IoT and BI.

IoT (Internet of Things) and BI(Business Intelligence) are recent typical buzzwords.

But many business people pay attentions to those new “epoch-making” technologies and keep investing huge amount of money to them.

In my opinion, only technologies or tools(application etc.) may not necessarily help you to resolve your business issues.

But you need a certain level of “analytical skills” to draw a meaningful result from the technology or tools.

In more specific, you need the skill to analyze the outputs which are visualized by a BI tool. A BI tool only gives you an “output” but not” conclusion”.

Likewise, those tools need an input to make an output, which the analyst needs to define.

iot

My training programs improve such analytical skills, which cannot be replaced by any kinds of machines so far. In reality, many of my clients recognized the fact that the technology is just a tool and improved their human skills to reach better performance.

 

 

 

Business logics class at Yokohama National University

The semester has just finished at Yokohama National University.

  • Business logic and team consensus
  • Problems solving

 

Good job! See you somewhere in the world!

I would be happy to give my lecture(s) of “practical” business logic making (for communication, negotiation and presentation etc.) for your company, university and many kinds of organization.

How to develop a “Logic Tree” for problem-solving

This is an exercise in my problem-solving class at Yokohama National University in Japan.

%e6%a8%aa%e5%9b%bd%ef%bc%91

Drawing a logic tree to show a whole picture of the stakeholders in the university, assuming that the diagram is used to make priority to implement an evacuation program for earthquake.

The students are learning how to breakdown the people into small pieces to show more details (such as students, professors and workers etc.).

In such exercise, they learn what is the effective category and what is the appropriate level of information to make a decision and how to avoid to miss critical information.

 

They learned to use MECE technique in the exercise as well.

Following is another exercise in the class to re-allocate the boxes and make an effective logic tree.

%e6%a8%aa%e5%9b%bd%ef%bc%92

 

And, here is an answer:

%e6%a8%aa%e5%9b%bd%ef%bc%93

The key point of this exercise was to keep the same level of the issue in the same layer and to gain the skills to summarize small pieces of information in a logical way.

 

My programs are quite unique as they are designed for the  (undergraduate) students to gain very practical business skills.

 

If you are interested in those academic but extremely practical programs, please contact me.

http://data-story.net/english/