Data Analytics Project Report

Title: Connecting Supabase (PostgreSQL) to Looker Studio for Data

Visualization
Prepared by: UMAIR SAAD

Date: 14/09/2025

DASHBOARD
Table of Contents
1. Introduction
 Background and Problem Statement
 Purpose and Scope

2. Tools and Technologies

2.1 Google Looker Studio – Visualization Features
2.2 Supabase – Hosted PostgreSQL and APIs
2.3 PostgreSQL – RDBMS Capabilities

3. Project Objectives
 Data Cleaning and Validation
 Master Table Creation
 Database Connection
 Dashboard Development
 Deliverables

4. Data Preparation
 Overview of Raw Datasets
 Cleaning and Standardization

5. Master Table
 Joining Datasets
 Schema and Relationships

6. Integration with Looker Studio

 Configuring Supabase
 Connecting and Testing

7. Dashboard Development
 KPI Visualizations
 Filters and Interactivity

8. Insights and Observations

9. Exporting and Sharing
10. Conclusion and Recommendations
 1. Background
In today’s digital era, organizations depend on data-driven insights for decision-making. Yet, raw data often
comes fragmented across multiple sources, inconsistent, or filled with errors.

This project focuses on data cleaning, integration, and visualization. The datasets are consolidated and
hosted on Supabase (PostgreSQL), while Google Looker Studio is used to create dynamic dashboards.

The end goal is to build a centralized, interactive reporting system that highlights KPIs like applicant
demographics, outreach trends, and campaign performance.

2. Tools and Technologies

Google Looker Studio

A free platform for building visual reports and dashboards by linking to diverse data sources.

Highlights:

 Intuitive drag-and-drop interface

 Customizable filters and date ranges
 Real-time collaboration features
 Simple sharing through live links or PDF exports

Supabase

An open-source backend alternative to Firebase, offering a hosted PostgreSQL database along with APIs for
authentication, storage, and real-time data handling.

Advantages:

 Quick setup and beginner-friendly

 Secure hosting for structured datasets
 Direct SQL query access via PostgreSQL

PostgreSQL

A robust open-source relational database management system (RDBMS) designed for reliability and advanced
data operations.

Core Strengths:

 Full support for SQL standards

 Strong mechanisms for data integrity
 Advanced features like indexing, joins, and constraints

3. Goals of the Project

The project is designed to achieve the following:

 Perform cleaning and validation of applicant, outreach, and campaign datasets

  Integrate them into a unified Master Table
 Establish a connection between the PostgreSQL database and Looker Studio
 Develop interactive dashboards showcasing KPIs
 Share insights through live dashboards or exported reports

1. Data Preparation and Cleaning

Data cleaning involved handling missing values, removing duplicates, correcting data
inaccuracies, and standardizing formats.
- Handling Missing Values
- Removing Duplicates
- Correcting Inaccuracies
- Standardizing Data

2. Master Table Creation

The Master Table was created by joining:
- Applicant Data: app_id, country, university_applicant
- Outreach Data: Reference_ID, Received_AT, Outcome_1
- Campaign Data: campaign_name, category, intake, start_date
3. How to Connect PostgreSQL Data to Looker Studio Using Supabase

o Steps in Looker Supabase

1. Set Up Your Supabase Project
 Go to Supabase.io and sign up or log in.

 Create a new project by linking it to your existing PostgreSQL database or by

creating a new PostgreSQL instance within Supabase.

 

 Once the project is ready, go to the Settings > Database to get your database
connection details, including host, port, database name, username, and password

 
 2. Steps in PGAdmin
 Open pgAdmin after installation.

 In pgAdmin, look for the Servers section in the left sidebar.

 Right-click on Servers and select Create > Server.

 Fill in the Connection Details

You’ll see a dialog with multiple tabs.

 General tab:
 Name: Give your server connection a friendly name (e.g., Supabase DB).

 

 Connection tab:
 Host name/address: This is the database host address from Supabase (e.g.,
db.xxxxx.supabase.co).

 Port: Default PostgreSQL port is 5432 (check your Supabase dashboard).

 Maintenance database: Usually postgres.

 Username: Your PostgreSQL user (from Supabase, often postgres).

 Password: Your PostgreSQL password (set when creating the Supabase project).
  

Optional: Check Save Password if you want pgAdmin to remember it.

 Save and Connect

 Click Save.

 pgAdmin will attempt to connect to the PostgreSQL database using the provided
credentials.

 If successful, your new server will appear under Servers in the left panel.

 Expand it to browse databases, schemas, tables, and other objects.

3. Steps in Looker Studio:

 Open Looker Studio and select Create > Data Source.

 Choose the PostgreSQL connector from the list of available connectors.

 Fill in the connection form with the following details:

o Host Name: Your PostgreSQL server address.

o Port: Usually 5432, unless your server uses a custom port.

o Database: The target database name.

 o Username: Your PostgreSQL username.

o Password: The password for the user.

 Click Authenticate or Connect.

 Once connected, select the tables or write custom SQL queries to define the data you
want to import.

 Save the data source and start building reports with live data.

 

 

4. Building the Dashboard

- KPIs (Scorecards): Total Applicants, Total Outreach Calls, Total Campaigns
- Bar Charts: Applicants by country, campaign, and university
- Line Charts: Outreach calls over time
- Tables: Campaign-wise KPIs and applicant details
- Filters: Country, campaign name, date range

9. Exporting and Sharing the Dashboard

- Exported dashboard to PDF (File → Download → PDF).
- Generated a live share link with 'Viewer' access for stakeholders.
10. Conclusion & Recommendations
This project successfully:
- Cleaned and standardized raw data from multiple sources
- Created a robust Master Table for analysis
- Built an interactive dashboard with filters and KPIs
- Made insights easily accessible via live link and PDF

Recommendations:
- Automate future data cleaning with scheduled SQL scripts
- Add more performance metrics like call success rates and conversion ratios
- Create campaign-level trend analysis for deeper insights

Short slide deck to explain the chart types, color schemes, layout
decisions, and storytelling approach used to build the dashboard

Dashboard_Design_p
pt.pptx
-----------Double Click here to view ppt

Link to the LOOKER STUDIO DASHBOARD:

LOOKER STUDIO DASHBOARD