I have completed some MS Excel Course. This repository contains all the excel files (practice and exercises solutions by me) which were provided as Homework's or as hands on practice in course section.

Analysis of the Sakila DVD Rental database using SQL

This file contains advanced excel formulas and functions like Vlookup with match function, index and match function, offset & counta, logical operators, max if function, formula formatting, text functions, Date and time functions, data cleaning, etc. which I have worked on to take my excel skills at the high level.

excel vba's

Ecommerce Sales Dashboard By using POWER BI (DATA ANALYTICS)

This project consists of an excel dashboard on the Super Store data. Along with the dashboard, it tries to answer a few business problems in a report created on a separate worksheet.

This project provides a system for keeping accurate track of the credentials attached to an employee in a man-power driven service providing organization. This system ensures the most suitable employees are always called up for job assignments.

Ineuron_FSDA_2.0_Course_Assignments

Housing value predictive model (Using US official datasets to build predictive model by using excel)

Advanced MS Excel

This repository shows my Data Analysis Projects

You can find all the Excel Projects that I have worked on in here. Thanks for viewing

Conducted in-depth data analysis on E-commerce Sales Data to gain some meaningful insights on Products' Sales for each region and segment.

Data analysis and insights from NYC Airbnb listings, focusing on key metrics such as host performance, neighborhood trends, pricing, and customer reviews. Comprehensive documentation of ETL processes and analytical methodologies is provided. Perfect for understanding Airbnb dynamics and decision-making in the NYC market.

Excel, SQL, Python, and ML projects

A Power BI report to identify top 11 players for a T20 cricket team.

The project utilized Tableau, Excel and MySQL to analyze CSV-based employee data, offering insights into performance and attrition, aimed at enhancing employee retention and satisfaction.

Zomato Pizza Sales Analysis

This project leverages Excel 📊 to forecast YouTube views 📈 for the next 7 days using three methods: FORECAST Function 📉 Graph Trendlines 📈 Forecast Sheet Tool 📅 By comparing these methods, the project aims to identify the most accurate forecasting technique 🎯 and enhance predictive accuracy 🔍 for future view counts.

Using VBA, analyzing one year of stock data