This portfolio project demonstrates the design and implementation of a relational SQL database and interactive Power BI dashboard for a fictional durable medical equipment (DME) company. The solution manages medical equipment rentals, patient information, insurance providers, deliveries, and rental agreements while supporting operational reporting and business intelligence through SQL and Power BI.
The interactive Power BI dashboard provides operational and financial insights into medical equipment rentals, including revenue, rental activity, equipment utilization, rental status, and monthly performance trends.
Medical equipment suppliers manage large amounts of operational data, including patients, equipment inventory, insurance providers, deliveries, and rental agreements. Without a structured database, tracking equipment availability, rental history, and billing information becomes inefficient and prone to errors.
This project demonstrates how a relational database can improve data organization, support business operations, and provide meaningful insights through SQL queries.
- Design a normalized relational database
- Create tables using SQL
- Establish primary and foreign key relationships
- Populate the database with sample data
- Develop SQL queries to answer business questions
- Demonstrate database management and analytical reporting skills
The database follows a normalized relational design, as illustrated in the Entity Relationship Diagram (ERD). The schema consists of six interconnected tables:
- Patient
- Equipment
- Insurance
- Driver
- Delivery
- RentalAgreement
Relationships are enforced through primary and foreign keys to maintain referential integrity and support efficient business reporting.
- Database Design
- Relational Data Modeling
- Primary & Foreign Keys
- SQL Joins
- Aggregate Functions
- GROUP BY
- ORDER BY
- Power BI Dashboard Development
- Power Query (ETL)
- KPI Reporting
- Business Intelligence
Example SQL queries were developed to answer questions such as:
- Which equipment is rented most frequently?
- How many active rental agreements exist?
- Which insurance providers cover the most rentals?
- Which drivers completed the most deliveries?
- What is the estimated rental revenue?
- Which equipment is currently available?
The interactive Power BI dashboard transforms the SQL database into actionable business insights by highlighting:
- Total rental revenue
- Total rentals and average rental duration
- Revenue by equipment category
- Rental distribution across equipment categories
- Active versus returned rental status
- Revenue generated by individual patients
- Interactive filtering by rental start date
- MySQL
- MySQL Workbench
- SQL
- Power BI
- Power Query
- Relational Database Design
- Entity Relationship Diagram (ERD)
- 📄 SQL_Schema.sql
- 📄 Sample_Data.sql
- 📄 SQL_Queries.sql
- 🖼️ CareRent ERD.png
- 📊 Medical Equipment Rental Performance Dashboard.pbix
- 🖼️ Medical Equipment Rental Dashboard.png
This project was created as part of my healthcare data analytics portfolio to demonstrate SQL development, relational database design, Power BI dashboard development, and business intelligence skills using a realistic healthcare business scenario.