Data Warehouse with Data Viz Project

Data Warehouse with Google Cloud Platform resources using Python for data Extraction/Transformation and Power BI for Data Visualization

Table of Contents

• About the Project
  • Built With
• Data Warehouse
• New Architecture Proposal
• Data Model View
• Data Visualization
• Contact

About The Project

The main objective of this project is to develop a full pipeline of data by extracting, transforming and loading(ETL)into a data warehouse environment considering the best practices, allowing data visualization platforms to connect and explore business questions and eventually retrieve insights of it.

Built With

These are the main softwares used to develop this project:

• Colab
• BigQuery
• PowerBI

Data Warehouse

You may access the data warehouse in Big Query through the following link: Google Big Query

New Architecture Proposal

To continuosly improve the architecture this is the latest proposal for the architecture considering GCP resources (ps:I'm currently working on the scripts)

Data Model View

Calculated Columns

Some calculated columns were created in power bi in order to support the measures

Data Visualization

You can access the report through the link below: SaaS - Customer Payment Analysis

The Report has 2 pages, the first one is an overview of the business and the second one has detailed information including all measures created for this report. First Page:

Second Page:

Contact

Samuel Geron - Linkedin

Project Link: https://github.com/SamuelGeron/gcpDW/