Tag Archives: 柏木吉基

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

Piano cover: Your mother should know (The Beatles)

Covered another great the Beatles’ song, which is not necessarily one of the well-known songs though.

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!

 

 

 

Piano cover: I will (The Beatles)

Another piano cover from the Beatles’s song, “I will” (in the white album).
This song is not that popular as other famous Beatles’ songs but the melody is extremely amazing.

Final exams at Yokohama National University

I have announced two final exams of the classes I have at Yokohama National University.

  • Business Logics and Team Consensus

final-presentation-announcement-biz-logic

・Business Problem Solving Logics and Frameworkfinal-presentation-announcement-problem-solving

Every student is assigned to a team and they still have two weeks to prepare for the final team-presentation.

I am looking forward to their excellent outputs.