r/LearnDataAnalytics

I've been building a SQL learning platform for the past few months. It's called QueryCase and I'd love honest feedback
▲ 152 r/LearnDataAnalytics+44 crossposts

I've been building a SQL learning platform for the past few months. It's called QueryCase and I'd love honest feedback

I've spent the last few months building something and I'm finally at the point where I want to share it properly rather than just quietly hoping people find it.

The idea came from a frustration I kept seeing (and feeling myself): SQL tutorials teach the syntax fine but there's never a reason to care about the answer. You filter a table called employees, get a result, and nothing happens. Your brain doesn't bother keeping it.

I wanted to try a different approach. QueryCase teaches SQL through detective investigations. You get a briefing from Chief Fox (our mascot), a real database to query, and a mystery to crack. The JOIN matters when a suspect has an alibi. The WHERE clause matters when you're trying to find who entered the building at 22:13. The SQL is the tool for solving something, not the point in itself.

Here's what's actually in it:

  • A structured learning path across 54 cases, going from Recruit through Rookie, Detective, Senior Detective, and Chief Detective. Each rank has drills and a level exam to pass before you progress.
  • Sandbox mode where you can explore real datasets (IMDB movies, Spotify, sports stats, Steam games) and run whatever you want with no pressure and no mystery attached. Just free exploration against actual data.
  • Everything runs in the browser using DuckDB WASM so there's nothing to install.

I'm a solo developer and this is genuinely early days. I'm sharing here because this community is exactly the kind of people I built it for, and I'd rather get honest feedback now than find out later I've built the wrong thing.

What's missing? What would make you actually stick with something like this versus what you've used before?

querycase.com if you want to take a look.

Any feedback appreciated!

u/conor-robertson — 3 days ago
▲ 1 r/LearnDataAnalytics+1 crossposts

Title: How I Used Data Analytics to Audit an Agency Making 187M DZD (~$1.4M) and Uncovered Major Budget Bleeding (Full Case Study Breakdown) !?

Hey everyone,

I wanted to share a recent marketing audit I conducted for a travel agency here in Algeria. The agency was doing high gross numbers—over 187M DZD (around $1.4M USD) in a single season across roughly 100 trips. On paper, they were crushing it. But behind the scenes, they were suffering from what I call "operational blindness"—spending heavily on Meta ads without a clear picture of which segments or seasons were actually driving true profitability.

I extracted their raw data, cleaned it up, and built a dynamic dashboard to isolate the variables (segmenting by quarters, age groups, geography, and family vs. individual targets).

Here are the 3 major insights that completely flipped their marketing strategy:

The Seasonality Flip: "Individuals" (youth) peak sharply during off-season months (January & October) to catch low-cost travel deals. Meanwhile, "Families" strictly travel during official school holiday windows (March, July/August, and December).

The June Black Hole: Family revenue drops to near zero in June. In Algeria, this is high-stakes national exam season (Baccalaureate & BEM), meaning families freeze all non-essential plans. Advertising to families here is a complete waste of budget.

Families = Higher ROI, Less Hassle: Even though the agency ran fewer family trips (46 vs. 54 individual trips), families generated higher total revenue (99M DZD vs. 88M DZD). The average cart value and profit margin per seat are significantly higher because families buy premium, all-inclusive packages.

📊 Full Case Study PDF & Visuals

I’ve put together the entire breakdown, including the data methodology, the exact dashboard visuals (Q1-Q4 filters), and the strategic recommendations into a clean PDF Case Study.

If you want to see exactly how to turn raw agency data into actionable media buying decisions, you can download the full PDF guide send me massage

💬 Let's Discuss:

For those managing service-based clients or agencies: How often do you deep-dive into client CRM data before setting up your ad sets? Are you seeing similar strict seasonality traps in your local markets?

Drop your thoughts or questions below—happy to talk shop and share analytics insights!

TL;DR: Agency was grossing $1.4M but burning cash on generic ad targeting. Audited the data, found that families spend more on fewer trips and that June is a dead month due to school exams. Rewrote their media buying playbook based on seasonal data. PDF guide attached.

reddit.com
u/othman_mark — 2 days ago
▲ 7 r/LearnDataAnalytics+2 crossposts

Resume review

I'm a 2024 BBA graduate transitioning into Data Analytics and applying for entry-level Data Analyst roles in India. I've built projects in SQL, Python, Excel, and Power BI, but I'm not getting as many interview calls as I'd like. I'd appreciate honest feedback on my resume.

u/Plastic-Buddy6324 — 3 days ago
▲ 16 r/LearnDataAnalytics+1 crossposts

Which data analytics course/ certificate should I do as an absolute beginner?

A lot of online courses and resources are available. I am an absolute beginner and have no background in computer science/ IT/ maths (just the barely basic stuff till class 10th) but I want to learn these skills in a way which can eventually help me earn. I came across Coursea Google Data Analytics course but then saw courses by other platforms too.

So which one shoul I go ahead with? And how should I plan this to make an earning out of it? Any other courses I should keep an eye out for?

reddit.com
u/aliiphatic — 4 days ago

Data analytics CodeWithHarry ?

Thinking of buying data analytics course of CWH,

IS IT WORTH OR NOT ? , Job ready or just fluf ?

Rate it out of 10.

Any other better suggestions ?

reddit.com
u/badmaas7 — 5 days ago
▲ 10 r/LearnDataAnalytics+2 crossposts

Job Market Situation for Data Analyst hiring

What is the current job market situation for Data Analyst and what are the expectations in terms of skills from a 4-6 years experienced candidates in interviews.

reddit.com
u/Happy_Human159 — 6 days ago

Strategy on Learning Data Analytics

Hi, everyone!

I am a full time office employee trying to upskill in Data Analytics. My niche is in biological sciences research and agriculture industry and I would like to build up on what I know so far about data analysis by learning more about:

- Excel

- SQL

- Python

- R

Planning to watch/finish 1-3 modules or vids per week and accomplish 1-2 exercises using real data from my previous projects.

Can you share your thoughts about my plan? Thanks in advance!

reddit.com
u/Background_Fox_4494 — 5 days ago
▲ 8 r/LearnDataAnalytics+2 crossposts

serious career advice from experienced Data Analysts / Data Engineers / AI folks

Feeling stuck in my current non-technical role after 5 years of experience. I want to switch into Data Analytics/Data Engineering + AI, but I want to learn in a way that makes me capable enough to match someone with 3–4 years of actual data experience.
Would really appreciate advice from people already working in data.

reddit.com
u/SavageJJ17 — 7 days ago
▲ 6 r/LearnDataAnalytics+1 crossposts

Building NetSuite experience — offering FREE functional consulting help while I grow my skills

Hi everyone,

I'm relatively new to NetSuite (under a year of hands-on experience) and looking to build real-world experience and expand my network while I work toward landing a full-time role. To that end, I'm offering free NetSuite functional consulting help to anyone who could use a hand — small businesses, fellow consultants overflow work, or anyone testing things out in a sandbox.

Things I can help with:

  • Saved searches and financial report customization
  • Data migration / CSV imports (and troubleshooting failed imports)
  • Advanced PDF/HTML templates (BFOs) customization
  • SuiteFlow workflows (approval routing, automated field updates, reminders)
  • Role and permission setup/troubleshooting
  • Custom fields, forms, and record customization
  • Dashboard and KPI setup
  • Basic SuiteScript troubleshooting (reading error logs, simple script tweaks)
  • Vendor/customer record cleanup and deduplication
  • User access reviews and basic security review
  • Subsidiary/intercompany setup support (OneWorld basics)
  • Item record setup and inventory basics
  • Approval routing for POs/bills
  • Basic reconciliation report building
  • Advanced Revenue Management
  • SuiteBilling

I'm doing this purely to build my portfolio and references, not for pay, so happy to work within a sandbox/test environment if you're not comfortable giving access to production. I'll also be transparent that I'm still learning, so this is best suited for non-urgent or lower-risk projects.

If you have something you've been putting off or need a second pair of hands on, feel free to comment or DM me. Thanks for reading!

reddit.com
u/Learn_110 — 6 days ago
▲ 3 r/LearnDataAnalytics+1 crossposts

Non-it background to Data analysis.

Hello all, so from the last 10-12 days i am thinking to learn and switch into technical background. I am a Microbiology graduate. And the salary in this field even after 5-10 years of experience seems so less. As a man handling whole family with that salary seems impossible. So now i need your help. Is it right time to switch to technical background. I am desperate and ready to give my most. I just need your suggestions.

reddit.com
u/Limp_Bed430 — 7 days ago

YouTube vs Paid Course: Which is better for learning Data Analysis?

Hi everyone! I need some advice.

​

I want to become a Data Analyst, but I'm confused about the best way to learn.

​

Which is better?

​

  1. Learning Data Analysis from YouTube (free resources), or

​

  1. Joining a paid institute/course?

​

If you've learned Data Analysis or are working as a Data Analyst, I'd really appreciate your advice. Which option helped you the most, and why?

​

Thanks in advance! 😊

reddit.com
u/VIKRAM_1243 — 9 days ago
▲ 15 r/LearnDataAnalytics+4 crossposts

Data Analytics

Hello!

I want to start my journey in Data Analytics, but I'm not sure where to begin. Since you have experience in this field, I would really appreciate your guidance.

Could you please suggest a roadmap for beginners? I'd like to know:

  • Which skills I should learn first.
  • What tools and programming languages I should focus on.
  • Which projects I should build.
  • Any courses or resources you recommend.

Your advice would mean a lot and help me start in the right direction.

Thank you!

reddit.com
u/No-Cranberry-6881 — 10 days ago
▲ 43 r/LearnDataAnalytics+2 crossposts

Just graduated, thinking about Data Analytics. Need guidance from self-taught people.

Hey guys,

​

I just graduated from college and honestly I don't know what step I should take now. After overthinking a bit, I feel like Data Analytics might be the better choice for me.

​

Is there anyone here who learnt everything from scratch by themselves?

​

I can buy a course if it's actually worth it, but I don't think I can afford expensive ones, so I'm mostly looking for free resources and YouTube.

​

I have the next 6 months free, so I'm ready to put in the work.

​

Can you guys help me structure a roadmap? Not a random roadmap from YouTube, but one that actually helped you or one you made for yourself.

​

Like

​

What should I learn first?

Which YouTube channels did you use?

When should I start SQL, Excel, Python, Power BI and Statistics?

When should I start building projects?

If you had to start again from zero, what would you do differently?

​

I'm starting from absolute zero, so any advice would really help.

​

Thanks :)

reddit.com
u/Far-Prompt9098 — 14 days ago
▲ 4 r/LearnDataAnalytics+1 crossposts

Studying for Databricks Data Engineer Associate

Hi! So I'm currently studying trying to get certified in Databricks with a entry-level c3rtification but also one that reflects some good knowledge from the plataform. I got a good SQL background, cloud computing deep experience, git understanding, python development experience, etc.

I want to know something. My company has access to the Databricks Partner Academy, taking into account my experience/knowledge, are these coursess enough (maybe with some practice tessts - if you know good and updated ones I'd appreciate too) to take the ex4m?

I've been also doing the Udemy coursse from Derar Alhussein, but don't know if I'm overstudying or if it's actually helpful.

https://preview.redd.it/09os0bxddv8h1.png?width=1232&format=png&auto=webp&s=441c7ae31e02612972afaabf66382539333f5558

Thanks in advance!

reddit.com
u/Diligent-Soil5617 — 13 days ago
▲ 2 r/LearnDataAnalytics+1 crossposts

How to get started on Data Analytics?

Hey everyone,

I recently completed my bachelor's in Statistics with minor in CS. I wanted to know how can I get started on Data Analytics. I have experience in excel, python, SPSS, R and somewhat strata. I have done some projects using these softwares. But I don't know how to combine them to get a job. Can anyone guide me or provide me with a roadmap on how to get market ready it would be of great help.

reddit.com
u/Chemical_Cookie7728 — 13 days ago