Popular repositories Loading

1. hr-management-sql hr-management-sql Public

   HR database system with 5 tables, 13 employees, self-referencing manager FK, and 15 analytical queries covering JOINs, subqueries, window functions (RANK, SUM OVER), salary history tracking, and de…

2. sales-analytics-dashboard sales-analytics-dashboard Public

   Interactive sales dashboard built with Flask, SQLite, and Chart.js. Features KPI cards (revenue, orders, customers), bar and doughnut charts for product performance, and a detailed product breakdow…

   Jupyter Notebook

3. access-control-system access-control-system Public

   Role-based access control system with bcrypt password hashing, admin/editor/viewer roles, user management, and a full audit log of every login attempt and admin action. Built with MySQL, Flask, and…

   HTML

4. banking-financial-sql banking-financial-sql Public

   Retail banking database with 7-table schema, realistic sample data, and 12 analysis queries covering cash flow, branch performance, loan health, dormant accounts, and high-value transaction flaggin…

5. medicaid-spending-analysis medicaid-spending-analysis Public

   Medicaid drug spending analysis (2019–2023) using MySQL, Power BI, and Python — built as a healthcare data analyst portfolio project.

   Jupyter Notebook