Greeve
Final Project Capstone Alterra Academy
Explore the Greeve Visualization Dashboard

About Project

Greeve is an innovative app that aims to increase user awareness and participation in environmental conservation and make it easier to purchase eco-friendly goods and equipment. The app not only offers a platform to purchase environmental goods and equipment, but also provides information on the impact of users' activities on the environment as well as how to measure and reduce that impact. The following is greeve documentation from the data engineer side.

Our Data Engineer Team

Name
Adhira Riyanti Amanda
Muhammad Dzikri Rizaldi
Zahra Putri Zanuarti

High Level Architecture

• Data Collection: We gather data from various sources, such as application logs using Cloud Logging and MySQL databases. This data includes user activities, transactions, challenges, and other relevant information.

• ETL Process: Using Apache Airflow, we schedule and manage the process of extracting data, transforming it into a usable format with Python scripts, and then loading it into Firebase for storage. This process ensures the data is clean and structured properly.

• Automation and Storage: We automate the transfer of data from Firebase to Google BigQuery tables using Google Cloud Functions.

• Data Analysis: In BigQuery, we perform detailed analysis to understand patterns and trends in user behavior, such as how users choose eco-friendly products and participate in challenges.

• Data Visualization: We use Looker Studio to create interactive dashboards. These visualizations help stakeholders easily understand and make decisions based on the data, such as assessing the effectiveness of environmental initiatives.

Star Schema

We use this star schema design in Big Query tables to simplify queries and improve their performance

Visualization Dashboard

Looker Studio Dashboard