🚀 Step into my tech universe! I'm not just exploring; I'm on a relentless mission to uncover the 'WHY' and 'HOW' that fuel the vast realm of technology. With an unbridled passion for data and a natural knack for problem-solving, I navigate the digital cosmos seeking answers.
This project is a real-life data analytics project in the hospitality domain, focusing on generating revenue insights for a fictional company called Lake Grants, which operates multiple 5-star hotels across India. The project involves the use of Power BI to build a dashboard that can provide valuable insights for the management team.
The primary objective of this project is to create a dashboard that can generate revenue insights for Lake Grants, a company facing stiff competition from other hotels. The data set used in this project is available for download from codebasics.io and includes various files such as hotel, room, booking, aggregated booking data, and metric lists. The data set mimics real-life scenarios and contains key metrics and concepts related to the hotel industry.
The dashboard mockup includes different visuals and key performance indicators (KPIs) related to revenue, occupancy, and weekly trends. The mockup was discussed with a domain expert, Abhishek Anand, a revenue manager at Oyo rooms, who provided valuable feedback and suggested additional key metrics to be included in the dashboard, such as RevPAR, ADR, and sellable room nights (SRN).
The project involves data modeling, including the creation of relationships between different data tables and the use of filters and slicers to visualize the data. The importance of dynamic pricing strategies based on the analysis of the dashboard data is also discussed, highlighting the opportunities for the fictional company to optimize its pricing strategies.
In conclusion, this project provides valuable insights into the potential benefits of adopting dynamic pricing strategies in the hospitality industry. The dashboard created through this project can serve as a powerful tool for Lake Grants to make informed business decisions and stay competitive in the market.
View and Intract ##Sales Insights Data Analysis
This project, based on a Codebasics YouTube playlist, demonstrates the use of Power BI for data analysis. Atliq Hardware, a computer hardware company, aims to address sales performance challenges by creating an insightful and interactive Power BI dashboard.
Atliq Hardware, facing challenges in tracking sales performance, aims to create a Power BI dashboard. Sales Director Bavin Patel seeks key metrics and trends in a simple and interactive format.
The Power BI dashboard will showcase:
- Total revenue and sales quantity by year, month, quarter, and region
- Revenue breakdown by product category and market
- Revenue trends over time and seasonality patterns
- Top and bottom performing products, markets, and customers
- Sales performance comparison between different regions and products
The project utilizes a MySQL database with five tables:
- Customers
- Products
- Markets
- Date
- Transactions
Before dashboard creation, data preparation involves cleaning and transforming data using Power Query Editor in Power BI. Steps include:
- Filtering out records with negative or zero sales amount
- Converting sales amount from USD to INR for transactions with USD currency
- Filtering out irrelevant records (New York and Paris markets)
- Creating relationships between the transactions table and other tables using common columns
Designed using Power BI Desktop, the dashboard features various visualizations, including:
- Total revenue and sales quantity cards
- Revenue trend line chart
- Clustered column chart for revenue by product category and market
- Slicer for filtering data by year, quarter, region, and product category
- Tables for top and bottom products and customers by revenue
- Map and donut chart for revenue by market and customer type
- Clustered column chart for revenue comparison by region and product category
This project provides Atliq Hardware with a powerful tool to make informed business decisions. The Power BI dashboard offers actionable insights, enabling the company to stay competitive in the market.
