Skip to content
View AmitPatel-analyst's full-sized avatar
🎯
Focusing
🎯
Focusing

Block or report AmitPatel-analyst

Block user

Prevent this user from interacting with your repositories and sending you notifications. Learn more about blocking users.

You must be logged in to block users.

Please don't include any personal information such as legal names or email addresses. Maximum 100 characters, markdown supported. This note will be visible to only you.
Report abuse

Contact GitHub support about this user’s behavior. Learn more about reporting abuse.

Report abuse
AmitPatel-analyst/README.md

LinkedlnCoverPage-New

🤗Welcome to my Github Profile

  • 👋 Hi, I am Amit Patel, I am a Data analyst, with a background in Engineering.
  • 👀 I am interested in learning new skills.
  • 🌱 I am proficient in SQL, Advanced Excel and data visualization tools like Power BI.
  • 📫 You can reach me on my GitHub account if you have any information 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:

amitpatel-analyst


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.

"Information is the oil of the 21st century, and analytics is the combustion engine"

🛠️ Tech Stack

Microsoft Excel Power Bi Microsoft PowerPoint Google Sheets Sql Server

🌐 Socials

LinkedIn

🖥️ Portfolio

Portfolio

amitpatel-analyst

Pinned Loading

  1. SQL-Case-Study SQL-Case-Study Public

    This Github repo showcases my SQL case studies, demonstrating proficiency in solving diverse business problems. Projects cover finance, healthcare and other sectors, and highlight my ability to ana…

    TSQL 6 5

  2. Excel-Projects Excel-Projects Public

    1

  3. PortfolioProjects PortfolioProjects Public

    Various projects dedicated to data analysis via the use of PowerBI Tool

    TSQL 1