Skip to content
View SandyGCabanes's full-sized avatar

Block or report SandyGCabanes

Block user

Prevent this user from interacting with your repositories and sending you notifications. Learn more about blocking users.

You must be logged in to block users.

Maximum 250 characters. Please don’t include any personal information such as legal names or email addresses. Markdown is supported. This note will only be visible to you.
Report abuse

Contact GitHub support about this user’s behavior. Learn more about reporting abuse.

Report abuse
SandyGCabanes/README.md

Sandy G Cabanes, Data Analyst

Hi, I'm Sandy G. Cabanes — a Freelance Full-Stack Data Analyst with a strong Marketing Research background.

AI spaces have made it easier to get an answer — but it is still critical to have clean data, sound structure, secure settings, replicability, and of course, pipelines that work. ML APIs are racing to get the analysis done quickly, but it is still important to link analysis to the right business questions, and make them actionable.

My work focuses on:

  • Building end-to-end pipelines to analysis for small teams and organizations
  • Cleaning and structuring data so it's ready for analysis — or for whatever AI layer sits on top
  • Delivering dashboards and insight reports that people can actually use

Tools I use: Python, SQL, R, Power BI, Tableau, Excel with Power Query.
Experience with cloud environments: Google Cloud, AWS, Azure, Databricks.

You can browse my analysis projects and case studies in the repositories below.
For a more comprehensive gallery of projects, see the Showcase Page



Recent Additions:



Xero → Fivetran → BigQuery Pipeline

A data pipeline that moves Xero accounting data into Google BigQuery automatically, applies a transformation layer using dbt, and produces analytics-ready tables that can be queried across all invoices, clients, and time periods simultaneously. Click Here for Analyst's Report to Stakeholders

Click Here for the Full Pipeline Details

Click Here for the Data Quality Findings

Xero - Fivetran - BigQuery Walkthrough

Xero - Fivetran - BigQuery Walkthrough




MMDA Traffic Data Pipeline from PDFs to Data Analysis with Databricks

Applies modern data workflow in the Databricks cloud platform. Parsed annual traffic data from Metro Manila Development Authority portal that are only available in scanned pdf hard copies of reports. Data from pdfs automatically stored as delta tables in Databricks.

Click here for the project

MMDA Average Annual Daily Traffic Analysis



ECommerce Sales and Customer Analytics With Supabase Google Sheets and Looker Studio (Data Studio)

Click Here for Analyst's Report to Stakeholders

ECommerce Sales and Customer Analytics With Supabase Google Sheets and Looker Studio





Health Code Compliance Analysis for NYC Restaurants Using SQL, Power BI

Click Here for Analyst's Report to Stakeholders

Health Inspection Dashboard for NYC Restaurants



Electric Vehicles Market Size and Revenue Analysis Dashboard - Python Version

Click Here for Analyst's Report to Stakeholders

[EV Dashboard]



Happiness Data - AWS Glue ETL

ETL Workflow


Data Analysis and Machine Learning:

Automation:

Data Engineering:

Pinned Loading

  1. Tableau_PortfolioProjects Tableau_PortfolioProjects Public

  2. SQLProject_Apple_Store_Apps SQLProject_Apple_Store_Apps Public

    Deeper Exploratory data analysis with my own SQL queries after following initial Guided Video