The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started
Back to feedPost
OGDCL Medical Analytics Dashboard
Designed and developed an interactive medical analytics dashboard during my AI-focused internship at Oil & Gas Development Company Limited (OGDCL), transforming a large healthcare dataset into clear, actionable visual insights.
The project focused on making complex medical and employee-visit data easier to analyze through structured KPIs, interactive visualizations, and an intuitive dashboard interface.
Key Features
Interactive medical data analytics dashboard
KPI cards for monitoring key healthcare metrics
Analysis of total visits and unique employee visits
Identification and visualization of top diseases and diagnoses
Demographic analysis including age and gender distributions
Analysis of medical visits across different locations and specialties
Interactive filters for exploring specific segments of the dataset
Clean visual hierarchy designed for quick decision-making
Data preparation and transformation before visualization
Dashboard structure designed to make large-scale healthcare data easier to understand
Data & Analytics
Worked with approximately 350,000 medical visit records containing fields related to patient visits, diagnoses, demographics, doctors, specialties, referrals, laboratory tests, and healthcare providers.
Because the underlying dataset contained sensitive medical information, the project focused on analytics and visualization rather than exposing identifiable patient information.
Tools
Power BI · Microsoft Excel · Data Analysis · Data Visualization · Data Cleaning · Healthcare Analytics
My Role
AI Intern — Data Analytics & Dashboard Development
Handled the data preparation, analysis, visualization strategy, KPI design, and dashboard development, translating a large and complex healthcare dataset into an interactive analytics experience suitable for organizational decision-making.
The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started
Related posts
Esports players generate a lot of performance data. The challenge is making it useful at a glance.
Fragstat is a mobile analytics app concept that brings champion insights, match statistics, seasonal progress, and achievements into one clear experience. Soft blue gradients, translucent cards, bold typography, and character imagery give the data a distinct gaming identity.
The result is a more approachable way to review performance, spot patterns, and follow progress over time.
Healthcare Executive Overview | Power BI Dashboard
This Healthcare Executive Overview dashboard brings key healthcare performance indicators into one interactive view, helping management monitor activity, identify trends, and make more informed operational decisions.
The dashboard provides an overview of:
Total Encounters, Unique Patients, Admission Rate, Total Charges, Average Waiting Time and more.
With interactive Year and Month slicers, users can explore performance across different reporting periods, compare trends, and examine results across healthcare facilities.
The goal is simple: turn healthcare data into meaningful insights that support better planning, resource allocation, financial monitoring, and operational decision-making.
Built with Power BI, this dashboard demonstrates how business intelligence can help healthcare administrators move beyond static reports and gain a clearer picture of organizational performance.
