A case study project of international accounting

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:

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.