Exploring Car Rental Data

You are an intern at a regional car dealership. You are interested in creating a demo of what Power BI can do for your manager at work. You are hoping to persuade your boss that the Power BI Desktop will be useful and hoping he will be willing to also subscribe to the Power BI

Service. Your manager provided you with some data from the past couple of years to use in your demonstration. If you use a previous year gauge, your boss would like the minimum to be $60\%$ of the prior year, a target of $108\%$ of the prior year, and a maximum of $125\%$ of the prior year.

The best demo will show visualizations that provide insight and interactivity.

a$.$ Open the Power BI Desktop and get all of the tables from Rentals.accdb. Save your file

as Rentals$\_$LastFirst using your last and first name.

b$.$ Include a calendar table that is related to a date field.

c$.$ Include at least two calculated column.

d$.$ Include at least four Measures, at least one of which is time analytics DAX measure.

e$.$ Include at least four of the following:

$$ Line Chart

$$ Trend and$/$or Forecasting Line

$$ Treemap

$$ Filled Map

$$ Slicer

$$ Gauge

f$.$ Where appropriate, control or limit interactions.

g$.$ Provide your boss with recommendations$/$managerial insights based on the visualization

charts in a WORD document. In addition, please document all your created measures and

charts in this document.

g$.$ Submit your files $($both $.$pbix file and Word file with all your answers to the project$).$

Please show all SQL codes and Steps