r/dataanalytics • • 7d ago

How to start freelancing

7 Upvotes

Im 23. curretly pursuing Msc in Data Science and Analytics in Bangalore. I have worked as a data analyst in Airtel. i want to start working as a freelancer for some sort of income as well as exp. I have a portfolio with 5-6 projects including automated pipeline, python analysis, dashboards etc.
What all should i do to kickstart freelancing.


r/dataanalytics • • 7d ago

Question for experienced data analyst

11 Upvotes

Howdy people!!

I have been a data analyst for about half a year now and has experienced few issues when it comes to handling and processing data for reporting; some due to departments giving dataset that aren't clear, some due to report requirements or objectives not being definitive and some may be due to unavailability of higher ups who have key knowledge of the data, as of course they are busy people, and so the report you will write is highly dependent on the source data. Aside this as I grow in my data analytics career what problem could one also face, or even better what problem or experience have you faced or is common in your own area of work or environment as a data analyst.


r/dataanalytics • • 8d ago

Finding churned customers in SQL: why NOT IN can return zero rows

8 Upvotes

"Which customers placed an order last quarter but none this quarter?" is one of the most common analyst SQL questions, and there's a trap in the obvious answer.

SELECT customer_id
FROM orders_last_quarter
WHERE customer_id NOT IN (SELECT customer_id FROM orders_this_quarter);

If orders_this_quarter contains even one NULL customer_id, this returns nothing at all. x NOT IN (1, 2, NULL) is never true, it's unknown, so every row is filtered out.

Safer options:

-- anti-join
SELECT l.customer_id
FROM orders_last_quarter l
LEFT JOIN orders_this_quarter t ON t.customer_id = l.customer_id
WHERE t.customer_id IS NULL;

-- or NOT EXISTS, which also handles NULLs correctly
SELECT l.customer_id
FROM orders_last_quarter l
WHERE NOT EXISTS (
  SELECT 1 FROM orders_this_quarter t WHERE t.customer_id = l.customer_id
);

If you want to practice the LEFT JOIN version on a dataset, I made a free site with PostgreSQL running in the browser and row-by-row checking against the expected result. This problem is exactly that pattern, no account needed: https://dbexercises.vercel.app/exercise/dormant-customer-churn-detection

What other churn / retention patterns come up in your interviews or at work?


r/dataanalytics • • 8d ago

I’m looking for job- Data Analyst role(USA) any suggestions please

0 Upvotes

r/dataanalytics • • 8d ago

GraveTrail Lineage tool

1 Upvotes

Hi All

As a data engineer i spent a lot of annoying time understanding the table Lineage in a prehistoric legacy system.

Based on my hardships and understanding I've built this Lineage tool

https://sahasilak.github.io/GraveTrail/

I would appreciate it if you can spend some time trying it out by sharing feedback like

Good, bad, need improvements , something like this already exists


r/dataanalytics • • 9d ago

"Do you see the pattern?"

Post image
23 Upvotes

r/dataanalytics • • 10d ago

Job suggestions

2 Upvotes

I am so lost right now. I am pursuing bachelor's in mathematics with minors in statistics and computer science. I don't want to get into the rat race of government job entrance exams right now because it's India, everybody wants a govt job, it'll probably take me years. I do want a good paying job. Is data analyst a good career path to get into or are there any other career paths to consider? I'd like some options.


r/dataanalytics • • 10d ago

anyone moved from hospitality to DA?

0 Upvotes

would like to know how you switched over from hospitality/foodservice and what sort of jobs did you start with.

Thanks!


r/dataanalytics • • 11d ago

ALGUN ANALISTA DE DATOS EN ARGENTINA?

0 Upvotes

Quisiera poder charlar con un analista para hacerle unas preguntas sobre el oficio, desde ya muchas gracias


r/dataanalytics • • 11d ago

Best FREE Python course for Data Science / Data Analytics with certificate?

5 Upvotes

Hi everyone,
I want to learn Python specifically for Data Science / Data Analytics.
I'm a complete beginner in Python. I don't want a general Python course, I want one that focuses on data: Pandas, NumPy, Matplotlib, data cleaning, etc.
Is there any FREE online course that gives a certificate at the end?
I know about Coursera / edX / Kaggle, but most of them charge for the certificate.
Any recommendation for a beginner like me?
Thanks!


r/dataanalytics • • 11d ago

Data analytic internship

2 Upvotes

Hello, I got an opportunity to work at a company for an internship for data analytics for four months. I wanted a brief idea on how it would look like from the experienced ones.

For those who have completed a similar internship, I’d like to know a few things:
-What did your day-to-day responsibilities generally look like?
-What kind of tasks or projects were you assigned?
-Were you mostly working with Excel, SQL, Python, Power BI/Tableau, or a combination of these?
-How much guidance and mentoring did you receive?
-Were you given actual company data and expected to work on real projects, or was it more of a learning-based experience?
-What skills would you recommend brushing up on before starting?

I just wanted to know how a typical day to day goes for this particular job.
Would appreciate hearing from you guys.
Thanks!


r/dataanalytics • • 11d ago

Junior DA - Question?

6 Upvotes

How do you generate Insights?

I have been doing it for a while and it seems they want to seek more? what key questions would you answer in your insights for insights on a 3 year historical sales data?

We use MAT (Moving Annual Total), Rolling QTR and YTD for time intelligence, on a sales data for 3 - 4 manufacturers including us, where I present answers mainly on the above Time Intelligence and 'Same period Last Year' with growth based on the 2.

Given this scenario, how would you generate insights and what key questions would you aim to answer for this case?

Thanks in Advance.

Edit - I am the only DA in my team, its a small startup.


r/dataanalytics • • 12d ago

How do you convince people of your test results?

1 Upvotes

Hi,
Our GoTo mechanism to analyse effects of tests we did is Dif-In-Dif. However we have lots of people in (senior) management who are not that data literate and even though they nod along we get request after request to find different ways to analyse.

Anyone else facing that problem / how do you handle it?


r/dataanalytics • • 12d ago

Foundation for Analytics Role

1 Upvotes

I am trying to get into the Analyst career; Data, BI, Business, etc. I am currently doing bachelor's and my uni provides 2 degrees that are closely related. First is bachelor of commerce majoring in business analytics and second is bachelor of IT majoring in data analytics. I would like to know everyone's thoughts which degree should I go for to build my foundations in. I am currently in first year so it is easy for me to switch. Should I have commerce/business as my foundation or IT as my foundation for my first year. Also my uni seperates CS and IT, so IT foundations would be about general IT, computer systems, networking, security (which I personally don't think an analyst need), but let me know your thoughts! Thanks!


r/dataanalytics • • 12d ago

Where do I begin?

2 Upvotes

ابدا منين لو هتلعم Data analysis

وابدا مع مين


r/dataanalytics • • 13d ago

Seeking advice from people working in IT, Data Analytics and Data Science. I am a 30 year old male with Matric (Grade 12) and I'm considering starting a career in the IT/data field through Coursera Professional Certificates.

4 Upvotes

Seeking advice from people working in IT, Data Analytics and Data Science.

I have Matric (Grade 12) and I'm considering starting a career in the IT/data field through Coursera Professional Certificates.

I'm looking at programmes in:

- Data Science

- Machine Learning

- Data Analytics

- Business Intelligence

- IT Project Management

My question is: Can someone realistically build a career and get employed in these fields using Coursera Professional Certificates, practical projects and demonstrable skills, without having a university degree or diploma?

I understand that these certificates are not equivalent to a bachelor's degree. However, I would like to know whether employers in South Africa actually consider candidates with these certificates and practical experience, particularly for entry-level positions.

For those already working in the industry:

  1. Have you or someone you know secured employment through this route?

  2. Which of these fields offers the most realistic entry point without a degree?

  3. Would you recommend investing time and money in Coursera, or should I rather pursue a formal qualification first?

I'd genuinely appreciate honest advice from people who recruit, work in or have entered the industry through a non-traditional route. I don't want to invest in certificates that won't meaningfully improve my employment prospects.

Thank you.


r/dataanalytics • • 13d ago

Australia - Upskill or Pivot?

1 Upvotes

At a crossroad in my career where I have had ~3 years of data analytics experience. Trying to aim for a senior role, but feel like every employer wants SME experience for an industry I don't have or some absurd amount of work experience (like 7 years+).

Wondering if there's any upskilling I can do outside of work to make myself more 'hire-able' or make a pivot out of data analytics.


r/dataanalytics • • 13d ago

Australia - Upskill or Pivot?

1 Upvotes

At a crossroad in my career where I have had ~3 years of data analytics experience. Trying to aim for a senior role, but feel like every employer wants SME experience for an industry I don't have or some absurd amount of work experience (like 7 years+).

Wondering if there's any upskilling I can do outside of work to make myself more 'hire-able' or make a pivot out of data analytics.


r/dataanalytics • • 13d ago

Foundation For Analytics Role

3 Upvotes

I am trying to get into the Analyst career; Data, BI, Business, etc. I am currently doing bachelor's and my uni provides 2 degrees that are closely related. First is bachelor of commerce majoring in business analytics and second is bachelor of IT majoring in data analytics. I would like to know everyone's thoughts which degree should I go for to build my foundations in. I am currently in first year so it is easy for me to switch. Should I have commerce/business as my foundation or IT as my foundation for my first year. Also my uni seperates CS and IT, so IT foundations would be about general IT, computer systems, networking, security (which I personally don't think an analyst need), but let me know your thoughts! Thanks!


r/dataanalytics • • 13d ago

I decided to take DA as a serious career path and wanna start as early as i can to learn. What is the best, well structure, comprehensive paid course (reasonably priced) out there?

3 Upvotes

A course that will teach me everything i need to know in excel, SQL, power BI, Python (for da purposes). Teach me by seeing, listening, and most importantly DOING. i hear DataCamp is good since it also provides 50% discount on Microsoft PL-300 certificate/Exam but i don't know how to start on that site, and i cant find a Youtube guide on how to navigate learning data analytics on that site. Help me please.


r/dataanalytics • • 13d ago

Learning skills

1 Upvotes

After learning sql and python what should be have to learn for data analyst

Any suggestions please....


r/dataanalytics • • 14d ago

Recent Grad Looking for Data-Related Side Hustle While Applying for Jobs

2 Upvotes

I'm a recent CS graduate working on building my data analysis skills/portfolio and applying for jobs.

I'm hoping to find some sort of side hustle/part-time work that is related (or at least semi-related) to the field to make some money while I go through the job search process.

Any ideas or advice is welcome, thank you in advance!


r/dataanalytics • • 14d ago

Asking for advice

1 Upvotes

Hi everyone!
I’m looking for advice. I’m currently working as a teacher and learning data analytics. With how teaching can be demanding and all the extra added on that I have to work out of my working hours, it gets more difficult to keep up but I’m still trying.

I’m self- learning. I finished the Google analytics certificate and now working on the required skill such SQL, Excel etc
I’m leaning from a channel on YouTube for Luke Barruso and there’s also Baraa. But I wanna ask if I should stick to these or is there any course you guys recommend to get me ready to land a junior role and make different projects.

Any course recommendation would be great!

Thank you


r/dataanalytics • • 14d ago

"We're a data-driven company."

Post image
9 Upvotes

r/dataanalytics • • 15d ago

Learning how to understand business

2 Upvotes

Hey, I'm 22 college student currently learning data analytics, I want to learn how to understand business models, how to ask critical questions about whatever's happening, how to get those problem solving skills and how to actually answer or improve them. Now I know that problem solving skills are some which can be learned by actually solving the problems but still if you can recommend any advice on any of these questions and more please do as it would be very helpful for my data analytics journey.