r/dataanalytics • • Feb 08 '25

How I changed careers to become a data analyst

479 Upvotes

I’ve seen a lot of posts on here asking for advice about switching careers into data analytics. I made the switch two years ago, and life has been great. However, it wasn’t easy, and it did require a large sacrifice of time and money. Now, keep in mind, my path definitely isn’t the only path and wouldn’t be a good fit for everyone, but for those looking for success stories, here is mine.

BEFORE SWITCHING: By the time I decided to attempt becoming a data analyst, I was already working two jobs. I worked part-time as a chemistry lecturer at a university and full-time as an editor of scientific research articles. I did not have a lot of time to study, so here’s what my typical schedule looked like:

7:30am - wake up 8:15am - drive to the university 8:45am - 12pm - teaching, office hours, meetings, writing exams 12pm - 1pm - drive home, eat lunch 1pm - 10pm - editing chemistry research papers 10pm - 11pm - cook and eat dinner 11pm - 2am - study analytics basics, answer student emails 2am - bed

For studying, I used LinkedIn Learning for statistics, DataCamp for R, Python, and SQL, and NC States online Intro to Analytics 2 course ($400). My partner is a data scientist, so he helped me when I got stuck, and I used his LinkedIn Learning and Datacamp accounts.

I applied to one Masters program: NC States Institute for Advanced Analytics. It is only 10 months, and I would have in-state tuition. It was the only Masters program I could afford at the time. I got an interview, but I was then waitlisted. I received my acceptance I think in May, and the program, which was full-time in person, started in June. I declined a summer teaching contract and gave 2 weeks notice at my editing job. I worked with my property manager to end my lease at my townhouse and moved into my partner’s tiny apartment to save money and be closer to the university.

BACK TO SCHOOL The IAA Masters program is full-time, in-person, for 10 months. I was typically at the university from 9am-6pm Monday-Friday. Aside from a lunch break, pretty much all of that time was spent in class, attending office hours, or working with my homework and project groups. By the time spring semester rolled around, job interviews were added to that list. Several companies came to the university to conduct their interviews in-person. Thankfully, we had courses in how to prepare a resume, tackle technical interviews and case studies, and answer “tell me about yourself” type of questions, so I felt prepared.

Before graduation, I received two job offers, both for $110k (which was the median for my graduating class). My two previous jobs combined were making me ~$50k total, so I was thrilled. I accepted a remote data analyst role at a local company. I would have loved the other job, too, but it would have required relocation, and my partner could not relocate due to his job. I started work 2 weeks after graduating.

SINCE THE SWITCH

I’m still with the same company, and overall, I’m very happy. I work 8-4:30 instead of 8:45-10, so life is more relaxing. Because my partner and I saved so much money by splitting his crappy apartment for over a year, we were able to buy a house, and now I have a home office. Sometimes work is extremely busy, and sometimes it’s extremely boring, but I get to work with very complex data, and I’ve become a much better analyst. My coding has improved, and I’ve become extremely skilled at Tableau.

Overall, it was worth it, but I had to make some huge sacrifices. I was out of the workforce for almost a year, I had to leave my townhouse and move to a tiny apartment in a different city, I had to study late at night, I went ~2 years with limited hobbies and social time, and I had to take out additional loans for tuition. Obviously, this would not be feasible for everyone, and part of why it worked for me is because I have an amazing, supportive partner who was already in data science. We don’t have kids yet, so we were able to really take the time to focus on career growth.

I hope this is helpful to some people. Change is possible, but whatever path you take, whether it is a degree or a certificate program, is going to come with challenges and sacrifice.


r/dataanalytics • • Feb 14 '25

Built My First Excel Dashboard! 🚴📊

288 Upvotes

A few months ago, I started diving into data analytics and decided to test my skills by building a Bike Sales Dashboard in Excel. The dataset included sales data from different cities and age groups, and I wanted to turn it into something insightful.

The process involved: ✔ Data Cleaning – Removing duplicates, fixing errors, and organizing data ✔ Data Transformation – Converting raw data into an analysis-ready format ✔ Pivot Tables & Charts – Visualizing key trends and insights

I learned a lot from Macquarie University’s Excel course on Coursera and resources like Alex the Analyst. This was my first project, and it made me realize how powerful Excel can be for data analysis.

Excited to keep improving and take on more complex projects! Any tips or feedback?


r/dataanalytics • • Oct 13 '26

I just got hired as data analyst and this is not what I expect

265 Upvotes

Hi, I just got hired as a data analyst and this is so exhausting 😭. I spend 90% of my data analysis encoding the data 10% doing the analysis it self. My company only do have physical copies of their data and I have to manually type it in Excel. I was expecting during the interview that they will be giving me a messy data and its up to me on how I clean it but now its so tiring!! Is this normal? I am currently doing doing the automation at home but this is just so unfair because am not paid to do it at home and I also dont have the time to build the automation at work because I spend most of it encoding.


r/dataanalytics • • Jul 30 '26

Is Excel Still Worth Learning in the AI Era?

Post image
246 Upvotes

Is learning Microsoft Excel from beginner to advanced still worth it in today's AI-driven world?

I only know the basics of Excel. While trying to clear some doubts, I started researching online and came across several Excel courses. That's when I realized there's actually a lot more to Excel than I knew.

Now I'm wondering whether it's worth investing my time to learn Excel at an advanced level, especially with AI becoming so powerful and widely used. Nowadays, everyone seems to be focusing on AI tools and automation.

So, what do you guys think? Is mastering Excel still a valuable skill in 2026, or should I spend that time learning something else? Also, the course offers a certificate. Is that certification worth it?


r/dataanalytics • • Aug 20 '26

I’m so fucking tired of executives and their AI slop

233 Upvotes

There’s two directors at my org that are so “AI is the future, AI will replace everyone.” He took a pdf of my power bi report dumped it into AI and generated an “exec summary” and said “and I did this in 20 minutes - this is the future”. Even my boss was like - yeah it’s really impressive.

I’ve been fucking fuming all day and then I actually read the content and it’s worse than garbage - it’s wrong.

Here’s some gems :

X is 219% - the inverse of 45% (no it’s not)
228 is the “run rate” of 1616x14% (no fucking clue what a run rate is and wrong)
Risk is role, tenure, job, and unit specific (no shit)
Redeploy before overtime (that means nothing)
We’re alternating between thin baseline capacity and reactive labor deployment. (That means nothing)


r/dataanalytics • • Apr 29 '25

Recruiter told me if I can't code I won't get a job as a Data Analyst

214 Upvotes

Hey folks,

I recently spoke with a few recruiters who’s actively hiring for data analyst roles. All of them asked for coding skills.

One of them had an honest conversation and said that without programming in this market I won't be land a new job. Few other things they mentioned:

Personal projects > cloned Coursera tutorials
Strong SQL knowledge
They asked for Cloud skills (especially AWS)
Dashboards that tell a story, not just look flashy

He said, "I'd rather see a real-world project your github rather than those standard datasets and trivial graphs or certificates."

I pulled together everything he shared (plus insights from other hiring managers) into a small post:https://prepare.sh/articles/perfect-data-analyst-resume-in-2025-to-get-your-first-job


r/dataanalytics • • Aug 09 '26

I made a cat doodle about data analysis

Post image
198 Upvotes

tried explaining a data analysis concept in a fun, visual way — for cat lovers. 😸
Would love to hear what you think! Any feedback or suggestions are very welcome :)


r/dataanalytics • • Aug 26 '26

Spent 3 weeks building a fully automated dashboard, only to be asked for an "Export to Excel" button.

193 Upvotes

I just need to vent for a minute because I feel like I am losing my mind.

I spent the last three weeks absolutely breaking my back over a dashboard for a major stakeholder request. I fully automated the data models and refresh schedules, complete with dynamic cross-filtering, drill-downs that update in milliseconds, and a spotless data model so that absolutely nobody would ever have to copy-paste numbers manually again. I was genuinely proud of the architecture.

Cue the demo meeting this week. I am five minutes into presenting, walking them through how the interactive parameters work, and the lead stakeholder just interrupts me.

"Wow, this looks really pretty. But where is the button to export all this to Excel? We usually just pull the raw data so Brenda can make her own pivot tables and highlight the cells in yellow."

I genuinely felt my soul leave my body.

Why did we even have six discovery meetings? Why did I spend days optimizing the refresh schedules and cleaning up the logic? I essentially just spent almost a month building the world’s most complicated, over-engineered CSV downloader just so they can continue doing things the exact same way they did ten years ago. It is so incredibly demoralizing to build a high-performance engine just to watch someone use it to tow a horse buggy.

For those of you who have been in the trenches longer than me:

  • Do you even bother trying to train stakeholders on how to use interactive BI tools, or do you just give up and build the "Export to Excel" button on Day 1?

  • How do you bridge the gap when leadership asks for "modern analytics" but culturally refuses to leave their 2003 spreadsheets?

Would love to hear your coping mechanisms and war stories.


r/dataanalytics • • Aug 12 '26

Had a Data Analyst interview recently, and these 2 questions genuinely made me think.

191 Upvotes

Question 1:

You have a dataset with 50 million rows, and it doesn't fit into memory. How would you analyze it efficiently?

My answer:

I wouldn't load everything into Pandas. I'd first filter only the required columns/rows, push aggregations to SQL where possible, process the data in chunks, and use tools like PySpark if distributed processing is actually needed.

Question 2:

Your dashboard suddenly shows a 40% drop in active users overnight. What would you check first?

My answer:

I wouldn't immediately assume user activity actually dropped. I'd first validate the data — pipeline status, data refresh, tracking events, source tables, filters, and any recent changes to the product or tracking logic. Once the data is confirmed, I'd investigate the actual cause.

If you were in my place, how would you answer these two questions?

Would love to hear how experienced Data Analysts would approach them.


r/dataanalytics • • Jan 07 '25

Got my first Analyst job!

168 Upvotes

Just got my first job in analytics! Some background I have been doing a little bit of data analysis for a relative who owns a small business. Nothing crazy, not a lot of data but I used Excel, sql and powerBi to analyze it and to refine my skills. After getting my degree in CS I have been applying to jobs for 4-5 months and it finally happened!

Keep pushing!


r/dataanalytics • • Feb 02 '26

Does anyone else see the writing on the wall for data analytics as a whole?

155 Upvotes

I know it's not going to be completely obsolete in five years, but I feel like a majority of the jobs in the last 5 years are going to be gone, maybe more. I am currently employed at a FAANG role in what I predict may be one of my last roles in this industry.

What is your backup plan? Where do you see this industry going? My only hope is my experience and the qualitative insights I can provide may be my only saving grace.


r/dataanalytics • • 14d ago

To everyone planning to make a career in DA

Post image
126 Upvotes

https://theuptimereport.com/tech-job-postings/

The graph does not tell you :

Supply Side: Alot of folks joined DA by completing random courses during the 2022 - 2023 peak. The graph might show that we are back to pre covid levels but the supply has also increased exponentially.


r/dataanalytics • • Jul 28 '26

Best way to learn Data Analytics from scratch and become job-ready?

108 Upvotes

I am starting my journey in Data Analytics and want to learn everything needed to become job-ready.

For people working as Data Analysts or who have successfully transitioned into analytics:

What is the best learning roadmap from beginner to job-ready?

Which courses, books, YouTube channels, or projects helped you the most?

Any practical advice from your experience would be highly appreciated.


r/dataanalytics • • Oct 27 '25

You'll never feel ready to apply to Data Jobs

103 Upvotes

I see so many people here saying things like:

“I’ll apply once I learn Power BI.”
“I’ll wait until my portfolio looks perfect.”
“I’ll start applying when I finish this course.”

But really... You'll never feel ready.

Even senior analysts aren't ready.

The only way to actually get better at interviewing, writing résumés, and talking about your projects... is to start doing it.

So apply before you think you’re ready.
- Message that recruiter.
- Share your projects online.
- Ask for feedback.

Every rejection teaches you something your next “win” will need.

The "applying to jobs" part of becoming a Data Analyst is the longest and worst part. Start now and not when everything is perfect.


r/dataanalytics • • Jul 29 '26

My first ever dashboard - Your opinion on this?

Post image
97 Upvotes

Hey Guys,

I'm a medical coder transitioning into Data analytics. I've created a dashboard with power BI from scratch using a synthetic dataset. This is my first ever dashboard. Kindly share your review on this? Any tips or suggestions please!


r/dataanalytics • • Oct 20 '25

Roast My Resume for Data Analyst Intern

Post image
91 Upvotes

r/dataanalytics • • Sep 03 '26 Popcorn

What does a real Data Analyst actually do at work?

86 Upvotes

I am currently learning Data Analytics, and I want to understand what the actual job looks like in the real world.

Online, I mostly see people talking about SQL, Excel, Python, Power BI/Tableau, statistics, and building projects. But I’m curious about what Data Analysts actually do once they are working in a company.

For those who currently work as Data Analysts :-

\* What does a typical day or week look like for you?

\* What kind of problems do people usually come to you with?

\* What do you actually use SQL for?

\* How much Excel, Python, Power BI/Tableau do you use in your daily work?

\* How much of your time is spent cleaning data vs actually analyzing it?

\* Do you mainly create reports and dashboards, or do you also do deeper analysis?

\* How much do you interact with managers or other business teams?

\* Can you give an example of a real problem your analysis helped solve?

\* What are some things Data Analysts do that beginners usually don’t hear about?

\* How important is business/domain knowledge compared to technical skills?

I’d especially like to hear from people working in different industries such as healthcare, pharma, finance, marketing, retail, or tech.

I’m trying to get a realistic understanding of the job beyond courses and YouTube tutorials, so I’d really appreciate real-world experiences.


r/dataanalytics • • Aug 30 '26

Finally got a job after applying to 300 jobs

78 Upvotes

I’m a junior analyst with a solid understanding of the role and the work that comes with it, although I’m still developing my coding skills. I’m sharing this mainly to give people some hope.

About a month ago, shortly after having a child, I was laid off. The stress was overwhelming and i was praying daily for that stress to end, what helped me was spending more time studying the types of roles I wanted instead of immediately applying to every job I saw.

I used AI as a study partner and in a way, as a manager. I asked it to give me assignments, walk me through realistic scenarios, and help me better understand the processes and expectations of the job. It gave me a structured way to build my skills, gain confidence, and develop practical experience.

I recently landed a position with a robotics company, and the salary is twice what I was making before!

If you’re currently job hunting or trying to break into a new role, don’t underestimate the value of training with AI. Used thoughtfully, it can be an incredibly effective way to learn, practice, and prepare. Keep going!


r/dataanalytics • • Sep 05 '26

Applied to 100+ entry level analyst jobs, zero interviews

Post image
77 Upvotes

I been grinding out applications for months now, not even one callback. something's clearly wrong but idk what since I'm too close to it lol

go ahead and be harsh, I'd rather fix it now than keep getting ghosted


r/dataanalytics • • Sep 08 '26

Data Analysts vs AI — what actually makes a Data Analyst valuable in 2026?

76 Upvotes

I’m currently trying to understand where the Data Analyst role is heading with AI becoming capable of doing a lot of the traditional analyst work.

AI can already:

* Write SQL
* Clean and analyze datasets
* Create charts and dashboards
* Find trends and correlations
* Explain insights
* Help automate reporting

So I’m wondering: what actually makes a human Data Analyst valuable today?

If AI can technically perform many of these tasks, why would a company hire a Data Analyst instead of simply giving the data to an AI tool?

For people currently working as Data Analysts, Analytics Managers, BI Analysts, etc.:

What are the things you do in your job that AI still can't reliably replace?

And if someone is trying to enter the field in 2026, what skills would you prioritize to stay valuable alongside AI rather than competing against it?

Would really appreciate honest answers from people actually working in the industry.


r/dataanalytics • • May 29 '26

Is becoming a data analyst still worth it with Al doing so much now?

70 Upvotes

I'm 31, have some finance background, and I'm considering learning data analytics.

But honestly, with ChatGPT and Al tools doing more every day, I'm wondering if it's still worth the time.

Is there a future here, or will Al replace most of the work?
Id rather invest time in something with long-term potential.

Thoughts?


r/dataanalytics • • Aug 26 '26 Bravo

How should I go from learning SQL, Excel and Power BI basics to actually being job-ready for Data Analyst roles?

69 Upvotes

I recently started seriously learning data analytics and my goal is to become job-ready for entry-level Data Analyst roles.

So far I've completed Alex The Analyst's beginner/tutorial content for SQL, Excel and Power BI, including the guided projects.

For practice:

  • SQL: I've started solving Easy problems on DataLemur and some HackerRank, but I still struggle with figuring out the approach to a problem even when I know the individual SQL concepts.

  • Excel: I've practiced formulas/lookups and other exercises on Spreadsheet Center, but I'm not sure what the best way is to practice Excel in a more realistic analyst setting.

  • Power BI: I've completed the introductory project, but haven't done much independent practice yet.

I also plan to start learning Python for data analysis, but I don't want to fall into the trap of constantly watching tutorials without becoming good at actually using the tools.

For people currently working as Data Analysts or involved in hiring:

  1. How would you practice SQL, Excel and Power BI after learning the fundamentals?

  2. What level of SQL is realistically expected for an entry-level analyst interview?

  3. What Excel skills should I be able to use without assistance?

  4. How much Power BI/DAX/data modeling should an entry-level candidate know?

  5. Should I start Python now while continuing to practice these three, or get stronger at them first?

  6. What kind of independent projects actually help a beginner portfolio rather than looking like another tutorial project?

  7. If you were starting from this point today and trying to get hired in the current market, what would you prioritize over the next 1–2 months?

I'm especially interested in advice on how to develop the problem-solving/analytical thinking side, rather than recommendations for more beginner courses.


r/dataanalytics • • Aug 19 '26

Need guidance on becoming a Data Analyst in 2026.

69 Upvotes

Hi everyone,

I'd really appreciate advice from people who are working as Data Analysts or recently got hired. Any roadmap, study plan, or resources would be incredibly helpful.

I'm a BBA graduate(2023) trying to break into data analytics by SELF TAUGHT after a long gap.

Now it's 2026, AI is everywhere, and I'm honestly confused about what skills employers actually expect from entry-level Data Analysts.

My questions are:

1)Is it possible to become a Data Analyst through self-study when I have 3.5 yrs of a career gap?

2) What skills are essential for a Data Analyst in 2026?

3) Which tools should I prioritize more(Excel, SQL, Python, Power BI, Tableau, AI tools, etc.)?

4) How much Python is actually needed?

5) What AI skills are becoming important for Data Analysts?

6) What kind of portfolio projects should I build to get interviews?

7) Are certifications like the Google Data Analytics Certificate still worth it?


r/dataanalytics • • May 19 '26

Data Analysis vs Data Engineering vs Data Science & AI: Which Career Has the Best Future?

69 Upvotes

Between Data Analysis, Data Engineering, and Data Science & AI, which course offers the best career opportunities, salary growth, and future demand?


r/dataanalytics • • Jun 16 '24

I scraped all Data Analysis Interview Questions for Google, Amazon, Uber, Apple, etc. here they are..

69 Upvotes

Hi Folks,

I scraped, few thousand Data Analysis interview questions for Google, Apple, Amazon, Microsoft, Uber, Accenture on various sources - (github, glassdoor, indeed and etc.) After cleaning and improving these questions (adding more details, removing less relevant ones, and writing solutions), I’ve compiled around 100 interview questions, which I am publishing for free.

Disclaimer: I'm publishing it for free and I don't make any money on this.
You can check them out at prepare.sh/interviews/data-analysis

I plan to keep adding more companies and questions to cover most major tech firms, so it's a work in progress. If you find this content useful and want to help with code, content, or any other aspect, please DM me!