Codebasics Logo

Powered by
Codebasics DA Bootcamp

Home

About

Projects

Experience

Certificates

Contact

Hello, I am

Ashok Kumar

Data Analyst
Resume

1

Excel
Project

2

PowerBI
Projects

About

Me

I’m an aspiring Data Analyst with hands-on experience analyzing data and deriving insights using Excel, Power BI, SQL, and Python. I hold a bachelor’s degree in Digital Marketing and a master’s degree in Marketing and Data Analytics, which helped me build a strong understanding of both business strategy and data-driven decision-making.

Over time, I realized that my natural strengths lie in data analysis—working with data, identifying trends, and converting raw information into meaningful insights. While I haven’t yet worked in a full-time organizational role, I’ve completed several real-world business and analytics projects that demonstrate my practical skills and analytical thinking.

Through these projects, I’ve worked on data cleaning, KPI analysis, trend evaluation, and dashboard creation. I’m now seeking an opportunity where I can apply my skills, continue learning, and contribute to data-driven outcomes.

Key

Skills

Excel

Microsoft Power BI

SQL

Python

Data Analysis

Data Visualization

Exploratory Data Analysis (EDA)

KPI Analysis

Business Analytics

Power BI Desktop

DAX (Basics)

Data Modeling

Excel Lookups (VLOOKUP, XLOOKUP)

Trend Analysis

Variance Analysis

Business Metrics

My

Projects

Business Performance Dashboard Using Excel
Business Performance Dashboard Using Excel

Domain/Function: Business Analytics

This project involved analyzing customer and marketing performance data in Excel to understand trends and performance gaps. By cleaning data and using pivot-based analysis, I created structured reports that highlight actionable insights for business decision-making.

QuickBite Express – Crisis Recovery Analysis Using Power BI
QuickBite Express – Crisis Recovery Analysis Using Power BI

Domain/Function: Business & Operations Analytics

This project analyzes QuickBite Express’s post-crisis business performance using Power BI. It tracks key KPIs, regional recovery trends, and revenue contribution to identify performance gaps and support data-driven recovery planning.

Air Purifier Product–Market Fit Analysis Using AQI Data
Air Purifier Product–Market Fit Analysis Using AQI Data

Domain/Function: Product Analytics & Market Research

This project analyzes air quality data to evaluate product–market fit for air purifiers. Using Power BI, I studied AQI trends, pollutant composition, and regional exposure patterns to identify high-demand regions and support data-driven product decisions.

My

Experience

Merino Industries                                                                                                                                                          Management Trainee (Full-Time)                                                                                                                                            

 Prepared structured Excel-based analytical reports covering 5+ regions to monitor sales and operational performance regularly. Performed target vs achievement analysis to identify regional trends, performance gaps, and growth opportunities across product categories. Analyzed monthly and quarterly performance metrics, highlighting deviations and areas requiring corrective action. Supported managers by summarizing insights using business KPIs and performance indicators to aid planning, forecasting, and operational decision-making. Collaborated with cross-functional teams to ensure data accuracy, consistency, and timely reporting.

Awards

& Certificate

CB Cert

Excel: Mother of Business Intelligence

CB Cert

Get Job Ready: Power BI Data Analytics for All Levels 3.0

Build Your Generative AI Productivity Skills with Microsoft and LinkedIn

Build Your Generative AI Productivity Skills with Microsoft and LinkedIn