• +234 (0) 7062274671
  • training@talentdigit.com
  • Log in
  • Register
Logo
  • About
  • Reviews
  • Portfolios
  • Programmes
    • Self-Paced Courses
    • Free Courses
    • Instructor-led Programmes
    • Training Centre (Hybrid)
    • Corporate Training
  • Free Resources
Avatar
Ayuba
Portfolios (4)

Healthcare Visits Analytics

October 05, 2026 (0) comments
Product
Project related images. Click to view
Product

I developed an interactive Healthcare Visits Analytics Dashboard using Microsoft Power BI to transform raw healthcare data into meaningful insights for monitoring patient activity and healthcare service performance.

The dataset contained 5,000 healthcare visit records involving 4,973 unique patients, covering the period from January 2024 to May 2025. The project involved data cleaning and preparation, data modeling, relationship management, calendar creation, DAX calculations, and interactive dashboard design.

The dashboard provides insights into monthly visit trends, service utilization, departmental workload, top diagnoses, patient gender distribution, emergency and inpatient visits, follow-up activity, treatment and medication costs, and patient satisfaction.

Key Findings

  • 5,000 total healthcare visits
  • 4,973 unique patients
  • 2,520 outpatient visits
  • 1,245 inpatient visits
  • 1,235 emergency visits
  • 2,507 visits with follow-up recorded
  • 3,176,445 total treatment and medication cost
  • 3.84/10 average patient satisfaction
  • Cardiology recorded the highest departmental visits with 1,281
  • Hypertension was the most frequently recorded diagnosis with 2,013 visits

The dashboard enables users to interactively filter the data by year, location, service type, and department, making it easier to identify trends, compare healthcare services, monitor workload, and support data-driven healthcare decision-making.

 


Comment (0)

Leave your thought here

Other projects by Ayuba

Blog

DANGATA STORES

Blog

Sales Summary Dashboard

Blog

ABC Stores Dashboard

Logo
  • Home
  • About
  • Reviews
  • Portfolios
  • Blog
  • Programmes
    • Self-Paced Courses
    • Free Courses
    • Instructor-led Programmes
    • Training Centre (Hybrid)
    • Corporate Training
  • Free Resources
    Log In
    Sign Up
Logo

Talentdigit Resources Limited is a digital training and consulting firm that equips individuals and organizations with digital skills training.

Quick Links

  • About
  • Reviews
  • Portfolios
  • Corporate Training
  • Blog
  • Refer a student and Earn
  • Verify Certificate
  • Login
  • Register

Programmes

  • Self-Paced Courses
  • Free Courses
  • Instructor-led Programmes
  • Hybrid Learning
  • Corporate Training
  • Free Resources

Sign Up for Our Newsletter

Receive weekly newsletter with educational materials, popular books and much more!

  • Terms of Use
  • Privacy Policy

© 2023 (c) All right reserve

Login

Don't have an account yet?

Forgot your password?

or Log-in with

  • Gacebook
  • Google
Sign Up

Already have an account?

Home
Home
Home
Home
Home
Home
Home
Home
Home