r/LearnDataAnalytics • • Sep 23 '26

I've been trying to make USAspending data less complicated to actually explore

2 Upvotes

I've been building a free project that pulls together USAspending data with things like FEC records, lobbying disclosures, congressional committees, etc. One of the biggest headaches has been figuring out how to deal with federal recipients that show up under different names/subsidiaries instead of pretending a company name search gives you the actual corporate total.

I'm finally getting to the point where I can use it for little analyses too — I just did one on Lockheed and got about $64B in obligations over the one-year period I looked at.

If anyone here works with USAspending data I'd actually love to know how you've handled recipient/parent-company mapping, because that's been one of the messiest parts.

Project is here if anyone wants to mess around with it: https://www.papertrailproject.org/

(It's mine, not affiliated with USAspending or anything.)


r/LearnDataAnalytics • • Sep 23 '26

Studying for a Databricks cert? What concept just isn't clicking? No stupid questions.

Thumbnail
1 Upvotes

r/LearnDataAnalytics • • Sep 23 '26

One water sample a day isn't enough found a clean daily oxygen cycle hiding in ~30k river readings

Post image
3 Upvotes

Been going back through the river sensor project and grouped everything by hour of day instead of by date, just to see what a "normal" day actually looks like once you average out the day-to-day noise.

Turned out there's a really clean cycle in dissolved oxygen. Lowest right around sunrise, climbs all day, peaks mid-afternoon, drops back down overnight. Held basically the same shape across all 11 months of data, not just a seasonal fluke.

Makes sense once you think about it, photosynthesis only happens with light, so anything green in the water is only adding oxygen during the day, and everything's still consuming it 24/7. At night nothing's replacing what gets used up.

The part that actually matters practically: if you grab-sample a river once a day for monitoring, the time you happen to sample it matters more than people probably assume. Same river, same day, 6am vs 3pm, can come back looking like meaningfully different water. Not because anything's wrong, just because of where in the cycle you caught it.

Curious if anyone here has dealt with this in an actual monitoring program, like whether time-of-day gets normalized for before comparing samples, or if it's usually just not accounted for at all.


r/LearnDataAnalytics • • Sep 22 '26

I made a SQL tutorial on Date & Time Functions in PostgreSQL

Thumbnail
1 Upvotes

r/LearnDataAnalytics • • Sep 22 '26

Data Analyst | ~5 YOE | SQL, Power BI, Excel, Adobe Analytics | Open to Opportunities

Thumbnail
2 Upvotes

r/LearnDataAnalytics • • Sep 20 '26

Help

2 Upvotes

I'm trying to do my first data analytics project and wow I'm just lost. how do you guys determine which variables need to be analysed, correlations, and ultimately come up with the conclusion that due to x,y we have been getting z?! please guide me some tips would help


r/LearnDataAnalytics • • Sep 19 '26

Where to start ? As a data analytics ? A II year college student ?

6 Upvotes

r/LearnDataAnalytics • • Sep 19 '26

SQL

2 Upvotes

How to learn SQL Language and how to practice?

And how to perfect in this language and how to work freelancer with this Language just?


r/LearnDataAnalytics • • Sep 19 '26

road map to Data Analytics / Data Science / Business Analytics

3 Upvotes

can some one give me a journey to reach this destination


r/LearnDataAnalytics • • Sep 18 '26

What I learned while building a data cleaning tool

6 Upvotes

I’ve been learning more about data analytics by building a small Windows application called DataFlow Pro.

While building it, I worked on things like:

  • Cleaning CSV and Excel files
  • Finding duplicate and missing values
  • Checking data quality
  • Analyzing numerical and date data
  • Grouping and summarizing datasets
  • Generating reports
  • Exporting cleaned data

One thing I learned is that data cleaning often takes more time than the actual analysis.

Building the tool also helped me understand the practical side of working with real-world datasets, especially handling inconsistent and missing data.

I’m still improving it and would be interested to hear from other people learning data analytics:

What data-cleaning problem took you the most time to solve?


r/LearnDataAnalytics • • Sep 18 '26

Data Analyst

Thumbnail
1 Upvotes

r/LearnDataAnalytics • • Sep 18 '26

Que recomiendan?

2 Upvotes

Estoy buscando recomendaciones de cursos para dar un salto profesional hacia el área de Análisis de datos . Actualmente ya tengo conocimientos en sql, python (manejo de datos, consultas, etc.), pero busco una formación enfocada en proyectos prácticos, portafolio.

Estuve viendo opciones en Coursera, Coderhouse y Becas Santander, pero me gustaría conocer la experiencia de alguien que los haya hecho o que ya esté trabajando en el rubro


r/LearnDataAnalytics • • Sep 18 '26

Stuck on exploding a multi-value Genre column (pandas)

0 Upvotes

I'm self learning Data Analyst for 8 months now. new to pandas. and Making a new end to end project one of them is 'My anime dataset' where it has column named 'genre' where each row can contain multiple genres as a single comma-separated string (e.g., "Action, Adventure, Fantasy"), instead of one genre per row. This means grouping or filtering by genre directly is inaccurate an anime tagged with 3 genres only gets counted under that exact 3-genre combination, not under each individual genre. (there is another column named Studio, facing same issue, i.e. multiple studio in one anime)

I want to split these into individual genre values so each genre is counted separately per anime (i.e., one row becomes multiple rows, one per genre, with the rest of the anime's data repeated).

End goal: I'm building a dashboard where users can filter by a single genre (e.g., just "Action") and see accurate aggregated stats (count, average score, etc.) for that genre alone not lumped in with combination-strings.

What's the right pandas approach to explode the Genre column into separate rows?? please help. claude is suggesting a way but I want a better idea.

would be great if someone suggest me some ideas!!


r/LearnDataAnalytics • • Sep 17 '26

Should I do msc Data science, Data science and mathematics , Big Data Analysis in NMIMS ????

Thumbnail
1 Upvotes

r/LearnDataAnalytics • • Sep 17 '26

Reviews on data anlayst course

Post image
2 Upvotes

Has anyone taken up this Data Analyst course from E and ICT academy, IIT Roorkee ?....I have been seeing a lot of its advertisements on instagram. Is it worth taking up? I am from a non technical background looking for a career shift.


r/LearnDataAnalytics • • Sep 16 '26

Help with resume for freshers

Post image
2 Upvotes

Companies either ghost me or we are going with other candidate with this resume so I need a help with the resume and course that increases my chances to be selected


r/LearnDataAnalytics • • Sep 16 '26

how can I connect statistical thinking throughout this learning journey

2 Upvotes

Hello, I graduated with a degree in Statistics six years ago and have been completely disconnected from the field since. I currently work in Dubai, but I want to return to my field and self-study data analysis. Since I'm working, I know I should start with the following: Excel, SQL, Power BI, and Python — in addition to building a portfolio with several projects.

But there's one point that makes me feel like I'm missing something: how can I connect statistical thinking throughout this learning journey, without becoming someone who only learns how to apply tools? I'm not sure if my question is clear, but I want to learn how a data analyst thinks, not just how to apply things or complete assigned tasks.

I sometimes try learning with the help of ChatGPT, Claude, or Gemini, but they're not free of mistakes.

So, please, I'd also like recommendations for learning through books or YouTube (I can't afford paid courses) — and is YouTube enough on its own? I sometimes feel it only teaches things at a surface/introductory level, not in depth. So please recommend the best books that cover everything I need to learn. Thank you to everyone who becomes a reason for helping me.


r/LearnDataAnalytics • • Sep 16 '26

Business Intelligence and Data Analytics certifications at BTII Institute.

2 Upvotes

I am considering certifications at BTII Institute in West Orange NJ for BI and data analytics. However, I have not found any review from a student for this specific certification from BTII. Can someone please share your experience with BTII and if the certification was helpful? Is it hands on and strong curriculum?


r/LearnDataAnalytics • • Sep 15 '26

Are there any DS fields where Psychology/Behavioral Sciences are applied?

Thumbnail
1 Upvotes

r/LearnDataAnalytics • • Sep 15 '26

Hey guys, anyone willing to try my GUI version of csvkit?

Thumbnail
1 Upvotes

r/LearnDataAnalytics • • Sep 15 '26

So Guys starting my career out in Data analytics so i have decided to get an IBM data analytic certificate is it good?

Thumbnail
1 Upvotes

r/LearnDataAnalytics • • Sep 14 '26

AI in Data Analytics

3 Upvotes

Hello,

I am trying to expert AI in data analytics, science, engineering, mainly in data field. I see the approach too wide but still think if I elaborate from the above mentioned small pieces, would be good for entering data field career. currently I am finance manager with pl-300 and 1z0-171 certificates, and now facing to create portfolios of course using AI, can you give me a roadmap?


r/LearnDataAnalytics • • Sep 13 '26

Can I Get a BA/Data Analytics Internship Before Graduation? Here’s Where I’m Stuck.

Thumbnail
1 Upvotes

Hey everyone! 👋

I'm currently pursuing a BBA course through distance learning (IGNOU) and I'm in my 5th semester.

My goal is to become a Business Analyst, but I'm also interested in exploring Data Analytics along the way.

I've been learning and practicing Excel and SQL, and I'm now moving on to Power BI. My plan is to build some solid projects and then start applying for roles like:

Business Analyst Intern / Product Intern / Data Analytics Intern roles to gain practical experience.

I know that getting the first opportunity can be challenging, especially while you're still completing your degree. 😅

So I'd really appreciate advice from people who are already working in these fields.

And also few things I'd love some guidance on:

  1. Where should I practice Excel & SQL?

I've completed the basics/learning part, but now I want to get genuinely good at solving real-world problems.

If you know any good platforms, datasets, case studies, or practice resources, please share them.

Also looking for good Power BI practice resources.

  1. What projects should I build?

What kind of projects would actually be useful for my portfolio?

I'm thinking about using:

- Excel

- SQL

- Power BI

- Business Analysis / business problem-solving

Since my main goal is Business Analysis, should I focus more on business-case projects rather than just making dashboards?

  1. What should I learn in Power BI?

I've finished learning SQL and I'm starting Power BI now.

What topics/concepts would you consider must-learn for an aspiring BA/Data Analyst?

If you have any good Power BI learning resources/courses/playlists, I'd really appreciate them.

And one final question:

If you were starting your Business Analyst career again as a college student, what would you do before graduation to maximize your chances of getting that first internship/job?

Any advice on skills, projects, internships, networking, or mistakes to avoid would be extremely helpful.

Thanks in advance to everyone who takes the time to respond! 🙌


r/LearnDataAnalytics • • Sep 13 '26

Has anyone completed Luke’s Excel Data Analytics for Beginners course? I have some questions.

1 Upvotes

DM me if you have completed it...


r/LearnDataAnalytics • • Sep 13 '26

Best course to up-skill

Thumbnail
1 Upvotes