Welcome to my Data Analyst portfolio, where I showcase a variety of projects highlighting my expertise in Python, Power BI, SQL, Excel, and Tableau. From data wrangling in Python to crafting interactive dashboards in Power BI, each project demonstrates my ability to extract insights and drive decision-making. With SQL for database management and Tableau for visualization, my portfolio reflects my commitment to analyzing data across diverse domains, delivering actionable insights for business success. Explore my work to see how I transform raw data into valuable insights.
App Rating Prediction-Python
I developed a predictive model using the dataset "googleplaystore.csv" to assess and predict app ratings on the Google Play Store. The model aims to help the Google Play Store team identify and promote apps likely to receive high ratings from users. By leveraging various dataset features, the goal is to create a robust model that accurately predicts the potential success and user satisfaction of new apps. This predictive model will enhance the visibility of promising apps in recommendations, search results, and other relevant sections, ultimately improving the overall user experience on the Google Play Store platform.
Data Manipulation and Reporting with Power-BI
Zomato, a renowned restaurant aggregation and meal delivery service, aims to analyze its global data to assess business performance effectively. This Power BI report consolidates restaurant information from various continents, enabling users to delve into detailed insights.
Air Cargo Analysis- SQL
Air Cargo, an aviation company, aims to enhance its operational efficiency and customer service by analyzing its database. As a DBA expert, the objective is to identify regular customers, analyze popular routes, and examine ticket sales details. This will enable Air Cargo to improve customer experience and optimize its services.
Identifying and Reccomending best Restaurants- Python
The objective of this project is to leverage Python for data analysis and tableau for visualization to identify and recommend the best restaurants in a given area. The project aims to extract insights from a dataset containing information about various restaurants, including customer reviews, ratings, cuisine types, and other relevant attributes. By employing advanced data analysis techniques, the goal is to develop a recommendation system that assists users in selecting the most suitable dining options based on their preferences.
Comparision of Region based Sales -Tableau
The objective of this project is to assist a leading organization in visualizing sales data between two selected regions using a dashboard. By comparing sales performance, the organization can identify areas for improvement and make informed decisions to enhance productivity and profitability.
Customer Retention Dashboard
The purpose of this dashboard is to provide clear and insightful visualizations regarding customer retention in the telecom industry. It aims to help the management team understand customer demographics, identify at-risk customers, and improve strategies for retaining customers.
Sales Insights
The goal of this project was to unlock valuable sales insights that were not readily visible before, in order to provide decision support for the AtliQ Hardware sales team. By leveraging data analysis and automation, the aim was to reveal new, actionable insights that could guide the sales team's decision-making.
The project involved automating the data gathering process, which previously required significant manual effort from the sales team. By automating the data collection and aggregation, the sales team could spend less time on manual data gathering and focus more on analyzing the insights and making informed decisions. The unlocked sales insights, combined with the automated data gathering, were intended to empower the AtliQ Hardware sales team with the information and tools they need to make more strategic and data-driven decisions. This approach aimed to enhance the sales team's decision support capabilities and improve the overall sales performance of the organization.