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.
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.
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.
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.
Posted in Data analysis for daily jobs, Uncategorized
Tagged Analysis, データ＆ストーリー, Business, Data, Excel, Lecturer, professor, training, website, 柏木吉基
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).
Please send an email for any inquiries.
You may also check the validity of your logic with the chart above.
This is NOT written in an academic text book but quite practical in any kinds of business situations.
When you develop your logic or storyline, you define a final message/conclusion. You may need to think about who are the stakeholders and what are thier interests. You may consider all aspects of those stakeholders and define the objective.
Based on the definition, you need to find reasonable and effective factors to support the conclusion. Do not forget MECE concept but do not simply and mechanically develop the factors. This is very critical in terms of its credibility and pursuasiveness. It all depends on what axis you choose and/or framework you apply.
Needless to say, each factor should be general, objective and fact-based. Your personal experience might work in some cases but it is weak to convince others in many cases. Try to find objective reasons and collect new information and insight if you do not have any.
Finally, you have to make sure all the factos are connected in a logical manner. To do this, you may rely on some techniques such as deductive/inductive methods. You may find “hidden” assumptions when you try to apply deductive method. In such case you may change your story or strategy after you find yourself having a biased assumption.
Those are fundamental points to make your story convinsing and logical, which I talk about in my university classes Continue reading
New video has been updated to learn how to utilize data in your daily work.
Enjoy an interesting case with a very basic data analysis skill.
Please contact me if you are interested in my training programs.
Today we continued some more exercise of deductive and inductive reasoning.
Some questions from GMAT test worked very well so that the students get familiar with the concepts of the two reasoning methods.
It is rather important and effective especially for beginners to start to learn the basic forms of logic development by finding common pitfalls in the questions.
Finally, the class was split into 6 groups again and requested to summarize one common conclusion from a conversation between two people regarding digital camera markets. It was a practice to develop a logic at an individual level and at the same time, to facilitate the group discussion to reach a consensus.
This is an individual assignment to be submitted by the end of May.
Posted in Data analysis for daily jobs
Tagged Analysis, データ＆ストーリー, Business, critical thinking, Education, 英語, 課題解決, lecture, Logical thinking, statistics, training, university, Yoshiki Kashiwagi, 柏木吉基, 横浜国立大学