Project Links

Data Cleaning Walkthrough using SQL

Using SQL to clean raw housing dataset using SSMS

Duplicates, correcting data types, checking nulls

Data Exploration using Yelp Dataset

Using SQL to explore and answer few related questions with the dataset using SSMS

Sales Dashboard Project using SQL and Power BI

This warehouse dataset was taken from the Microsoft sample dataset website and I have used SQL and Power BI to answer business scenario

Covid-19 Data Exploration using SQL

This dataset was taken from the website

SQL Window Functions for Data Manipulation

Using SQL window functions to manipulate database using SSMS

Lead, lag, Row number, CTE, Partition By, First Value

Sales Dashboard Project using SQL and Power BI

This warehouse dataset was taken from the Microsoft sample dataset website and I have used SQL and Power BI to answer business scenario

Data Professionals Survey

Using Power BI to create dashboard using the dataset that has been cleaned

Pahang Crime Statistics

The data was taken from the Malaysia Open dataset under PDRM statistics in the year 2018

Using DAX in Power BI

Using DAX throughout Power BI to create robust data scenarios, manipulate data and derive insights

Exploratory data analysis (EDA) for Bike Sharing system using R and Power BI

Demonstrate the map and location functionality using Power BI

Exploratory data analysis (EDA) for Bike Sharing system using R and Power BI

Using R to explore the dataset

Amazon Web Scraping using Python

For this project, I used python to scrape product data and transferring it into an excel file so that it can be used for further analysis

BeautifulSoup,requests, time, datetime, smtplib

Covid-19 Dashboard

This dashboard was created as an extension of the Covid-19 Data Exploration using SQL project