This project automates the process of collecting, analyzing, and responding to customer feedback using Google Forms, Google Sheets, and Zapier. When negative feedback is submitted, a real-time alert is triggered via Gmail, asking the respondent how the service could be improved. A live dashboard provides insights into ratings, feedback trends, and recommendation percentages.
I built a fully automated Excel system that tracks and analyzes athletic performance data for over ninety students across three testing periods in a school year. The tool reads raw inputs from a master data sheet, assigns each result to the correct test phase using the test date, applies gender-based benchmarks, and color-codes the results as Poor, Okay, or Good in real time. The report can be generated for any student through a simple dropdown and exports as a one-page PDF ready to upload to student portals. This system replaced manual reporting and now delivers polished, consistent and coach-ready reports in minutes, not hours.
I analyzed cancer patient data from European countries (2014–2024) to identify high-risk groups and treatment outcomes by cleaning the data with SQL, building a two-page Power BI dashboard using DAX for deeper insights, and delivering findings that support data-driven decisions in healthcare.
Healthcare Management Insights is a data analysis project aimed at helping healthcare administrators and professionals make smarter, data-driven decisions. Using SQL for data extraction and Power BI for visualization, I built a dynamic dashboard that streamlined complex patient, doctor, and hospital data into actionable insights. This solution improved operational efficiency by highlighting key trends, segmenting patient demographics, and identifying top-performing medical personnel and institutions.
I built a Google Sheets based system that analyzes gym testing results and automatically generates professional performance reports for clients. The system calculates percentiles for squat strength, grip strength, sled volume, bike power, body composition and overall fitness, but instead of ranking everyone together it compares each client only to people in the same age group and gender which makes the results more fair and meaningful.
It feeds the cleaned and calculated data into an AutoCrat report template and creates personalized PDF report cards instantly, ready to send to each client without any manual work. Age groups can be changed at any time and the logic updates everywhere automatically. The structure is flexible so new columns can be added or moved without breaking the system.
I built a fully automated Dental KPI Dashboard in Google Sheets to help dental practices track performance and make informed revenue decisions. The system analyzes key Revenue Cycle Management (RCM) metrics such as Net Collection Rate, Gross vs Net Production, Total Collections, and Insurance Claim Aging across 0–30, 31–60, 61–90 and over 90-day buckets.
The dashboard includes a structured Data Tab for monthly entries, a KPI summary view, a Target Tab for benchmark controls and both Monthly and Yearly Graph tabs with dynamic visuals driven by dropdown selection. All metrics and charts update automatically using indexed formulas, error-proofing logic and smart referencing.
This tool delivers a clear, executive-level view of financial health, identifies delays in reimbursement and supports better decision-making for dental offices.
I analyzed U.S. data job listings using Python to identify the most in-demand and best-paying skills for Data Analysts. The project provided clear insights to guide career growth while strengthening my data analysis and visualization skills.
I built an Excel system that automates internal work request tracking across departments, featuring smart categorization, urgency detection, and clean visual workflows to enhance team coordination and reduce manual effort.
I built an Excel-based scheduling and resource management system for a primary care practice. The file organizes doctor schedules, appointment times, and room availability in one structured view. It includes automated summaries that calculate room utilization, total working hours per doctor, and shows available slots to prevent double bookings. This system helps clinic staff make faster scheduling decisions, reduce conflicts, and improve daily workflow efficiency.
I built a fully automated Business Sales Tracker in Google Sheets to help business owners monitor sales performance in real time. The system includes a clean data entry interface with dropdowns, a dynamic sales table for Date, Customer, Product, Quantity, Cost, Sales, Profit and Status, and array formulas that calculate profit and KPIs without manual work. Conditional formatting provides instant visual insights, and the dashboard scales automatically as new data is added, giving the business a single source of truth for revenue, orders and profitability.
I designed a custom Excel dashboard for an estate agency to monitor and manage budgets across 13 departments. The solution provides a clear view of departmental spending, enabling smarter financial decisions and improved budget control.
I built an automated Excel dashboard for a senior living facility that projects which residents are expected to move to Assisted Living within the next three months. The system runs on a 52-week monitoring table where staff manually mark each week with Yellow or Red depending on the resident’s risk or readiness level. The dashboard automatically scans the next thirteen weeks based on the current reporting week, identifies residents with upcoming movement activity, and displays a live list of only those residents flagged for transition. This allows leadership to anticipate moves early, plan resources in advance, and coordinate care more proactively without changing their data entry process. The entire solution is driven by formulas only and does not require VBA or external tools.
I built a fully-automated Student Accountability Tracking System using Google Sheets, Google Forms, and custom automation logic. The system tracks daily, weekly, and monthly student actions over a six-week period. All inputs are collected through Google Forms and connected to a centralized Google Sheet where the data is automatically processed into a live dashboard and a printable client report card. The logic was designed to correctly return and display multiple test periods for each student rather than only the most recent one, which allows proper comparison across time. The dashboard summarizes individual and class-level progress, highlights consistency patterns, and provides a clean reporting layout that can be printed or exported directly from Sheets. This system gives the instructor a clear and reliable way to track student commitment without manual data work.
I built a fully linked financial model that connects the Income Statement, Balance Sheet and Cash Flow using operational drivers such as pricing, volume, COGS and expense assumptions. The model includes quarterly and annual projections, scenario testing, automated ratio outputs and dynamic sensitivity for valuation decisions. It is structured for CFO and investor review and avoids hard-coded values to maintain transparency and auditability.
The Soccer Season Planner is a fully automated, macro free Excel system built to help grassroots and amateur soccer teams manage an entire season with clarity and structure. The aim was to create a professional, easy to use planning tool that feels like a real soccer management dashboard rather than a traditional spreadsheet.
The system centralises squad management, fixtures and results tracking, an automatically updating league table, structured matchday setup with event logging, player performance statistics, and cup competition history. All data flows from a single source of truth, ensuring accuracy and eliminating repetitive manual work.
An interactive dashboard provides instant visibility into league position, key team metrics, and top performers, allowing coaches to quickly understand performance at a glance. Designed to be clean, practical, and reusable, the planner can be reset and used season after season without rebuilding the structure.
The final result is a polished, reliable soccer management tool that saves time, reduces errors, and gives coaches full control of their season in one organised system.
