Portfolio - Shail Sahu

PowerBI Project

Revenue_Insight_AtliQ Hospitality _PowerBI _Project

Atliq Grands owns multiple five-star hotels across India. They have been in the hospitality industry for the past 20 years. Due to strategic moves from other competitors and ineffective decision-making in management, Atliq Grands are losing its market share and revenue in the luxury/business hotels

View Project
Engagement

View Project
on GitHUB

Revenue_Insight_AtliQ Hospitality _PowerBI _Project

Discover the secrets to maximizing revenue in the dynamic world of hospitality. Our data-driven approach unravels hidden patterns.

Explore the diverse mattresses of the hospitality landscape and gain powerful insights for strategic decision-making.

Project Details

TaskList:
1.Developrelevantmetrics.
2.Designanintuitivedashboard.
3.Uncovervaluableinsights.

LearningPoints:
1.Builtanewvisual(Scoller)fordatavisualization.
2.Discoveredhotels'cancellationpolicytrends.
3.Masteredpagenavigationandclearfilterimplementation.
4.Usedaconsistentcolorpalettethroughoutthedashboard.

KeyDashboardInsights:
1.Mumbaigeneratesthehighestrevenue(669M),followedbyBangalore,Hyderabad,andDelhi.
2.AtliQExoticaperformsbettercomparedtoallproperties(320Mrevenue,rating3.62,57%occupancy,24.4%cancellationrate).
3.AtliQBayhasthehighestoccupancyat66%.
4.Delhitopsbothinoccupancyandrating,followedbyHyderabad,Mumbai,andBangalore.
5.AtliQlosesaround24%ofrevenueduetocancellations.
6.Eliteroomshavethemostbookingsbutalsoahighercancellationrate.

Project video

Live Interactive Dashboard

PowerBI Project

Sales_Insight_360

Having successfully completed the codebasics Power BI course, I gained valuable insights on problem-solving beyond the tools. The course covered essential tech skills like SQL, Power BI Desktop, Excel, DAX language, and DAX Studio for optimizing reports.

View Project
Engagement

View Project
on GitHUB

Concise insights for decision-makers. Visualize critical metrics, spot trends, and drive strategy. Empower executives with data-driven clarity.

Sales View: Unlock sales potential with data-driven precision. Track performance, identify opportunities, and boost revenue.

Project Details

Having successfully completed the codebasics Power BI course, I gained valuable insights on problem-solving beyond the tools. The course covered essential tech skills like SQL, Power BI Desktop, Excel, DAX language, and DAX Studio for optimizing reports.
✔ Crafted calculated columns and measures using DAX language.✔ Mastered data modeling techniques.✔ Leveraged Bookmarks to switch between visuals and enabled smooth page navigation with buttons.✔ Implemented divide function for error-free division.✔ Created dynamic date tables using M language.✔ Customized titles based on applied filters.✔ Incorporated KPI indicators and conditional formatting using icons and background colors.✔ Explored data validation techniques.
✔ Learned about Power BI services, report publishing, personal gateway setup, and app creation.✔ Acquired proficiency in collaboration, workspace management, and access permissions on Power BI services.✔ Analyzed Gross Price, Pre-Invoice Deductions, Post-Invoice Deductions.

Project video

Live Interactive Dashboard

SQL Project

Consumer Good Ad-Hoc Insights

Its Resume challenge Project_SQL-based consumer good insights for AtliQ Hardware(Fiction Company),Atliq Hardware is a prominent computer hardware producer based in India, holding a leading position not only in the Indian market but also in various other countries.

View Project
Engagement

View Project
on GitHUB

The data model with dimension tables and its relationship with fact tables. along with the 10 Ad-Hoc requests to discover insights for decision making

SQL query to find out the Unique product count and its outcome visualized by PowerBI

Project Details

Enhance Decision-Making: Improve the quality of decision-making by providing the management with quick and data-informed insights.
Expand Data Analytics Team: Strengthen the data analytics team by hiring multiple junior data analysts proficient in both technical and soft skills.
Evaluate Candidate Skills: Conduct a SQL challenge to assess candidates' proficiency in technical abilities and communication, ensuring the selection of suitable candidates with a balanced skill set.

Excel Project

Road Accident Analysis

𝗔𝗻 𝗘𝘅𝗰𝗲𝗹 𝗗𝗮𝘀𝗵𝗯𝗼𝗮𝗿𝗱 𝗮𝗻𝗮𝗹𝘆𝘇𝗶𝗻𝗴 𝗨𝗞 𝗿𝗼𝗮𝗱 𝗮𝗰𝗰𝗶𝗱𝗲𝗻𝘁 𝗱𝗮𝘁𝗮.I've dived deep into the numbers to uncover insights about accident trends, locations, and contributing factors;𝗟𝗲𝗮𝗿𝗻𝗶𝗻𝗴 𝗳𝗿𝗼𝗺 𝗣𝗿𝗼𝗷𝗲𝗰𝘁:Creating Multiple Pivots and Exploring to analyze.

View Project
Engagement

View Project
on GitHUB

The dashboard covers all the important KPIs and also a time series filter to view the data insights monthly and quarterly.

This sheet has all Pivot tables used for creating the Dashboard.

Project Details

𝗧𝗼𝗼𝗹 𝗨𝘀𝗲𝗱: 𝗘𝘅𝗰𝗲𝗹

𝗣𝗿𝗼𝗰𝗲𝘀𝘀 𝗙𝗼𝗹𝗹𝗼𝘄𝗲𝗱:

1. 𝗥𝗲𝗮𝗱𝗶𝗻𝗴 𝗱𝗮𝘁𝗮 for better Understanding.
2. 𝗗𝗮𝘁𝗮 𝗖𝗹𝗲𝗮𝗻𝗶𝗻𝗴 it as required.
3. 𝗣𝗿𝗼𝗰𝗲𝘀𝘀𝗶𝗻𝗴 𝗱𝗮𝘁𝗮 and creating additional columns like month and year.
4. 𝗗𝗮𝘁𝗮 𝗮𝗻𝗮𝗹𝘆𝘀𝗶𝘀 with the help of Pivot Tables

𝗟𝗲𝗮𝗿𝗻𝗶𝗻𝗴 𝗳𝗿𝗼𝗺 𝗣𝗿𝗼𝗷𝗲𝗰𝘁:

1. Creating Multiple Pivots and Exploring to analyze.
2. Utilization of formula and making dashboard dynamic
3. Use of Hyperlink for easy navigation and drop email as required
4. Grouping of categorical data to make it concise for usage and better outcomes.

PowerBI Project

Telangana Growth Analysis

This project aims to find insights into Telangana's economic Growth on the basis of given data sets. It is the task of resume challenge number # 7. This project has given me the opportunity to showcase my talent and interest in this field.

View Project
Engagement

View Project
on GitHUB

This is the TS-iPass data set and its analysis in terms of investment in different sectors.

In this report, the total stamp revenue of Telangana State has been segmented as per district levels.

Project Details

I led a pivotal project in 𝗧𝗲𝗹𝗮𝗻𝗴𝗮𝗻𝗮, leveraging data to drive socio-𝗲𝗰𝗼𝗻𝗼𝗺𝗶𝗰 𝗴𝗿𝗼𝘄𝘁𝗵. The goal was to provide the government with 𝗮𝗰𝘁𝗶𝗼𝗻𝗮𝗯𝗹𝗲 𝗶𝗻𝘀𝗶𝗴𝗵𝘁𝘀 and summarize key 𝗣𝗼𝘄𝗲𝗿 𝗕𝗜 𝗱𝗮𝘀𝗵𝗯𝗼𝗮𝗿𝗱 𝗳𝗶𝗻𝗱𝗶𝗻𝗴𝘀 𝗶𝗻𝘁𝗼 𝗶𝗺𝗽𝗮𝗰𝘁𝗳𝘂𝗹 𝗣𝗼𝘄𝗲𝗿𝗣𝗼𝗶𝗻𝘁 𝗽𝗿𝗲𝘀𝗲𝗻𝘁𝗮𝘁𝗶𝗼𝗻𝘀 to enhance 𝗱𝗮𝘁𝗮-𝗱𝗿𝗶𝘃𝗲𝗻 𝘀𝘁𝗼𝗿𝘆𝘁𝗲𝗹𝗹𝗶𝗻𝗴 𝗮𝗻𝗱 𝗱𝗲𝗰𝗶𝘀𝗶𝗼𝗻-𝗺𝗮𝗸𝗶𝗻𝗴 𝗱𝘂𝗿𝗶𝗻𝗴 𝗽𝗿𝗲𝘀𝗲𝗻𝘁𝗮𝘁𝗶𝗼𝗻𝘀
Insights:
E-challan revenue in Telangana surged significantly, increasing from 12% in 2020 to an impressive 48% in 2022
Year-to-year data indicates a consistent increase in electric vehicle demand in Telangana remake in 2022 by 60% sales of 63K
Hyderabad ranked the highest in motor-cycle sales revenue 207k in 2022
Plastic and rubber industry has taken its peak in 2022 with 58.56bn.
Pharmaceutical industry has grown due to Covid in 2021 by 43.26%
Fertilizers (Organic and Inorganic), Pesticides, Insecticides, and Related Se

Hello, I am

Shail Sahu

1

3

1

About

Key

My

Revenue_Insight_AtliQ Hospitality _PowerBI _Project

Sales_Insight_360

Consumer Good Ad-Hoc Insights

Road Accident Analysis

Telangana Growth Analysis

Contact Me

Email

Github

Linkedin

Call

Shail Sahu

Download Resume