Build a dashboard $($Tableau$)$ or page $($Power BI$)$ called Management with the following:

$1.$ Add a filter to show only sales orders from November.

$2.$ Add a table to your page called Total Sales by Day that shows the total sales order

amount by sales order date. Tableau Hint: Set the sales order date to DAY$()$ and place

the total sales order amount as a text mark.

$3.$ Add a bar chart to your page called Sales by Customer that shows the total sales order

amount by customer account name in descending order.

$4.$ Add a new matrix table to your page called AR by Customer that shows the customer

and invoices in rows, and earliest invoice due date, age, and balance as values.

a$.$ Create a parameter showing the Report Date as $12/31/2020.$

b$.$ Create a new measure showing the Age as the difference between the Invoice

Due Date and the Report Date.

c$.$ Filter the table to show only outstanding balances that are greater than $0.$

$5.$ Add a new card to your page called Days Sales Outstanding to show the current KPI

value. Hint: Create a new measure showing the DSO as the accounts receivable

balance divided by the total sales amount multiplied by $30$ days.

$6.$ In Tableau, combine all of these visuals into one dashboard.