RK-AIassistant · online
Data Analyst · AI assistant online

RavindraKumar

Analytical Data Analyst with proven expertise in Python, SQL, MS Excel and Power BI — turning raw, messy data into dashboards and decisions that hold up under scrutiny.

01
Python & SQL
Clean, query, analyse
02
Excel & Power BI
Dashboards that decide
03
Insights
Data to decisions

About Me

Ravindra Kumar

I'm a data analyst who enjoys the part most people skip — sitting with messy, inconsistent data until it starts making sense. Over the past couple of years I've built a habit of picking up real, sizeable datasets and taking them the full distance: cleaning, modeling, and shaping them into dashboards that a business owner could actually act on, not just admire.

My core toolkit is Python, SQL, Excel and Power BI, and I lean on all four depending on what the data needs — SQL to pull and shape it, Python when the analysis gets exploratory, Excel for fast iteration, and Power BI to turn the result into something leadership can open and understand in thirty seconds. I care more about whether a number is trustworthy than whether a chart looks impressive.

I'm currently pursuing my BCA alongside a structured Data Science training program at Red & White Skill Education, and actively building toward a full-time Data Analyst role — every project on this page is something I built end-to-end, not a tutorial I followed.

Projects

01 / selected work
shopping screenshot 1

Customer Shopping Behavior Analysis

Python + MySQL

Cleaned 3,900 retail transactions in Python, queried them in MySQL and built a Power BI dashboard on revenue, discounts and loyalty. Analyzed category, age-group and subscription behavior to recommend ways to improve customer loyalty and sales.

github.com/customer-shopping-behavior-analysis →
uplift screenshot 1

Retail Sales Uplift Dashboard

SQL + Power BI

Used SQL to analyze 50,000 multi-region transactions (Jan 2024 to Jul 2026) by region, product, payment mode and channel. Built a Power BI dashboard on monthly trend, top products and seasonal dips to help with inventory planning.

github.com/retails-sales-uplift-dashboard →
finance screenshot 1
finance screenshot 2
1/2

Finance Analysis Dashboard

Power BI

Built a 2-page Power BI report on 50,069 transactions and 5,000 customers covering segments, channels and fraud risk signals. Designed KPI cards, monthly trends and state-level views with year and category filters.

github.com/finance-analysis-dashboard →
salesbi screenshot 1
salesbi screenshot 2
salesbi screenshot 3
1/3

Sales Performance Dashboard

Power BI + DAX

Built a star-schema model with 20+ DAX measures for a 3-page report (Executive, Customer, Product). Tracked sales, profit, returns and margin trends by category, season and region.

github.com/powerbi-sales-dashboard →
health screenshot 1
health screenshot 2
health screenshot 3
health screenshot 4
1/4

Health Data Statistical Analysis

Python

Ran t-test, z-test, chi-square and ANOVA and built confidence intervals on a health dataset in Python. Explained covariance, correlation and each result in plain language with charts.

github.com/health-data-statistical-analysis →
adventureworks screenshot 1
adventureworks screenshot 2
adventureworks screenshot 3
adventureworks screenshot 4
1/4

AdventureWorks Sales & Returns Report

Power BI

Built a 4-page Power BI report covering revenue trends, return performance and territory-level sales, with MoM trend indicators and a what-if price scenario.

github.com/powerbi-adventureworks-sales-and-return →

Technical Skills

02 / toolkit
PROGRAMMING & DATABASES
SQL (MySQL) Python (Pandas, NumPy, Matplotlib, Seaborn)
BI & VISUALIZATION
Power BI Interactive Dashboards KPI Design Advanced Excel (Pivot Tables, Slicers, XLOOKUP, INDEX-MATCH)
DATA PREPARATION & MODELING
Data Cleaning Power Query Star-Schema Data Modeling DAX
ANALYSIS & STATISTICS
Exploratory Data Analysis (EDA) Hypothesis Testing Trend Analysis Correlation Probability
TOOLS
GitHub Jupyter Notebook ChatGPT Advanced Data Analysis Julius AI

Training

03 / learning
Jul 2025 – Present
Data Science Trainee (Training Program)
Red & White Skill Education, Ahmedabad
Enrolled in a structured data science training program spanning core analytics tools through to machine learning and GenAI — practicing each concept through guided exercises and applying it to the independent projects featured on this page.
CURRICULUM COVERED
Python SQL MS Excel Power BI Statistics & Probability A/B Testing Data Preprocessing & Feature Engineering Scikit-learn Supervised & Unsupervised Learning Model Selection & Evaluation Deep Learning Reinforcement Learning Natural Language Processing (NLP) Generative AI / ML

Education

04 / foundation
Pursuing · 2029
Bachelor of Computer Applications (BCA)
IGNOU — Indira Gandhi National Open University · Rajkot, Gujarat
2025
Senior Secondary (12th), Commerce
NIOS — National Institute of Open Schooling · Dhrol, Jamnagar, Gujarat

Certifications

05 / verified
Data Analytics Job Simulation
Deloitte, via Forage — Data Analysis & Forensic Technology
Sep 2026
Data Analysis: Visualisations in Excel
The Open University — OpenLearn (Course B126_3)
Aug 2026

Resume

05 / download

Ravindra Kumar — Resume

Download my full resume as a PDF, covering my projects, skills, certifications and education.

Download Resume (PDF)

Get In Touch

06 / connect

Open to opportunities in Data Analysis and BI reporting. Reach out directly, or send a message alongside.

LOCATION Ahmedabad, Gujarat, India

This opens your email client with the message pre-filled.