This repository provides a set of scripts to extract data from a MySQL database, transform it into a CSV file, and integrate it with Google Sheets. The workflow includes database connection, querying, data transformation, and file generation.
This project consolidates monthly credit card statement data from Nubank into a single CSV file using Python, enabling data visualization through a Google Sheets dashboard in Looker Studio.
This project performs association analysis on a sales dataset, using the Apriori algorithm. The dataset is loaded from an Excel file, and a basket of items is created for each transaction. The Apriori algorithm is then applied to find frequent itemsets and association rules based on the support, confidence, and lift metrics.
data analytics and visualization workflow using Google BigQuery and Looker Studio. Using historical U.S. flight data from the Bureau of Transportation Statistics using GC BigQuery data Wearhouse, Looker Studio for data visualization.
This final task showcases a full end-to-end Business Intelligence workflow using PostgreSQL and Looker Studio. I performed data ingestion, table joining, relationship modeling, and created a consolidated master table to support dashboard development.
A serverless, event-driven data engineering pipeline on Google Cloud (Medallion Architecture) for real-time Transport for NSW transit analytics.
This project describes the analysis of San Franciso dataset using SQL in Bigquery and Looker Studio
Looker Studio - Portfolio
Manage big data on cloud computing to find a list of best-selling audible books, generate reports and dashboards, and provide products and sales promotions that meet the needs of consumers in Thailand
SaaS deal desk analytics using BigQuery, SQL, and Looker Studio
Dashboard de Análisis del Mercado Naviero desarrollado en Looker Studio, diseñado para analizar el flujo de importaciones y exportaciones del mercado peruano mediante datos de comercio marítimo.
Monitoring Google Cloud costs with Looker Studio.
This project aims to analyze Kimia Farma's business performance from 2020 - 2023. The analysis focuses on sales, profit, branch performance, and transaction ratings to provide insights that support strategic decision-making for the company.
Business performance analytics for Kimia Farma 2020–2023 using SQL (BigQuery) and Looker Studio
End-to-end data analytics project analyzing global unicorn startups using Python, BigQuery SQL, and Looker Studio.
Nutri Score impact on composition & distribution strategies.
To associate your repository with the lookerstudio topic, visit your repo's landing page and select "manage topics."