Name: Mukesh kr Pandey

Job Role: Data Analyst Intern

Experience: Internship(Data Science & Data Analyst)

Address: Lucknow, India

Skills

MS Excel 85%
MS Power BI 80%
Data Visualization 80%
SQL 75%
Python Libraries 70%

About

About Me

Looking for an opportunity in the field of Data (Science & Analyst) || Courses (With some Internships) are learning in the field of Data (Science & Analyst) etc. || Power BI Developer || Expert as M.S.Office || Part time working as Tutor..

  • Profile: Data Science & Analytics
  • Domain: Retail, Ecommerce, BFSI & Digital Marketing
  • Education: Bachelor of Technology in CSE
  • Language: English, Hindi
  • BI Tools: Microsoft Power BI & Tableau
  • Other Skills: Excel, Data Visualization, Creating Intractive Dashboard , Google Analytics & SEO
  • Interest: Traveling, Learning, Teaching

0 +   Projects completed

LinkedIn

Resume

Resume

Data Analyst Intern with 3+ months of experience driving business strategies through data-driven insights. Proven expertise in data science, statistical analysis, machine learning algorithms and project management.

Experience


2023(Aug-Sep)

Data Scientist Internship

Teachnook

TEACHNOOK is an online learning service provider that offers programs across various domains such as computer science, electronics, management, and biotechnology.

  • The journey of a data scientist begins with understanding core concepts. Teachnook takes you through this foundational stage, covering essential topics such as information analysis and programming
  • Teachnook believes in mentorship. Throughout your journey, you’ll have access to industry experts who are passionate about data science and AI.
  • By working on real-world tasks, you’ll gain practical skills that prepare you for success in the data science field.

2023(Oct-Nov)

Data Analyst Internship

MeriSkill

MeriSKILL is a rapidly expanding Edtech platform with a global presence, reaching over 50+ countries including India, the United States, the United Kingdom, Canada, and many more.

  • This program provides a comprehensive, hands-on experience in the dynamic field of data and business analytics.
  • Participants gain practical insights into collecting, processing, and analyzing data to derive valuable business insights
  • The internship covers areas such as data mining, statistical analysis, predictive modeling, and data visualization



Education


2021-2025

Bachelor of Technology

In Computer Science & Engineering

Dr A.P.J. Abdul Kalam Technical University
2019-2021

Higher Secondary School

Navjeevan Inter College, MLG, Lucknow

Grade: First class distinction.

2018-2019

Industrial Training Institute

Govt. ITI, Charbagh

Grade: First class distinction.

2016-2018

High School

King George Inter College, Chinhat, Lucknow

Grade: First class distinction.

Projects

Projects

Below are the sample Data Analytics projects on Power BI, Excel, SQL, Python & ML.

Sales Data Analysis of a Super Store using Power BI (During Internship)

Analyze sales data to identify the Orders, Sales, Profit and Quantity Ordered of the Products. Also Analyze Sales by Region, Sales by City, Sales by Product.

HR Analytics Dashboard using Power BI (During Internship)

Insights on Attrition at a particular company, it shows the attrition rate of the employee based on various categories such as age, gender, job role, education, job satisfaction rate etc .

Regression/Classification Model using Machine Learning (During Internship)

Choose any dataset of your choice, apply a suitable algorithm (Regression/Classification) and create a model, Using Python and Machine Learning




Self Practice Project


Coffee Shop Sales Dashboard using MS Excel

The main objective of this project is to analyze retail sales data to gain actionable insights that will enhance the performance of the Coffee Shop.

Sales Dashboard Overview: Regional Performance Analysis Using Excel

This sales dashboard provides a comprehensive overview of sales performance across various regions including Chennai, Delhi, Mumbai, Nagpur, Patna, Pune, Ranchi, and Surat.

Dynamic Sales Dashboard

I designed a comprehensive Sales Dashboard designed using Excel. This dashboard is an essential tool for visualizing sales performance across different regions, helping to drive business growth through data-driven decisions.


Self Learning

Self Learning

Below are the sample Data Analytics Self Learning on Python Library.

Complete NumPy for Beginners

"Sure! NumPy is a Python library for numerical computing. It's great for handling large datasets and performing mathematical operations efficiently. With NumPy, you can create arrays (multi-dimensional data structures), manipulate them easily, and perform various mathematical operations like addition, subtraction, and more. It's a must-have tool for anyone working with data or doing scientific computing in Python.".

Complete Pandas for Beginners

Certainly! Pandas is another essential Python library for data manipulation and analysis. It provides powerful data structures like DataFrame and Series, which allow you to work with structured data easily. With Pandas, you can load data from various sources, clean and preprocess it, perform data exploration and analysis, and then visualize the results. It's widely used in data science, machine learning, and data analysis projects due to its simplicity and efficiency..

Complete Matplotlib for Beginners

Matplotlib is a popular Python library used for creating static, interactive, and animated visualizations. It provides a wide range of plotting functions and styles, allowing you to create various types of plots such as line plots, scatter plots, bar plots, histograms, and more. Matplotlib is flexible and customizable, enabling you to adjust the appearance of your plots with labels, titles, colors, and styles. It's widely used in data analysis, scientific research, and visualization projects due to its simplicity and versatility.

Contact

Contact Me

Below are the details to reach out to me!

Address

Lucknow, India

Contact Number

+91 7703078864

Email Address

mp9956010547@gmail.com

Download Resume

resumelink