- ๐ 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.
- Power BI
- SQL , T-SQL
- Advanced Excel
-
๐ญ 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/
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. |