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.
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.
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!
I will conduct four classes at Yokohama National University this year.
All the classes are designed for the international undergraduate students who study business.The classes are all about “Decision science”.
I arranged the programs,which I developed for business persons, for undergraduate students .
All programs are not academic but extremely practical as they are all coming from my professional experience in Nissan Motor Co.. for 11 years.
You can find the syllabus for each program as follows. Please let me know if you are interested in those programs!
(1) Business Management with Accounting and Finance
(2) Business Logics and Team Consensus
(3)Business Problem solving Logics and Framework
(4)Modeling with statistics
Posted in Uncategorized
Tagged Bigdata, Business, Business skill, Business statistics, Excel, international, Logical thinking, student, syllabus, university, 柏木吉基
I have just updated “5 useful tips #4” on how you can draw useful insights from your data in the business settings.
This time, I introduce “A pair concept” to develop a two-axis chart, where you do not need any technical knowledge about statistics and data analysis.
You will find the fact that you can apply “data” insights for your daily business only when you know how to connect your issue and data….
No other business/data trainer can deliver this kind of programs since they do not have work-experience in an organization, where a practical approach is required rather than academic approach.
Please let me know if you are intereted in my programs.
Posted in Data analysis for daily jobs, Uncategorized
Tagged Analysis, データ＆ストーリー, Bigdata, Business, Data, insight, science, statistics, tips, Trainer, 柏木吉基
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.
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.
Posted in Data analysis for daily jobs
Tagged Analysing, Analysis, データ＆ストーリー, データ分析, Bigdata, Business, Business data, Business statistics, corporate, Data, Kashiwagi, Lecturer, literacy, organization, questions, Teacher, Trainer, training, Utilization, Yoshiki, 柏木吉基
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.
Posted in Data analysis for daily jobs
Tagged Analysis, データ＆ストーリー, データ分析, Bigdata, busines school, Business, Business data, Business skill, Business statistics, course, Data, data analysis, Data analyst, Decision making, Kashiwagi, lecture, management, practical, professor, program, training, university, Yoshiki, 柏木吉基