Uncategorized

Housing Price Prediction: A Data-Driven Guide to Real Estate Valuation

The Problem Whether buying, selling, or making real estate recommendations, accurate housing price predictions are essential. The housing market is complex—two seemingly identical homes can sell for vastly different prices depending on quality, condition, location, and construction details. Without data-driven guidance, pricing decisions rely on intuition rather than evidence, leading to either missed opportunities or

Housing Price Prediction: A Data-Driven Guide to Real Estate Valuation Read More »

Predicting Mental Health Crisis Demand Before It Happens

The Problem Every week, thousands of people in Toronto experience a mental health crisis that requires police intervention. These calls — known as Persons-in-Crisis (PIC) calls — are unpredictable, resource-intensive, and emotionally taxing on first responders. When demand spikes unexpectedly, crisis teams are stretched thin, response times suffer, and communities are left vulnerable. The question

Predicting Mental Health Crisis Demand Before It Happens Read More »

Healthcare Database for Multi-Branch Hospital Networks

A comprehensive database design project for a multi-branch hospital network system. Built with MySQL, covering ER modeling, normalization to BCNF, DDL, DML, and DQL — addressing real-world challenges in healthcare data integration. In today’s healthcare landscape, patient information is often fragmented across multiple hospitals, clinics, and departments. When a patient visits different branches of a

Healthcare Database for Multi-Branch Hospital Networks Read More »

IT Spending Visibility Dashboard using Power BI

Visibility is power Built an advanced, multi-page Power BI dashboard for a client company to consolidate fragmented IT procurement data into a single, interactive reporting tool — enabling leadership to track technology spending across years, categories, vendors, and subcategories, with forecasting and drill-down capabilities for confident budgeting decisions. Problem / Objective A mid-sized client company

IT Spending Visibility Dashboard using Power BI Read More »