Project Details

In this project, I leveraged Excel pivot tables to create a robust sales report. This tool empowers businesses to strategically determine customer discounts, negotiate effectively, and identify growth opportunities across global markets. The reports offer actionable insights to optimize sales strategies, enhance customer satisfaction, and drive revenue.

Key skills honed:
1. Proficiency in pivot tables for in-depth data analysis.
2. Utilization of Power Query for seamless data manipulation.
3. Introduction to DAX calculations for advanced analytics.
4. Application of conditional formatting for visual clarity.
5. Enhancing report aesthetics for professional presentation.
6. Understanding critical sales metrics to drive strategic decisions.

This initiative equips businesses with essential tools to monitor, evaluate, and enhance sales operations. By harnessing data-driven insights, organizations can uncover new growth avenues and maintain competitiveness in a dynamic market.

Project video

Project Details

This project aimed to create a comprehensive report for stakeholders across sales, marketing, finance, and executive teams. It focused on robust data modeling, user-friendly report design, and providing drillable insights.

Key Learnings:
1. Mastering Power Query for data manipulation.
2. Developing basic and complex DAX formulas.
3. Managing complex data models with 10+ tables.
4. Choosing appropriate visuals and formatting for clarity.
5. Designing effective dashboards with user navigation in mind.
6. Utilizing bookmarks for interactive report experiences.
7. Deploying solutions on the Power BI service platform.
8. Incorporating stakeholder feedback to improve usability.
9. Analyzing metrics from sales, marketing, finance, and supply chain domains.

This project enhanced my technical skills and emphasized the importance of designing reports that meet diverse stakeholder needs and foster informed decision-making across departments.

Project video

Project Details

This project aims to harness Business and Data Intelligence to create a comprehensive report for the revenue management team. It focuses on robust data modeling, user-friendly report design, and providing detailed, actionable insights.

KPIs Learned:
1. Revenue
2. Revenue per Available Room (RevPAR)
3. Average Daily Rate (ADR)
4. Daily Sellable Room Nights (DSRN)
5. No Show Rate (%)
6. Daily Booked Room Nights (DBRN)
7. Daily Utilized Room Nights (DURN)
8. Realization Percentage
9. Booking Percentage
10. Occupancy Percentage
11. Cancellation Percentage

This initiative aims to identify and capitalize on market opportunities, optimize operational efficiencies, and develop data-driven strategies to regain market share and boost revenue in the luxury and business hotels category across India. By integrating advanced analytics, AtliQ Grands seeks to enhance decision-making, improve customer satisfaction, and ensure sustainable growth in a competitive hospitality industry.

Project video

Project Details

Ad Hoc Insights
Efficiently tackled and analyzed 10 ad-hoc requests using advanced SQL techniques, including WHERE clauses, GROUP BY, ORDER BY, CTEs, and Window Functions. Ensured precision and speed in data retrieval, providing robust query results.

PowerBI Visualizations
Employed PowerBI to create compelling visual representations of insights derived from SQL queries. Utilized sophisticated data modeling techniques to establish relationships between fact and dimension tables using the star schema concept.

Insight Presentation
Delivered an engaging video presentation to elucidate insights gleaned from the visualizations. Highlighted observations and provided actionable recommendations. Crafted a clear and captivating narrative to enhance comprehension and engagement.

From adept ad-hoc query resolution to impactful data visualization and insightful presentation, this approach epitomizes a comprehensive strategy for converting raw data into informed decision-making.

Project video

Project Details

I embarked on a captivating journey to clean and analyze a Netflix dataset, which encompasses details about TV shows and movies available on the platform up to 2021. This rich data, sourced from Flixable (a third-party Netflix search engine) and available on Kaggle, served as the foundation for extracting actionable insights and answering pivotal business questions posed by various stakeholders.

Stakeholders Involved:

- Content Acquisition Team: Delving into content trends and preferences.
- Marketing Team: Crafting bespoke promotional strategies based on content popularity and demographics.
- Executive Leadership: Driving strategic decisions regarding content investments and market expansion.

Project Requirements:

- Data Cleaning
- Data Analysis
- Insight Generation

Project video

Project Details

AtliQ Motors, a leading automotive giant from the USA, has made significant strides in the electric vehicle (EV) market, achieving a 25% market share in the electric and hybrid vehicle segment in the North America over the past five years. As part of their ambitious expansion plans, they aim to introduce their bestselling models in India, where their current market share is less than 2%. To ensure a successful launch, Bruce Haryali, the Chief of AtliQ Motors India, has commissioned a comprehensive market study of the existing EV/Hybrid market in India. This critical task has been assigned to the data analytics team at AtliQ Motors, with Peter Pandey, a skilled data analyst, leading the effort.

For the project:-

1. Analyze Primary and Secondary Questions
2. Design Your Dashboard
3. Incorporate Additional Data

Project video