imamhambali.hashnode.devPostgreSQL 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...Feb 5·4 min read
imamhambali.hashnode.devData 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...Jan 30·5 min read
imamhambali.hashnode.devData 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 ...Jan 30·10 min read
imamhambali.hashnode.devABC 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...Jan 30·7 min read
imamhambali.hashnode.devFrom 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 ...Jan 30·19 min read
