Walmart Weekly Sales
Analysis
In this project we are analyzing weekly sales data from Walmart various stores, using SQL to gain insights into stores sales performance during holidays.
Bookstore Database Analysis
In this project we are working with the bookshop data set for tableau. This is a good dataset to practice SQL skills as it showcases relationships and combination of data consisting of 13 tables.
HR Analysis:
Health bonus program and ansenteeism
In this project the HR department asked us to provide a list of healthy employess and employess with low absenteeism or their Healthy Bonus Program.
They also want to provide an annual compensation for an specific category of employess and better understand overall absenteeism at the company with a
dashboard based on an approved wireframe.
Segment shopping customers
with exploratory analysis
In this project we would like to help a marketing team to plan a strategy based on shopping groups devided by income, age and the mall score.
We performed exploratory analysis and k-means clustering algorithm to create our segments.
Analysing revenue
from hotel booking data
In this project we create a visual data story using Power BI to present to the stakeholders. They want to know if the hotel revenue yearly, if parking lot size should increase and what overall trends can we see.
Data cleaning in SQL
Simple student-food relationship raw data cleaning on SQL server to make it more usable for analysis.