- 👋 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: amitpatel.apnitw@gmail.com
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. |
