Ankita Yadav

Hi! I'm a data analyst with a knack for transforming data into valuable insights. I enjoy utilizing SQL, Excel, and Python, as well as leveraging visualization tools like Power BI.
I love solving complex problems and discovering patterns in data to help businesses make informed decisions.

YouTube Data Analysis-Power BI | Python

This project aims to analyze YouTube data to gain insights into the performance, audience engagement, and content effectiveness of three different channels.

E-Commerce Sales Analysis-Power BI

The project 's objective is to understand customer behavior and sales patterns to identify areas for improvement and growth.

IPL Analysis-SQL | Power BI

This project involves developing an interactive Power BI dashboard for the Indian Premier League (IPL) seasons from 2008 to 2022.
The dashboard provides detailed insights into various aspects of the IPL, including team performance, player statistics, and match outcomes.

Pizza Sales Analysis- SQL | Power BI

This project is focused on examining key performance indicators (KPIs) and visualizing different facets of our pizza sales data to gain a deeper understanding of our business performance.
The goal is to compute crucial metrics and develop charts that reveal trends and patterns in the sales data.

Bank Loan data Analysis- EXCEL

This project focuses on analyzing various aspects of loan applications and their performance metrics for a financial institution.
The goal is to provide comprehensive insights through a series of dashboards and visualizations that facilitate data-driven decision-making.
This analysis encompasses key performance indicators (KPIs), trends, and detailed metrics to offer a clear understanding of the loan portfolio's health and performance.

Hotel Booking cancellation Analysis- python

This project aims to analyze hotel booking cancellations and identify factors affecting them to help City Hotel and Resort Hotel reduce their high cancellation rates.
By understanding the variables influencing cancellations, the hotels can implement strategies to increase revenue and optimize room usage. The analysis is based on data from 2015 to 2017, assuming no unusual occurrences significantly impact the data.

Thanks !

Thank you for taking the time to visit my portfolio !
If you'd like to chat about me joining your team, feel free to email me at [email protected]