Dashboard - Click here to view dashboard in Power Bi app

Problem

You work for Airbnb. You are the New Operational Manager in New York for 1 year. You are then responsible of the good development of the Airbnb service on renting in this town.

* In 1 week, the Directory Manager comes to New York in order to: 1. Make a review of your operational KPI on your perimeter (New York) 2. Work with you to improve the quality of service of the plateform, by keeping only the best and profitable renters

* Until now, the reports have been made in Excel / Power Point and Airbnb aims to digitalize its reporting with Power BI in order to: 1/ Make them more interactive; 2/ Make them more industrialized ; 3/ Access to anytime to the dashboard on PC, smartphone, etc.

* You decided with your team that it would be a great opportunity to make a dashboard in Power BI

Objectives

1. Make review of your activities and present them to the Directory Manager

2. Prepare the analysis to align to the next year target operating model of Airbnb: - Identify good and bad practionner - Evaluate the number of bad practitioners and the reasons

We need to create an analytical dashboard for Airbnb New York Directory Manager by

analyzing the dataset of properties located in New York.

We have the following data fields in our dataset:

Host Id - The unique ID value of host

Host Since- The date year the host joined in Airbnb

Name - The name of the property

Neighbourhood - The details of borough where each property located

Property Type - The type of property

Review Scores Rating (bin) - The scaled value of review rating

Room Type - Type of room like whether its shared or private

Zip Code - Property zipcode

Beds - The number of beds for each property

Number of Records - Number of records of property

Number Of Reviews- the total reviews per property

Price - The price listed for property in Airbnb

Review Scores Rating - The actual consolidated review score rating.

Power Bi - Project for Airbnb