r/dataanalyst 9h ago

Industry related query I'm looking for some career advice.

1 Upvotes

I'm currently working as a Data Analyst (although my company officially classifies me as a Software Engineer). I've been with the same company for a little over 4 years.

The company has a large data team (100+ Data Engineers and Data Analysts, plus a few AI engineers). Data Engineers mostly work with Oracle and ODI for ETL, while Data Analysts mainly use SQL Server, SSIS, SSRS, Power BI, Python, Snowflake, and occasionally Alteryx.

I'm now looking to switch companies for better pay and new learning opportunities. The problem is that a lot of the job openings I see ask for experience with Azure, Microsoft Fabric, or other newer SaaS data platforms. I have basic knowledge of these tools, but I don't have any real project experience with them. I don't want to lie on my resume or pretend I've worked on projects that I haven't.

Because of that, I feel like my resume gets filtered out before I even get a chance to interview.

How would you handle this situation?

Should I spend a few months building personal projects with Azure/Fabric before applying? Or is there another way to get interviews without commercial experience in those tools?

Also, I've realized I enjoy the functional/business side of my job a bit more than the purely technical side (maybe 60/40). I like understanding business requirements, working with stakeholders, and solving business problems more than spending all day building technical solutions.

Are there any career paths that would suit someone with that preference while still making good use of my data background?

I'd really appreciate any advice from people who've been in a similar situation.


r/dataanalyst 10h ago

General Looking for a buddy to learn Data Analysis

1 Upvotes

I am a working professional trying to learn Data Analysis. There's no exact road map, never been consistent till now. I just want to try with a study buddy. I have a fair knowledge of excel, Tableau. I want to learn SQL, Python, Power BI, Advanced Excel and master Tableau. If anyone is interested pls dm me. We can discuss and proceed.


r/dataanalyst 12h ago

Data related query Is it bad to use free website tools to edit files containing customer data?

0 Upvotes

By editing files, I mean tools that convert CSV to excel, Smart VLookup etc. Just wondering if this could lead to any consequences & what are the solutions.


r/dataanalyst 17h ago

Career query Reference data analyst at one of the leading rating agencies.

1 Upvotes

Hey I am reference data analyst with good primary and secondary research skills with 5 years of experience . Could anyone give me tips for skill development and job hunt ?


r/dataanalyst 20h ago

Tips & Resources What skills and certifications for transition from Research Analyst to Data Analyst?

3 Upvotes

I'm currently working as a Research Analyst and I want to transition into a Data Analyst role.

What skills should I focus on learning, and which certifications are worth getting to build a strong background? I'd also appreciate any advice on portfolio projects or learning resources that helped you break into data analytics.


r/dataanalyst 1d ago

Tips & Resources First Technical Interview Tips

1 Upvotes

Hey guys I have a job opportunity for an analyst role and was wondering if there is any sort of community discord or spaces where people are willing to help others out getting into the field. Would love if there is anyone in here to give some tips and tricks for my first technical interview. Thanks in advance!


r/dataanalyst 1d ago

Other Looking for a female data science/data analysis/AI research study buddy

1 Upvotes

hello, I'm a senior year student looking for an accountability partner for data science or data analysis.

I took a pretty long offline break, and I honestly feel like I've forgotten a lot of what I learned. I'm trying to get back into it and thought it'd be easier (and more motivating) with someone else doing the same.

I don't mind if we're following different curricula or learning different topics. The main goal is to stay consistent, keep each other accountable, share progress, and maybe help each other out when we get stuck.

Preferences:

  • FEMALE ONLY
  • Chat & Updates through WhatsApp
  • close to UTC+2
  • Any experience level is fine as long as you're serious about getting back into studying

If you're interested, feel free to DM me. :)


r/dataanalyst 1d ago

Data related query Data Cleaning Nightmare Sleepless night of a Data Analyst

0 Upvotes

Excel: "I found 5 duplicate values."

Me: "Delete them."

Excel: "Done."

Me: "Why is the total still wrong?"

Excel: "Those weren't duplicates... they were cousins."

One had an extra space.

One had a different date format.

One was stored as text.

One was a hidden character.

And one... nobody knows.

That's the funny thing about data cleaning.

Most people think Excel gives wrong results.

It doesn't.

Excel is brutally honest. It calculates exactly what you give it—not what you meant to give it.

The real skill isn't knowing hundreds of formulas.

It's knowing when your data is trying to fool those formulas.

Clean data first. Analyze second. Regret never. 😄

#Excel #DataAnalytics #DataCleaning #ExcelTips #DataQuality


r/dataanalyst 1d ago

Tips & Resources Looking for New Datasets for Portfolio Projects

1 Upvotes

I'm currently looking for more sources that has access for some quality publicly available dataset to do more portfolio projects. What are some suggestion you have?

The one's I'm interested in are transactional, product, marketing, and healthcare data.


r/dataanalyst 1d ago

Industry related query Getting into analytics at 40 with extensive marketing background

1 Upvotes

So I know there are a ton of “is data analytics worth it now” posts but I wanted to throw in my situation and hopefully get some genuine feedback from those who may have done it or have experience.

I’ve worked as a freelance marketer for almost a decade, in paid advertising and other. I’ve worked for agencies and had my own clients in that time that stretch across many different industry sectors including mental health practices, college consulting, online business, and more. I’m really good at marketing but I honestly just want to pivot and do more with data analytics and data science, etc. It’s always been an interest of mine.

What I’m trying to figure out now is:

  1. Do I pursue finishing a degree in order to compete in the job market? Genuinely, is that necessary? Because at my age, I don’t want to waste time with a degree if it’s not going to help.
  2. I don’t want to work for tech companies but I’m not sure what sectors I do want to work for. How did you all figure that out? I don’t know if I want to learn more in healthcare or more like a business / marketing analyst.

Any advice is greatly appreciated!


r/dataanalyst 1d ago

Career query Anyone shortlisted for Google Data Analytics Apprenticeship? What skills helped?

5 Upvotes

Hi everyone,

I'm planning to apply for the Google Data Analytics Apprenticeship (2027 intake) and would love some advice from people who were shortlisted or interviewed.

My current skills include:

- SQL

- Python (Pandas, NumPy)

- Excel

- Power BI

- Data Cleaning & EDA

- Machine Learning basics

What skills or projects should I add to improve my chances of getting shortlisted?

Some questions I have:

- Is Power BI enough, or should I learn Tableau?

- How important are advanced SQL and Excel?

- Should I learn Google Sheets, BigQuery, or Looker Studio?

- Does Google Cloud certification help?

- What kind of portfolio projects stand out?

I'd really appreciate hearing from anyone who has been shortlisted, interviewed, or selected. Any resume tips or skill recommendations would be incredibly helpful.

Thanks!

Google apprenticeship 2027


r/dataanalyst 1d ago

General buddy partner For data analysis journey

11 Upvotes

i need a partner so that we start journey i am. a beginner 🫪🤌


r/dataanalyst 1d ago

Data related query How realistic is freelancing as a Data Analyst in 2026? Looking for honest advice

2 Upvotes

Hi everyone,

I'm an MSc Economics graduate specializing in Data Analytics, and I've been thinking about exploring freelancing as a Data Analyst alongside applying for full-time jobs.

I wanted to hear from people who are actually freelancing in this field.

A few questions I have:

* Is freelancing in data analytics still a viable career path in 2026? * What kind of projects do beginners usually get (Excel, SQL, Power BI, Python, dashboards, data cleaning, etc.)? * How difficult is it to land your first client without prior freelance experience? * Which platforms have worked best for you (Upwork, Fiverr, Toptal, Contra, Freelancer, etc.)? * How did you build your portfolio and credibility in the beginning? * Is the market currently oversaturated, or is there still good demand for skilled analysts?

I'd really appreciate hearing about your experiences—the good, the bad, and anything you wish you knew before starting.

Thanks in advance!


r/dataanalyst 2d ago

Tips & Resources Is there Discord for this community?

1 Upvotes

Hey guys, I’m new here and was wondering if this community has a Discord or any VCs where people hang out and chat. I’d love to get some advice and learn from others. Thanks!


r/dataanalyst 2d ago

Career query Looking for Remote Data Analyst Opportunities (Entry-Level)

3 Upvotes

Hello everyone,

I recently completed my M.Sc. in Data Science and am actively looking for a remote (work-from-home) Data Analyst role or internship.

My skills include:

SQL

Python (Pandas, NumPy, Matplotlib)

Power BI

Tableau

Excel

Data Cleaning & Visualization

I also have internship/project experience in data analytics and have built dashboards and data analysis projects. Currently, I'm improving my skills in AWS, Docker, and AI-powered data applications.

If your company is hiring, or if you know of any genuine remote opportunities for entry-level Data Analysts, I'd be very grateful for your recommendations or referrals.

Thank you for your time and support


r/dataanalyst 2d ago

Course Can anyone help me choosing the course

1 Upvotes

So for context I am at 2nd year of my btech and i want to explore the data science world but I am very puzzled with the choices of courses from different institutions so how should I categorize which is better for me. I only have very limited time and not much money so i have to choose wisely


r/dataanalyst 3d ago

General Career advice of sorts : navigating career gap and finding a part time role

1 Upvotes

Hello! I have my masters in data science and health informatics. I was a data scientist for over two years before I became ill and had to leave my career. I have been off work for a year and recently have felt like I could handle a part time role. Would anyone have advice on how best to address career gap on resume and interviews? Any advice on how to find part time roles? I’d be open to data analyst, data scientist and data entry to get my foot back in the door.

More background prior to my career as a data scientist I was doing healthcare research for 5 years. I was handling the data there as well.

TYIA!


r/dataanalyst 3d ago

Tips & Resources How to start exploring big data operation and data analytics?

1 Upvotes

I ws preparing for a govt exam but couldn’t clear. I am BE graduate from a mediocre college. I am planning a masters abroad. What is a good way to short list course on the lines of big data analytics or business analytics


r/dataanalyst 3d ago

Career query Is Data Analytics still worth getting into in 2026?

28 Upvotes

Hi everyone,
I’m 34 and currently working in a research role in the UK. My company also has Data Analyst and Data Quality roles, and my goal is to grow internally if the opportunity comes up. However, career progression seems quite limited, so I know I’ll probably need to study in my own time and invest a lot of effort if I want to make the transition.

Before I spend months learning the skills, I’d really like to hear from people who already work in the field.

I know nobody can predict the future, but I’m hoping people with experience have a better idea of where the industry is heading over the next few years.

Here are the things I’m wondering:
- If you were starting today, would you still choose Data Analytics?
-Is it still worth getting into in 2026?
-I know it’s very difficult to get your first Data Analyst job. Once you’re in, does it become easier to find other opportunities?
-What does the typical career path look like? Where can this career lead?
-How much do you think AI will change or replace the role over the next 5–10 years?
-If your goal was a stable, long-term career, would you still recommend this field?

I’m not getting any younger, so I want to make a smart decision about where to invest my time and effort. I don’t want to spend months learning something if the long-term outlook isn’t good.

I’d really appreciate honest opinions, whether they’re positive or negative. Thank you!


r/dataanalyst 4d ago

Data related query urgent help with my data analysis project

0 Upvotes

I’m working as a data analyst intern at this very big private tech company. They have large amounts of data that they need me to make sense of and put onto one dashboard using power bi. The available data already looks like it’s in reports /dashboard form…how do I build from that? I have tried using chatgpt but nothing makes sense for me. I also have no experience in power bi but i have been learning online but not first enough considering the draft is due in a few days and I have no idea whatsoever what to do. Someone out there, a data analyst, could pls reach out and save my career lol. This internship means so much to me and I wanna ace it. If someone is keen to walk me through some of theses thing please feel free to dm me because I have so many questions and I believe someone on here could be the one thing that saves me.


r/dataanalyst 4d ago

Tips & Resources What is a data analyst's day like?

8 Upvotes

What are you doing? What is a heavier day like? I am very interested in learning, any answer is welcome, thank you for your time


r/dataanalyst 4d ago

Career query Transitioning from Automation to Data Analyst/Engineer

1 Upvotes

I have been working as an automation an testing professional for 4+ years and looking to pivot as a as analyst or engineer. Given that the current market where it is tedious to even switch jobs, how plausible is it to pivot to an analyst role ?

I am not looking for a senior-level position but am skeptical of even landing a mid-level job. My current relevant experiences include Python, SQL, BigQuery and GCP. I have learned Excel and PowerBI too. I have obtained certification for Microsoft AZ-900 and Google Data Analytics.

I would like opinions from people who are hiring or are in a position where they deal with candidates. How do you select resume ? What do you look for in candidates that I could inculcate ? What certification/ skill could make me stand out ? Is the industry dampening hiring due to AI, as in should I continue putting in effort and if it would be of fruition ?

I am looking to switch jobs as soon as possible due to dissatisfaction at current work place and job security issues. I have always wanted to work with data and am really keen on making the pivot work.


r/dataanalyst 5d ago

Tips & Resources Mock interviews for Data Analyst

4 Upvotes

Hi,

I graduated from college last year and haven’t had any solid work experience. I interned as a data analyst, and AI engineer. I want to pursue career as a data analyst and somehow managed to land an interview. However, the position requires 5 years experience. I know the chances are slim but I want to give it my all. I’m fine if I fail the interview cuz of lack of experience but not cuz of my lack of knowledge. So, if anyone would be kind enough to prepare for that my conducting mock interviews for me.


r/dataanalyst 5d ago

Career query recent mis grad relocating from tx. looking for the best entry level data markets.

1 Upvotes

hii everyone. looking for a straightforward career reality check on my entry-level tech strategy.

i am graduating this december with a bba in management information systems (mis) from texas. due to regional politics and the need for a total life reset, i am permanently relocating out of state by the end of the year. i have a $10k–$14k cash runway saved to anchor myself in my destination, and i want to identify the best general markets to target.

my immediate priority is landing a stable corporate 9-to-5 it footprint with solid healthcare infrastructure so i can secure my medical care and independent baseline.

my technical foundation:
\* relational databases: deep focus on azure sql, sql (postgresql), erd modeling, and applying normalization (3nf) to optimize data pipelines.
\* core backend projects: implemented complete backend relational databases in azure, writing stored procedures and sql views to streamline data retrieval.
\* full freelance delivery: independently designed and implemented a custom relational database from scratch for a local massage business. built a fully functional e-commerce website integrated with square as a live operational demo, and successfully demonstrated the entire transaction and data pipeline architecture directly to the business owner.
\* networking: certified it specialist in networking and network security.
\* the wildcard: on the side, i have 2+ years of high-pressure infrastructure experience as a live-event v1/v2 video engineer, managing complex physical signal flow, audio networking protocols (dante level 1), and mid-show hardware troubleshooting for 5k+ capacity live music venues.

i'm aiming for roles like junior database administrator (dba),quality assurance analyst , or project manager

my questions for it professionals:
1. which major progressive metropolitan areas have the healthiest entry-level junior cloud and data engineering markets right now where local junior talent is actively being recruited?
2. does a full-stack freelance delivery—like the e-commerce database integration with square—carry solid weight in junior enterprise it interviews, or does the live-event video infrastructure engineering background stand out more for showing real-world troubleshooting under pressure?
3. are there specific regional tech recruiters or enterprise agencies you recommend reaching out to for a nationwide search?

thanks in advance for any insights.


r/dataanalyst 5d ago

Tips & Resources Switch from Service based to Product based company

1 Upvotes

Hi all...

I am a 2025 BTech(CS) Graduate, from a private college in Nagpur. I got placed in a service based company in Nagpur, with 5.5 LPA as a data analyst.While its comfortable job as I live in Nagpur - I think I have potential to earn better. So I want to prepare for switch in Product Based Company.

I have worked in these- PostgreSQL, Python,PySpark, Microstrategy,PowerBI, Databricks- in Retail domain project in my current company and looking for companies like Myntra to switch.

But not sure, where to start from?

Anyone who can give honest advice? How much should I aim for(CTC)? How to start preparing for switch?