Hi there, there are different forms of analysts. But in a nutshell, below are the skills that I use / have commonly come across during applications:
Hard Skills
1) Advanced Excel (Nested IFs / VLookUp / Pivot Table / Index & Match etc.)
2) Excel Dashboards (Present data graphically so that it is clear, useful and informative)
3) Coding (Depends on industry / nature of role) - R, Python, C++
4) Statistics (Standard Deviation, Distribution curve etc.)
5) Business Intelligence software (Tableau, Qlikview)
6) Developing a financial model from scratch, relevant analysis - Monte Carlo, Football Field to ultimately get your valuation (For financial analysts)
Soft Skills
1) Meticulous - As you are dealing with numbers, it is important to be accurate and detailed-conscious
2) Comfortable with tremendous amount of data - Data is to analysts, an uncut diamond, hence the role of an analyst is to really bring out the value of these data in the decision making of the company
3) Strong-willed - You need to have confidence in your analysis by ensuring all bases are covered and all factors have been taken into account (Hence you usually have best/worst case scenario if one is doing modelling / forecasting). When people question you about your analysis, you need to have the relevant explainations to explain why certain assumptions are taken in the analysis.
Hope the above is useful. May you excel (See what I did there) in your current / future role as an analyst!
Hi there, there are different forms of analysts. But in a nutshell, below are the skills that I use / have commonly come across during applications:
Hard Skills
1) Advanced Excel (Nested IFs / VLookUp / Pivot Table / Index & Match etc.)
2) Excel Dashboards (Present data graphically so that it is clear, useful and informative)
3) Coding (Depends on industry / nature of role) - R, Python, C++
4) Statistics (Standard Deviation, Distribution curve etc.)
5) Business Intelligence software (Tableau, Qlikview)
6) Developing a financial model from scratch, relevant analysis - Monte Carlo, Football Field to ultimately get your valuation (For financial analysts)
Soft Skills
1) Meticulous - As you are dealing with numbers, it is important to be accurate and detailed-conscious
2) Comfortable with tremendous amount of data - Data is to analysts, an uncut diamond, hence the role of an analyst is to really bring out the value of these data in the decision making of the company
3) Strong-willed - You need to have confidence in your analysis by ensuring all bases are covered and all factors have been taken into account (Hence you usually have best/worst case scenario if one is doing modelling / forecasting). When people question you about your analysis, you need to have the relevant explainations to explain why certain assumptions are taken in the analysis.
Hope the above is useful. May you excel (See what I did there) in your current / future role as an analyst!