Portfolio - Usha Kumari Yadav

Excel Project

Excel: Sales and Analytics

In this challenging project, I had dived deep into the world of data analytics, transforming a massive dataset of about 1 million records of raw sales data into actionable insights. Here's a glimpse of what I accomplished:

View Project
Engagement

View Project
on GitHUB

Other Tools

MS Power Point

Power Query

**Sales Report: ** **Customer Performance Report: ** A deep dive into customer behavior and performance dynamics.

**Finance Report: * **Profit and Loss Analysis: * A thorough exploration of the Profit and Loss (P&L) statement within different fiscal years.

Project Details

📊 Presenting an Excel Project Report on Sales and Finance Analytics for AtliQ Technologies Hardwares
🔹 𝗣𝗿𝗼𝗷𝗲𝗰𝘁 𝗢𝘃𝗲𝗿𝘃𝗶𝗲𝘄

📈 𝗢𝗽𝗲𝗿𝗮𝘁𝗶𝗼𝗻𝘀 𝗣𝗲𝗿𝗳𝗼𝗿𝗺𝗲𝗱:
• Utilized ETL (Extract, Transform, Load) techniques using Power Query to efficiently clean and prepare data.
• Mastered advanced Excel functions, including VLOOKUP and XLOOKUP, to seamlessly integrate and analyze data from multiple sources.
• Leveraged Power Pivot and Data Analysis Expressions (DAX) for multidimensional analysis, crafting dynamic data models.
• Applied sophisticated conditional formatting techniques to enhance data visualization, making insights easier to interpret.
• Created slicers, measures, and filters, empowering users to dynamically tailor their analysis for a user-friendly experience.
I delved deep into understanding the dynamics of sales and finance, making me well-equipped to provide data-driven insights to support decision-making.

PowerBI Project

Business Insights: AtliQ Technologies

I'm excited to share comprehensive Power BI Project for AtliQ Technologies Business Insights 360. Key Business Metrics ➡ Gross Price ➡ Pre-Invoice Deductions ➡ Post-Invoice Deductions ➡ Net Invoice Sale ➡ Gross Margin ➡ Net Sales ➡ Net Profit ➡ COGC

View Project
Engagement

View Project
on GitHUB

Other Tools

Excel

Dax studio

MySQL

➡️ Finance View: Purpose: Offers a comprehensive financial overview.

➡️ Executive View: Purpose: Provides high-level insights for executives. Key Elements: KPI Visual Charts: Net sales, Gross margin %, Net Profit %

Project Details

AtliQ Hardware is a company which engages in selling PC electronic items. This report provides insights to Finance, Sales, Marketing, Executive & Supply Chain Departments & providing them data in concise and visualist form so they can extract insights for their needs.
Analyze whether the customers in the 'Customer Performance' sales view meet the GM % target or not.
For the top 5 countries, explore the top 5 products and bottom 5 products based on GM % growth YoY and the post-discount % trend for each of these customers.

Live Interactive Dashboard

PowerBI Project

Banking Domain Resume Challenge

The project is focused on expanding Mitron Bank's product offerings, specifically introducing a new line of credit cards. The objective is to strategically tailor these credit cards to meet the diverse needs and preferences of the customer base while aligning with market trends and opportunities.

View Project
Engagement

View Project
on GitHUB

Other Tools

Excel

Power point

GitHub

Spending Insights: It shows where do people spend money the most? Does it have any impact due to occupation, gender, city, age etc.?

Avg income utilization %: Higher the average income utilization % of customers, the more is their likelihood to use the Credit card.

Project Details

➡ Problem Statement
📊 We have to analyze the provided sample data and report key findings to the strategy team of Mitron Bank.

🎯 The objective is to strategically tailor these credit cards to meet the diverse needs and preferences of the customer base while aligning with market trends and opportunities.

👉 The analysis delves into:
Demographic classification: Classifying the customers based on available demography such as age group, gender, occupation etc. and provide insights based on them.
↗ Key Metric
Avg income utilization %: Finding the average income utilization % of customers (avg_spends/avg_income). The higher the average income utilization %, the more is their likelihood to use credit cards.
➡ Spending Insights: Where do people spend money the most? Does it have any impact due to occupation, gender, city, age etc.?
➡ Key Customer Segments: By doing this, we should be able to identify and profile key customer segments that are likely to be the highest-value users.

Live Interactive Dashboard

PowerBI Project

U.S Healthcare Analytics

This Power BI Dashboard showcases insights into U.S. healthcare dynamics for the years 2019–2020. The dashboard includes analyses of hospital performance, patient outcomes, and healthcare provider metrics.

View Project
on GitHUB

The healthcare provider metrics report details patient distribution across regions and specialties, along with the total patient count by department.

KPIs include distinct patients, enrolled total, states, cities, & averages, age. State-wise gender distribution & blood group distribution visuals

Project Details

Explore the U.S. healthcare landscape from 2019 to 2020 with this carefully crafted project, offering deep insights across different aspects of the industry. Detailed reports and visuals powered by Power BI help healthcare stakeholders make informed decisions.

Unlocking Insights for Informed Healthcare Decision-Making: This endeavor offers a comprehensive analysis of the U.S. healthcare industry for the years 2019–2020 through Power BI. Dive into detailed reports and visualizations that provide strategic insights for healthcare stakeholders.

Empowering Informed Healthcare Decisions through Analytical Insights: Explore detailed reports and compelling visualizations that deliver strategic intelligence for stakeholders in the healthcare landscape

Hello, I am

Usha Kumari Yadav

1

3

About

Key

My

Excel: Sales and Analytics

Business Insights: AtliQ Technologies

Banking Domain Resume Challenge

U.S Healthcare Analytics

Awards

Contact Me

Email

Github

Linkedin

Call

Usha Kumari Yadav

Download Resume