Accepted Solution

HR Payroll Hotel Industry

Super User
1901 Views
Super User
Posts: 935
Registered: ‎06-09-2016
Accepted Solution

HR Payroll Hotel Industry

This Report focuses on the Payroll Analysis of the Hotel Industry.

 

Any Hotel have 4 main cost centers:

Housekeeping

Front Office

Maintenance and

Food & Beverage.

 

Housekeeping is the biggest department in any hotel in terms of budget and no. of employees and it can make or break the guest sentiments. It is also crucial for the housekeeping department to be time and budget bound.

This report analyses the no. of minutes spent in various areas of the housekeeping department such as room cleaning, supervisors role, houseman’s role and various others. It is also focussed deeply with day & date specific granularity, Month specific results and overall trend.

This report is dedicated to the PowerBI community Members who would like to develop Proof of Concept in this area.

Hope You would like this and Let me know your thoughts on this.

Thanks & Regards,
Bhavesh

Love the Self Service BI.
Please use the 'Mark as answer' link to mark a post that answers your question. If you find a reply helpful, please remember to give Kudos.

Accepted Solutions
Member
Posts: 92
Registered: ‎11-02-2016

Re: HR Payroll Hotel Industry

Very informative report! Congratulations!

I've found something very funny. It's that one of the employees average cleaning time is "Infinity". Smiley Very Happy 

View solution in original post


All Replies
Member
Posts: 92
Registered: ‎11-02-2016

Re: HR Payroll Hotel Industry

Very informative report! Congratulations!

I've found something very funny. It's that one of the employees average cleaning time is "Infinity". Smiley Very Happy 

Frequent Visitor
Posts: 15
Registered: ‎10-06-2016

Re: HR Payroll Hotel Industry

Good Report @BhaveshPatel

 

For more specific Power BI Dashboard and Report for Human Resource Department. Advaiya developed Power BI dashboards and reports for the client to provide faster and better insights into their human resources data. The client wanted to visualize headcount statistics, and similar HR metrics on a single interface and reduce dependency on a large number of operational reports.

Advaiya, leveraging data related to headcount, finance, and internal Azure usage from multiple sources including SSAS cubes and SQL queries from SQL Server, developed a Power BI dashboard, and Excel reports using Power Pivot Data Model. Advaiya also helped the client gain deeper insights into the technical seller roles’ growth trends and attrition using custom analysis.

 

Join Live Demo of Power BI Dashboard Essentials and ShareAdvance - To supercharge your Business Intelligence, http://web.advaiya.com/power-bi-showcase-dashboard-essentials/?src=power