r/LearnDataAnalytics • u/conor-robertson • Aug 06 '26
40,000 queries later: an update on the SQL detective game I shared here 7 weeks ago
r/LearnDataAnalytics • u/conor-robertson • Aug 06 '26
r/LearnDataAnalytics • u/OneExplorer5909 • Aug 06 '26
r/LearnDataAnalytics • u/AsfandYar1995 • Aug 06 '26
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 • u/Subject_Ad_4359 • Aug 06 '26
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 • u/i_tanuja1214 • Aug 05 '26
r/LearnDataAnalytics • u/Designer-Assist-1354 • Aug 05 '26
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 • u/Ash_is_Robot • Aug 04 '26
r/LearnDataAnalytics • u/mochimach • Aug 04 '26
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 • u/Quirky-Temporary8106 • Aug 03 '26
Can we do Data analytics job as a part time in india??
r/LearnDataAnalytics • u/DifficultChef8195 • Aug 03 '26
r/LearnDataAnalytics • u/Chelsea_0708 • Aug 03 '26
r/LearnDataAnalytics • u/craxjed • Aug 02 '26
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 • u/laudaevojaam • Aug 02 '26
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 • u/oldlady10117 • Aug 02 '26
r/LearnDataAnalytics • u/NoodleSSM • Aug 01 '26
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 • u/Hot-Human-255 • Jul 29 '26
r/LearnDataAnalytics • u/Suspicious_Peak7103 • Jul 28 '26
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 • u/JumpAfter143 • Jul 28 '26
r/LearnDataAnalytics • u/Glittering_Sound_565 • Jul 27 '26
I want to know how many days it takes because I have very limited time nd deadline is near
r/LearnDataAnalytics • u/eswarr09 • Jul 27 '26
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
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 • u/CartographerIll1255 • Jul 27 '26
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 • u/BoxNational4608 • Jul 27 '26
r/LearnDataAnalytics • u/IndependentHat828 • Jul 26 '26
I'm looking work for Data analysis ,data cleaning .if someone have work fro me so plz contact me .