CHANDAN KUMAR — Data Analyst

01.

About

I am a passionate Data Analyst skilled in Excel, SQL, Power BI, DAX, and Python. I specialize in data cleaning, transformation, and analysis, creating interactive dashboards that drive results. I thrive on turning complex data into clear insights that help businesses optimize performance and achieve their goals.

02.

Selected work

Credit Card Transaction Analysis

SQL, Power BI, DAX

Analyzed credit card transaction data to identify spending patterns and customer segments, leading to targeted marketing strategies.
Utilized DAX measures to calculate key metrics, enhancing the dashboard's analytical capabilities.

SQLPower BIDAX

PhonePe Payment Insights Dashboard

Power BI, Power Query

Developed a comprehensive dashboard to visualize payment trends and user engagement metrics, facilitating data-driven decision-making.
Implemented Power Query for data transformation, streamlining the data preparation process.

Power BIPower Query

Insurance Policy Analytics Dashboard

Power BI

Created an interactive dashboard to analyze insurance policy performance, providing insights into customer retention and policy uptake.
Leveraged DAX to create calculated columns and measures, enhancing the dashboard's analytical depth.

Power BI

Daily Global Stock Market Analysis Dashboard

Microsoft Excel

Compiled and analyzed daily stock market data to identify trends and investment opportunities, improving portfolio management strategies.
Designed visualizations using Excel charts and pivot tables to present findings effectively.

Microsoft Excel

Sales Dashboard

Microsoft Excel

Developed a sales dashboard to track performance metrics, enabling real-time insights into sales trends and forecasts.
Utilized Excel functions to automate data analysis, reducing manual reporting time by 40%.

Microsoft Excel

YouTube Data Analysis Dashboard

Microsoft Excel

Analyzed YouTube channel performance metrics to optimize content strategy, resulting in a 25% increase in viewer engagement.
Created visual reports using Excel to present data insights to the content team.

Microsoft Excel

03.

Skills & tools

LanguagesFrameworks/LibrariesDatabasesTools & PlatformsMethodologies & PracticesData & AnalyticsOther Technical Skills

04.

Education

Babasaheb Bhimrao Ambedkar Bihar University

Bachelor of Arts

2029

Bihar School Examination Board (BSEB)

12th Science – PCM

2025

05.

Certifications

Data Visualisation: Empowering Business with Effective Insights

Tata · 2026

Data Analytics Job Simulation

Deloitte · 2026

Data Analytics Job Simulation

Quantium · 2026

06.

Get in touch

Have a role or a project in mind? I'd love to hear from you.

chandangupta0450@gmail.com 9113766089