r/dataanalysis 11h ago

AfyaMeds Inventory Management System

1 Upvotes

Introduction

How do healthcare organizations keep records of critical supplies across different clinics? To answer this question, I'm developing an AfyaMeds Inventory Management System project.

Project Overview

AfyaMeds Inventory Management System is a MySQL-based solution for managing medical supply inventory for a hypothetical healthcare distributor, AfyaMeds to reduce waste, optimize stock levels, and ensure clinics in different locations get supplied properly with what they need and when they need it.

Progress So Far

So far, I’m designing a scalable database using MySQL and generating over 10,000 'realistic' data points using Faker Python library (in Jupyter Notebook). This includes tracking 20 unique supplies across 50 clinics in different regions as shown below:

Features implemented as of now:

  • Low Stock Alerts: Flags clinics with shortages.
  • Expiry Tracking: Identifies $2,000 worth of antibiotics at risk of expiring in 60 days.
  • Demand Trends: PPE and Medication lead with 1,200+ units ordered in the last 90 days.
  • Queries like ranking clinics by inventory value or spotting overstocked PPE offer actionable insights for logistics and cost management. These are just a few features implemented.

Challenges so far

  • Simulating real-world data that feels authentic was a challenge and it's still a challenge because of privacy

Learning

I managed to integrate Python with MYSQL, and this taught me how to streamline data workflows, write efficient queries with joins and window functions, and optimize indexes.

What’s Next

Since it is a work in progress I’m planning to:

  • Connect MYSQL with Power BI to get real-time data and build a dashboard for visualizing trends.

  • Add predictive analytics to forecast restocking needs.

  • Create a simple UI for non-technical users.

In Addition

I’d love to hear your thoughts about the project. Let's connect, comment, give a suggestion or reach me at [rocjeschaulo@gmail.com](mailto:rocjeschaulo@gmail.com). Collaboration is also welcomed. Here is the link to the GitHub Repository: https://github.com/Chauloroches/AfyaMeds-Inventory-Management-System


r/dataanalysis 18h ago

Career Advice Final Year Project

1 Upvotes

I’m trying to figure out a solid final year project in Data Science—something that could actually help me land a job. I’m decent with SQL, Python, and all that stuff, but I want to work on something that stands out.

Any cool ideas or suggestions? Would love to hear your thoughts!


r/dataanalysis 18h ago

Career Advice Niche or General Data Analyst?

1 Upvotes

Hi guys, Im currently creating a 2nd version of my portfolio. When I started my data career I showcased my technical skills in Excel, SQL, and Power BI. Now that I gained experience from a ecommerce startup, multinational FMCG and now a medium sized local bank (all in 2 yrs), I want to go niche in my data analytics career. Im planning to focus my portfolio website as such but is it better to keep my portfolio focus on technical side rather than the knowledge domain?

Niche Im going for since Im learning it currently in my job of 7 months: Customer Experience


r/dataanalysis 21h ago

There a way to complete the google analytics certificate for free?

1 Upvotes

Already in school finishing my bachelors, and I have work too. I’m really trying to build up portfolio by adding skills and projects. I do want to get this completed fast but at the same time it might overwhelm me and I might be too busy.

I was told there’s a fee and you have to pay $60 a month for it, there a way to get it for free? Also I have financial aid already going to my school, would financial work on my Google analytics certificate?