Project-Based-Virtual-Internship-BI-Analyst-Bank-Muamalat

Tools: MySQL Workbench, Looker Studio

Programming Language: SQL

Project Background

The project employs a case study featuring comprehensive transaction records of PT Sejahtera Bersama within Bank Muamalat X Rakamin Academy's virtual internal project. It utilizes four tables for analysis, including Customers, Products, Orders, and ProductCategory.

Steps for Analysis:

1. Identifying the Primary Key across four tables: Customers, Products, Orders, and ProductCategory.
2. Establishing Foreign Keys to establish connections between tables.
3. Defining table relationships using MySQL Workbench.
4. Generating a master table via MySQL Workbench, comprising:

• Customer Email
• Customer City
• Order Date
• Order Quantity
• Product Name
• Product Price
• Product Category Name
• Total Sales

5. Saving the master table results in CSV format.
6. Creating dashboards or visualizations through Looker Studio.
7. Offering recommendations or proposals to PT Sejahtera Bersama for maintaining or boosting sales based on transactional data.

Dashboard Visualization

Link Dashboard Looker Studio

Result Slide