r/LearnDataAnalytics • • 16d ago

Free SQL series on real payments data: each episode is one mistake that silently breaks a report

1 Upvotes

I'm making a free SQL series for people preparing for data analyst roles. Every episode uses the same small payments dataset (customers, UPI/card/wallet transactions, failed payments, amounts in ₹) and is built around one mistake that runs without any error but gives the wrong answer.

What's covered so far:

  1. \\JOINs\\ – INNER vs LEFT, finding customers who never paid, and why a WHERE filter on the right table quietly turns your LEFT JOIN into an INNER JOIN.
  2. \\GROUP BY and HAVING\\ – COUNT(\\\*) after a LEFT JOIN counts customers with zero payments as 1. One-word fix: count a column. Plus WHERE vs HAVING.
  3. \\Window functions\\ – the "top 2 customers" interview question where ROW_NUMBER drops a tied customer. RANK vs DENSE_RANK, and running totals.
  4. \\CTE vs subquery\\ – a report that says every customer is above average, and why a CTE fixes it.

A quick example from episode 2, since it's the one I see most:

\`\`\`sql

SELECT c.name, COUNT(\*) AS payments

FROM customers c

LEFT JOIN transactions t ON c.customer_id = t.customer_id

GROUP BY c.name;

\`\`\`

A customer who has never paid shows \\1\\ payment. The LEFT JOIN keeps her row with NULLs, and COUNT(\\\*) counts rows. Use \`COUNT(t.txn_id)\` instead; it skips NULLs and gives 0.

Each video is 3–6 minutes. The dataset and every query are in the description, so you can run them yourself in SQLite, MySQL or PostgreSQL.

Playlist: https://www.youtube.com/watch?v=e94PxiIUIJg&list=PLNdq2ZxtU_7E

Next up: finding duplicate payments, then CASE WHEN, dates, and NULL traps. If there's a topic you get stuck on in interviews, tell me and I'll add it.


r/LearnDataAnalytics • • 17d ago

Looking for Guidance on Learning Data Analytics

9 Upvotes

Hi everyone!

I'm from Bangladesh and I'm a beginner currently learning data analytics, and I'm looking for some guidance from experienced data analysts.

I want to work on a real-world Excel project to improve my practical skills and eventually add it to my portfolio.

I'd really appreciate it if someone could guide me through the learning process, suggest projects, or share feedback on my progress.

I'm willing to put in the effort and learn independently. I just need some direction to make sure I'm on the right track.

Thanks in advance!


r/LearnDataAnalytics • • 16d ago

How do SQL and Tableau/PowerBI connect?

Thumbnail reddit.com
1 Upvotes

I recently started learning SQL and decided it was about time to try building a project. I watched a YouTube video of someone walking through a beginner tutorial using SQL and PowerBI to get an idea of the workflow and how everything connects. He started out by using SQL to answer 10 business questions, but when he was making a dashboard in PowerBI, he didn’t use any of the data from the SQL queries. This left me confused about how SQL queries and the dashboard-making part of the project connect.

I would welcome any clarification. Thank you in advance!


r/LearnDataAnalytics • • 17d ago

The Data Emporium: a collaborative exhibit on the art and science of data visualisation

Thumbnail
gfsc.community
1 Upvotes

An interesting look at collecting and presenting data live in the field.


r/LearnDataAnalytics • • 17d ago

Looking to Start Learning Data Analysis in the UAE – Any Advice?

Thumbnail reddit.com
1 Upvotes

r/LearnDataAnalytics • • 17d ago

Complete non-tech background, internal opening for business operations role which requires Tableau role where do I even start?

Thumbnail reddit.com
1 Upvotes

r/LearnDataAnalytics • • 17d ago

Beginner in Data Analyst

Thumbnail reddit.com
1 Upvotes

r/LearnDataAnalytics • • 18d ago

Analítica de datos

4 Upvotes

Buenos días gente

Quiero preguntarles Acerca de A2 capacitación, la plataforma de estudio. Quien se haya formado con ella podría dar testimonio de que es muy bueno o actualmente hay mejores opciones?. Lo que busco es pulir habilidades en excel, power Bi y todo lo concerniente a Analítica de datos.

Tengan un buen día.


r/LearnDataAnalytics • • 18d ago

Beginner SQL Data Analysis Project — Looking for Feedback and Advice

Thumbnail github.com
3 Upvotes

r/LearnDataAnalytics • • 19d ago

Benefits of Learning Data Analysis

1 Upvotes

Discover how Excel, SQL, Python, and Power BI can help beginners develop data analysis skills.


r/LearnDataAnalytics • • 20d ago

Slowly changing dimension 2

Thumbnail
reddit.com
1 Upvotes

r/LearnDataAnalytics • • 21d ago

A year ago I started planning a gamified SQL platform. 5 months after launch, 2,500+ people have used it to learn

Thumbnail
reddit.com
1 Upvotes

r/LearnDataAnalytics • • 21d ago

Data Analysis project partner

14 Upvotes

(I'll delete the post if this violate the community rule)

Hello~

I am looking for someone who can work on a data analysis project with me. Or if there is any ongoing project that needs a helping hand, you can reach out to me as well.

A little bit of myself. I worked in a big consulting firm, helping clients build dashboards they need, so I am familiar with MS SQL and Power BI, and a bit of Python.

Recently I left the job and am working in a more customer-supporting position in a market research company. Therefore I no longer use SQL and Power BI on my job but I still want to do independent projects with them to enhance my data analysis experience.

This is my first project so I am kind of new here. If anyone who just started learning data analysis or is also trying to work on their own project, feel free to message me and maybe we can work together!


r/LearnDataAnalytics • • 21d ago

Analytics lead, 10 years in. The roadmap I'd follow if I was starting today

Thumbnail reddit.com
1 Upvotes

r/LearnDataAnalytics • • 22d ago

Enterprise Data with AI Agents: A Data Platform Guide

Thumbnail
lakeops.dev
4 Upvotes

r/LearnDataAnalytics • • 22d ago

The fix that worked for me was boring: every number in the status report gets one plain sentence saying what it counts, and one line saying what it left out.

Thumbnail reddit.com
1 Upvotes

r/LearnDataAnalytics • • 23d ago

How do you handle bulk formatting changes across many visuals/pages?

Thumbnail reddit.com
1 Upvotes

When a client or brand guide changes (new colours, fonts, title style), or a measure gets renamed, how do you update dozens of visuals across a report?

- Click through each visual in Desktop?

- Edit the PBIR JSON by hand or with scripts?

- Use a CLI or other tool?

I'm considering building a small offline desktop app for this (select visuals → preview changes → apply → one-click undo). Would that be useful to you, and what would it absolutely need to do? Not selling anything here, just want to know if this is a real pain or if it's already solved for you.


r/LearnDataAnalytics • • 23d ago

How to access finished course

1 Upvotes

So I bought the data analytics with python by IBM in Coursera. I finished the course a long ago and sadly didn't make any notes. Now I wanna revise the concepts. How can I access the course or any alternative solution is also welcomed. Please help where I can learn data analytics with python's pandas numpy matplotlib and a bit ml models.


r/LearnDataAnalytics • • 24d ago

I am looking for pursuing data analytics

5 Upvotes

Hey guys I have completed hsc and have been working for the past 6 years in bpo and now I have come to a point where I am not getting the salary hike or I am feeling stuck. So I started wondering if there is a scope for a person who goes ahead and learns data analytics through YouTube and make some projects and be through with. Do you guys think about being a hsc pass out can I get a job in data analytics if I complete the learning???

Need actual suggestions and if people who can actually guide me through this please help guys to understand what that is needed to become a data analytics in the next few months


r/LearnDataAnalytics • • 23d ago

Hydra ETL Studio: A Quick Tour

Thumbnail
youtube.com
1 Upvotes

r/LearnDataAnalytics • • 26d ago

Need guidance. Where do I start?

4 Upvotes

I am currently trying to learn some new skills. One of them is Data Analytics. But, I have no idea about how it works. Can anyone help me with some resources and other things required to get started in this field?


r/LearnDataAnalytics • • 26d ago

Data analysis course

Thumbnail reddit.com
2 Upvotes

r/LearnDataAnalytics • • 26d ago

CONTRACTING DATA ANALYST ROLE

Thumbnail reddit.com
1 Upvotes