Project Details

In this project, the primary objective was to create a unified report for stakeholders in sales, marketing, finance, and the executive team. Key areas of focus included:

1. Building a Robust Data Model
2. Designing User-Centric Reports
3. Providing Drillable Insights

During this project, I acquired the following skills and knowledge:

1. Proficiency in Power Query, covering both basic and advanced operations.
2. Mastery of basic and complex DAX formulas.
3. Expertise in data modeling with over 10 interconnected tables.
4. Selection of appropriate visuals and formatting techniques.
5. Skill in using bookmarks for enhanced user experience.
6. Deployment on the Power BI service platform.
7. Actively incorporating stakeholder feedback.
8. Analysis and reporting of metrics across sales, marketing, finance, and supply chain domains.

Project video

Project Details

In the Sales Performance Enhancement project, our mission was to empower decision-makers with actionable insights. Focused on boosting sales, key priorities included:

1. Executing In-Depth Data Queries
2. Informing Decision-Making Strategies
3. Enhancing Overall Sales Performance

Throughout this project, I developed the following skills:

1. Proficiency in SQL data querying, covering diverse business questions.
2. Mastery of data interpretation and strategic decision support.
3. Selection of effective visualizations for clear data representation.
4. Successful implementation of SQL solutions in a business context.
5. Comprehensive analysis of key sales metrics for informed decision-making.

Project video

Project Details

AtliQ Grands, famed for its luxurious five-star hotels in India, faces declining market share and revenues in luxury and business segments. To combat this, the managing director initiates a strategic "Business and Data Intelligence" integration.

Key Focus Areas:

Creation of an interactive Power BI dashboard for real-time data analysis.
Implementation of vital hospitality domain metrics including RevPAR, ADR, DBRN, DSRN, and DURN.
Thorough analysis of historical data to identify revenue-enhancing opportunities.
Provision of actionable insights to inform pricing and occupancy decisions.
Throughout this project, I honed the following skills and knowledge:

Proficiency in Power BI for data visualization and analysis.
In-depth comprehension of key hospitality metrics and KPIs.
Data-driven decision-making methodologies for pricing and occupancy optimization.
Effective data presentation techniques to facilitate strategic decision-making.

Project video

Project Details

Employed Power BI for an in-depth analysis of Shield Insurance. Explored revenue, customer behavior, city trends, sales modes, and age group dynamics. Generated a comprehensive report leading to strategic decisions and actionable recommendations. Contributed to an 8-10% revenue growth projection and expanded market presence via data-driven insights.

Project video

Project Details

This project offers a comprehensive analysis of the Lok Sabha election results for 2014 and 2019. The aim is to examine electoral trends, voting patterns, and key metrics across India's parliamentary constituencies during these pivotal election years. Utilizing tools like Power BI for data visualization, Power Query for data cleaning and transformation, the project highlights critical insights and patterns. Key performance indicators (KPIs) include voter turnout percentages, winning margins, and vote shares by party. The analysis also covers correlations between voter turnout and factors such as postal votes, GDP, and literacy rates. Additionally, recommendations are provided to improve voter turnout in future elections.

Project video