StudySphere

Search This Blog

Data Structure & Algorithms

on March 16, 2026

Get link
Facebook
X
Pinterest
Email
Other Apps

Data Structure & Algorithms

Get link
Facebook
X
Pinterest
Email
Other Apps

Comments

Retail Analytics Dashboard on Zepto Dataset using PostgreSQL, Excel, and Power BI

📁 Retail Analytics Dashboard on Zepto Dataset using PostgreSQL, Excel, and Power BI 📝 Project Description: 🃏The project focuses on analyzing a structured dataset from Zepto , a hyperlocal grocery delivery platform. It involves performing data cleaning, transformation, and visualization to uncover insights across categories, pricing, discount strategies, and product performance. The process integrates SQL for data exploration , Excel for data modeling , and Power BI for interactive dashboards to help understand business-critical KPIs like revenue distribution, stock status, discount optimization, and product-wise performance. 📄 Dataset Overview (Zepto Dataset) The dataset contains detailed information on products listed on Zepto, with the following key columns: 🚏 Column_Name | 🗺 Description 💧 Category | Product category (e.g., Beverages, Dairy, Fruits, etc.) 💧 name | Product name 💧 mrp | Maximum...

Complete SQL Tutorial / PostgreSQL Notes

🎀Introduction To SQL 1️⃣. What is SQL 2️⃣. Basic SQL Commands ? 3️⃣. SQL v/s NoSQL 4️⃣. Types of SQL Commands 5️⃣. What is Database 1️⃣. What is SQL SQL (Structured Query Language) is a standardized programming language used to manage and manipulate relational databases. It allows you to interact with a database. What You Can Do with SQL ? 💎Create databases and tables 💎Insert data into tables 💎Read/retrieve data (using SELECT) 💎Update existing data 💎Delete records 💎Control access to data (permissions) 💎Set constraints to maintain data accuracy 2️⃣. Basic SQL Commands 🗃 Command | 📇 Purpose 💎SELECT : Retrieve data 💎INSERT : Add new data 💎UPDATE : Modify data 💎DELETE : Remove data 💎CREATE : Create table or database 💎DROP : Delete table or database 3️⃣. SQL v/s NoSQL ⚔️ SQL vs NoSQL Feature | 🗃️ SQL (Relational) | 📦 NoSQL (Non-relational) (1.) Data Structure | Tables (rows and columns) | Varies: Documents, ...

IPL Sports Analysis Project in PostgreSQL

➣ IPL-Sports-Analysis-Project ➣ IPL Sports Analysis Project Using PostgreSQL. ➣ IPL - Indian Premier League 💬 IPL is a Professional Twenty20 Cricket League in India organised by the Board of Control for Cricket in India (BCCI). 💬 Founded in 2007, The League Features ten State or city based Franchies Teams. 💬 The IPL is the most Popular and richest Cricket League in the world and is held between March and May. 💬 IPL League Consists of Ten Teams. NO. | TEAM | City (01) | Chennai Super Kings(CSK) | Chennai, Tamil Nadu 💭 Chennai Super Kings (CSK) Owner : Narayanaswami Srinivas Won : 2010, 2011, 2018, 2021, 2023 Runner-UP : 2008, 2012, 2013, 2015...

Powered by Blogger