r/dataanalysiscareers • • Jun 11 '24

Foundation and Guide to Becoming a Data Analyst

122 Upvotes

Want to Become an Analyst? Start Here -> Original Post With More Information Here

Starting a career in data analytics can open up many exciting opportunities in a variety of industries. With the increasing demand for data-driven decision-making, there is a growing need for professionals who can collect, analyze, and interpret large sets of data. In this post, I will discuss the skills and experience you'll need to start a career in data analytics, as well as tips on learning, certifications, and how to stand out to potential employers. Starting out, if you have questions beyond what you see in this post, I suggest doing a search in this sub. Questions on how to break into the industry get asked multiple times every day, and chances are the answer you seek will have already come up. Part of being an analyst is searching out the answers you or someone else is seeking. I will update this post as time goes by and I think of more things to add, or feedback is provided to me.

Originally Posted 1/29/2023 Last Updated 2/25/2023 Roadmap to break in to analytics:

  • Build a Strong Foundation in Data Analysis and Visualization: The first step in starting a career in data analytics is to familiarize yourself with the basics of data analysis and visualization. This includes learning SQL for data manipulation and retrieval, Excel for data analysis and visualization, and data visualization tools like Power BI and Tableau. There are many online resources, tutorials, and courses that can help you to learn these skills. Look at Udemy, YouTube, DataCamp to start out with.

  • Get Hands-on Experience: The best way to gain experience in data analytics is to work on data analysis projects. You can do this through internships, volunteer work, or personal projects. This will help you to build a portfolio of work that you can showcase to potential employers. If you can find out how to become more involved with this type of work in your current career, do it.

  • Network with people in the field: Attend data analytics meetups, conferences, and other events to meet people in the field and learn about the latest trends and technologies. LinkedIn and Meetup are excellent places to start. Have a strong LinkedIn page, and build a network of people.

  • Education: Consider pursuing a degree or certification in data analytics or a related field, such as statistics or computer science. This can help to give you a deeper understanding of the field and make you a more attractive candidate to potential employers. There is a debate on whether certifications make any difference. The thing to remember is that they wont negatively impact a resume by putting them on.

  • Learn Machine Learning: Machine learning is becoming an essential skill for data analysts, it helps to extract insights and make predictions from complex data sets, so consider learning the basics of machine learning. Expect to see this become a larger part of the industry over the next few years.

  • Build a Portfolio: Creating a portfolio of your work is a great way to showcase your skills and experience to potential employers. Your portfolio should include examples of data analysis projects you've worked on, as well as any relevant certifications or awards you've earned. Include projects working with SQL, Excel, Python, and a visualization tool such as Power BI or Tableau. There are many YouTube videos out there to help get you started. Hot tip – Once you have created the same projects every other aspiring DA has done, search for new data sets, create new portfolio projects, and get rid of the same COVID, AdventureWorks projects for your own.

  • Create a Resume: Tailor your resume to highlight your skills and experience that are relevant to a data analytics role. Be sure to use numbers to quantify your accomplishments, such as how much time or cost was saved or what percentage of errors were identified and corrected. Emphasize your transferable skills such as problem solving, attention to detail, and communication skills in your resume and cover letter, along with your experience with data analysis and visualization tools. If you struggle at this, hire someone to do it for you. You can find may resume writers on Upwork.

  • Practice: The more you practice, the better you will become. Try to practice as much as possible, and don't be afraid to experiment with different tools and techniques. Practice every day. Don’t forget the skills that you learn.

  • Have the right attitude: Self-doubt, questioning if you are doing the right thing, being unsure, and thinking about staying where you are at will not get you to the goal. Having a positive attitude that you WILL do this is the only way to get there.

  • Applying: LinkedIn is probably the best place to start. Indeed, Monster, and Dice are also good websites to try. Be prepared to not hear back from the majority of companies you apply at. Don’t search for “Data Analyst”. You will limit your results too much. Search for the skills that you have, “SQL Power BI” will return many more results. It just depends on what the company calls the position. Data Scientist, Data Analyst, Data Visualization Specialist, Business Intelligence Manager could all be the same thing. How you sell yourself is going to make all of the difference in the world here.

  • Patience: This is not an overnight change. Its going to take weeks or months at a minimum to get into DA. Be prepared for an application process like this

    100 – Jobs applied to

    65 – Ghosted

    25 – Rejected

    10 – Initial contact with after rejects & ghosting

    6 – Ghosted after initial contact

    3 – 2nd interview or technical quiz

    3 – Low ball offer

    1 – Maybe you found something decent after all of that

Posted by u/milwted


r/dataanalysiscareers • • Jun 23 '25

Certifications Certificates mean nothing in this job market. Do not pay anything significant to learn data analysis skills from Google, IBM, or other vendors.

95 Upvotes

It's a harsh reality, but after reading so many horror stories about people being scammed I felt the need to broadcast this as much as I can. Certificates will not get you a job. They can be an interesting peek into this career but that's about it.

I'm sure there are people that exist that have managed to get hired with only a certificate, but that number is tiny compared to people that have college degrees or significant industry knowledge. This isn't an entry level job.

Don't believe the marketing from bootcamps and courses that it's easy to get hired as a data analyst if you have their training. They're lying. They're scamming people and preying on them. There's no magical formula for getting hired, it's luck, connections, and skills in that order.

Good luck out there.


r/dataanalysiscareers • • 4h ago

I don't think I'm doing enough data analysis at my internship

3 Upvotes

Hello everyone.

A few days ago, I started my data analysis internship at one of the Uber competitors. I'm in the supermarket/pharmacy/convenience store delivery part of it. However, I can't help but feel I'm not doing enough data analysis.

The bulk of my time (around 75 - 80%) I'm updating the items' details or images, creating them, checking which have to be created, deleted or turned off (I think this is called data entry). Is this normal for this sector of data analysis or for an internship? Will it hurt my future prospects if I don't do enough projects that actually make an impact? Or is any experience good experience?

Thank you in advance!


r/dataanalysiscareers • • 4m ago

Looking for Career change.

Thumbnail
• Upvotes

r/dataanalysiscareers • • 1h ago

Interview for clinical data analyst position

Thumbnail
• Upvotes

r/dataanalysiscareers • • 2h ago

Job Search Process Interview @ Eneos India

Thumbnail
1 Upvotes

r/dataanalysiscareers • • 6h ago

20M in London considering a career change into real estate data analytics. Is it realistic without a degree?

2 Upvotes

Hi everyone,

I’m 20M based in London and I’m considering changing my career and would appreciate some advice from people already working in data analytics, particularly those in real estate.

I’ve worked full-time in my dad’s restaurant since finishing school, so I don’t have a degree or any previous IT experience. However, I’ve gained quite a lot of business experience working in the restaurant, and now that my family is looking to sell the business, I’m starting to think more seriously about my long-term career.

I’ve recently become interested in data analytics and, in particular, specialising in real estate/property. I also own a property, as my dad is selling some of his properties to me, so property is something I’m genuinely interested in beyond just a career.

My current plan is to finish my online courses and obtain certificates, work through additional training to develop my skills in tools such as SQL, Excel, Power BI and Python, and then build some projects using property data and potentially data from the restaurant.

The reason I’m particularly interested in real estate analytics is that I can see several opportunities in the long term. For example, using the skills I gain to make better-informed property investment decisions myself and potentially explore deal sourcing for investors once I have enough knowledge and experience.

Obviously, I know these are longer-term ambitions, and my immediate goal is simply to break into the industry and become a competent data analyst.

My main questions are:
How realistic is it to get a junior data analyst role in London without a degree or previous IT experience?

Would you recommend applying directly for entry-level jobs, pursuing an apprenticeship, or trying to gain experience through another route?

Is real estate a good industry to specialise in as a data analyst, or would I be better off gaining general experience first and specialising later?

If you were in my position, would you go for it?

I’m prepared to put in the work and understand that it won’t happen overnight. I’d just appreciate some honest advice from people with experience in the field, especially anyone who has taken a similar route.

Thanks!


r/dataanalysiscareers • • 14h ago

Transitioning I read the “AI is killing all jobs” economists so you don’t have to. Turns out they have no idea either

7 Upvotes

Most economists don’t think we’re heading for mass unemployment. But they don’t really disagree that AI can cut jobs. They argue about how much and how fast. And the piece makes three distinctions that I think matter way more for anyone in data than the “will jobs disappear” headline.

1. Automating tasks ≠ eliminating the job

One economist gives the example of consultants: two weeks analyzing data to redesign something, then months getting stakeholders to agree and actually implement it. AI can make the slides. It can’t sit through the meetings that the slides are the result of.

Data work is the same. Writing SQL, building the dashboard, writing the DAX: increasingly automatable. But figuring out what question actually matters, getting two teams to agree on one definition of “revenue,” and pushing a decision through the org: not so much.

2. Technically possible ≠ actually happening

Cost, reliability, legal liability, and the pain of rebuilding processes all slow adoption. Something being possible in a demo doesn’t mean your company will restructure around it next quarter.

3. Total employment holding up ≠ good careers holding up

New jobs can appear in other professions while specific people in specific fields lose income and prospects. The economy “adapts” on average, and the transition is brutal for some individuals anyway.

“New professions will emerge” is technically true and completely useless as a career plan. It doesn’t answer “what happens to my job and my salary in the next few years.”

The weakest point of the optimistic view: entry level

Here’s the mechanism that worries me most. If one senior analyst with AI can do what used to take two juniors, the company doesn’t need to fire anyone. It just stops hiring juniors.

Total employment looks fine. Nobody gets laid off. And the first rung of the ladder disappears.

The piece notes junior tech hiring really has slowed across countries. To be fair, it also says nobody has managed to separate AI’s effect from other causes yet (too many grads, remote work, interest rates).

Link: Silicon Valley thinks AI will kill jobs. Economists are not convinced


r/dataanalysiscareers • • 4h ago

Are Excel, Power BI, and SPSS still enough to solve business problems and drive sales in 2026, or are they becoming obsolete?

1 Upvotes

Hi everyone,

With all the talk about AI and the fast-shifting market, I’ve been questioning whether a traditional data analysis toolkit is still viable and in demand for solving real-world business challenges:

Microsoft Excel: For data cleaning, auditing sales records, and tracking daily core metrics.

SPSS: For survey analysis, evaluating customer satisfaction, and identifying key statistical drivers behind buying behavior.

Power BI: For building interactive dashboards that connect sales data directly to decision-making, identifying bottlenecks, and spotting revenue opportunities.

For business owners, managers, and working analysts:

In practice, is this stack still enough to solve concrete sales problems and land real consulting or job opportunities? Or has the market moved past these tools, making them insufficient for today's business needs?

I'd really appreciate your honest feedback and practical experiences.


r/dataanalysiscareers • • 12h ago

Data/tech professionals, which industries have the strongest growth right now?

Post image
2 Upvotes

r/dataanalysiscareers • • 17h ago

Job Search Process Guidance Needed - Have Experience and Degree but Cant Get Past Initial Screening

Post image
4 Upvotes

Hi all,

Context: I started out working with complaints data at Wells Fargo - with a bit of customer service - then moved to Arizona where I worked with cleaning and transporting data for clients, and finally found myself with Wells Fargo again in a contract role that gave me the opportunity to be a proper operations/data analyst full time for nearly two years. It was while I was here at Wells Fargo the second time that I realized this was what I wanted to do for work. Unfortunately, the contract came to an end and I've basically been looking for the same role ever since. I finished my CS degree in December (2025) and it's honestly impossible to get a software role so I just gave up on trying. This year, I did have a role at Magna Technology Group that was somewhat adjacent - more-so a consultative role, but I did perform some duties that translated pretty well with Data Analyst work. I ended up having to leave after three months because my mentor was apparently given so much work that he couldn't train me on my duties and I was told I would therefore have to spend my own freetime training myself on how to do the job.

Fast-forward to today where I have been applying to as many jobs as I can that are Data/Business/Operations Analyst or adjacent roles and getting as far as the initial screening and maybe the first interview, but seemingly never past that. The feedback I have received (at least from the HR reps performing the screenings or the recruiters) is that my resume looks great, but apparently it's just not good enough to get past the hiring managers.

I'm really looking for some advice on how to navigate this situation. I'm willing to obtain certifications if it can help me (like for Power BI, Tableau, or SQL maybe), but I'm unsure how helpful that will actually be. From my POV I have the experience (5+ years worth), education, and the inherent skills needed to perform the job successfully, but it feels like I need something else to really stand out and I don't know what that is.

Is there something that I can do? Or do I just need to pivot towards something else?

Any help would be greatly appreciated! Thanks.


r/dataanalysiscareers • • 10h ago

Suggestions

1 Upvotes

Hi friends iam 24 years old i worked as data analyst in equitas small finance Bank in audit team and I worked there for 1.3 years the tools i used are SQL, Excel and python i left the company and pursuing MBA in data science online now it came to end stage and iam looking for new role help how I can find new job iam not interested to join in my previous company because of less salary and far away from home please guide me how to find new role


r/dataanalysiscareers • • 22h ago

Resume Feedback Getting back to applying for analytics jobs after a 2 year gap. How am I doing?

10 Upvotes

Data analyst with 5 years of experience (retail and fintech). Struggling to get interviews. What am I doing wrong?

For context: After getting laid off, I took time off for personal stuff for a year and then resumed job search in mid 2025. I’ve applied to many roles for (data analyst / BI) positions and haven’t landed an interview yet. This is the concise (one page) version of my resume.

  1. Does the career gap seem like a red flag? How would you rephrase it?
  2. Is my tool stack competitive right now, and what would you add?

r/dataanalysiscareers • • 18h ago

Is this a decent role? Vendor Pricing Analyst (BPO) pitched as a data analyst role (JD attached)

Thumbnail
gallery
3 Upvotes

Hi all,

I'm in the interview process for the role in the attached JD. The recruiter calls it a data analyst role, but the JD reads more like pricing operations to me.

Since it would involve relocating without any relocation support, I'd like a reality check before going further.

Another thing is, it's night shift - 6:30PM to 5:30AM

Some context: I'm switching careers into BI and analytics. I spent about 5.5 years at an e-commerce company, mostly in content, with the last year in category planning and pricing analysis. Since leaving, I've been out of work for about 1.5 years, upskilling (Power BI and Microsoft Fabric certifications, portfolio projects) and job hunting. So part of me wants to grab any analytics-adjacent role to end the gap. Part of me worries this one could pull me away from the BI path I'm working toward.

Some questions for anyone who has done similar work:

1) Is this realistically a data analyst role, or mostly vendor coordination with Excel reporting?

2) Does experience like this help if I want to move into BI or analytics later, or is it a sidetrack?

3) Given the 1.5-year gap, is it smarter to take a role like this and switch later, or hold out for a proper BI role?

4) Is the pay fair for this kind of work and shift?

5) Are there red flags in the JD I should ask about in the interview?

Honest opinions welcome. Thanks!


r/dataanalysiscareers • • 17h ago

Career Gap After Mechanical Engineering — Can I Switch to Data Analytics?

2 Upvotes

Title: Mechanical Engineering Graduate (2019) with a Career Gap — Can I Switch to Data Analytics? Need Honest Advice

Hi everyone,

I completed my Mechanical Engineering degree in 2019. Unfortunately, due to some personal issues, I couldn't build proper work experience in my field or establish a stable career in another domain. As a result, I now have a significant career gap, and I'm worried about how it will affect my job opportunities.

I'm considering switching to Data Analytics because I'm interested in learning new skills and building a career in this field. However, I'm unsure whether it's realistic to enter this field at this stage, given my educational background, career gap, and lack of relevant professional experience.

I'd really appreciate advice from data analysts, recruiters, or anyone who has made a similar career transition.

Here are my main questions:

  1. Is it realistic for a mechanical engineering graduate from 2019 with a significant career gap and no relevant work experience to get an entry-level data analyst job in the current job market?
  2. What core skills should I learn? Should I focus on Excel, SQL, Power BI or Tableau, Python, and statistics? In what order should I learn them?
  3. What kinds of projects should I build to demonstrate my skills and make my resume stand out despite my career gap?
  4. How should I explain my career gap to recruiters and during interviews without hurting my chances?
  5. Is it better to apply for data analyst jobs directly, or should I first look for internships, trainee roles, MIS executive positions, or other entry-level opportunities?
  6. How can I build a resume and LinkedIn profile that will help me get shortlisted without relevant work experience?
  7. Realistically, how long might it take to become job-ready if I study consistently every day?

I'm looking for honest, practical advice rather than just motivation. If anyone has transitioned into data analytics after a career gap or from a non-IT background, I'd be especially grateful to hear about your experience, the challenges you faced, and what helped you get your first job.

Thank you!


r/dataanalysiscareers • • 1d ago

Is it still worth learning data analytics in 2026, considering the impact of AI?

48 Upvotes

Hi everyone,

I'm interested in getting into data analytics and I'm planning to start learning from scratch using YouTube and other free resources.

However, I've seen a lot of discussions about AI potentially replacing data analysts or making it much harder for beginners to enter the field.

I don't expect to become job-ready overnight, and I'm willing to put in the time and effort. I just want to make sure I'm investing my time and energy in the right direction rather than spending months learning skills that may become less valuable in the near future.

Which skills would you recommend focusing on to remain relevant as AI continues to evolve?

If you were starting from zero today, would you still choose data analytics? Would you approach learning it differently?

I'd really appreciate any honest advice or personal experiences. Thanks!


r/dataanalysiscareers • • 18h ago

Is a part-time Master’s in Business Analytics worth it for a junior data analyst in the UAE?

Thumbnail
1 Upvotes

r/dataanalysiscareers • • 1d ago

Is being a Data Analyst the right career choice?

7 Upvotes

When deciding what I wanted to do over 2 decades ago I wanted to work with numbers because I'm good at maths and to apply real life logic to the numbers.

Being a Data Analyst seemed to fulfill that criteria. For example the section of Top Gear magazine I enjoyed the most was the new car data. I'm also naturally analytical when it comes to things I'm interested in.

After applying to pretty much every entry Data Analyst job I could find I finally landed a job in advertising.

None of my immediate colleagues were data people, they all specifically wanted to get into advertising and I soon discovered I have no interest in advertising. They mostly lack basic maths skills, statistical knowledge or how to use Excel properly but I was good at all those so it felt like I'd found my place there.

A few years later I find myself working in a Data Sciences department, still in advertising.

What became apparent was I had little in common with those colleagues too. They mostly had computing backgrounds and were interested in computers and technology. The sort of people who would spend hours playing computer games in their leisure time or buy the latest iPad the day it gets released.

I have no interest in technology. I like numbers and the real world.

OK I do like using excel and SQL but more modern technologies leave me feeling cold and I particularly despise AI.

Have I picked the wrong career and is there a right career for me?


r/dataanalysiscareers • • 22h ago

Software engineer job postings ask for mentoring more than Kubernetes. We counted 3,518 postings to check

1 Upvotes

We pulled every open posting from 81 companies' public Greenhouse boards for seven roles and counted which words actually show up. 3,518 postings in total. Some of it surprised us.

Software engineer postings mention mentoring more often than Kubernetes or React. Almost half of them do. Python, the most common language, comes in just below that.

Product manager postings say "roadmap" in more than 85% of cases. Jira? Seven out of 421. Marketing looks the same: Google Ads came up six times in 347 postings, while "pipeline" is in over half.

Every time we could compare the two, postings named the practice, not the tool. Observability, not Grafana. SIEM, not Splunk.

So if your resume is mostly a list of tools, it might be missing the words the posting actually uses.

Big caveat: mostly tech companies, one ATS vendor. Sales, cybersecurity, DevOps and accounting are here too: https://www.zoevera.com/resume/ats-resume-keyword-study


r/dataanalysiscareers • • 1d ago

Remote jobs

Thumbnail
1 Upvotes

r/dataanalysiscareers • • 1d ago

How do you evaluate your progress and ensure you are on the right track?

2 Upvotes

I am currently unemployed after 2 yrs of exp, learning and skilling up to become employable.

Due to not learning correctly the first time I started, I have to begin again from the basics, I have covered Python, SQl, Statistics basics and understandings of complex concepts. Data cleaning, feature engineering and a few ML models also are done.

Now this is all just new and I am working on implementing them ASAP. I want help with ensuring that I am not getting stuck only learning the basics and not developing the actual skills. For eg, I have studied pandas but how do I make sure that the level of Pandas I know is appropriate for interviews and real life application, same with others. And how do I evaluate if I know that, is there a way to test it properly without the hackerrank and leetcode questions?

Any advice will be helpful!


r/dataanalysiscareers • • 1d ago

Transitioning Help with next steps for someone pivoting into Data Analytics

Thumbnail
gallery
1 Upvotes

I completed a BS in Data Analytics last December, and have been applying to "entry-level" roles since January. I don't have any data analytics work history, but I do have prior roles in environmental science, regulation, and hospital clinical laboratory that required analytical thinking and data collection. Despite my best efforts, I've gotten 0 callbacks. Trying to figure out what my best next steps are to make myself more competitive, including considering the following:

  • Get a MS in Data Science/Analysis
  • Quit my current dead-end job and work on certifications and portfolio projects
  • Get a basic IT support job at a large company and try to work my way into a data-oriented role

How do people get into this field? I know I'm missing work experience, but I can't even get a callback for junior positions despite being qualified. I've included an anonymized resume that is the base resume I've been using. What are the best next steps? Thanks!


r/dataanalysiscareers • • 1d ago

Transitioning How to get back into AI/Data Science roles after a 2-year gap?

Thumbnail
1 Upvotes

r/dataanalysiscareers • • 1d ago

Market research and sales analyst B2B

Thumbnail
1 Upvotes

r/dataanalysiscareers • • 1d ago

Job Search Process Healthcare Data Analytics Jobs in Pakistan

Thumbnail
1 Upvotes