IHImam Hambaliinimamhambali.hashnode.dev·Feb 5 · 4 min readPostgreSQL to BigQuery: Simple Data Type MappingIf you move data from a PostgreSQL production database to BigQuery, you will quickly notice that the data types are different. PostgreSQL has many detailed types, while BigQuery uses fewer types and is designed for analytics. If you map the types cor...00
IHImam Hambaliinimamhambali.hashnode.dev·Jan 30 · 5 min readData Wrangling and Analysis in Ecommerce-Pt2This is Part 2. If you haven't read Part 1, check it out here , I covered data wrangling, cleaning, and analysis of sales by state and order trends. Question 3: Does Late Delivery Hurt Customer Satisfaction? Late delivery is a common problem in e-com...00
IHImam Hambaliinimamhambali.hashnode.dev·Jan 30 · 10 min readData Wrangling and Analysis in Ecommerce-Pt1In e-commerce, data helps businesses make better decisions and improve customer experience. But before we can analyze data, we need to clean and transform it first , that's what data wrangling is about. This can be simple stuff like removing missing ...00
IHImam Hambaliinimamhambali.hashnode.dev·Jan 30 · 7 min readABC Pizza Annual Sales PerformanceTL;DR Total revenue: $1.7 juta dari 38.85 ribu order Delivery vs Dine in: Delivery menghasilkan revenue lebih tinggi ($0.89 juta) meski order lebih sedikit Promo berhasil: Diskon 10% di Nov-Des meningkatkan order 26% Rekomendasi: Optimalkan jam o...00
IHImam Hambaliinimamhambali.hashnode.dev·Jan 30 · 19 min readFrom Match Results to Standings: A Step-by-Step Tutorial for Building a Premier League Table in SQLThe English Premier League (EPL) is a very famous football league. Many people all over the world love to watch it. If you are a fan, you might want to make your own league table to see how your favorite teams are doing. This guide will show you how ...00
