Ujjwal Garg

Data Aspirant

[email protected] +91 9773760824

Resume

Hello, I am

Ujjwal Garg.

1

Excel
Project

2

PowerBI
Projects

1

SQL
Project

About Me

I am an aspiring Data Analyst who loves turning data into meaningful insights. With a solid grasp of Excel, Power BI, SQL, and Python, I excel at finding patterns and answers in data. My journey started with a Bachelor's degree in Computer Science Engineering with specialization in AI, ML, and Robotics. During my studies, I discovered a natural talent and passion for data analysis, which led me to focus on this field.

Although I haven't yet worked for an organization, I have completed several business projects that demonstrate my skills and dedication. These projects, showcased in my portfolio below, highlight my ability to analyze data and provide valuable insights that drive decision-making. I am eager to bring my analytical skills, enthusiasm, and fresh perspective to your team, helping to unlock the full potential of your data.

Key Skills

SQL

Communication

Problem Solving

PowerBi

Excel

My Projects

AtliQ Hardware Sales and Finance Report

Domain/Function: Business

Business Insight 360

Domain/Function: Business

Ad-Hoc Insights SQL

Domain/Function: Consumer Goods

EV Market Analysis in India

Domain/Function: Automotive

My Experience

Data Analyst Virtual Internship - MeriSkill April 2024
● Conducted in-depth analysis using PowerBi and Excel, resulting in actionable insights
● Led the Sales Data Analysis Dashboard project, identifying revenue trends and optimizing sales strategies for a 20% increase in efficiency. Live Dashboard
● Developed the HR Analytics Dashboard, analyzing workforce KPIs and reducing employee attrition by 15% through targeted strategies. Live Dashboard
● Extracted data-driven insights on workforce demographics and job satisfaction factors, enabling leadership to implement targeted policies that improved overall employee satisfaction scores by 25%.

Awards & Certificate

Excel: Mother of Business Intelligence

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

SQL Beginner to Advanced For Data Professionals

Data Analytics and Visualization Job Simulation

Community Champion of the Month

Let's Connect

Feel free to get in touch with me. I am always open to discussing new projects, creative ideas or opportunities to be part of your visions.

Mail Me

[email protected]

https://www.linkedin.com/in/ujjwalgrg/

Call Me

+91 9773760824

GitHub

https://github.com/UjjwalGrg

Excel Project

AtliQ Hardware Sales and Finance Report

Domain/Function: Business

Designed a detailed sales and finance report for AtliQ Hardware for FY 2022 using Excel’s advanced features, including Pivot Tables and DAX, to deliver in-depth analysis of revenue streams and expense categories.

View Project
Engagement

View Project
on GitHUB

Market performance vs Target report across years showcase the country's performance and compare it to set targets.

P & L report showcase the performance across years by different P & L metrics.

Project Details

A detailed report analyzing AtliQ Hardware's sales and financial performance over three years, focusing on optimizing sales and improving net gross margins. This report aims to provide valuable insights into market performance, helping AtliQ optimize sales strategies and improve financial decision-making.

The project covers customer performance analysis, market performance vs. targets, top product analysis, division-level growth, and detailed profit and loss evaluations by fiscal year and months. Insights into gross margin percentages by quarters for different market segments were also highlighted.

The project involved advanced data cleaning, transformation, analysis, and visualization techniques using Excel. This included applying ETL methodology, generating date tables, establishing data model relationships, and utilizing Power Query and Power Pivot for robust data processing.

PowerBI Project

Business Insight 360

Domain/Function: Business

Created a Power BI dashboard for AtliQ Hardware. The dashboard offers in-depth business analysis across finance, sales, marketing, etc, helping AtliQ make data-driven decisions. It integrates MySQL and Excel datasets, totaling million records, and spans five years of data.

View Project
Engagement

View Project
on GitHUB

Other Tools

SQL

Data model of dashboard where the dimension and fact tables are connected in snowflake schema.

Get P & L statement for any customer / product / country or aggregation of the above over any time period and More.

Project Details

AtliQ Hardware, a rapidly growing hardware manufacturer, wanted to revolutionized their analytics capabilities with a comprehensive Power BI dashboard.

The dashboard includes Finance, Sales, Marketing, Supply Chain, Executive, and Product views, offering interactive insights crucial for strategic decision-making.

Users can delve into key metrics like Net Sales, Gross Margin %, and Market Share % across departments, facilitating deep dives into performance trends and operational efficiencies.
The integration of extensive datasets from MySQL and Excel ensures comprehensive data analysis, enhanced further through interactive features such as filters, slicers, and drill-downs. This project not only improves data-driven insights but also empowers AtliQ Hardware to adapt swiftly to market dynamics and optimize their business strategies.

Live Interactive Dashboard

SQL Project

Ad-Hoc Insights SQL

Domain/Function: Consumer Goods

Atliq Hardwares, a computer hardware producer in India, seeks to improve data-driven decision-making. As part of a SQL challenge for a junior data analyst role, I addressed 10 ad-hoc business requests to deliver insights crucial for executive management.

View Project
on GitHUB

Data model integrates customer, product, and various fact tables like sales, gross price, and etc, enabling comprehensive business insights.

The image shows a 36.33% increase in unique products from 245 in 2020 to 334 in 2021, visualized with a comparison bar chart.

Project Details

Project Overview:

Atliq Hardwares, a leading computer hardware producer in India with global operations, needed to enhance data-driven decision-making. To support this, the management sought to expand their data analytics team by hiring junior analysts skilled in both technical and soft skills. Tony Sharma, the Data Analytics Director, initiated a SQL challenge to evaluate candidates.

As a data analyst:

- Analyzed 10 ad-hoc business requests related to sales data from different regions and product lines for 2020-2021.
- Used SQL to extract insights on market opportunities, product performance, and sales trends.
- Delivered critical insights, including top-performing products, the impact of new launches, and sales performance across channels.
- Showcased technical and analytical skills by effectively translating complex data into actionable business insights.

PowerBI Project

EV Market Analysis in India

Domain/Function: Automotive

AtliQ Motors' EV Market Analysis in India aims to explore the electric vehicle landscape, analyzing sales data, penetration rates, and market trends from 2022 to 2024. The project informs AtliQ's expansion strategy by identifying key states and makers, leveraging government incentives.

View Project
Engagement

View Project
on GitHUB

Dashboard's Home page contains navigations buttons to access other views i.e. State View, Makers View and Overall Analysis.

Data model showcasing relationships between the data tables used for Analysis.

Project Details

This project, part of AtliQ Motors' Resume Project Challenge 12, focuses on analyzing the Indian EV market to guide the company’s expansion strategy. Leveraging Power BI, the project explores EV sales and penetration rates from 2022 to 2024, covering both 2-wheeler and 4-wheeler segments. Key insights include the top states and manufacturers driving EV adoption, quarterly sales trends, and future sales projections based on CAGR. Additionally, the project delves into the impact of charging infrastructure availability and government incentives on EV growth. It answers crucial questions regarding market leaders, seasonal trends, and potential revenue growth. With this comprehensive analysis, AtliQ Motors is well-positioned to make informed decisions about entering the Indian market, optimizing product launches, and expanding infrastructure support.