Olist E-commerce Data Analysis with BigQuery & Looker Studio | Full Project Walkthrough

📊 Olist E-commerce Data Analysis Project | Google Cloud + BigQuery SQL + Looker Studio Dashboard

In this video, I walk you through a complete end-to-end data analysis project using the popular Olist e-commerce dataset. This is a perfect case study for aspiring data analysts looking to build real-world projects for their portfolio or interviews.

🚀 What I cover in this project:

Uploading raw CSVs to Google Cloud Storage (GCS)

Performing data cleaning, merging, and transformation using BigQuery SQL

Creating a final clean internal table for analysis

Connecting BigQuery to Looker Studio for report-building

Designing a filterable one-year performance dashboard with key e-commerce KPIs

🔍 Skills Used:

Google Cloud Platform (GCP)

BigQuery SQL (Joins, Aggregations, CASE, DATE functions, etc.)

Data Transformation & Modeling

Looker Studio (formerly Data Studio) for reporting

🎯 Whether you're learning how to use Google Cloud for data analysis or want inspiration for your next data project, this video will guide you step-by-step through the process.

📁 Dataset: Olist (Brazilian E-commerce Public Dataset)
📌 Tools: Google Cloud Storage | BigQuery | Looker Studio
💼 Ideal for: Data Analyst Portfolios | Interview Preparation | SQL Practice

👉 Don't forget to like, comment, and subscribe for more data projects!

#OlistProject #BigQuery #LookerStudio #GoogleCloud #DataAnalystPortfolio #SQLProject #EcommerceData #DataAnalysis #DataVisualization #GCP #BigQuerySQL #LookerDashboard

Видео Olist E-commerce Data Analysis with BigQuery & Looker Studio | Full Project Walkthrough канала Mohd Arshad