Kopi Tengah Hari is a small business focused on producing and selling coffee to people of Surabaya with Pre-order system. This project aims to develop a data warehouse for the business and give insights to business owners using easy-to-understand dashboard.
Pentaho
The ETL Process is mainly developed by Pentaho
Microsoft Power BI
The Dashboard is designed and created using Microsoft Power BI
Microsoft Excel
The raw source data is stored in Microsoft Excel
In the team of eight members, my role is mainly to design the dashboard as well as the data flow to implement the ETL using Pentaho.
Drive Files