SHOBHIT SHUKLA

Aspiring Data Analyst

Bengaluru, IN.

About

Aspiring Data Analyst with a robust foundation in statistics, Python, SQL, Excel, and Power BI, adept at transforming complex datasets into actionable insights. Proven ability to leverage data visualization and analytical techniques to solve real-world problems, as demonstrated through academic projects. Eager to apply strong analytical and problem-solving capabilities to drive data-driven decision-making within a dynamic team.

Volunteer

Volunteer, Organizing Committee – Utsav 2023

|

BMSCE

→

Coordinated logistics and operations for Utsav 2023, a major college cultural fest, ensuring seamless execution of events.

Highlights

Coordinated comprehensive event logistics and operational workflows for Utsav 2023, a large-scale college cultural fest.

Collaborated with diverse teams to manage event flow, ensuring smooth execution and positive participant experience.

Coordinator, Logistics Committee – Utsav 2023

|

BMSCE

→

Managed event logistics, inventory, and vendor coordination during college cultural fest, ensuring efficient resource allocation.

Highlights

Managed comprehensive event logistics, including inventory tracking and vendor coordination, for the Utsav 2023 college cultural fest.

Ensured efficient resource allocation and timely delivery of materials, contributing to the successful execution of multiple events.

Education

BMS College of Engineering

Bengaluru, Karnataka, India
→
Bachelor of Technology Aerospace Engineering

Certificates

SQL for Data Science

Coursera

Skills

Languages

Python, SQL.

Data Visualization

Power BI, Excel, Pivot Tables, VLOOKUP, Matplotlib, Seaborn.

Libraries

Pandas, Numpy.

Tools & Others

Jupyter Notebook, Git, GitHub, Google Sheets, MySQL, VsCode, Microsoft Excel, Power Query, DAX.

Data Analysis

Exploratory Data Analysis (EDA), KPI Calculation, Trend Analysis, Consumer Behavior Analysis, Sales Forecasting, Data Cleaning, Data Aggregation.

Business Intelligence

Dashboard Development, Interactive Reports, Actionable Insights, Data-Driven Decision Making.

Content Creation

Tutorial Development, Market Analysis, Audience Engagement.

Projects

Amazon Sales and Discount Analysis — Excel Project

→

Summary

Developed an interactive Excel dashboard to analyze Amazon product sales trends, integrating AI-supported tools for enhanced analytical guidance.

Uber Bookings Analysis — PowerBI SQL Project

→

Summary

Developed a comprehensive Power BI dashboard to analyze Uber booking trends, revenue streams, and ride dynamics, providing a holistic view of operational performance.

Zepto Grocery Sales Dashboard — Power BI Project

→

Summary

Designed a dynamic Power BI dashboard for Zepto, providing critical insights into grocery sales, product performance, and outlet-specific trends.

Diwali Sales EDA — Exploratory Data Analysis Project

→

Summary

Conducted comprehensive Exploratory Data Analysis (EDA) on Diwali sales data to uncover significant consumer behavior patterns and sales trends.

YouTube Channel Creator – Forex Markets

→

Summary

Created and managed a YouTube channel focused on Forex Markets, developing beginner-friendly tutorials and insights on trading strategies and market analysis.