Ujwala Shanbhag

Data analyst

[email protected] +91 8806272089

Resume

Hello, I am

Ujwala Shanbhag.

1

Excel
Project

2

PowerBI
Projects

1

Python
Project

About Me

I’m Ujwala Shanbhag, an aspiring Data Analyst with an engineering background. My career shift reflects my passion for data and its potential. Skilled in data manipulation, statistical analysis, and problem-solving, I excel in communication and presentation, essential for translating complex data into actionable insights. I thrive on challenges that enhance my growth in the data-driven world.

Key Skills

Python

SQL

Data Analytics

Business Analytics

My Projects

Excel-Sales-Analytics

POWER-BI-Business-Insights-360

Python-Hospitality-Data-Analysis

HR Data Analytics

Awards & Certificate

Python

Python Basics

Excel Basics

SQL (Basics)

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/ujwala-shanbhag-17466a2b1/

Call Me

+91 8806272089

GitHub

https://github.com/UjwalaS99

Excel Project

Excel-Sales-Analytics

Developed comprehensive reports for the sales team, providing insights into customer behavior and market trends using enhanced data analysis skills in Pivot Tables, Power Query, DAX Functions, Conditional Formatting, and Sales Metrics to support strategic decision-making and foster growth.

View Project
Engagement

View Project
on GitHUB

AtliQ Hardwares: 2021 Market Performance vs Target by Country, with Sales Data from 2019-2021.

AtliQ Hardwares: 2021 P&L by Market, featuring Net Sales, COGS, and Gross Margin Percentage.

Project Details

Excel Sales Data Analysis Project
I developed user-friendly reports for our sales team, providing insights into customer performance and market trends. These reports empower our team with actionable data for informed decisions and growth.

Key Learning Points:

Pivot Tables: Mastered Pivot Tables to summarize and analyze large datasets, identifying key patterns and trends.
Power Query: Used Power Query to efficiently process and transform raw data into clean, structured datasets.
DAX Functions: Gained foundational knowledge of DAX functions for complex calculations.
Conditional Formatting: Applied Conditional Formatting to highlight critical data points and trends.
Report Presentation: Designed visually appealing reports that effectively communicate insights.
Sales Metrics: Developed a deep understanding of key sales metrics to evaluate performance and identify opportunities.

PowerBI Project

POWER-BI-Business-Insights-360

Power BI Business Insights 360 dashboard offers Finance, Sales, Marketing, Supply Chain & Executive insights in one place, streamlining data-driven decision-making.

View Project
Engagement

View Project
on GitHUB

Business Insight 360 Dashboard Homepage: Comprehensive Views for Finance, Executive, Sales, Supply Chain, Marketing.

Sales View Dashboard: Focus on product-based data instead of customers. Include sales-related KPIs and trends.

Project Details

Project Overview
AtliQ Hardwares, competing in the consumer electronics market, needed advanced analytics to maintain their edge. Relying on Excel reports was no longer sufficient. Our mission: transform their analytics with a comprehensive Power BI solution for informed decision-making across departments.

Project Journey
We developed a multifaceted report for sales, marketing, finance, and executive stakeholders, focusing on:

Data Modeling: Building a robust base for insights.
User-Centric Design: Ensuring intuitive reports.
Drillable Insights: Extracting actionable insights.
Continuous Learning: Mastering Power Query and DAX.
Data Management: Handling interconnected data from multiple tables.
Visuals & Functionality: Balancing clarity and appeal.
Deployment: Launching on Power BI service.
Iterative Improvement: Refining with feedback.
Holistic Metrics: Covering sales, marketing, finance, supply chain and Executive views.

Live Interactive Dashboard

Python Project

Python-Hospitality-Data-Analysis

This project aims to design and implement a data analysis solution that extracts valuable insights from AtliQ Grands’ booking database. The goal is to identify patterns, optimize revenue, and enhance customer experience.

View Project
Engagement

View Project
on GitHUB

Screenshot of the python code for Hospitality data analysis using Jupyter notebook.

Project Details

AtliQ Grands, a fictional hotel chain, seeks to regain market dominance through data-driven strategies. This project entails real-time transaction processing (OLTP), historical data analysis (OLAP), ETL processes, and data warehousing. Key components include understanding CSV files, fact vs. dimension tables, and data exploration. The aim is to optimize revenue and enhance customer experience through insightful decision-making.

This project involves comprehensive data exploration to uncover patterns, trends, and anomalies, facilitating insightful decision-making. Data cleaning ensures accuracy by addressing missing values, duplicates, and inconsistencies. Through data transformation, including aggregation and reshaping, we prepare the data for analysis. Finally, insights are generated from cleaned and transformed data, guiding strategic decision-making processes.

PowerBI Project

HR Data Analytics

Using Power query, Power BI, and DAX formulas, I created an interactive dashboard that provides comprehensive insights into various HR workforce metrics.

View Project
Engagement

View Project
on GitHUB

HR Data Analytics of the Human Resources department.

HR Data Analytics of the Human Research and Development department.

Project Details

Key Metrics Included:

Total Employees
Attrition by Gender
Attrition by Education
Attrition by Age: Detailed age distribution
Attrition by Job Role: Breakdown by roles like Manager, Research Scientist, Sales Executive, etc.
Salary Distribution: Salary slabs (e.g., 5k-10k, 10k-15k) and corresponding employee counts
Years at Company: Employee tenure distribution

This dashboard allows HR professionals to:

-Analyze attrition rates across various dimensions
-Visualize salary distribution and tenure
-Make data-driven decisions to improve workforce management