Deepanshu Bardiya

Data Analyst

https://www.opentalent.in/deepanshu-bardiya

Data Analyst with less than a year in Data Analysis & Visualization

Key Strengths

Strong foundational skills in data cleaning, transformation, and analysis using Excel, SQL, Power BI, and Tableau.
Demonstrated ability to build interactive dashboards and reports, including KPI tracking and forecasting.
Proficient in SQL with experience in complex queries, joins, subqueries, window functions, and schema design.
Experience with Star Schema data modeling and ETL processes using Power Query.
Completed several academic projects showcasing practical application of data analysis and visualization tools.

Cultural & Operational Fit

Cultural Fit Analysis

The candidate's academic projects cover diverse domains like restaurant analytics, weather data, sales performance, and hotel bookings, indicating a broad interest in applying data analysis across different business contexts. The certifications from Deloitte and Tata suggest an initiative to align with industry best practices and corporate environments. The focus on business intelligence and reporting tools aligns well with typical data analyst roles, suggesting a good cultural fit for data-driven organizations.

Soft Skills & Operational Fit

The candidate's project descriptions indicate an ability to translate raw data into actionable insights, which is crucial for a Data Analyst role. The academic nature of projects suggests a structured approach to problem-solving and a willingness to learn and apply new concepts. However, without professional experience, it's difficult to assess operational fit, teamwork, or stress handling in a real-world business environment.

AI is analyzing your overall score…

Identifying your key strengths…

Evaluating your skill match against the job requirements…

Assessing your cultural and operational fit

About

Results-driven Data Analyst fresher with hands-on experience in data analysis, data cleaning, data transformation, and interactive dashboard development using Microsoft Excel, SQL (MySQL), Power BI, and Tableau. Proficient in writing complex SQL queries, building DAX measures, and designing Star Schema data models. Skilled in ETL processes using Power Query, KPI tracking, and business intelligence reporting. Strong ability to translate raw data into actionable insights that support business decision-making. Seeking an entry-level Data Analyst role to apply analytical skills and deliver measurable business value.

Top Skills

MysqlForecastingBusiness Intelligence

Projects

Hotels Analytics Dashboard

May 1, 2026 – May 31, 2026

Joined 5 tables (95,215 records) - Bookings, Guests, Hotels, Staff, Reviews - using Left Joins. Cleaned data using 8 calculated fields (TRIM, ABS, DATEDIFF, IF/ISNULL) fixing nulls and invalid values. Built 3 dashboards with 14 visualizations - Donut, Lollipop, Waterfall, Motion Chart using Dual Axis. Added Parameters, Dynamic Sets, Geographic Hierarchies, Action Filters, and Forecasting for interactivity.

BharatMart Sales Performance Dashboard

April 1, 2026 – April 30, 2026

Built Star Schema model and performed ETL using Power Query for clean, structured data. Created 9 DAX measures - Total Sales, Profit Margin %, YOY Growth, MOM Growth. Developed KPI dashboards for executive-level tracking; found 48% YOY growth in North region.

Weather Data Analysis

March 1, 2026 – March 31, 2026

Designed a normalized relational database with 4 tables ensuring referential integrity. Performed end-to-end SQL analysis using JOINs, subqueries, GROUP BY, HAVING, and date functions. Identified hottest cities, highest rainfall regions, and wind speed trends from query results.

Zomato Restaurant Analytics Dashboard

February 1, 2026 – March 1, 2026

Cleaned raw Zomato dataset handled missing values, duplicates, and inconsistent formats using Excel. Built Pivot Table dashboards analyzing restaurant performance, cuisine popularity, and city-wise trends. Analyzed cost vs. rating patterns to identify key factors driving high-rated restaurants. Derived location-based insights on top-performing cuisines and cities by average rating.

Certifications

Tableau Essentials

I.T.Vedant

May 1, 2026 – Present

SQL (Intermediate)

HackerRank

April 1, 2026 – Present

SQL (Basic)

HackerRank

April 1, 2026 – Present

SQL (Advanced)

HackerRank

April 1, 2026 – Present

Tata Data Visualisation: Empowering Business with Effective Insights

Tata & Forage

April 1, 2026 – Present

Deloitte Australia Data Analytics Job Simulation

Deloitte & Forage

April 1, 2026 – Present

Power BI Essentials

I.T.Vedant

April 1, 2026 – Present

SQL Mastery

I.T.Vedant

March 1, 2026 – Present

Advanced Excel

I.T.Vedant

February 1, 2026 – Present

Key Strengths

Strong foundational skills in data cleaning, transformation, and analysis using Excel, SQL, Power BI, and Tableau.
Demonstrated ability to build interactive dashboards and reports, including KPI tracking and forecasting.
Proficient in SQL with experience in complex queries, joins, subqueries, window functions, and schema design.
Experience with Star Schema data modeling and ETL processes using Power Query.
Completed several academic projects showcasing practical application of data analysis and visualization tools.

Cultural & Operational Fit

Cultural Fit Analysis

Soft Skills & Operational Fit

Deepanshu Bardiya

Key Strengths

Cultural & Operational Fit

About

Top Skills

Skills

Education

Projects

Certifications

Key Strengths

Cultural & Operational Fit