Covid-19 Data Exploration Using SQL

In this project, I carried out an exploratory analysis on covid-19 deaths and vaccination. Insights like the continents and countries with the highest recorded cases, deaths, and vaccinations were derived

Power BI - Ski Resorts Analysis

In this project, I created a one-page interactive and informative dashboard to help skiers around the world find the ideal ski resort for thier location, skiing level, and budget.

Demand and Supply Analysis

The Analysis of Demand and Supply means investigating the relationship between the quantity demanded and the quantity supplied. It helps businesses understand the factors influencing consumer demand to maximize profits. In this project, I used Python to analyze and visualize the demand and supply relationship of a ride company.

Data Cleaning and Preparation in SQL

In this project, I loaded a raw housing data and transformed it in SQL server to render it more usable for analysis and visualization.

Plato's Pizza - Sales Performance Analysis

In this project, Using Microsoft Excel for data preprocessing and Power BI for analysis and visualization, I played the role of a BI analyst and I analyzed Plato's pizza datasets to improve operations, work efficiently, find opportunities and drive more sales

Sales Analysis using Microsoft Excel

I played the role of a Business Intelligence Analyst for G 'n' G fashion store. I dug deeply into their sales across all branches. I analyzed the sales of G 'n' G fashion store to know the sales by state, manager, channel, category, month and year. I then built an interactive Excel dashboard answering the relevant business questions.

A/B Testing Using Python

In this project, I used python to analyze two marketing strategies to choose the best marketing strategy that can effectively and efficiently convert more traffic into sales.

Visual Dashboards

The majority of stakeholders' concerns center on insights, and it has been demonstrated that insights are easier to comprehend with images than with figures. As a result of this, I have done a lot of research on the best chart formats for different audiences and the peculiarity of the insight that needs to be conveyed.

Here are a few dashboards I created using Power BI and Microsoft Excel.

Get in touch