Put together this one-page SQL revision sheet for analyst interviews.

I tried to cover the things that tend to matter beyond just remembering syntax: joins, aggregation grain, NULL handling, CTEs, window functions, common interview patterns, and mistakes that can quietly give you the wrong result.

For people who've actually done data analyst interviews, what SQL topic or question pattern would you add?

I’m currently trying to pursue a career in Data Analytics, but I’m feeling pretty demotivated after a conversation I had recently.

Someone I know already works in this field, and when I told her that I’m learning Data Analytics, she pointed out that I don’t have a relevant IT/CS degree and I don’t come from a strong mathematics background.

She told me that getting a job would be difficult for me and that I shouldn’t waste too much time on this, especially because spending years learning this without a relevant degree could create a gap in my education/career.

Now I’m genuinely confused.

I’ve already started learning SQL and I’m planning to learn Python, Pandas, statistics, data visualization, and eventually work on real-world projects and build a portfolio.

I’m not expecting to become a Data Scientist immediately. My initial goal is to become employable as a Data Analyst and then grow from there.

For people who actually work in Data Analytics:

• How important is having a CS/IT/Statistics/Math degree for getting your first Data Analyst job?
• Can someone from a non-math/non-CS background realistically break into the field?
• How much math do you actually use in your day-to-day work?
• Can strong SQL, Python, statistics, projects and a good portfolio compensate for not having the “right” degree?
• Is this realistically worth pursuing, or am I setting myself up for a difficult job search?

I’d really appreciate honest answers, even if the answer is not what I want to hear. I’m trying to make a realistic decision about where to invest the next few years of my life.

How screwed am I in this market? I’m trying to transition into analytics; I have some prior tech experience—though I currently work in Ops—and I’m also pursuing a master’s degree at a good university. I’ve been trying to apply for internships, but given the current state of things, the very act of applying feels like a waste of time. What are the prospects for someone with my profile?

For context, I am just entering the final year of my undergraduate degree in statistics and data science at a T30 university in the U.S.. Unfortunately, I did not get an internship in analytics, but I did have 2 software developer internships at a small company (same place both times) that I got via family connections.

I initially thought this experience would prove beneficial in my job search, but I am starting to get concerned that I won’t seem very employable for data analyst or similar roles.

Realistically, would I be able to get a data analyst position as a new grad only having internship experience in software development? If not, what other fields/positions would I be able to get hired in as new grad with my degree and experience that would allow me to transition to analytics (preferably something that uses statistics or data)?

​

I’ve created two versions of my resume for Data Analyst roles. Could you please compare them and let me know which one is better and what improvements I should make?

Would really appreciate your honest feedback! 🙌 Even small suggestions would be helpful. Thanks in advance!

Hi fellas!

I'm going into my final year at college and now applying for new grad data analyst roles. Haven't gotten any interviews since July (previous interviews were for intern roles).

I still apply for summer 2027 internships by switching the graduate date to Dec 2027, since I can delay a quarter to graduate. And will continue working remotely (part-time) for the public transit company over school year.

I'm trying to look for roles around Washington / California. Would love to hear any advice that can make my resume more outstanding!

Thanks everyone

I know I am cooked 😵 but what can be done to land an entry level daa analytics job or internship?

I have a B.Pharm background and I'm currently considering a transition into Data Analytics.

I'd especially like to hear from people who also come from a B.Pharm or pharmaceutical background and have successfully moved into Data Analytics, Healthcare Analytics, Pharma Analytics, Clinical Data, Business Analytics, or related fields.

I'd like to know:

How did you transition from B.Pharm into Data Analytics?

Did your pharmaceutical background help you get your first job?

Which skills were actually important for getting hired — SQL, Excel, Power BI, Python, Statistics, etc.?

Did you initially target pharma/healthcare analytics roles, or did you apply for general Data Analyst positions?

How difficult was it to get your first job or internship?

What did you wish you had learned earlier?

Do you think this is a realistic and worthwhile career path in India in 2026?

I'm particularly interested in real experiences rather than generic advice. If you're from a B.Pharm background and made this transition, I'd really appreciate hearing about your journey.

Thanks!

I am currently not working and applying full time, with no luck over a 100+ applications. Would like some advice to know where I am going wrong.

Target roles: Data Analyst, BI Analyst, and reporting or analytics engineering roles where the work is closer to SQL, data quality and the semantic layer than to modelling. I keep a separate Data Science CV for DS roles since I have experience with ML and DL as well. This is the analyst version.

I would like feedback on the experience bullets, the technical skills, and the resume as a whole.

Thanks in advance to anyone who takes the time.

Here is my resume: https://docs.google.com/document/d/1i-Umef5gEsdrzEvgKsRQr_J4bWLIT2pk/edit

I have a decent-sized career gap where I am only working part-time as a tutor. What can I do to improve my resume? Is it okay as it is now?

unlike many people here wanting to be Data Analyst, i’m quite the opposite. I’m always stressed and anxious. Most of the time the data is so messy and nowhere to be found while stakeholders are waiting and pushing to have reports ready. I hate talking in front of people, doing presentations in front of 60+ people. Having to always clean up, dealing with business people and explaining simple stuff while they’re already angry. Then having to set KPIs, targets, that takes months.
I’m working as DA for huge corporate. Maybe that doesn’t help.

Anyone who left DA, what made you decide it was a good move? And why you left?

I’m trying to leave, but haven’t had much luck yet getting a new job.

Hi Myself M(26) from Pune, Maharashtra.
I am actively looking for a data analyst job, and for that I'm continuously applying through Naukri, Foundit, Indeed and LinkedIn. Today I got a call in which a woman said she was calling from AAI(AIRPORTS AUTHORITY OF INDIA) and there are several openings for IT and non-IT profiles. As I spoke further, she said they have many openings for Data Analysts throughout India. At first, I thought it was a legit call, but when I asked Where did you get my profile, as I didn't remember applying for AAI, she said through an online portal. As I got a little curious and asked one more time, like, "Can you tell me the exact platform?" she fumbled. At this point, I knew something was fishy. She said we're offering you around 40- 45 K in-hand salary, and for that, you have to give an online interview. The first round will be telephonic, the second online interview and if needed, you have to come for a face-to-face interview. I said yes to that. Then she said that, as your profile is not registered and is non-referral, you have to pay Rs 1200, which is refundable if you fail the interview.
At this point, I was convinced that this is a SCAM. So I said that this seems like a scam and you're looting money from people which is desperately looking for a job. She said, " No, sir, you can check the AAI website and all." As I told her, after checking there so such job openings on the official portal, and I started confronting her. I told her this way is not gonna work; she cut the call.
I want to tell you pls be aware of such fraud calls and fake job offers; there are plenty of them in the market. I already worked with 2 companies in the past, so I know nobody asks for money or fees that are refundable if you didn't get selected for a job when they're calling you from a company. People like me who are desperately looking for a job are their main target, as we don't think that much when we get a call for a job due to excitement.
So be aware.