Complete this using Tableau, please do not use coding software like python, and do not try to the compute the key tasks using just math, since the task is to actually make visualizations in Tableau that can answer the key task requirements.

The images uploaded is the data for the Budget vs Actuals excel, please extract and convert to an excel file in order to use in Tableau.

Overview

Imagine you work for a firm that is leading a project for a major client. The project$$s budget and actual expenditures need to be reviewed to ensure that the project is on track and to identify any variances that may require attention.

In this project, there are many different employees in different roles, all with different hourly rates and amounts of time they can bill to a project. The data includes time billed to a project by each person, that person$$s role, and their hourly bill rate. You are assigned to prepare visualizations comparing the project$$s budget to actual status.

Assume we have completed $40\%$of the overall amount of work done $($meaning we are behind schedule, we should have completed about $50\%$if we started April $1$st and end September $1$st$).$Also assume that our budget for the project was one million dollars. We had allotted $$250,000$of the budget to the partner's hours, $$250,000$to the manager's hours, $$450,000$to the analyst's hours, $$25,000$for travel $($for everyone$),$and $$25,000$for food $($for everyone$).$

Assume the project is due on $9/1/2024.$

Key Tasks

Upload the Budget vs Actuals.xlsx data set in Tableau

Specifically, we want you to visualize whether these things are on track:

Overall budget for the project relative to the amount of work doneAmount of work done relative to where we should be at this point in the project based on the timelineThe amount of budget allocated to analysts, associates, managers, senior managers, and partners, compared to the actual amount spent thus farTravel costs compared to the amount budgeted

Prepare at least three visualizations

Execute on all prior knowledge of data visualization best practices up to this point