Em Andamento

Perform some data analytics and a Power BI dashboard

Find some answers and insights for the following questions:

What are the popular choices of booking rates (table rate, columns ShortRateName or RateName) for different segments of customers (table reservation, columns AgeGroup, Gender, NationalityCode)?

What are the typical guests who do online check-in? Is it somehow different when you compare reservations created across different weekdays (table reservation, IsOnlineCheckin column)?

Look at the average night cost per single occupied capacity. What guest segment is the most profitable per occupied space unit? And what guest segment is the least profitable?

First, answer the questions using SQL and with your answer provide also the final SQL queries and output.

Then, build a report/dashboard ideally using Power BI that also help answering the questions. You may also use python and build a jupyter notebook.

Include the comments to present your solution

Thanks.

Assets

Attached are two CSV files rates and reservations that you can load into SQL database of your choice.

Specification

For 3rd task, you will use NightCost_Sum and OccupiedSpace_Sum columns. Since the data already contains aggregated values, here is how the OccupiedSpace_Sum is calculated:

SELECT

...

ISNULL(SUM(RoomCategory.[Capacity] + RoomCategory.[ExtraCapacity]), 0) as OccupiedSpace_Sum,

...

FROM Reservation

LEFT JOIN Room ON ([login to view URL] = [login to view URL])

LEFT JOIN RoomCategory ON ([login to view URL] = [login to view URL])

where Capacity is pretty much how many people you can fit into the space, or more vaguely how many beds are there.

Habilidades: Programação de Banco de Dados, SQL, Desenvolvimento de Banco de Dados, Power BI

Veja mais: power bi dashboard vs report, power bi dashboard download, power bi dashboard design, power bi dashboard examples, power bi dashboard gallery, power bi dashboard, power bi dashboard templates, power bi dashboard designer, power bi dashboard tutorial, power bi dashboard login, power bi dashboard filters, share power bi dashboard without pro, how to get data from power bi, power bi dashboard tile size, power bi dashboard price, embed power bi dashboard javascript, display power bi dashboard on tv, power bi dashboard title, power bi dashboard tiles not refreshing, power bi dashboard vs report vs workbook

Acerca do Empregador:
( 0 comentários ) Cheadle, United Kingdom

ID do Projeto: #30975044

Concedido a:

daniyal3214

Hello, I will be glad to assist you with that. I am an experienced Data Scientist and Data Visualization expert holding years of experience in performing Data Visualization, Data Analytics and Automation using Power BI Mais

£40 GBP em 1 dia
(4 Comentários)
3.9

8 freelancers estão ofertando em média £117 nesse trabalho

aksharkthakkar

checked the attached CSV files and I can represent the required KPIs on the power BI dashboard Power BI Experts || Worked On Indian Government Data || Dashboard Experts - I understood the requirements and I am glad t Mais

£250 GBP in 8 dias
(3 Comentários)
4.0
sajidjasi

Hi Dear !, I am applying for Perform some data analytics and a Power BI dashboard. Profile Link: https://www.freelancer.com/u/sajidjasi Hope you doing well. I have post graduation in Economic and Statistics and I work Mais

£150 GBP in 8 dias
(8 Comentários)
3.8
(19 Comentários)
4.0
merinsinha

Power BI , SQL Expert. As 9+ years experiences in these field. I can give good quality work. I have read the guidelines of your work.I believe that i can provide you the best quality works you are anticipating from thi Mais

£170 GBP in 3 dias
(19 Comentários)
3.7
AleksandarDikic

Hello SQL EXPERT I have read your description and I am so interested in your project. You can see well experienced and skillful SQL +5 years of experience in software development. Confident in your project and I can fi Mais

£120 GBP in 3 dias
(1 Comentário)
1.0
pantadeveloperr3

Dear, Hiring Manager I have gone through your posted project and I read your project's specifications and I can tell you that you will have a wonderful working experience with excellent outcomes. My primary focus is c Mais

£50 GBP em 1 dia
(0 Comentários)
0.0
smhuda

Hi, I understand your project requirements completely and feel confident to deliver the job perfectly. Kindly share some more details so I can start this job right away. I am expert programmer with expertise in PHP, W Mais

£135 GBP in 7 dias
(0 Comentários)
0.0