Skip to main content

StudySphere

Search This Blog

Previous Year Questions (MCQs) on data structures - II

on May 15, 2026

Get link
Facebook
X
Pinterest
Email
Other Apps

100+ PYQ Data Structure

Get link
Facebook
X
Pinterest
Email
Other Apps

Comments

Popular Posts

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...

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...

Blinkit Grocery Analysis

✅Blinkit Analysis 🛒 ❇️ Business Requirements To conduct a comprehensive analysis of Blinkit's sales Performance, customer satisfaction, and inventory distribution to identify key insights and opportunities for optimization using various KPIs and visualizations in Power BI . ❇️ KPI's (Key Performance Indicator) Requirements 📊 (A). Total Sales : The Overall revenue generated from all items sold. (B). Average Sales : The Average revenue per sale. (C). Number of Items : The total count of different items sold. (D). Average Rating : The Average customer rating for items sold. ❇️ Chart's Requirements 📶 1️⃣ Total Sales by Fat Content 🎯 Objective : Analyze the impact of fat content on total sales. 📊 Additional KPI Metrics : Assess how other KPIs(Average Sales, Number of Items, Average Rating) vary with fat content. 📶Chart Type : Donut Chart. 2️⃣ Total Sales by Item Type 🎯 Objective : Identify the performance of different i...

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, ...

Powered by Blogger