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 Por 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 y 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 yea 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 fi 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

Treemar

Filled Map

Slicer

Gauge

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