Skip to content

The Walmart Black Friday Real-Time Data Warehousing project aims to build an advanced solution for handling the surge of data on Black Friday, enabling strategic decision-making.

Notifications You must be signed in to change notification settings

KRISHNASAIRAJ/Black-Friday-Sales-Analytics

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

8 Commits
 
 
 
 
 
 
 
 

Repository files navigation

Black-Friday-Sales-Analytics

The Walmart Black Friday Real-Time Data Warehousing project aims to build an advanced solution for handling the surge of data on Black Friday, enabling strategic decision-making.

Architecture

🚀 Here is my real time "Black Friday Sales Analytics Project"! Built Using Python, GCP Pub/Sub, BigQuery, Cloud Functions and Google Looker Studio.

🔍 Project Highlights:

📊 Python Enchantment: Generating mock sales transactions and inventory changes, publishing them to Pub/Sub topics.

🪈 Double Pub/Sub: Distributing data to distinct Pub/Sub topics, each activating its dedicated Cloud Function.

🛠️ Cloud Functions: Reacting to Pub/Sub events, extracting and integrating data from the stream (Python script) into BigQuery for comprehensive analysis.

📈 Real-time Inventory Maintenance: Ensuring synchronized inventory data for precise stock levels and enriched sales analysis, updating in real-time upon transaction generation.

📉 Google Looker Studio Unleashed: Leveraging Google Looker Studio for data visualization, presenting Hourly, Daily, Weekly Sales Reports with dynamic visualizations for actionable insights.

Hourly,_Daily,_Weekly_Sales_Report_page-0001

https://lookerstudio.google.com/s/n6KBF6FfwXE

Video Explanation

Check out the video below for a detailed explanation of the project:

Watch Video - In this video, I provide a clear explanation of the project architecture and its components, demonstrating how each technology is utilized to create a real-time Black Friday sales analytics solution.

Original Products List Dataset

https://www.kaggle.com/datasets/mdhamani/extensive-products-data

About

The Walmart Black Friday Real-Time Data Warehousing project aims to build an advanced solution for handling the surge of data on Black Friday, enabling strategic decision-making.

Topics

Resources

Stars

Watchers

Forks

Languages