Embedded Files
School Performance Tracking Dashboard
Project Title: School Performance Dashboard (Excel & Power BI)
Project Title: School Performance Dashboard (Excel & Power BI)
🧩 Overview
🧩 Overview
This project is an interactive dashboard created using Excel and Power BI to track and analyze academic performance. It enables administrators and teachers to monitor performance at the class, student, subject, and teacher levels with clear visual insights.
⚙️ Key Features
⚙️ Key Features
Excel Automation:
Data entry sheets for classes, students, subjects, and teachers.
Formulas and pivot tables for automated calculations.
Attendance and marks tracking with conditional formatting.
Power BI Dashboard:
Class-level overview with average marks, attendance %, and top performers.
Drill-down navigation: Class → Student → Teacher.
Interactive charts (bar, line, pie) for subject-wise and student-wise analysis.
Teacher performance evaluation based on subject outcomes.
Sales & Profit Dashboard
View Dashboard
An interactive Power BI dashboard designed to analyze business performance using dynamic metric selection.
The dashboard enables users to seamlessly switch between Sales, Profit, Quantity, and Discount, with Year-over-Year (YoY) growth analysis, geographical insights, and identification of top-performing regions.
It demonstrates advanced DAX, data modeling, and dashboard storytelling best practices commonly used in enterprise BI solutions.
Bank Marketing Campaign Analysis Dashboard (Power BI)
This project presents a professional Power BI dashboard designed to analyze a bank’s term deposit marketing campaigns. The focus is precision targeting, not mass outreach — identifying who to contact, when, how, and how often to maximize subscription rates and campaign ROI.
The dashboard combines customer segmentation, campaign intelligence, and macroeconomic signals into a single, executive-ready analytical product.
Healthcare Analysis Dashboard
Developed an interactive healthcare dashboard in Power BI to analyze hospital performance, patient demographics, treatment costs, and medical conditions. The dashboard provides both high-level KPIs and detailed drill-down views, enabling healthcare administrators to make data-driven decisions.
⚙️ Key Features
⚙️ Key Features
Top KPIs: Patient count, average treatment cost, average hospital stay.
Demographics: Patients by age group, gender, and blood type.
Hospital Insights: Patient distribution across major hospitals.
Medical Analysis: Vulnerability by condition (Diabetes, Obesity, Arthritis, Cancer, Asthma).
Financials: Total treatment cost by region.
Detailed Records: Patient-level data including admission type, doctor, medication, insurance, billing, and test results.
Library Management System using SQL Project
Library Management System using SQL Project
This project demonstrates the implementation of a Library Management System using SQL. It includes creating and managing tables, performing CRUD operations, and executing advanced SQL queries. The goal is to showcase skills in database design, manipulation, and querying.
Set up the Library Management System Database: Create and populate the database with tables for branches, employees, members, books, issued status, and return status.
CRUD Operations: Perform Create, Read, Update, and Delete operations on the data.
CTAS (Create Table As Select): Utilize CTAS to create new tables based on query results.
Advanced SQL Queries: Develop complex queries to analyze and retrieve specific data.
Superstore Sales & Profit EDA Using Python
Objective
Objective
Analyze sales, profit, discounts, and shipping strategies to uncover key business insights.
🛠 Tools Used
🛠 Tools Used
Python (Pandas, Matplotlib, Seaborn)
Jupyter Notebook
Page updated
Google Sites
Report abuse