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

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

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

πŸ–‹οΈ 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

Let's Connect!

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

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

    Project Challenge by Code Basics: Mitron Bank, a legacy financial institution based in Hyderabad, aims to launch a new line of credit cards. This initiative seeks to expand its product offerings an…

  2. SQL_AdHoc_Analysis_Project SQL_AdHoc_Analysis_Project Public

    Atliq Hardwares, a leading computer hardware producer in India with a global reach, seeks to enhance its data analytics team for better decision-making insights. Tony Sharma, the Data Analytics Dir…

  3. Excel_Sales_Finance_Report Excel_Sales_Finance_Report Public

    AtliQ Tech need a sales and finance report covering customer net sales performance, top products, division-level data, new product performance, top countries by sales, market performance, P&L by fi…

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

    Python

  5. CodeJava CodeJava Public

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

    Java 1

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