I’m Chua Chua:
I am currently engaged in the retail industry, and my work often involves statement analysis, such as purchase, sales and inventory analysis, product structure analysis, smooth and unsalable analysis, and performance analysis.
Data analyst is a job, but after working for such a long time, I am increasingly aware that data analysis is a universal ability in the workplace, which is needed by all industries, such as how to make corresponding statements from data, how to analyze problems from data and make corresponding decisions.
After working for many years, I co-wrote the chapter on “Retail Industry” in the best-selling book “Data Analytical Thinking”. Here’s how I got the job.
1. How to prepare?
Learn the basic knowledge of Excel and related functions, such as VLOOKUP, SUMIF, SUMIFS, COUNTIFS, INDEX, LEFT, RIGHT, etc. Also learn the data analysis functions of Excel, that is, pivottables, pivotcharts, etc.
Learn the business knowledge of the target industry. To understand the business model of the industry, understand the business process, and the meaning of relevant indicators.
Learn to communicate. This communication includes communication within the department, with agents, dealers, store personnel, manufacturers, and suppliers of fabrics and accessories.
Analyze. Ability to analyze level by level in a pile of data using relevant commodity knowledge and indicators. For example, analysis of indicators to achieve the situation, analysis of year-on-year and sequential, inventory structure and so on.
2. How do I submit my resume?
Resume submission is also generally online, basically Posting your resume to several major online recruitment platforms and updating it regularly.
You can first search for the company you want to go to and aspire to, see where they basically publish recruitment information on several platforms, and then targeted in the corresponding recruitment platform to deliver the resume.
Of course, in order to improve the reading rate of your resume, so that more people know your resume, you can also choose online recruitment platform related payment items, such as resume 30 days at the top.
In addition to sending resumes, there is also a way to do, that is through the introduction of acquaintances. For example, if your former manager or a relative or friend is also looking for a related position, and you are a good match for the position, you can apply through acquaintance introduction, acquaintance introduction can also greatly improve the interview pass rate.
Interview experience
The most impressive interview was for a brand of women’s shoes. At that time, HR first made an interview and then directly gave an examination paper.
The questions written on the paper are related to commodities: how to calculate the completion rate of indicators, how to calculate the ratio of stock to sales, how to calculate the gross margin.
After the examination papers are finished, the merchandise manager will interview you. After the interview, the product manager will directly inspect the computer operation, and they will provide you with an Excel table, so that you can operate Excel related functions and pivottables on site.
After the first time, to the branch manager of the second interview, and then by the headquarters HR telephone interview.
This is an interview that impressed me deeply, and I have been in contact with several similar questions that were directly answered in the test paper. The main questions were related knowledge of commodities, skills needed to be used in the work, and relevant working experience, so there was no problem in the basic interview.
4. What is your daily job now?
Commodity work in the retail industry mainly focuses on commodities, such as the order of the whole market, how many SKUs to order, the depth and breadth of SKUS, and what price to set.
Of commodity put on the shelf, cent appear on the market band according to the characteristic of commodity, go up first for instance long T shirt, go up again guard coat, go up again coat, cent rhythm put on the shelf.
The moving pin of the product is related to the moving pin rate. 50 SKUs have been listed. How many have generated sales?
Replenishment and allocation of goods; Later merging and integration of goods; Sales of goods, monthly indicators, how many completed, year-on-year, quarter-on-quarter situation and so on.
The analysis of retail industry mainly includes purchase, sale and inventory analysis, product structure analysis, smooth and unsalable analysis and performance analysis. Here will not expand to say, you can go to see the bestseller “data analysis thinking”, there are, I wish you a smooth job. The above content from the “monkey data analysis” share job experience, students source: ⠀ www.zhihu.com/question/29…
Recommendation: There’s a job search tip waiting to be picked up
