What I Do

Data Analysis

I perform thorough data analysis using Python, including data cleaning, preprocessing, and exploratory analysis, to uncover valuable insights and patterns

Data Visualization

I create visually apealing and interactive data visualizations using tools like Tableau, effectively communicating complex data insights

SQL & Database Quering

I possess strong SQL skills, allowing me to efficiently retrieve and manipulate data from databases, perform joins, aggreagations, and create complex queries for analysis

Excel

I am proficient in using excel functionalities such as Vlookup, conditional formatting, pivot tables, and formulas to manipulate large datasets efficiently

Projects

Analyzing YouTube Data

The goal of this analysis was to construct an interactive Tableau dashboard to extract insights on the preferred and unpopular categories, identified the channel with the highest views, and assessed the correlation between increased views and higher likes

Hotel Booking Cancellation Analysis

The goal of this analysis was to gain insights into the factors influencing booking cancellations, understand patterns and trends, and identify opportunities to reduce cancellations.The analysis was based on historical booking data spanning from 2015 to 2017, comprising of 19390 bookings.

Exploration of US Bikeshare Data

Explored data related to bike share systems for three major cities in the United States—Chicago, New York City, and Washington. Wrote code to import the data and answer interesting questions about it by computing descriptive statistics and a script that takes in raw input to create an interactive experience in the terminal to present the statistics

Investigate a Relational Database

Queried the database to gain an understanding of the customer base, such as what the patterns in movie watching are across different customer groups, how they compare on payment earnings, and how the stores compare in their performance. Used of SQL- PostgreSQL to query the data by using joins, aggregates, subqueries and window functions and loaded the results in Excel to gain insights

AirBnB Booking Analysis

This project's objective was to understand pricing patterns of Airbnb listings. The average price per bedroom, price per zip code was examined. The distinct count of bedrooms was also checked. This project will help customers to check the price for each bedroom and to decide which location is most suitable. It will also help the company to check in which time of the year they generated the most revenue