Shubham Malik Email & Phone Number

Delhi, India

Gurugram, Haryana, India

This Internship helped me to honed my skills in Excel, Power BI, SQL, and Python, enabling me to proficiently clean and analyze data for informed decision-making. I completed three impactful projects:Sales Analysis:Conducted a deep dive into sales data of over 25000 customers across 10 countries to extract insights and enhance strategic decision-making. Demonstrated proficiency in translating raw data into actionable insights for business optimization.Diabetic… Show more This Internship helped me to honed my skills in Excel, Power BI, SQL, and Python, enabling me to proficiently clean and analyze data for informed decision-making. I completed three impactful projects:Sales Analysis:Conducted a deep dive into sales data of over 25000 customers across 10 countries to extract insights and enhance strategic decision-making. Demonstrated proficiency in translating raw data into actionable insights for business optimization.Diabetic Patients:Explored diabetic patient data to identify trends for improved healthcare outcomes. Showcased analytical prowess and a commitment to leveraging data for social impact in the healthcare sector.HR Analytics:Applied data analysis to optimize talent management and organizational performance in the human resources domain by analyzing data from over 1,400 employees, revealing an attrition rate of 16%. Highlighted versatility in using analytical skills across diverse business functions.This internship not only refined my technical skills but also provided a holistic understanding of leveraging data for strategic decision-making, laying a strong foundation for continued growth in the field of data analysis. Show less

Delhi, India

During my internship as a data analyst, I gained valuable experience and skills by working on various tasks and projects related to SQL, Python, Power BI, and Excel. Here's a description of the work I completed using each of these tools:SQL:Proficiently crafted intricate SQL queries to extract, transform and analyze large datasets from relational databases.Conducted tasks such as data retrieval, table joins, and aggregation for diverse business needs.Python: Applied… Show more During my internship as a data analyst, I gained valuable experience and skills by working on various tasks and projects related to SQL, Python, Power BI, and Excel. Here's a description of the work I completed using each of these tools:SQL:Proficiently crafted intricate SQL queries to extract, transform and analyze large datasets from relational databases.Conducted tasks such as data retrieval, table joins, and aggregation for diverse business needs.Python: Applied Python for data preprocessing, statistical analysis, and visualization.Employed Pandas and NumPy for data manipulation and exploration.Used Matplotlib and Seaborn for creating insightful visualizations and calculating descriptive statistics.Power BI:Principal tool for crafting interactive dashboards and reports.Leveraged Power Query for data transformation and cleansing within the Power BI environment.Utilized DAX for custom calculations and measures and used Power BI data modeling to establish data relationships enhancing drill-down capabilities and scheduled data refreshes.Excel:Utilized Excel for data cleaning, validation and analysis, especially with smaller datasets.Created pivot tables and charts for summarizing and visualizing data effectively and applied advance functions for comprehensive analysis. Show less