A high-performance interactive dashboard developed for a Large-Scale Winter Donation Campaign, managed by the Technical Committee of Farrah Association. This project focuses on consolidating complex data streams into actionable insights for humanitarian aid distribution.
The dashboard was designed to provide a 360-degree view of the campaign's operations. By unifying data from multiple technical sources, it enabled the team to monitor donations, track volunteer contributions, and manage the distribution of winter clothing across various demographics in real-time.
- Advanced Data Integration: Successfully unified data from diverse systems (BigQuery, Firebase, and Google Sheets) into a single, scalable, and auto-updating structure.
- Granular Analytics: Designed visualizations to track daily progress and detailed category breakdowns (e.g., gender, age groups, and clothing types).
- Operational Excellence: Empowered field teams with timely, accurate data, facilitating better planning and more efficient distribution strategies.
- Custom UI/UX: Developed a multi-page interface specifically tailored for campaign-optimized screen dimensions.
- Visualization: Looker Studio.
- Cloud Data Warehouse: Google BigQuery.
- Real-time Database: Firebase.
- Data Management: Google Sheets.
- Live Donation Tracking: Monitoring inflow and types of winter clothing donated.
- Demographic Breakdown: Statistics filtered by gender and age groups to ensure balanced distribution.
- Volunteer Logistics: Tracking total volunteer hours and field activity.
- Inventory & Distribution: Real-time metrics on clothing types and quantities distributed.