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."

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

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

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

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.

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."

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

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

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

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

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. 🚀