Back to Developers
Adarsh choubey

Adarsh choubey

Data Analyst

Indore, Madhya Pradesh 0+ yrs exp 81 ยท Excellent

About

Results-driven Data Analyst with hands-on experience in SQL, Python, Pandas, Power BI, Excel, data cleaning, ETL, exploratory data analysis, and dashboard development. Experienced in transforming raw datasets into structured, analysis-ready data and generating actionable business insights through SQL analysis and interactive dashboards. Hands-on exposure to AWS S3, AWS RDS, MariaDB, dbt, Apache Airflow, Docker, Git/GitHub, and Jira through an end-to-end Restaurant Analytics project.

Skills & Expertise (43)

Pandas Intermediate
7.0/10
0.5
Years Exp
VLOOKUP Intermediate
7.0/10
0.5
Years Exp
Python Intermediate
7.0/10
0.5
Years Exp
Pivot Tables Intermediate
7.0/10
0.5
Years Exp
Advanced Excel Intermediate
7.0/10
0.5
Years Exp
Dashboard Development Intermediate
7.0/10
0.5
Years Exp
SQL Intermediate
7.0/10
0.5
Years Exp
Power BI Intermediate
7.0/10
0.5
Years Exp
Data Filtering Intermediate
6.5/10
0.5
Years Exp
ETL Intermediate
6.5/10
0.5
Years Exp
Data Cleaning Intermediate
6.5/10
0.5
Years Exp
Data Transformation Intermediate
6.5/10
0.5
Years Exp
Data Modeling Intermediate
6.5/10
0.5
Years Exp
Aggregations Intermediate
6.5/10
0.5
Years Exp
Joins Intermediate
6.5/10
0.5
Years Exp
Exploratory data analysis Intermediate
6.5/10
0.5
Years Exp
NumPy Intermediate
6.5/10
0.5
Years Exp
AWS RDS Intermediate
6.0/10
0.5
Years Exp
Jira Intermediate
6.0/10
0.5
Years Exp
DBT Intermediate
6.0/10
0.5
Years Exp
AWS S3 Intermediate
6.0/10
0.5
Years Exp
Apache Airflow Intermediate
6.0/10
0.5
Years Exp
Data Validation Intermediate
6.0/10
0.5
Years Exp
Git Intermediate
6.0/10
0.5
Years Exp
GitHub Intermediate
6.0/10
0.5
Years Exp
Docker Intermediate
6.0/10
0.5
Years Exp
Conditional Formatting Intermediate
6.0/10
0.5
Years Exp
Power Pivot Intermediate
6.0/10
0.5
Years Exp
Power Query Intermediate
6.0/10
0.5
Years Exp
Index-match Intermediate
6.0/10
0.5
Years Exp
HLOOKUP Intermediate
6.0/10
0.5
Years Exp
Drill-through Reports Intermediate
6.0/10
0.5
Years Exp
Slicers Intermediate
6.0/10
0.5
Years Exp
KPI Cards Intermediate
6.0/10
0.5
Years Exp
Relationships Intermediate
6.0/10
0.5
Years Exp
DAX Intermediate
6.0/10
0.5
Years Exp
Date functions Intermediate
6.0/10
0.5
Years Exp
Window Functions Intermediate
6.0/10
0.5
Years Exp
Subqueries Intermediate
6.0/10
0.5
Years Exp
MariaDB Intermediate
6.0/10
0.5
Years Exp
Statistical Analysis Intermediate
6.0/10
0.5
Years Exp
Seaborn Intermediate
6.0/10
0.5
Years Exp
Matplotlib Intermediate
6.0/10
0.5
Years Exp

Work Experience

Data Analyst Intern

RPS Business Solutions

Jun 2026 - Sep 2026

Worked on an end-to-end Restaurant Analytics ETL pipeline, processing raw CSV data through data validation, cleaning, transformation, and database loading. Developed Python-based data processing workflows using Pandas and SQLAlchemy to validate, clean, transform, and prepare datasets for analysis. Loaded processed data into MariaDB on AWS RDS and used SQL to perform joins, aggregations, subqueries, date analysis, and window-function-based analysis. Worked with dbt to develop staging models and analytical data marts supporting downstream reporting and Power BI dashboards. Analyzed daily sales, revenue, order volume, top-performing days, and peak sales periods to identify business trends and performance patterns. Worked with Apache Airflow, AWS S3, Docker, Git/GitHub, and Jira as part of the project workflow and data pipeline environment.

Data Analyst Intern

Bignalytics IT Solutions

Apr 2026 - Jun 2026

Performed end-to-end data cleaning and preprocessing on a large admission enquiry dataset, resolving missing values, duplicate records, and inconsistent formats. Conducted exploratory data analysis (EDA) and transformed raw admission records into a structured, analysis-ready dataset. Built an interactive dashboard tracking 1,719 Total Enquiries, 130 Admissions, and a 7.56% Conversion Rate. Developed dynamic visualizations covering course popularity, lead-source performance, follow-up distribution, education background, and monthly lead trends. Implemented interactive slicers for Year, Course, Education Background, Lead Source, and Follow-Up Status to support self-service data exploration. Identified high-performing courses, effective lead channels, and follow-up gaps to generate actionable business insights.

Education

B.Sc - Shri Vaishnav Vidhyapeeth Vishvidhyalaya

- ยท Afghanistan

PGDCA - Makhanlal Chaturvedi National University

- ยท Afghanistan

Higher Secondary (12th Grade) - Indore Glorius Public School

- ยท Afghanistan

Certifications

No certifications added yet

Interested in this developer?

Profile Score Breakdown

๐Ÿ“ท Photo 10/10
๐Ÿ“„ Resume 10/10
๐Ÿ’ผ Job Title 10/10
โœ๏ธ Bio 10/10
๐Ÿ› ๏ธ Skills 20/20
๐ŸŽ“ Education 10/10
โฑ๏ธ Experience 6/15
๐Ÿ’ฐ Rate 0/5
๐Ÿ† Certs 0/5
โœ… Verified 5/5
Total Score 81/100

Profile Overview

Member sinceSep 2026