Tag Archives: Analysis

Final exam of “business data analysis” class at Yokohama National University

This is an assignment of another class “Business data analysis” at Yokohama National University.

Students are required to develop their own story, supported with the analyzed data.


This is the key skill-set when you apply those analytical techniques to the practical business issues/proposals.

We have already experienced several similar exercises at the class and I am so excited that they will enjoy it and present interesting insights.


Good luck!


Please send me an email if you / your organization would like to try those lessons/lectures.


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



The class is composed of three parts:

 (1) Data management basics

(2) Data analysis techniques

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



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




Launched “Data&Story” website in English

The new website in English has just been opened for English-speaking customers.

As I have some classes in English at Yokohama National University, I am always welcome clients who want “business data analysis(Excel-based)”, ” problem-solving” programs taken place in English.

You can try those programs either in Japan or any other countries.



My programs are all practical based on my 20 year experience at Hitachi and Nissan.

My clients are large organization which have issues to develop basic business skills in new business development, marketing, sales, administration etc.

While they have huge data and systems, they really do not have human skills to manage those technologies/data. My programs will help you have practical skills to make the most of your business assets.

The human skills will change your organization to be even more competitive with data analysis and logical problem-solving skills.

For more detail, please visit the site and please feel free to ask any questions if any.



Business skill training programs updated!

My programs have been updated as below:

All programs are delivered both in Japanese and English.

Professional business trainer, Yoshiki Kashiwagi, who has 20 years of experience at Hitachi and Nissan Motor Ltd., leads all programs.


The unique values our programs emphasize

 These values help your organization develop competitive “problem-solving” skills with logical and analytical techniques.

 (VALUE 1) Practicality first: Unlike other programs that consultants or academic lecturers with no business experience lead, ours has the goal of providing you with skill sets that you can apply TOMORROW!

(VALUE 2) Workshop-based (active learning): During the course, you will undertake 5-10 exercises that will meet your practical needs at your daily jobs.

(VALUE 3) Informed by professional experience: The course trainer has experience in several areas; he is a business book writer, a business school professor, and a professional trainer with experience working at large companies (Hitachi and Nissan).

Program lineup 2016-6

Program lineup 2016-7

Please send an email for any inquiries.

A mini case for Business profit simulation class at Yokohama National University

In the program for international students at Yokohama National University, the students study some basic business skills.

Each student is required to present their own business plan at the end of the 3rd year.

In general students tend to jump to their subjective ideas without any objective justifications.

But not only an innovative idea but also logical / analytical thinking and presentation skills are required for making a valid business plan.


As one of the classes to acquire those skills I started a new class where the students learn how to financially justify their plan with a basic profit simulation with Excel.

They put their own assumptions in the simulation and are required to make sure that the accumulated profit will be positive at the end of the designated period, which each assumptions keep feasible.

This is a good exercise for the students to learn some basic business accounting and make a solid business proposal.


Today, we develop a new business simulation for the following case:

Mini case1

This was a very simple case, thus the students were required to complete the plan within an hour and they did it!

Mini case2

Mini case3

I was so happy that all the students made their own business story and mad assumptions for the story within the limited time.


I would be happy to deliver the program at your company or organizations/universities (business schools).


The class is all based on my business experience at the global company, Nissan.



How to make an “effective” graph

A new class “Modeling with statistics” started for undergraduate students at Yokohama National University.

In the class, I talk about practical data analysis skills for business. It is not just an academic statistics but how you find/create insights from data and apply them to practical solutions.

The main message of the class is “Goal-oriented” approach, where the thinking process is quite important. Many business persons/students tend to start to process data once received, but such approach would not show anything useful for the ultimate goal.  In any case, you need to start with goal setting/definition and identify what data to collect and how to show/analyze the data in order to achieve the goal.

Main topic of this week was data aggregation/breakdown to effectively achieve the goal.

You need to think of the appropriate level of aggregation of data which many people tend to use the raw data without thinking about the level of aggregation.



One of the exercise in the class this week was as follows:


Students need to think of the most effective way to illustrate their messages by aggregating or breaking down the data. Also they are required to find the most effective graph to show the conclusion.

I gave them advice that “Outputs” are NOT necessarily your final “Message/conclusion”. You need to put the final conclusion, not just showing the graphs or tables.


As an output example, if you want to show the yearly trend by Product, then you may aggregate the regional data into the total by year and make a graph as follows:


As another example, if you want to show the sales ratio by region or by-product so that you can discuss the future potential market(s) or identify the area to focus, then you may illustrate the message as follows:

In this case, you can aggregate yearly data into the average to simplify the message.


Final example is as follows:

If you want to identify the potential market(s), then you may distinguish the trends across the markets. In this case, I would put more business focus on the Asian market rather than America.


This was a simple exercise, but the students struggled to define their goals(what to show) , to find an effective way to show the outputs and to summarize the conclusion briefly.

I believe this is a good exercise for them to learn how to utilize the data to create value in business operations. It must be a good skill for students to learn before going to the “real” business world!




【 Final presentation at Yokohama national university 】

My students are preparing team presentations at my logical problem solving class.

Each student is required to make a group and make a team conclusion of the following topic:

XXXX is the most critical factor for new graduates to get a job.


You are also required to show how you choose XXXX as your first priority. Showing some criteria to make the priority was suggested.


During the team discussion, they are expected to experience and learn:

1) how to apply the problem-solving and/or logical thinking techniques learned in the class.

2) how to manage the diverse team members to reach a conclusion in a limited time, including (logical) facilitation skills


This is a virtual but extremely PRACTICAL experience for student to solve an issue whitinthe global business environment.


I am excited to train those global students.

I am happy to consider any possobility to provide my PRACTICAL programs to your organization even outside of Japan. My programs are all developed by myself based on my business transformation experience in a large global organization, Nissan Motor Company. You will be able to learn how to logiclly and quantitatively solve an issue and develop your conclusions.

Please contact me if you need more information!