The majority companies today have realized the value of a data-driven strategy, and are in need of talented individuals to provide insight into the constant stream of information they are collecting. According to a report from IBM, openings for data driven positions will rise to 2.7 million by 2020, and the demand for analysts will only grow as we continue to digitize our physical world.
If you’re just starting your research and are wondering how to make the transition to a career in data analytics, you’re not alone. Scanning job postings for data driven positions is a great jumping off point, but many roles are nuanced, so it can be difficult to try to discern which skills are most important. As we prepare our students for roles in the field of data analytics, we know the blend that employers are looking for, coming down to a few must have skills:
SQL, or Structured Query Language, is the ubiquitous industry standard database language, and one of, if not the, top must-have skills for data analysts. The language is often thought of as the “graduated” version of Excel – it is able to handle large datasets that Excel simply can’t. Almost every organization needs someone who knows SQL – whether it be to manage and store data, relate multiple databases (like the ones Amazon uses to recommend products you may be interested in) or build or change those database structures altogether. Each month, thousands of job postings advertising SQL pop up, and the median salary for someone who knows the tool is well over $80,000. If you’re looking to work with Big Data, learning SQL is the first step, and even non-techies are encouraged to learn the tool.
When you think Excel, the first thing that comes to mind might be spreadsheets, but there’s a lot more analysis power under the hood. While a programming language like R or Python is better suited to handle a large data set, advanced Excel methods
like writing Macros and using VBA lookups .are still widely used for smaller lifts and lighter, quick analytics. If you are working at a bootstraps company or startup, you the first version of your database may even be in Excel. Over the years, the tool has remained a mainstay for businesses in every industry, so learning it is a must. Luckily, there is an abundance of great free resources online to help you get started, as well as structured data analytics classes led by instructors.
Pro tip: Excel is limited with big datasets, so learning a statistical programming language is often another must as you move up in your career as an analyst.
Using data to find answers to your questions means figuring out what to ask in the first place. That can be quite tricky! In order to be an analyst, you have to think like an analyst. It is the role of an analyst to uncover and synthesize connections that are not always so clear. While this ability is innate to a certain extent, there are a number of tips you can try to help improve your critical thinking skills.
R or Python – Statistical Programming
Anything Excel can do, R or Python can do better, and 10 times faster. Like SQL, R and Python can handle what Excel can’t. They are powerful statistical programming languages used to perform advanced analyses and predictive analytics on big data sets. And they’re both industry standard. To truly work as an analyst, you’ll need to go beyond SQL and master at least one of these languages.
So which one should you learn? Both R and Python are open source and free, and employers typically don’t care what their employees choose to use as long as their analyses are accurate. Since it was built specifically for analytics, some analysts prefer R over Python for exploring datasets and doing ad hoc analysis.
Pro tip: Wondering about SPSS or SAS? Learning R or Python over these tools is considered best practice, because like Excel, SAS programs are limited.
Being able to tell a compelling story with data is crucial to getting your point across and keeping your audience engaged. If your findings can’t be easily and quickly identified, then you’re going to have a difficult time getting through to others. For this reason, data visualization can have a make-or-break effect when it comes to the impact of your data. Analysts use eye-catching, high quality charts and graphs to present their findings in a clear and concise way. Tableau’s visualization software is considered an industry standard analytics tool, and it is refreshingly user friendly.
Data visualization and presentation skills go hand-in-hand. But presentation doesn’t always come naturally to everyone, and that’s ok! Even seasoned presenters will feel their nerves at times. As with anything else, start with practice – then practice some more until you get into your groove. Forbes also has some helpful tricks on how to get comfortable presenting.
BONUS: Machine Learning
Machine Learning and predictive modeling are quickly becoming two of the hottest topics in the field of data science. While not every analyst works with Machine Learning, the tools and concepts are important to learn in order to get ahead in the field. You’ll need to have your statistical programming skills down first to advance with Machine Learning. An “out-of-the-box” tool like Orange can also help you start building Machine Learning models.
Knowing which skills you’ll need to break into analytics and start working with data is key to building the right tool belt. Industries are buzzing about Big Data, and organizations are looking for hires with these high-demand, short-supply skills. Getting into data analytics early means more opportunity (and more money) for you!