In this case study, I worked with a dataset from Danny's Diner, a restaurant that is expanding its customer base by offering a new rewards program.
My task was to analyze the data and answer questions related to customer spending habits and rewards program performance.
I found Case Study 1 to be an excellent way to apply my SQL skills to a real-world business problem.
I also learned how to use SQL to join tables, filter data, and aggregate information using functions like COUNT, SUM, AVG, and more.
In this project, I have performed Exploratory Data analysis on data about Covid deaths and vaccinations in SQL using SSMS.
Peformed data exploration on IPL dataset using python(pandas,numpy, matplotlib) in Jupyter Notebook.
Here, I performed web scraping on IMDB website to fetch the info aboout top 250 movies and store it in an excel file.
In this project created a dashboard for Overall dataset as well as product specific detail.
I have created a dashboard for Maven Market Sales Dataset which includes info about total transactions, revenue, profit, return rate of products. It can help stake holders to take business decisions.
I created dashboard using IBM Cognos Analytics software on an Auto industry dataset. It's a BI software which provides facility to create interactive visualizations.