Technical Case Study
Automated Client Reporting System
A data pipeline designed to generate recurring market and operational reports using automated workflows.
Reduced manual reporting work while improving consistency and timeliness of client insights.
PythonSQLDashboard Systems
Open Case Technical Case Study
Executive Market Intelligence Dashboards
A suite of real-time dashboards designed for leadership to monitor housing market conditions and internal performance signals.
Enabled leadership teams to track market conditions and internal performance through continuously updated analytical dashboards.
SQLBI ToolsAutomation
Open Case Technical Case Study
Home SQL Server for Sensor Inputs
A Raspberry Pi-based MariaDB setup used to receive sensor data and support end-to-end experimental data collection without relying on hosted infrastructure.
Created a small self-hosted database environment that could accept live sensor inputs and support downstream analysis projects.
MariaDBRaspberry PiApachePHPphpMyAdmin
Open Case Technical Case Study
Daily Stock Data Ingestion Pipeline
A scripted workflow that scraped daily market data, joined supporting financial datasets, computed valuation-oriented features, and wrote the results back to SQL for dashboard use.
Built a repeatable daily ingestion workflow that turned scraped market data into structured SQL tables for downstream analysis and dashboards.
RSQLWeb ScrapingYahoo FinancePower BI
Open Case Technical Case Study
Environmental Sensor and ML Experiment
An end-to-end experiment that collected temperature and humidity data from sensors, stored it in SQL, and tested whether machine learning could reduce air-conditioning usage.
Built a full workflow from sensor hardware to analysis, showing how environmental data could support more efficient air-conditioning decisions.
RSQLPower BIArduinoStatistical Testing
Open Case Technical Case Study
Live Feedback Pipeline From Google Forms to SQL
An ingestion workflow that moved Google Form responses into SQL on a schedule so Power BI dashboards could refresh close to real time without paid middleware.
Created a practical low-cost pipeline that kept customer-feedback dashboards updated within minutes of submission.
RGoogle SheetsGoogle FormsSQL ServerPower BI
Open Case Technical Case Study
Sensor Uptime Monitoring Dashboard
A monitoring dashboard built to detect sensor dropouts, latency issues, and abnormal posting intervals across multiple devices sending data into SQL.
Made it easier to identify failing or lagging sensors quickly instead of discovering data problems only after downstream analysis broke.
Power BISQLArduinoDirectQuery
Open Case