DATA CLEANING USING SQL
PROJECT
USING SELECT, UPDATE, DELETE, INSERT, MULTIPLE STRING FUNCTIONS, DATE AND TIME FUNCTIONS, CONDITIONAL LOGIC, JOINS, SUBQUERIES, ROW_NUMBER(), AND DISTINCT FUNCTIONS.
DATA CLEANING USING SQL
EXPLORATORY DATA ANALYSIS PROJECT
USING SQL
Explored the data of layoffs in some companies in the world to find trends or patterns or anything interesting like outliers.
TABLEAU DASHBOARD FOR THE SEATTLE AIRBNB
This is a tableau dashboard for the projects on Seattle Airbnb.
COMPANY REGISTRATION DATA ANALYSIS USING EXCEL
Analyzed anonymized company registration data using Excel to uncover sector trends in turnover, incorporation, and closures. The project involved data cleaning, PivotTables, calculated columns, and interactive dashboards using charts and formulas to visualize insights and support recommendations.
PYTHON WEB SCRAPING PROJECT
I built an automated Amazon price tracker using Python, BeautifulSoup, and Pandas to scrape product titles and prices daily. The system logs data with timestamps and sends an email alert whenever the price drops to $15 or below.
SALES DATA ANALYSIS PROJECT USING POWERBI
This project involved analysing the sales performance of a retail business and an interactive Power BI dashboard was designed to display key performance indicators and visual insights
CUSTOMER CARE CALL LOGS ANALYSIS USING EXCEL
This project analyzed customer care call log data to identify key patterns in customer satisfaction, call duration, and representative performance.