This is a huge case study project, I have post the instruction file, there might need to use the Power BI to analysis.

Assignment

The team has been tasked to perform the following:

• Overall performance analytics:
  • How is Capo BnB performing globally?
  • What are the revenues by region?
  • How are the various accommodations performing?
  • What are the most and least profitable accommodations?
• Regional performance analytics:
  • How is Capo BnB performing regionally?
  • What are the revenues by countries with a region?
  • How are the various accommodations performing?
  • What are the most and least profitable accommodations?
• Regional performance analytics:
  • How is Capo BnB performing by country?
  • What are the revenues by cities with a region?
  • How are the various accommodations performing?
  • What are the most and least profitable accommodations?

Deliverable

You should prepare a business report formatted as follows:

• Title Page – example follows
• Executive summary
  • Clear and concise reason for performing the analysis containing a description of the revenues
  • Main points, conclusions and recommendations
• Introduction- describe the company and the process used by the team to conduct the analysis.
• Main Body
  • Follow the order of the questions in the assignment.
  • Discussion of the findings
  • Include any visualizations- graphs tables
  • Overall discussion- highlight the main points of your analysis
• Recommendations
  • Based on your analysis what should Capo BnB do going forward?
  • Are there regions, countries, cities, types of accommodation that should be encouraged or discouraged?
• The report should be in a word document.

Tasks:

Cleanup the data:

• Open the data file Air-BNB-Data-Worldwide.xlsx
• Should be three sheets “North America,” “Europe,” and “Orient”
• Make sure all column headings are named the same
• Remove blanks
• Remove items that have $0 revenue
• Remove duplicate headers

Bring in only the data elements you need to perform the analysis.

Conduct the analysis- create the visualizations.

Export to a PDF- be careful use one page for each table or graph or else there will be problems arranging them in the Word document.