Skip to content

iankitnegi/iankitnegi

Folders and files

NameName
Last commit message
Last commit date

Latest commit

Β 

History

18 Commits
Β 
Β 

Repository files navigation

Data Ana(7)

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
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. 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.

🀯 EXPLORATORY DATA ANALYSIS
Domain: Hospitality
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
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
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
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

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. πŸš€

About

Config files for my GitHub profile.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published