Data Cleaning
in SQL
Take raw housing data and transform it in SQL Server to make it more usable for analysis.
Data Cleaning
Data Cleaning in Excel
Bike Sales Analysis
This project involved building a dynamic and interactive dashboard using raw bike sales data in Excel. Key features include the use of pivot tables, slicers, and Excel’s built-in charting tools to summarize and visualize key sales metrics, providing clear insights into customer segments, sales trends, and regional performance.
Web Scraping
with Pandas
This project demonstrates how to extract and structure tabular data from a website using Python. By leveraging libraries such as requests, BeautifulSoup, and pandas, the project showcases a simple yet effective approach to web scraping, focusing on gathering meaningful data and converting it into a structured format for analysis.
Data Analysis
Mini Projects
This collection consists of hands-on mini projects including above projects designed to explore a variety of real-world data tasks such as data cleaning, SQL-based EDA, Excel dashboards, Python scripting, web scraping, and data visualization using Power BI and Tableau.