Ujjwal yadav

Data Aspirant

[email protected] +91 7078111677

Resume

Hello, I am

Ujjwal yadav.

1

Excel
Project

2

PowerBI
Projects

About Me

I’m a B.Com (Hons.) graduate from the University of Delhi with a strong interest in turning raw data into meaningful business insights. With hands-on experience in Microsoft Excel and Power BI, I’ve built dashboards and reports that visualize key metrics, uncover trends, and support decision-making.
My background in commerce gives me a solid understanding of business operations and financial data — making it easier to align analytical insights with real-world business goals.

Key Skills

Excel

Power BI

DAX

Data Visualization

Data Modelling

Data Preparation

My Projects

Business Insights 360

Domain/Function: Finance

Hotel Chain Business

Domain/Function: Hospitality

Customer Performance Report

Domain/Function: Finance

Awards & Certificate

Excel: Mother of Business Intelligence

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

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/ujjwal-yadav-699550250/

Call Me

+91 7078111677

GitHub

https://github.com/ujjwal9344

PowerBI Project

Business Insights 360

Domain/Function: Finance

Implementing Power BI for AtliQ Hardware enables advanced analytics, transforming Excel data into actionable insights for informed decision-making, empowering rapid expansion and competitive edge in the consumer electronics market.

View Project
on GitHUB

Other Tools

Microsoft Excel

SQL

Finance View

Executive View

Project Details

In this project, the goal is to develop one dashboard which could be used by Stakeholders from Sales, Marketing, Finance and Executives team. The project is made on the following:

1. Adaptive Data Modelling
2. User-centric Report Design
3. Drillable Insights

I learned the following concepts in this project:
1. Power Query(Basics and Advanced Operations)
2. Basic and complex DAX formulas
3. Data Modelling involving 11+ tables
4. Selection of rights visuals and formatting
5. Dashboard designing principles
6. Using Bookmarks and Selections
7. Deploying project in Power BI Service
8. Stakeholder Management
9. Sales, Finance, Marketing & Supply Chain metrics

PowerBI Project

Hotel Chain Business

Domain/Function: Hospitality

Created a Dashboard for the Revenue team of AtliQ Hotels to analyze their position in the Industry and help regain their Market Share and Revenue by providing them with the relevant insights about their hotels business

View Project
on GitHUB

Other Tools

Microsoft Excel

Executive View

Revenue View

Project Details

In this project, the goal is to develop one dashboard which could be used by the Revenue team of AtliQ Hotels for providing them with insights about their business.

1. Star Schema Data modelling
2. User-Centric Report Design
3. Drillable Insights
4. KPI View for Cancellation % and Revenue trends

I learned the following concepts in this project:
1. Formulating DAX measure, columns
2. Generating calculated columns
3. Excelling in Data Modelling
4. Applying conditional formatting for more impact
5. Utilizing Heatmaps for total booking by different platforms
6. Selection of rights visuals and formatting
7. Publishing and sharing reports via Power BI Service
8. Hospitality Domain metric(ADR, RevPAR, DSRN, SRN, Cancellation %, more)

Live Interactive Dashboard

Excel Project

Customer Performance Report

Domain/Function: Finance

Created 2 reports for the Sales department which will help in evaluating Customer Performance and understand their Market Performance with respect to their targets.

View Project
Engagement

View Project
on GitHUB

Customer Net Sales Performance

P&L for Market

Project Details

The Customer Performance Report empowers businesses to delve into their sales data and extract valuable insights for strategic decision-making. Utilizing advanced Excel techniques, including DAX formulas and Pivot tables, combined with Power Query for data manipulation, the report provides a comprehensive overview of customer performance metrics. From determining effective customer discounts to facilitating negotiations and identifying expansion opportunities, this report equips stakeholders with actionable insights.

I have learned the following:
1. Advanced Excel functionalities: DAX formulas, Pivot Tables, Conditional Formatting.
2. Power Query for data transformation and cleaning.
3. Comprehensive knowledge on Sales Domain Metrics.
4. Report Beautification

By leveraging this tool, businesses can optimize their customer relationships, drive sales growth, and make informed decisions to stay ahead in today's competitive market