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
Trending
retrofuturism
Share your favorite designs from the past exploring the distant future. Or your own take on the aesthetic 🚀
halftone
Dots. Texture. Grain. Let's see your designs using the halftone technique.
Midjourney
Creatives are showing off what they're making with Midjourney.
colorgrade
Video editors sound off: How do you enhance the mood of your video in color grading?
Challenges
View all
Related posts
Finding the right job often requires manually comparing a resume against dozens of job descriptions.
This project automates that process by:
Analyzing a resume against multiple real job postings
Generating AI-powered match scores
Identifying missing skills
Providing resume improvement suggestions
Storing results in a SQL database
Visualizing insights in Power BI
Offering a live Streamlit web application
🛠️ Tech Stack
Python
Pandas
SQLite
SQL
Google Gemini AI API
Streamlit
Power BI
VS Code
📊 Key Features
AI Resume Analysis
Resume-to-job match scoring (0–100%)
Missing skill identification
AI-generated recruiter feedback
Resume improvement recommendations
Database & SQL
Stores analyzed jobs in SQLite
Performs analytical queries
Identifies skill gaps
Finds best-fit companies and locations
Power BI Dashboard
Average Match Score
Strong Fit Jobs
Top Match Score
Company Match Analysis
Skill Gap Analysis
Streamlit Application
Paste any job description and instantly receive:
Match Score
Missing Skills
AI Feedback
Resume Improvement Tips
📈 Dashboard Insights
The dashboard provides:
Overall resume strength across jobs
Best matching companies
Skill gap analysis
Job fit distribution
Career improvement opportunities
🎯 Business Value
This project demonstrates:
Data Cleaning
Data Analysis
SQL Querying
AI Integration
Dashboard Development
Data Visualization
End-to-End Analytics Workflow
🔮 Future Improvements
Analyze 100+ job postings
Automated LinkedIn job ingestion
Multiple resume comparison
Industry-specific recommendations
Advanced skill trend tracking
👨💻 Author
Gourav Jangid
Aspiring Data Analyst passionate about transforming data into actionable insights using Analytics, SQL, Python, Power BI, and AI.
Awesome use case! Automating resume-job matching saves so much time.
Built an interactive Power BI dashboard to analyze Netflix content, genres, countries, ratings, and release trends. Used data cleaning, data modeling, DAX, and interactive visualizations to transform raw data into meaningful insights.
Another productive day — this time showcasing my Hand Gesture Mouse Control project. A Python-based computer vision project that lets you control your computer mouse using hand gestures in real time.
👆 Index finger → Move the cursor
👌 Pinch index + middle finger → Click
Built using OpenCV, MediaPipe, NumPy, and AutoPy, with real-time hand landmark detection and gesture tracking.
Wow..😲