Skip to content

GretaLim/BigQuery_Dashboards

BranchesTags

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

32 Commits
M3 S1 retention graph.sql
M3 S1 retention graph.sql
 
 
M3 S1 retention.sql
M3 S1 retention.sql
 
 
M3 S2 A_B testing.sql
M3 S2 A_B testing.sql
 
 
M3 S2 funnel analysis.sql
M3 S2 funnel analysis.sql
 
 
M3 S3 CLV.sql
M3 S3 CLV.sql
 
 
M3 S3 RFM.sql
M3 S3 RFM.sql
 
 
M4 S1 Protuct Analyst.sql
M4 S1 Protuct Analyst.sql
 
 
M4 S2 Marketing Aalysis.sql
M4 S2 Marketing Aalysis.sql
 
 
M4 S3 correlations.sql
M4 S3 correlations.sql
 
 
M4 S3 geolocation data clean.sql
M4 S3 geolocation data clean.sql
 
 
M4 S3 order_customer_review.sql
M4 S3 order_customer_review.sql
 
 
M4 S3 order_product_seller.sql
M4 S3 order_product_seller.sql
 
 
M4 S3 payments.sql
M4 S3 payments.sql
 
 
Module_1_Sprint_3_Task-1.1.sql
Module_1_Sprint_3_Task-1.1.sql
 
 
Module_1_Sprint_3_Task-1.2.sql
Module_1_Sprint_3_Task-1.2.sql
 
 
Module_1_Sprint_3_Task-1.3.sql
Module_1_Sprint_3_Task-1.3.sql
 
 
Module_1_Sprint_3_Task-1.4.sql
Module_1_Sprint_3_Task-1.4.sql
 
 
Module_1_Sprint_3_Task-2.1.sql
Module_1_Sprint_3_Task-2.1.sql
 
 
Module_1_Sprint_3_Task-2.2.sql
Module_1_Sprint_3_Task-2.2.sql
 
 
Module_1_Sprint_3_Task-2.3.sql
Module_1_Sprint_3_Task-2.3.sql
 
 
Module_1_Sprint_4_Task-1.sql
Module_1_Sprint_4_Task-1.sql
 
 
Module_1_Sprint_4_Task-2.sql
Module_1_Sprint_4_Task-2.sql
 
 
Module_2_Sprint_1_Customer_Loyalty.sql
Module_2_Sprint_1_Customer_Loyalty.sql
 
 
Module_2_Sprint_1_Sales_reason.sql
Module_2_Sprint_1_Sales_reason.sql
 
 
Module_2_Sprint_1_order_details.sql
Module_2_Sprint_1_order_details.sql
 
 
Module_2_Sprint_1_sales_location.sql
Module_2_Sprint_1_sales_location.sql
 
 
Module_2_Sprint_2_Customer_by_Region.sql
Module_2_Sprint_2_Customer_by_Region.sql
 
 
Module_2_Sprint_2_Customer_by_year.sql
Module_2_Sprint_2_Customer_by_year.sql
 
 
README.md
README.md
 
 

Repository files navigation

BigQuery Codes, Looker-Studio Dashboards

Payments/Monetization Analyst

BigQuery codes:
Payments
Location data cleanup
Order-Customer-Review
Order-Product-Seller
Correlations

Marketing Analyst

The Tableau Public Dashboard

BigQuery codes:
Sessions & Marketing Analysis

Product Analyst

The Looker Studio Dashboard

BigQuery codes:
Sessions with Purchases

CLV, Customer Segmentation & RFM

CLV: The Looker Studio Dashboard
RFM: The Looker Studio Dashboard

BigQuery codes:
CLV
RFM

Funnels & A/B Tests

Funnel Analysis Overview
A/B testing Review

BigQuery codes:
Funnel Analysis
A/B Testing

Retention, Cohorts & Churn.

The Looker Studio Dashboard

BigQuery codes:
Retention Rate
The Graph

The AdventureWorks Offline Sales Analysis Project:

The Looker Studio Dashboard

BigQuery codes:
Customer by Region
Customer by Years

The AdventureWorks Sales Analysis Project:

The Looker Studio Dashboard

BigQuery codes:
Customer Loyalty
Sales Reason
Orders Details
Sales Headers

My First Codes with Advanced SQL Techniques:

Customers report, Sales report.

First BigQuery codes (can be omitted):

A, B, C, D, E, F, G.

About

Some of my SQL code, created dashboards

Topics

bigquery dashboards tableau looker-studio

Resources

Readme
Activity

Stars

1 star

Watchers

1 watching

Forks

0 forks
Report repository

Releases

No releases published

Packages

No packages published