Ani The Analyst Portfolio

This project involves the exploration and analysis of COVID-19 data using SQL. The analysis includes data cleaning, aggregation, and querying to extract meaningful insights from the dataset. Key tasks include calculating total cases, deaths, and recoveries, as well as identifying trends and patterns over time. The project highlights skills in database management, SQL query optimization, and data-driven decision-making.

• View Project

This Tableau dashboard provides an interactive visualization of COVID-19 data. It includes key metrics such as case counts, recoveries, and deaths, segmented by region. The dashboard allows users to explore trends over time, compare data across different regions, and gain insights into the pandemic's impact. The project demonstrates proficiency in data visualization, dashboard design, and using Tableau for presenting complex datasets in an intuitive and user-friendly manner.

• View Project

This project involves developing a Python script to scrape product data from Amazon using the BeautifulSoup library. The script extracts product titles and prices and saves them to a CSV file for analysis. The project showcases the use of libraries like requests, BeautifulSoup, and pandas for web scraping and data processing, and it demonstrates automation by running the scraper at regular intervals.

• View Project

This project demonstrates how to interact with APIs using Python. It covers making requests to an API, parsing JSON responses, and visualizing data from a Crypto website. The project is designed to help users understand the basics of API integration, including sending requests, handling responses, and analyzing data retrieved from external services. The notebook also includes examples of using popular libraries like requests and pandas for data manipulation and seaborn for data visualization.

• View Project