• 🔭 I’m currently working on enhancing my skills and learning Advanced approach for Data Analysis
• 🌱 I’m currently learning Machine learning and Python Advanced Use case
• 💬 Ask me about 𝘌𝘹𝘤𝘦𝘭, 𝘗𝘰𝘸𝘦𝘳 𝘉𝘐, 𝘚𝘘𝘓, 𝘗𝘺𝘵𝘩𝘰𝘯, Tableau
• 📫 How to reach me: prafulgangrade@gmail.com
• ⚡ Fun fact: I always try to learn and never give up

Projects

SQL

• Project 1 : SQL challange Case Study #1 - Danny's Diner

  Details : Here is the link of SQL challange Case Study #1 - Danny's Diner https://8weeksqlchallenge.com/case-study-1/

  Introduction

  In this Task I try to solve and answer all query related to this task and find insights from data for answer a few simple questions about his customers, especially about their visiting patterns, how much money they’ve spent and also which menu items are their favourite. Having this deeper connection with customers will help to deliver a better and more personalised experience for loyal customers.

  Link : https://github.com/prafullgangrade/Danny-s-Dinner_SQL_Challenge-1.git

• Project 2 : SQL challange Case Study #2 Pizza runner

  Details : Here is the link of SQL challange Case Study #2 Pizza runner https://8weeksqlchallenge.com/case-study-2/

  In this Task I try to solve and answer all query related to this task and find insights from data for answer a few simple questions about pizza quantity ordered, unique customer, successful order, type of pizza delivered, maximum nuber of pizza in single order, etc. type of insight i try to find and answer them with sql query.

  Link : https://github.com/prafullgangrade/Pizza-Runner_SQL_challange-2.git

Python

• Project 1 : Call center performance analysis

  Details : The goal of this project is to identify trends in call center performance over time, analyze factors that contribute to high or low performance, and generate insights to help call center managers make data-driven decisions to improve their operations.

  Link : https://github.com/prafullgangrade/Call-Center-Trends-Analysis-using-Python.git

• Project 2 : Tourism data analysis of Telangana State(India)

  Details : The main objective of this project is to analyze the tourism data of Telangana, a state in India, and to identify the trends and patterns in the data using Python. The data set used in this project is obtained from the Telangana Tourism website, which contains information about the number of tourists visiting different tourist destinations in the state.

  Link : https://github.com/prafullgangrade/Tourism-Data-analysis-with-python.git

Power BI

• Project 1 : HR data analysis dashboard

  Details :

  A HR data analysis dashboard in Power BI is a visual tool that helps human resources professionals to track and analyze various metrics related to employee performance, recruitment, retention, and overall workforce management.

  Link https://github.com/prafullgangrade/Hr_data_analysis_PowerBi.git

• Project 2 : Financial analysis Power BI dashboard

  Details :

  A financial analysis Power BI dashboard is a visual representation of financial data that provides a clear and concise overview of an organization's financial health. It allows users to quickly and easily analyze financial data and identify trends, anomalies, and areas of concern.

  Link : https://github.com/prafullgangrade/Financial_Analaysis_power_bi.git