🤗Welcome to my Github Profile

👋 Hi, I am Amit Patel
👀 I want to become a Data Analyst
🌱 I am proficient in SQL, Advanced Excel and data visualization tools like Power BI.
📫 You can reach me on my github account if any information do you want to share Or If you want any information from me as well. :)

Over the past few months, I have been actively learning about data analysis through online courses and projects, and I am constantly impressed by the power of data to drive change and improve decision making. I believe that my skills and knowledge, combined with my passion for this field, make me well-suited to contribute as a Data Analyst. I am excited about the opportunity to work with a team of experienced professionals and continue to grow my skills and knowledge as a Data Analyst. I am confident that I have what it takes to succeed in this role, and I am looking forward to contributing my skills and knowledge to help organizations achieve their goals.

💻Skills:

Power BI
SQL , T-SQL
Advanced Excel

💫 About Me:

🔭 I’m currently working on my Portfolio Projects
👨‍💻 All of my projects are available at
💬 Ask me about anything, I'm happy to help.
📫 How to reach me:
Email: [email protected]
Linkedin Id: https://www.linkedin.com/in/amit-patel999/

SQL CASE STUDY

Project Link	Area of Analysis	Project Description	Features
💳 Credit Card	Descriptive analysis	I analyse customer's spending behaviour and interests to help clients understand their customers.	Data cleaning, Advanced aggregations, CASE WHEN statements, Window Functions, Joins, Date time functions,CTEs
🏦 The Tiny Shop	Price & Customer Order analysis	I calculate metrics important to the organization, and analyze data for order rate, spending and sales pattern and product popularity	Aggregations, CASE WHEN statements, Window Functions, Joins, Date time functions,CTEs
🍜 Danny's Diner	Exploratory Data analysis	I Conducted thorough data analysis for Danny's restaurant, extracting customer spending patterns, frequent visits, and menu preferences. Delivered insights to enrich personalized experiences and assess expansion potential of the loyalty program.	Aggregations, CASE WHEN statements, Window Functions, Joins, Date time functions,CTEs
✨ Steel data challenge	Data analysis, data cleaning, data transformation	This repo serves as the solution for the 6 case studies from the SteelDataSQLChallenge. It showcases my ability to tackle various SQL challenges and demonstrates my proficiency in SQL query writing and problem-solving skills.
🏩 Oyo room sales analysis	Exploratory analysis	I answer business questions related to room bookings data, such as average room rates and % cancellation rate per city, Discount offered by different cities, monthwise new customers and repeat customers.