Portfolio - Ankesh Yadav

Excel Project

Financial Domain ( Bank Loan Analysis)

"Bank Loan Analysis: Employing data analytics to assess credit risk, repayment trends, and customer behavior. Enhancing financial decision-making for optimized loan management and risk mitigation in the banking sector."

View Project
on GitHUB

This Interactive dashboard explains summary of the project.

This Interactive dashboard explains overview of the project.

Project Details

"Bank Loan Analysis Project: This financial endeavor centers on leveraging data analytics to enhance the efficiency of bank loan processes. By scrutinizing credit risk, repayment patterns, and customer financial behavior, the project aims to provide valuable insights for informed decision-making. Through the application of advanced statistical models, predictive analytics, and machine learning algorithms, the analysis will identify key factors influencing loan performance. The focus extends to optimizing loan approval processes, minimizing default risks, and improving overall portfolio management. The project's overarching goal is to foster a more robust and data-driven approach in the financial domain, ensuring prudent lending practices, and ultimately contributing to the long-term stability and growth of the banking institution."

PowerBI Project

Business Insights 360 Dashboard for Finance, Sales,Executive, Marketing and Supply Chain

"AtliQ Hardwares aims to enhance competitiveness by transitioning from Excel reports to an advanced Power BI analytics solution. Accelerating data-driven insights, this move empowers informed decision-making for sustainable growth in the dynamic consumer electronics market."

View Project
on GitHUB

Business Insights 360 Dashboard for Finance, Sales,Executive, Marketing and Supply Chain

This interactive Dashboard of Bussiness insights 360 describes about Executive Dashboard

Data modelling involving 10+ tables

Project Details

In this project, the goal is to be one report which could be used by stakeholders from sales, marketing, finance and executive team. The focus is made on the following

1. Robust Data Modeling
2. User-empathetic Report design
3. Drillable Insights

I learned the following things in this project

1. Power Query (Basic and Advanced Operations)
2. Basic and complex DAX formulas
3. Data modelling involving 10+ tables
4. Choosing the right visuals and formatting
5. Dashboard designing principles
6. Using bookmarks
7. Deploying in Power BI service
8. Stakeholder Feedback Implementation
9. Sales, Marketing, Finance & Supply Chain metrics

Live Interactive Dashboard

PowerBI Project

Global Superstore Analysis (Sales, Forecast, Decomposition, Comparison)

"Global Superstore Analysis: Unveiling sales trends, forecasting future performance, and conducting in-depth decomposition and comparison. Harnessing data for strategic insights in a dynamic global retail landscape."

View Project
on GitHUB

Global Superstore Analysis (Sales, Forecast, Decomposition, Comparison)

This Interactive Dashboard Explains detailed analysis of Global Sales.

This Dashboard explains forecast about sales based on previous data.

Project Details

"Embarking on the Global Superstore Analysis project involves a comprehensive exploration of sales dynamics, forecasting future trends, meticulous decomposition, and insightful comparisons. By leveraging advanced analytics tools, the project aims to unravel intricate patterns within the vast dataset of a global retail giant. The focus spans sales performance across regions, product categories, and customer segments. Utilizing forecasting models ensures proactive planning, while decomposition analysis dissects contributing factors. Comparative assessments provide benchmarking insights for strategic decision-making. The project's overarching goal is to empower the organization with actionable insights, fostering data-driven decision-making in the complex landscape of global retail operations."

Live Interactive Dashboard

PowerBI Project

T20 World Cup (2022) Analysis (Overview, Batsman Stats,, Bowler Stats)

"T20 World Cup 2022 Analysis in Power BI: Offering a dynamic overview, detailed batsman statistics, and bowler performance insights. Visualizing cricket data to unveil trends and player contributions, enhancing the understanding of the T20 World Cup narrative."

View Project
on GitHUB

T20 World Cup (2022) Analysis (Overview, Batsman Stats,, Bowler Stats)

This Interactive dashboard explains T20 World Cup Batsmen Analysis.

This Interactive dashboard explains T20 World Cup Bowler Analysis.

Project Details

"The T20 World Cup 2022 Analysis project in Power BI is an immersive exploration of cricket dynamics. Providing a comprehensive overview, it dives into batsmen and bowlers' statistical performances, unveiling patterns and player contributions. The Power BI platform transforms raw data into interactive visualizations, offering in-depth insights into match trends, player form, and team dynamics. Through advanced analytics, the project aims to enhance cricket enthusiasts' understanding of the T20 World Cup, bringing the excitement of the game to life through data-driven storytelling and interactive dashboards. It serves as a powerful tool for cricket enthusiasts, analysts, and teams alike to appreciate, analyze, and strategize in the world of T20 cricket."

Live Interactive Dashboard

SQL Project

Atliq Hardwares

Atliq Hardwares, a top computer hardware producer in India, seeks improved data insights for swift, informed decisions. Despite global expansion, there's a drive to enhance data-informed strategies for efficient management.

View Project
on GitHUB

Sample of adhoc queries

Project Details

Atliq Hardwares, a prominent computer hardware producer in India with a global footprint, faces a challenge in obtaining timely insights for agile decision-making. To address this, the management plans to augment their data analytics capabilities by recruiting junior data analysts. Tony Sharma, the Director of Data Analytics, aims to hire individuals proficient in both technical and soft skills. To assess these qualities, he has devised an SQL challenge, a crucial step in ensuring the team's ability to contribute to quick and informed data-driven decisions. This initiative aligns with Atliq Hardwares' commitment to fostering a skilled workforce capable of navigating the evolving landscape of data analytics.

Python Project

Diwali Sales Analysis

"Diwali Sales Analysis in Python: Unveiling trends and patterns in festive sales data. Leveraging Python for comprehensive insights, this project enhances decision-making for optimizing Diwali marketing strategies and maximizing sales outcomes."

View Project
on GitHUB

Sample of adhoc queries

Project Details

"Diwali Sales Analysis Project in Python involves a detailed exploration of festive sales data. Leveraging Python's robust analytics tools, the project aims to uncover intricate patterns, trends, and insights within the Diwali sales landscape. Key objectives include analyzing product performance, customer preferences, and sales channels during the festive season. Through data visualization and statistical analysis, the project provides a holistic view of sales dynamics, aiding in strategic decision-making for businesses. Additionally, predictive modeling helps forecast future trends and demand, allowing companies to optimize inventory and marketing strategies. By embracing Python for data analysis, this project empowers businesses to make informed decisions, capitalize on Diwali opportunities, and enhance overall sales performance during this crucial festive period."

PowerBI Project

Tata Group Entities, Stocks and Tata Car Models

Domain/Function: FinTech and AutoMobile Industries

I performed an in-depth Power BI analysis on the Tata Group and the diverse car models of the Tata Group, one of the most renowned conglomerates in the world. This project was inspired by the incredible contributions of Mr. Ratan Tata Sir, whose leadership has significantly shaped the Tata Group's l

View Project
Engagement

View Project
on GitHUB

Tata Group Entities, Stocks and Tata Car Models

Tata Motors The details description of the Tata Motors with Decomposition Tree visual

Tata Stocks This is the description of the Tata Stocks with visuals

Project Details

I performed an in-depth Power BI analysis on the Tata Group and the diverse car models of the Tata Group, one of the most renowned conglomerates in the world. This project was inspired by the incredible contributions of Mr. Ratan Tata Sir, whose leadership has significantly shaped the Tata Group's legacy.

I am excited to share my latest project where I performed an in-depth Power BI analysis on the Tata Group and the diverse car models of the Tata Group, one of the most renowned conglomerates in the world. This project was inspired by the incredible contributions of Mr. Ratan Tata Sir, whose leadership has significantly shaped the Tata Group's legacy.

Live Interactive Dashboard

PowerBI Project

India's Election Analysis 2014 and 2019

Domain/Function: India1's Elections

Through this project, I’ve gained valuable insights into India’s evolving political landscape while honing my data visualization and storytelling skills using Power BI. Key Features: Interactive dashboards for exploring party performance Visual breakdown of votes and margins

View Project
Engagement

View Project
on GitHUB

India's Election Analysis 2014 and 2019 Home Dashboard.

Some Data Samples and Operations.

Project Details

I’m excited to share my latest project on Indian Election Analysis for the years 2014 and 2019! 📊

This Power BI dashboard dives deep into the electoral trends, showcasing:
✅ Seat distribution across major parties (BJP, INC, and others)
✅ Voter turnout and party-wise vote shares
✅ Comparative analysis of vote margins between 2014 and 2019
✅ Detailed data insights at the constituency level

Through this project, I’ve gained valuable insights into India’s evolving political landscape while honing my data visualization and storytelling skills using Power BI.

Key Features:

Interactive dashboards for exploring party performance
Visual breakdown of votes and margins
A comprehensive look at the democratic transformation.

Live Interactive Dashboard

Excel Project

Road Accident Analysis

Domain/Function: Road Accident

𝗔𝗻 𝗘𝘅𝗰𝗲𝗹 𝗗𝗮𝘀𝗵𝗯𝗼𝗮𝗿𝗱 𝗮𝗻𝗮𝗹𝘆𝘇𝗶𝗻𝗴 𝗨𝗞 𝗿𝗼𝗮𝗱 𝗮𝗰𝗰𝗶𝗱𝗲𝗻𝘁 𝗱𝗮𝘁𝗮.I've dived deep into the numbers to uncover insights about accident trends, locations, and contributing factors;𝗟𝗲𝗮𝗿𝗻𝗶𝗻𝗴 𝗳𝗿𝗼𝗺 𝗣𝗿𝗼𝗷𝗲𝗰𝘁:Creating Multiple Pivots and Exploring to analyze.

View Project
Engagement

View Project
on GitHUB

This interactive Road Accident Analysis Dashboard in Excel provides a comprehensive overview of accident trends and casualties.

This Pivot Table Summary provides raw insights into accident data

Project Details

🚗 Road Accident Analysis Dashboard - Excel Project 📊

I recently completed an Excel-based Road Accident Analysis Dashboard, providing key insights into accident trends and their impact. This interactive dashboard helps identify patterns and risk factors, aiding in data-driven decision-making for road safety improvements.

🔹 Key Insights:
✅ Total Casualties: 121,251, categorized into fatal, serious, and slight injuries
✅ Casualties by Vehicle Type: Highest for motorcycles, followed by cars and buses
✅ Trends Over Time: Comparison of 2021 vs. 2022 casualties, showing monthly fluctuations
✅ Casualties by Road Type: Highest on single carriageways, with significant numbers on dual carriageways and roundabouts
✅ Impact of Road Surface & Light Conditions: Majority of accidents occur on dry roads, with daylight conditions being the most common

PowerBI Project

Call Centre Analysis

Domain/Function: Call Centre Analysis

I built a Call Centre Analysis dashboard to track 32.94K calls, avg. 25.02 min duration, and sentiment trends. Features geo-analysis, key call reasons, and drill-down filters to optimize 75.26% response time and enhance service.

View Project
Engagement

View Project
on GitHUB

•Total Calls: 32.94K •Average Call Duration: 25.02 minutes •Call Breakdown by Day, Channel, and Sentiment

•Detailed Data Table for Enhanced Drill-Down Analysis •Filters for Date, Channel, and City for customized insights

Project Details

Call Centre Analysis Dashboard in Power BI

I recently built a Call Centre Analysis dashboard in Power BI, showcasing data visualization, modeling, and storytelling to analyze call center performance & customer insights.

🔹 Home Page Highlights:
✔ 32.94K Total Calls, 25.02 min Avg. Call Duration
✔ Call Breakdown by Day, Channel & Sentiment
✔ Geo-analysis of Call Distribution by State
✔ Key Call Reasons: Billing Queries, Service Outages & Payments

🔹 Grid Page Features:
✔ Drill-down Table for detailed analysis
✔ Filters for Date, Channel & City

💡 Impact:
✔ Optimize Response Time (currently 75.26%)
✔ Identify areas for improvement
✔ Understand customer behavior & service demands

📊 Power BI's interactive visuals turned raw data into actionable insights, enabling better decision-making.

Live Interactive Dashboard

Excel Project

E-commerce Sales Analysis

Domain/Function: E-commerce

I analyzed e-commerce sales data using Excel to uncover insights with: ✅ Interactive Dashboard with KPIs ✅ Sales & Profit Trends via charts & maps ✅ Category-Wise Insights for growth trends ✅ Dynamic Filters for deeper analysis

View Project
Engagement

View Project
on GitHUB

View Project
on Excel

Dashboard

Pivot Charts

Project Details

🚀 Completed My E-commerce Sales Analysis Project in Excel! 📊

I'm excited to share my latest project, where I analyzed e-commerce sales data using Excel to uncover key business insights. This project involved:

✅ Interactive Dashboard with KPIs like Sales, Profit, Orders, and Profit Margin
✅ Sales & Profit Analysis across months and states using charts & maps
✅ Category-Wise Insights to track growth trends and optimize business decisions
✅ Dynamic Filters for Year, Region, and Segment to drill down into data

This project strengthened my skills in data visualization, Excel formulas, pivot tables, and business analytics. 🚀

Hello, I am

Ankesh Yadav

3

6

1

1

About

Key

My

Financial Domain ( Bank Loan Analysis)

Business Insights 360 Dashboard for Finance, Sales,Executive, Marketing and Supply Chain

Global Superstore Analysis (Sales, Forecast, Decomposition, Comparison)

T20 World Cup (2022) Analysis (Overview, Batsman Stats,, Bowler Stats)

Atliq Hardwares

Diwali Sales Analysis

Tata Group Entities, Stocks and Tata Car Models

India's Election Analysis 2014 and 2019

Road Accident Analysis

Call Centre Analysis

E-commerce Sales Analysis

My

Awards

Contact Me

Email

Github

Linkedin

Call

Ankesh Yadav

Download Resume