Madan Surthani | Data analyst

Madan Surthani

Data analyst

Based in Bangalore

About

I am an aspiring Data analyst with alove for getting meaningful insights from data. As a recent graduate in Aeronautical Engineering, I have a solid foundation in data analysis methodologies, statistical modeling, cleaning, and data visualization tools. My initiatives, such as "Bank loan default risk analysis" and "Sales dashboard analysis," have allowed me to apply my skills to real-world data difficulties. I am proficient in tools such as Advanced Excel, SQL, Python, Machine Learning, Power BI, Tableau, Numpy, Seaborn, pandas, matplotlib, Data Analytics, Project Management, Business Analyst, KPI dashboard, Presentation, data cleaning, Processing, data validation, drop-down list, index function, Vlookup, conditional formatting, Microsoft Excel, dashboard. I am eager to take on new chal

Skills

Projects

Sales Data Dashboard

In this project, we will analyze a sales dataset to extract valuable insights that will inform sales strategies and decision-making. This analysis will encompass several key aspects of the sales data, including sales trends, top-selling products, and visualizations to effectively communicate our fin

Terrorism Dashboard

In this project, I have created a Power BI dashboard to analyze terrorism data, with a focus on success rate by type of attack, target type, weapon type, country, region, and name of group. The dashboard also includes a slicer for country and cards for the most used weapon, total targets,

YouTube Stream Analysis

To work with This dataset contains valuable information about the top YouTube streamers, including their ranking, categories, subscribers, country, visits, likes, comments, and more. Your task is to perform a comprehensive analysis of the dataset to extract insights about the top YouTube

Hr Dashboard

This project showcases the use of Power Query and DAX Query to analyze employee attendance data, add new measures and columns, and create a dashboard using Power BI. The goal is to provide insights into attendance patterns and identify areas for improvement for HR.

Experience

2023

Data analyst internship

Cleaned and manipulated raw data Created graphs and charts to visualize data analysis results Utilized statistical software to analyze and process large datasets Tested, validated, and refined models for accurate outcome predictions Applied feature selection algorithms for predictive modeling Resolved customer issues with expertise and a friendly approach Delivered exceptional service and support in face-to-face and phone interactions.

Education

2017-2022

Singhania university