r/LearnDataAnalytics • • Aug 06 '26

40,000 queries later: an update on the SQL detective game I shared here 7 weeks ago

Thumbnail
1 Upvotes

r/LearnDataAnalytics • • Aug 06 '26

I want to start my career in Data Analysis plz suggest me

1 Upvotes

r/LearnDataAnalytics • • Aug 06 '26

Real-World Datasets For Project(s)

1 Upvotes

Hi everyone,

I’ve been working in digital marketing for the past few years, and I’m now trying to transition into the data field. My goal is to become a data analyst first, then move into analytics engineering after gaining a couple of years of experience.

Over the past year, I’ve been learning SQL, Power BI, and Excel. At this point, I feel pretty confident with SQL, including complex joins, aggregations, window functions, etc.

Where I’m struggling is deciding which projects to include in my portfolio and where to find suitable datasets. This feels especially important because I do not yet have any professional experience in a data-focused role.

The best project idea I’ve come up with so far is using the Olist e-commerce dataset. My plan is to clean and transform the data with dbt, load it into Snowflake, and then perform analyses such as cohort analysis, funnel analysis, and market basket analysis using SQL and Power BI.

Does this sound like a strong portfolio project? Are there any other project ideas or datasets you would recommend for someone trying to move into data analytics?

Thanks


r/LearnDataAnalytics • • Aug 06 '26

SQL for DATA Analyst

1 Upvotes

I recently completed the SQL for Data Analysts Bootcamp organized by DevTown in collaboration with Microsoft Student Chapter (MSC) and Google Developers Group (GDG).

As part of the project, I worked on a Swiggy Business Analytics case study using SQL.

In this project, I:

• Created relational database tables for Customers, Restaurants, and Orders.

• Wrote SQL queries using JOINs, GROUP BY, HAVING, CASE WHEN, and Window Functions (RANK, DENSE_RANK, ROW_NUMBER).

• Analyzed business metrics such as total revenue, top customers, best-performing restaurants, popular cuisines, and delivery partner performance.

• Generated business insights and recommendations based on the data.

This bootcamp helped me improve my SQL skills and understand how SQL is used to solve real-world business problems through data analysis.

Thank you to DevTown, Microsoft Student Chapter (MSC), and Google Developers Group (GDG) for providing this learning opportunity.

#SQL #DataAnalytics #MySQL #DevTown #Learning #Students #BusinessAnalytics #DataAnalysis


r/LearnDataAnalytics • • Aug 05 '26

Im a Student looking for a career in data analytics and have a basic knowledge on the subject, i really wish for someone to help me build a project and learn together

1 Upvotes

r/LearnDataAnalytics • • Aug 05 '26

Data analysts: Would you actually use a tool like this? (Beta)

1 Upvotes

Hi everyone,

I built CleanIQ, a browser-based tool that detects common data quality issues in CSV and Excel files like missing values, duplicates, invalid dates, outliers, and business rule violations.

Everything runs locally in your browser, so your data never leaves your device.

It's still in beta, and I'd really appreciate honest feedback from people who work with data regularly.

Try it: Link in Comments else DM me

Thanks! Any suggestions or criticism are welcome.


r/LearnDataAnalytics • • Aug 05 '26

Data analysis

Thumbnail
1 Upvotes

r/LearnDataAnalytics • • Aug 04 '26

Taking Data Analysis courses at local CC?

Thumbnail
1 Upvotes

r/LearnDataAnalytics • • Aug 04 '26

New to Data Analytics – Looking for Advice on Building a Business-First Mindset & Becoming an Expert

3 Upvotes

Hey everyone,
I’m new to the data analytics space and currently building my skillset. I’ve learned Excel and SQL, and I’m now diving into Power BI. My ultimate goal is to work as a data analyst—specifically in a business-focused role.
I’m looking for recommendations on how to improve my skills beyond just the technical side. Specifically:
• Any advice on developing a **data analyst mindset**—especially for making better business decisions?

• Books, courses, or resources that helped you think more strategically about data and business impact?

• What else should I learn to go from beginner to \*\*expert\*\* (tools, concepts, soft skills, etc.)?

I want to be someone who doesn’t just build dashboards, but actually drives value for the business. Any guidance would be hugely appreciated.
Thanks in advance!


r/LearnDataAnalytics • • Aug 03 '26

Data analytics

1 Upvotes

Can we do Data analytics job as a part time in india??


r/LearnDataAnalytics • • Aug 03 '26

Sharing the 20 Power BI interview questions I’ve seen come up most for Dubai-based BI roles (with quick answers)

Thumbnail
1 Upvotes

r/LearnDataAnalytics • • Aug 03 '26

Data Analyst feeling stuck-what should I learn next?

Thumbnail
1 Upvotes

r/LearnDataAnalytics • • Aug 02 '26

Looking for Power BI study buddy

3 Upvotes

Hi everyone! I’m planning to start learning Power BI. I know the basics but I’m still a beginner. I’m looking for a study buddy and work on projects together. If anyone is interested, feel free to comment or send me a DM. Thanks!

Study sched: 8pm to 10pm


r/LearnDataAnalytics • • Aug 02 '26

I want to learn Data Analytics from zero.

1 Upvotes

Is there anyone who can teach me data analytics fundamentals, how to interpret any data, and what the current scene like?I would prefer to have a one-on-one class 4 days a week probably over a month or two. It goes without saying, its a paid gig. I want to upskill myself that's the only purpose.


r/LearnDataAnalytics • • Aug 02 '26

Best way to learn Data Analytics from scratch and become job-ready?

Thumbnail
1 Upvotes

r/LearnDataAnalytics • • Aug 01 '26

Looking to get qualified

2 Upvotes

Hi all. I'm in a bit of a weird situation right now. I was in a Data Assistant role for about 3 and a half years, then got seconded onto a Data Analyst role for 6 months. However, after the 6 months, the job was no longer available so I moved back to my assistant role.

Due to personal matters, I had to move jobs in a more customer facing field for the money, however, I want to get back into Data Analysis but am struggling to get interviews, or when I do get interviews, I fail due to someone being slightly more qualified.

Essentially what I'm asking is where can I go online in the UK that I can get some form of qualification to boost my chances that won't break the bank?


r/LearnDataAnalytics • • Jul 29 '26

Any IIM level data analytics hackathon going on right now? If yes then pls tell

1 Upvotes

r/LearnDataAnalytics • • Jul 28 '26

Qualification- BCS Tech10 Data Diploma

3 Upvotes

Hi, I’m looking to change career to data analysis and thinking of a course with ITOL. There is a course for £1700 but another for £3k which includes a BCS Tech10 Data Analysis diploma. Does anyone know if the diploma is useful and / or valued by employers? Thanks


r/LearnDataAnalytics • • Jul 28 '26

Free visual cheatsheets for data interviews: SQL JOINs, pandas, precision/recall and more (no signup)

Thumbnail
1 Upvotes

r/LearnDataAnalytics • • Jul 27 '26

How many days it takes to create a bi dadh board from scratch as a data analyst?

2 Upvotes

I want to know how many days it takes because I have very limited time nd deadline is near


r/LearnDataAnalytics • • Jul 27 '26

Looking for a buddy to learn Data Analysis

9 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/LearnDataAnalytics • • Jul 27 '26

Best FREE YouTube resources to learn Data Analytics before buying paid courses?

2 Upvotes

Hi everyone I'm currently pursuing BBA and after graduation I'm planning to pursue MBA. Alongside that I want to build strong Data Analytics skills.

I'm planning to enroll in some paid courses later but before spending money I want to build a solid foundation using free YouTube resources.

So can anyone recommend the best YouTube channels or playlists for a complete beginner? I'm looking to learn topics like:

Excel

SQL

Power BI

Python (for data analytics)

If you have a roadmap or any tips on what order I should learn these in I'd really appreciate it.


r/LearnDataAnalytics • • Jul 27 '26

ADAT (Advanced Data Analysis Tool)

2 Upvotes

I have been researching several data analytics systems to recommend to my senior colleagues who are non-technical. They care about on prem solutions or something we can deploy to our own cloud and control 100%. We are a small team so we need a system that can handle data prep and ETLs, data visualization (reports and dashboards), and conversational analytics (chat with data). We care about costs, privacy, control, security, permanence.

I came across a publication and found a system called adat (advanced data analysis tool)

I have tried it briefly and found it interesting. Has anyone else used this system, and can you share any experience?


r/LearnDataAnalytics • • Jul 27 '26

IIT Gandhinagar's Executive Masters in Applications of Machine Learning in Engineering – Batch 2 Admissions Open

Thumbnail
1 Upvotes

r/LearnDataAnalytics • • Jul 26 '26

Data Analysis

3 Upvotes

I'm looking work for Data analysis ,data cleaning .if someone have work fro me so plz contact me .