A Data Engineering deep dive with several data warehouses using real data sourced from Kaggle
-
Updated
Jan 12, 2025 - Python
A Data Engineering deep dive with several data warehouses using real data sourced from Kaggle
SQL case studies and exercises from my studies at Mate Academy. This repository contains queries for data analysis, transformations, and optimization, covering topics like joins, window functions, and aggregate queries. A learning journey in SQL for data analytics.
Combined and manipulated 12 datasets to get insights into bike rider behavior and trends.
Code Repository
GitHub repository showcasing strategies to optimize Google BigQuery (GBQ) costs when dealing with raw data dumps.
Google Data Analytics Capstone Project
Apache Airflow powered ETL Pipeline for moving about 133k images from Kaggle to GCS and BigQuery
Target Brazil E-Commerce Analytics | SQL Business Case Study + Customer Intelligence & Retention Analytics
Analyzed 100,000+ Target Brazil e-commerce orders (2016–2018) using SQL and Google BigQuery. Explored customer behavior, sales trends, and purchasing patterns to uncover business insights. Recommended targeted promotions and inventory optimization to improve sales performance.
Digital User Churn Dashboard RakaminxBankMuamalat
This project showcases a sales operations Velocity Dashboard in Power Bi. Designed to track sales velocity, I utilized a public B2B ficticious dataset as the source of data, Google BigQuery for data warehousing and Power BI for advanced data modeling, DAX measure creation, and interactive visualization.
End-to-end E-commerce Sales Analytics project using Google BigQuery, SQL and Microsoft Power BI.
Statistical analysis and visualization of A/B test results to evaluate key metrics. Data aggregated via SQL in BigQuery, significance tested in Python, results shown in an interactive Tableau dashboard.
Automated ETL pipeline using Python, Pandas, Apache Airflow, Docker, and Google BigQuery to extract, transform, and analyze trending movies and TV shows from the TMDB API.
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.
medicare data analysis
📑 This repository serves as a business case study for a prominent retail supermarket, leveraging SQL to analyze and derive valuable insights, aiding in strategic decision-making for the retail giant.
🌾 AI-Powered Multi-District Precision Agriculture, Multilingual Odia/Hindi Voice Intelligence, Real-Time Open-Meteo Telemetry & DAO Governance Workflows for Odisha. Built for Google Cloud Gen AI Academy APAC Edition.
To associate your repository with the googlebigquery topic, visit your repo's landing page and select "manage topics."