Global Covid-19 Trends Analysis
The Global COVID-19 Trends Analysis project uses SQL to clean, organize, and analyze worldwide COVID-19 data, uncovering insights into infection rates, hotspots, and the effectiveness of containment measures.
TEJVIL CHAVAN
Data analyst with proficiency in Data Modelling, Data Transformation with the help of Python, Excel, SQL, Talbeau and Power Bi in addition to data cleansing and visualisation .
Housing Data
The Housing Data Analysis project employs SQL to clean, organize, and analyze housing data, revealing trends in prices, availability, and regional market dynamics to inform real estate decisions.
AIRBNB Price exploration
Created an Airbnb price exploration dashboard in Tableau, utilizing Excel for data cleaning, including pivot tables and advanced functions, to provide clear and actionable insights.
Retail Sales Power BI Dashboard
Developed a retail sales dashboard in Power BI, employing DAX for complex calculations, visualization techniques, and conditional formatting. Additionally, utilized Excel for initial data cleaning to enhance data quality and dashboard accuracy.
Amazon Product Analysis
Conducted Amazon product analysis using web scraping techniques with Beautifulsoup and requests in Python. Employed pandas for data manipulation and visualization to derive insights on pricing and reviews.
Tools
These tools and libraries form the backbone of a data analyst's toolkit, enabling efficient data handling, analysis, and visualization.
SQL Server
Essential for querying,data Cleaning and managing databases.
Microsoft Excel
Widely used for data manipulation, analysis, and visualization.
Microsoft Power BI
Microsoft tool for data visualization and business intelligence.
Tableau
Powerful tool for creating interactive data visualizations.
Python-BeautifulSoup
Library for web scraping and parsing HTML/XML documents.
Python-PANDAS
Library for data manipulation and analysis.