Data Analysis - SQL, Python, Power BI.
Data analysis projects using SQL
1. Sales Data Exploration using SQL.
This project demonstrates a series of SQL queries used to analyze and extract meaningful insights from a sales database. The database consists of multiple tables, including regions, sales representatives, accounts, orders, and web events. Each query is designed to perform specific data retrieval and aggregation tasks to support business analysis.
2. Zomato Data analysis using SQL.
This project involves analyzing restaurant data from Zomato to gain insights into restaurant ratings, types, votes, and other attributes. The dataset includes various features such as restaurant name, rating, location, type of service, votes, approximate cost, and whether online ordering is available.
3. Exploring the NASA Astronauts using SQL.
In this project, we analysed their talent, education, and diverse backgrounds are paramount. Every astronaut who has embarked on a journey to the cosmos is a testament to years of unwavering commitment and relentless pursuit of knowledge. Their experiences are as varied as the constellations in the night sky, with each astronaut bringing their unique set of skills, education, and expertise to the NASA family.
4. Book Recommendation System using Python.
This project aims to build a book recommendation system using collaborative filtering and cosine similarity. The system provides book recommendations based on user ratings and similarities between books.
5. E-commerce Analysis using Power BI.
This project provides an in-depth analysis of an e-commerce business using Power BI tools. Key business metrics and trends are visualized through a comprehensive dashboard, enabling data-driven decision-making and fostering business growth. The project also incorporates forecasting techniques for predictive analysis. The primary objective is to deliver actionable insights into the e-commerce landscape, identifying areas for improvement and growth through thorough analysis.