Personal repository for hobby and work projects

This is a dataset related to web logging with attributes such hit rate, visit date, exit rate, bounce rate, no. of imp. pages etc, A lot of Data Mining Technologies can be applied to extract better information out of it, I have applied clustering and classification and also created the report that is the model explanation is very important in terms of real life problems.

Machine Learning involves using historical data and predictive modeling techniques to forecast the future demand for cab rides and the corresponding supply of cabs needed to meet that demand. This can help transportation companies optimize their fleet management and improve customer satisfaction.

Performed Big Data Analysis on Bundesliga Football League Dataset using tools PySpark, spark-SQL, and numpy and done in Jupyter Notebook.

This repository features SQL-based analysis on bike rentals and the NFT market. The bike rental project explores customer trends, peak rental times, and revenue insights, while the NFT case study analyzes sales trends, blockchain transactions, and market dynamics. Built using SQL queries for data cleaning, aggregation, and joins in MySQL.

Craft SQL queries to address the specified Business requirements.

Production-ready ELT pipelines using Airflow

Ad-Hoc analysis on Consumer Goods data to retrieve required insights using My SQL.

This project analyzes IPL data from the past three years to provide insights into player and team performance for Sports Basics' special edition magazine. It includes data analysis, dashboard creation in Power BI, and performance metrics to enhance fan engagement and decision-making. Built with SQL, Power BI, and Excel. 🚀

This project looks at how a telecom company's key metrics changed after launching 5G in May 2022. It compares data from before and after the launch to find out why active users and revenue dropped. The goal is to find useful insights and suggest ways to improve user growth and internet plans.

Data Analysis Using Excel Functions & Formulas — A practical business data analysis project

"This project analyzes ad hoc insights in the consumer goods domain for Atliq Hardware, a leading computer hardware manufacturer. It includes SQL queries for business insights, Power BI visualizations, and a presentation showcasing key findings. The objective is to analyze sales, costs, and customer trends to support data-driven decision-making."

This project leverages SQL to generate reports for top customers, market products, forecast accuracy, and monthly gross sales for AtliQ Hardware, a consumer electronics company. It includes stored procedures and SQL views for post and pre-invoice sales, enabling data-driven insights and improved business intelligence.

Решение ad-hoc задач на SQL для оценки рынка недвижимости и времени экспозиции лотов // Solving SQL ad-hoc tasks to evaluate real estate market trends and listing exposure time.

Two-way ANOVA with Interaction consulting analysis in R

Ad-hoc SQL analysis for AtliQ Hardware providing insights on products, sales, and market performance

Designed and developed an end-to-end Business Intelligence solution that converts complex sales data into strategic insights using SQL-driven modeling and Power BI analytics.

Streamlit repo for NOCCCD ad-hoc reports.