md khalid

md khalid

Data Analyst
India
Hindi, English

نبذة عني

Dynamic Data Analyst Proficient in statistical modeling,data analysis,and vusualization techniques. Leveraging advanced expertise in Python,SQL,Tableau,and other analytical tools,I excel in transforming raw datasets into…

الخبرة

Project

SuerStore Sales DashBoard
Jun 2024 - حتى الآن · 2 سنوات 1 شهر

Conducted a comprehensive analysis of employee data to identify key factors influencing attrition rates.
Utilized Python and Tableau to visualize trends, uncovering insights related to demographics, job satisfaction, and departmental differences.
Developed actionable recommendations that aimed to enhance employee retention and engagement.
Contributed to data-driven strategies that potentially reduced turnover by addressing identified pain points.
Explored the impact of remote work, flexible hours, or company culture on employee decisions to stay or leave.
Examined attrition rates based on employee tenure to see if certain periods (e.g., first year) are more critical for retention.

Project

Pizza Sales Report DashBoard Analysis
Sep 2024

Analyzed a year’s worth of sales from a fictitious pizzaplace, including the date and time of each order and the pizzas served, with additional details on the type, size, quantity, price, and ingredients.
Explored how many customers are present each day and whether there are peak hours.
Analyzed how many pizzas are typically in order and whether there are any bestsellers.
Analyzed how much money was made during the year and whether there is any seasonality in the sales.
Considered whether any pizzas should be taken off the menu or whether any promotions could be leveraged.

Project

HR Attrition Analysi
Aug 2024

Analyzed HR Attrition data to identify trends and pettern in Employe behavior using excel and Tableau.
Developed visualization that hilighted department wise Attrition,total employee ,Attrition by age group,Attriton by job role ,and Education field and department of the employee also Attrition rate.
Used Tableau to analyse Attrition rate by gender for different Age Group.
Identified that the Attriton rate are 16.2 percent and active employees are 1233 in which the average age of the employee are 37 years and the highe rate of the job satisfaction in the sales executive field.
Analyzed sales trends over time across different time periods (daily, weekly, monthly) to inform inventory and staffing decisions.

المهارات

دمج وتحويل البيانات باستخدام ETL (ETL) إكسل ماي إس كيو إل لوحة المعلومات التصور البياني للبيانات باور بي آي التحليل الإحصائي تابلو Python SQL Data Cleaning Data Modelling Pandas NumPy Seaborn Matplotlib Looker Studio Jupyter Notebook Kaggle Google Colab Statistics Data Analysis Data Manipulation Report Building Excellent Communication
الإبلاغ عن هذا الملف الشخصي؟