iankitnegi Goto Github PK

followers: 1.0 following: 1.0 repos: 21.0 gists: 0.0

Name: Ankit Negi

Type: User

Bio: Analyst | Minimalist | Learner

Location: India

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:

Wrote complex SQL queries for data extraction & analysis.
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:

Demographic classification / Spending Insights
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:

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

🍕PIZZA SALES 🧑‍🤝‍🧑HR ANALYTICS

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

Ankit Negi's Projects

bi_bootcamp

codejava

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

datapy

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!

daxterity

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 environment for learning and experimenting with commonly used DAX functions and patterns.

excel_sales_dashboard

excel_sales_finance_report

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 fiscal periods, and gross margin by quarters.

hr_analytics

Learn how to create an HR analytics dashboard in Excel! I'll guide you through data collection, cleaning, and visualization techniques step-by-step for effective HR insights.

iankitnegi

Config files for my GitHub profile.

internship_atliqtechnologies

leetsql-solutions

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 each solution featuring detailed explanations and optimized queries for better understanding and future reference.

powerbi_banking_project

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 and enhance its presence in the financial market.

powerbi_election_project

Lok Sabha Election by Code Basis is a project analyzing India's 2014 and 2019 elections. It offers unbiased insights and explores themes like voter turnout percentages, presenting data-driven findings.

powerbi_hospitality_project

python_portfolioprojects

Data Analyst Toolkit: A comprehensive collection of Python scripts and notebooks designed for data analysis tasks. Features data cleaning, visualization, statistical analysis, and machine learning models. Ideal for analysts seeking efficient, reproducible workflows.

sqlninjas_bootcamp

sql_adhoc_analysis_project

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 Director, is hiring junior analysts with strong tech and soft skills, using a SQL and code basics challenge to evaluate candidates.

sql_pizza_sales_project

As a BI Consultant for Plato's Pizza, you'll analyze a year's worth of transactional data to identify opportunities for driving sales and improving operational efficiency, helping the restaurant enhance its performance.

sql_population_analysis

statisticalexcelence

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 useful. Let's dive into the world of data together and uncover statistical insights!

statistically_speaking

Explore diverse projects showcasing statistical techniques with real-world data, comprehensive docs, and interactive visualizations.

tableautales

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