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

Block or report iankitnegi

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
iankitnegi/README.md

Data Ana(1)

Hello, I'm Ankit NegiπŸ‘‹

Welcome to my GitHub profile!
I'm on a journey to become a Data Analyst specializing in Machine Learning. 🌟

About Me πŸ˜‡

Aspiring Data Analyst with a passion for numbers and data visualization, looking to align my career with Machine Learning.

  • I love playing with numbers and enjoy the intricacies of mathematics.
  • Experienced in Power BI and Excel for insightful data visualization.
  • Practicing MySQL for data management and querying.
  • Currently learning Python to advance my skills in data analysis and machine learning.

Goals 🌏

My goal is to utilize my analytical skills to make data-driven decisions based on mathematical principles, starting as a data analyst and progressing towards expertise in machine learning, creating impactful solutions along the way.

Skills πŸ’ͺ

  • Data Collection & Cleaning: Proficient in collecting, cleansing, and organizing data from diverse sources, including databases, spreadsheets, and external systems. Ensuring high data quality and integrity.
  • Data & Statistical Analysis: Skilled in analyzing data using statistical techniques and data mining to identify trends, patterns, and actionable insights.
  • Reporting & Visualization: Skilled in creating compelling reports, dashboards, and visualizations using Power BI and Excel to make complex information clear and support informed decision-making.
  • Problem Solving & Critical Thinking: Use data-driven approaches to solve business problems, optimize processes, and make data-informed decisions.
  • Data Quality & Integrity: Committed to performing thorough data quality assessments and stress tests to guarantee reliable and trustworthy data.

Projects πŸ“š

πŸ›΅ MARKET RESEARCH ANALYSIS
Domain: Automotive
Date: 08/2024
Description: Conduct ad hoc market research for AtliQ Motors in the EV/Hybrid Vehicles Industry for data-driven decisions.
Technologies: Tableau, MS-Excel
Key Features:

  1. Ola Electric led the 2-wheeler EV market in FY 2023-2024 with 1.58M units sold; Goa tops 2-wheeler EV adoption at 17.99%.
  2. Karnataka surpassed Delhi in 2024 EV sales and penetration, driven by favorable policies.

🀯 EXPLORATORY DATA ANALYSIS
Domain: Hospitality
Date: 07/2024
Description: Performed data analysis on Hotels dataset using pandas in Python to uncover booking patterns and revenue insights.
Technologies: Python, Pandas, Numpy
Key Features:

  1. Identified the revenue contributions of different booking platforms, enabling targeted marketing and resource allocation.
  2. Uncovered seasonal booking patterns, allowing for strategic pricing adjustments and promotional planning during peak periods.

πŸ–‹οΈ ADHOC ANALYSIS
Domain: Cosumer Goods
Date: 06/2024
Description: Perform ad hoc analysis for Atliq Hardwares to extract actionable insights for swift, data-driven decision-making by management.
Technologies: SQL, MySQL, Joins, Subqueries, CTE
Key Features:

  1. Wrote complex SQL queries for data extraction & analysis.
  2. Optimized SQL queries for improve performance and efficiency.

πŸ’³ CREDIT CARD RECOMMENDATION
Domain: Banking
Date: 05/2024
Description: Developed a comprehensive analysis dashboard using Power BI to visualize usage, identify trends, patterns and uncover insights.
Technologies: Power BI, Power Query, DAX
Key Features:

  1. Demographic classification / Spending Insights
  2. Credit Card Feature Recommendations

πŸ–± SALES & FINANCE REPORT
Domain: Sales
Date: 04/2024
Description: Created detailed reports using MS-Excel, including Pivot Tables and Power Pivot, to provide monthly and yearly sales comparisons.
Technologies: MS-Excel, Pivot Table, Power Pivot
Key Features:

  1. Reports based upon the template provide by stakeholders.
  2. Monthly and yearly sales comparisons

πŸ•PIZZA SALES πŸ§‘β€πŸ€β€πŸ§‘HR ANALYTICS πŸ˜…SALES ANALYTICS

Languages/Tools πŸ”ͺ

python logo jupyter logo mysql logo numpy logo pandas logo

Let's Connect 🀝

πŸ“§ Email πŸ’Ό LinkedIn πŸ“š Portfolio 🐦 Twitter ▢️ YouTube 🧩 Kaggle πŸͺ€Tableau

Let's explore the world of data together! Feel free to reach outβ€”I'm always open to new opportunities and collaborations. πŸš€

Pinned Loading

  1. DataPy DataPy Public

    Welcome to DATAPy! This repo contains my Python coding projects for data science, featuring data manipulation, analysis, and visualization. Stay tuned for updates and new content!

    Jupyter Notebook 1

  2. CodeJava CodeJava Public

    "Collection of programs" : A repository for solving questions & enhancing my logic skills through Java programming.

    Java 1

  3. LeetSQL-Solutions LeetSQL-Solutions Public

    LeetSQL Solutions is my dedicated space for practicing competitive coding and solving SQL-related LeetCode questions. This repository showcases my problem-solving skills and SQL expertise, with eac…

    1

  4. StatisticalExcelence StatisticalExcelence Public

    Welcome to Statistify! This repository is dedicated to sharing my learning journey in statistics as it applies to data science. Here, you'll find notes, code snippets, and resources that I find use…

  5. DAXterity DAXterity Public

    DAXterity is a repository dedicated to practicing and mastering DAX, the formula language used in Power BI for data modeling and calculations. This repository aims to provide a structured environme…

    1

  6. TableauTales TableauTales Public

    "Discover my Tableau journey! Dive into data-driven stories, visualizations, and projects as I explore the power of data visualization."