Project Details

Embark on a journey of thorough analysis with my latest project, where I delved deep into net sales performance across various dimensions. Through meticulous examination spanning years, customers, markets, products, growth metrics, and divisions, I uncovered valuable insights to drive strategic decision-making.

Key Highlights:

Comprehensive Examination:Conducted a thorough analysis of net sales performance, dissecting data across multiple dimensions to unveil hidden patterns and trends.

Strategic Alignment: Ensured alignment with organizational objectives by rigorously scrutinizing market performance against predefined targets, paving the way for strategic adjustments and optimizations.

In-Depth Insights: Generated comprehensive insights shedding light on critical aspects of sales operations, empowering businesses with actionable intelligence to fuel growth and success.

Project Details

Embark on a journey of data-driven decision-making with our comprehensive Bank Loan Report project. Designed to monitor and assess lending activities, this report is a strategic asset for understanding key loan-related metrics, tracking portfolio health, and informing lending strategies.

**Key Performance Indicators (KPIs) Requirements:**
1. Total Loan Applications
2. Total Funded Amount
3. Total Amount Received
4. Average Interest Rate
5. Average Debt-to-Income Ratio (DTI)

Good Loan vs. Bad Loan KPIs:
- Good Loan KPIs: Application Percentage, Applications, Funded Amount, Total Received Amount
- Bad Loan KPIs: Application Percentage, Applications, Funded Amount, Total Received Amount
Provide a consolidated view of key loan-related metrics and data points, serving as a user-friendly interface for accessing vital loan data efficiently.

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

Working with AtliQ Grands, a renowned luxury hotel chain, we implemented "Business and Data Intelligence" strategies to revitalize their market share and revenue. Our primary task was to create a dynamic Power BI dashboard to glean insights from their historical data.

Key areas of focus included:
1. Developing an interactive Power BI dashboard for real-time data analysis.
2. Implementing crucial hospitality domain metrics like RevPAR, ADR, DBRN, DSRN, and DURN.
3. Analyzing historical data to uncover revenue-enhancing opportunities.
4. Providing actionable insights to guide pricing and occupancy decisions.

During this project, I acquired the following skills and knowledge:
1. Proficiency in Power BI for data visualization and analysis.
2. Deep understanding of key hospitality metrics and KPIs.
3. Data-driven decision-making for pricing and occupancy optimization.
4. Effective data presentation to aid in strategic decision-making.

Live Interactive Dashboard