How to Become a Data Analyst (Without Going Back to College)
Supply and demand… we all know that as job seekers, high demand and low supply work in our favor. It's a booming job market already, but even more so for data analysts.
The 2018 KMPG CIO Survey found that 46% of Chief Information Officers see "big data and analytics" as the area most in need of additional talent to support growth.
While this impacts careers in data science and data analysis alike, this article focuses strictly on a career as a data analyst, as it's a bit easier to pursue without an advanced knowledge of (read PhD in) Statistics.
Alright, now let's dive in - how can you become a data analyst?
What does a data analyst do?
In simple terms, a data analyst takes data that's been gathered and uses it to help their company or companies make informed business decisions. A data analyst gathers data on specific topics or metrics, often called Key Performance Indicators (KPIs), analyzes that data, and then prepares and presents their findings.
They also work with business development and product teams to use past data in order to set KPIs and track performance over time.
How can you become a data analyst?
Now that you know what a data analyst does, how do you develop the skills necessary to become a data analyst?
First off, let's take a look at what you need to know from a technical perspective.
- Statistical modeling
- Experience using statistical packages to analyze datasets (Excel, SPSS, SAS, R)
- Knowledge of and experience with reporting packages, databases, and programming
- Strong analytical skills and the ability to organize, understand, and identify trends in data
- The ability to share findings with others
- Data visualization skills and familiarity with programs like Tableau
Lots of sources will tell you you need a degree in a related field to get hired, but with large companies like Google and Apple ditching their degree requirements, what you really need is demonstrated experience in the field.
Consider Coursera's statistics courses and remember that regardless of your major, if you took any stats courses in college, they're great things to flag on your resume when applying to data analyst roles.
Any quantitative academic research (be it in sociology, psychology, or chemistry) will also be highly transferable, so be sure that's listed as well. (You don't need to have studied economics to understand modeling, but recruiters don't always know that, so do what you can to make it obvious to them!)
Lots of the tools you'll need to use as a business analyst offer free tutorials and certifications, so be sure to check them out as well:
Once you've got the basics down, look at job descriptions for data analysts at some companies where you'd like to work. Read each item on the list and ask yourself if you've done any work to prove that you're capable of the listed task. If you have, jot down what you've done and why it's relevant.
If you haven't, think of projects you could do independently to demonstrate that experience. Consider applying for internships, asking your current employer to allow you to take on data analyst tasks (companies love actionable data, so this should be an easy pitch), or working on a passion project with friends who already have experience in the field.
Within a year or two, you'll easily have enough experience to score an entry-level data analyst role, or maybe even pivot into (or create) one at your current company.
So, recap - how can you become a data analyst... as quickly as possible?
- Understand what the role entails
- Explore free resources to gain exposure
- Review the list of required technical skills
- Identify gaps in your existing skill set
- Take tailored cost-effective and free courses to address the gaps (be sure to make use of free software-specific trainings)
- Start looking at job postings at your target companies - what skills are you still missing?
- Design projects (at your company, with friends, or independently) to give yourself the opportunity to demonstrate your knowledge in those areas
- Get an internship, if feasible/necessary
- Apply to full-time roles! (And don't forget, if you work at a small company that doesn't yet have any data analysts, you can always pitch the role to them!)
Remember, you can always go back to school for an advanced degree to unlock even more earning potential later on, but why put two years of time and money into a degree when you could dive straight into the career first?
Growing Your Career in Technical Support: 4 Tips for Getting Hired at Elastic from Support Director Heidi Sager
Heidi Sager loves math, but she also loves working with people.
She always has, which is why she enjoyed her part-time job working at the IT department of the University of Colorado while she was studying electrical engineering. (She'd started in computer science, but explains that it "wasn't for her" and switched her major.) She helped students and professors with word processors, basic programming, and software checkout, and took a full-time job after graduation as a UNIX system administrator.
Working at Relativity—the global tech company that equips legal and compliance professionals with a powerful data-organizing and discovery platform—looked different in 2020. The highly collaborative environment of their Chicago headquarters transitioned to a virtual setting, and just like companies around the country, Relativity adapted their goals and major projects to a completely remote environment.
Diversity Reboot 2021: The One Hundred Day Kickoff<p><strong>When</strong>: February 1-5, 2021</p><p><strong>Where</strong>: Virtual</p><p><strong>Price to register:</strong> Free!</p><p><strong>Where to register: </strong><a href="https://summit.powertofly.com/" target="_blank">Here</a></p><p>We had to include our own Diversity Reboot on our list of the best diversity and inclusion events to attend in 2021 because we know firsthand how the quality of 100+ expert speakers, the enthusiasm of 10,000 participants, and the cutting-edge tech that enables meaningful virtual networking and job fairs combine to create a truly epic five-day experience. This year, the theme 100 Day Kickoff harnesses the energy of the new government's first 100 days in office to help jump-start personal and professional plans to build more diverse and inclusive workplaces. </p><p>Following the February summit, we'll have a monthly series of smaller virtual summits on topics spanning everything from returnships to LGBTQ+ advocacy, so be sure to stay tuned for updates!<br></p>
The Future of Diversity, Equity and Inclusion 2021<p><strong>When</strong>: February 3-4, 2021</p><p><strong>Where</strong>: Virtual</p><p><strong>Price to register:</strong> Free</p><p><strong>Where to register:</strong> <a href="https://www.hr.com/en/webcasts_events/virtual_events/upcoming_virtual_events/the-future-of-diversity-equity-and-inclusion-2021_kcxf8glq.html#detail" target="_blank">Here</a></p><p>This virtual conference put on by HR.com focuses on how social movements like #MeToo and Black Lives Matter have pushed DEI at work beyond legal compliance and into a major factor of any company or brand's culture, employee engagement, and performance. Topics include how to uncover and resolve pay gaps across your team and hire top-level diverse talent.</p>
Workplace Revolution: From Talk to Collective Action<p><strong>When</strong>: March 8-12, 2021</p><p><strong>Where</strong>: Virtual</p><p><strong>Price to register: </strong>$820</p><p><strong>Where to register:</strong> <a href="https://cvent.me/ZQ4BbE" target="_blank">Here</a></p><p>The Forum on Workplace Inclusion's 33rd annual conference includes 12 session tracks, from DEI Strategy to Social Responsibility, along with 59 workshops and daily networking sessions. This year's theme focuses on one question: "What will it take to start a workplace revolution that moves us from talk to action?"</p>
Diversity: How Employers Can Match Words With Deeds<p><strong>When</strong><strong>: </strong>May 19, 2021</p><p><strong>Where:</strong> Virtual</p><p><strong>Price to register</strong><strong>: </strong>Early bird registration is $49 and general admission is $149</p><p><strong>Where to register:</strong> <a href="https://hopin.com/events/may-virtual-conference-diversity-how-employers-can-match-words-with-deeds" target="_blank" rel="noopener noreferrer">Here</a></p><p>From Day One is hosting monthly conferences in 2021 focused on different ways for companies to foster strong relationships with their customers, communities, and employees. May's half-day virtual event is focused specifically on how companies can make diversity promises that don't fall flat and features workshops, panels, and a fireside chat.</p>
Hire with Diversity, Equity, and Inclusion<p><strong>When:</strong> August 18, 2021</p><p><strong>Where: </strong>Virtual</p><p><strong>Price to register: </strong>$195</p><p><strong>Where to register:</strong> <a href="https://www.hci.org/conferences/2021-virtual-conference-hire-diversity-equity-and-inclusion-august-18-2021" target="_blank">Here</a></p><p>This conference put on by the Human Capital Institute is one of 12 virtual conferences that HCI has planned for 2021. This one focuses on fair and inclusive talent acquisition, including how to attract diverse talent, implement inclusive hiring practices, and addressing bias in employee selection. Other conferences will focus on optimizing talent strategy, engaging employees, and developing your workforce.</p>
Virtual Grace Hopper Celebration 2021<p><strong>When:</strong> September 26-29, 2021</p><p><strong>Where:</strong> Virtual, broadcast from Chicago, Illinois</p><p><strong>Price to register:</strong> Was $799 for regular access to the virtual conference in 2020; 2021 pricing hasn't yet been announced</p><p><strong>Where to register:</strong> <a href="https://ghc.anitab.org/attend/registration/" target="_blank">Here</a>, though 2021 registration wasn't live at the time of writing</p><p>Grace Hopper might be the best-known conference for women in tech. Through keynote presentations, networking sessions, job fairs, and community-building activities, vGHC reached over 30,000 women for their 2020 conference and are expecting even more in 2021! While not a conference focused exclusively on diversity and inclusion, many speakers plan to focus their talks on creating environments for women to thrive in the male-dominated tech field.</p>
Inclusion 2021<p><strong>When:</strong> October 25-27, 2021</p><p><strong>Where:</strong> Virtual and in person in Austin, Texas as of now</p><p><strong>Price to register:</strong> Hasn't yet been announced</p><p><strong>Where to register: </strong><a href="https://conferences.shrm.org/inclusion" target="_blank">Here</a>, though 2021 registration wasn't live at the time of writing</p><p>The Society for Human Resource Management's biggest conference of the year saw 1,200 DEI leaders participate last year; SHRM hopes to see even more come to learn, be inspired, and to walk away with a playbook of implementable strategies to create truly inclusive workplace cultures.</p>
AfroTech 2021<p><strong></strong><strong>When:</strong> November 8-13, 2021</p><p><strong>Where:</strong> Virtual</p><p><strong>Price to register:</strong> Early bird pricing is $149 for individuals and $249 for corporate attendees; regular pricing hasn't yet been announced</p><p><strong>Where to register:</strong> <a href="https://experience.afrotech.com/" target="_blank">Here</a></p><p>AfroTech is a conference hosted by Blavity, a tech media platform for Black millennials. It focuses on emerging tech trends, connecting Black talent with top tech recruiters, and providing networking and educational opportunities, with an overall goal of building a strong Black tech community. Over 10,000 people participated in 2020. While the conference isn't focused specifically on DEI, its main audience of Black tech talent is an important one to understand and to engage at work and beyond, and several speakers plan to focus on issues of race and inclusion at work. </p>
A Conversation with Vouch's Lead Designer Carrie Phillips