Phase 3: Analytics & Reporting

I developed several specialized SQL queries to analyze operations:

1. Basic Checkout Details Report: Transaction-level data for auditing

2. Item Popularity Report: Frequency metrics for inventory planning

3. Monthly Donation Trends: Time-series analysis of student reach and volume

4. Student Program Distribution: Demographic analysis by academic program

5. Inventory Usage Report: 4-month comparative analysis for stocking needs

6. Staff Payroll Report: Labor hour tracking and expense management

Source Code:

The query files for this project can be found on my GitHub repository: https://github.com/RodrigoSeneca/donation-center-management-system