$!$

Required information

$[$The following information applies to the questions displayed below.$]$

Required:

Create a calculated field to calculate the Days Past Due for each invoice.

Summarize the accounts receivable by customer.

Get the detailed receivables for the customer "Taste of Thai".

Ask the Question: How can we use Tableau on the total detailed late accounts receivables balance to get specific detail on invoices due by customer?

Master the Data: To begin, we have a list of $200$ receivables that are all past their due date as of today's date of $12/31/2021.$ This is shown in the Excel file Lab $2-2$ Data.xIsx, which will be imported into Tableau.

Software needed

Tableau

Screen capture tool $($Windows: Snipping Tool; Mac: Cmd$+$Shift$+4)$

Data: Excel File Lab $2-2$ Alt Data.xlsx$.$

Perform the Analysis: Refer to Lab $2-2$ Alternative in the text for instructions and Lab $2-2$ steps for each of the lab parts.

Share the Story:

Required:

What is the grand total amount owed in past due invoices for Brewed Miracles?

$4,805$

$5,078$

$1,393$

$187$

How many days late is Grandma's Greasy Spoon's oldest invoice $($most days past due$)?$

$159$

$720$

$419$

$84$

How many invoices does Pita Pan have past due?

$4$

$10$

$18$

$5$

Which customer has the highest balance past due?

Planet of the Grapes

One in a Million

Pita Pan

Grandma's Greasy Spoon

Which customer owes $$5,156?$

Thai Tap

The Godfather

We Fry it All

Tequila Taste

$!$

Required information

$[$The following information applies to the questions displayed below.$]$

Required:

Create a calculated field to calculate the Days Past Due for each invoice.

Summarize the accounts receivable by customer.

Get the detailed receivables for the customer "Taste of Thai".

Ask the Question: How can we use Tableau on the total detailed late accounts receivables balance to get specific detail on invoices due by customer?

Master the Data: To begin, we have a list of $200$ receivables that are all past their due date as of today's date of $12/31/2021.$ This is shown in the Excel file Lab $2-2$ Data.xIsx, which will be imported into Tableau.

Software needed

Tableau

Screen capture tool $($Windows: Snipping Tool; Mac: Cmd$+$Shift$+4)$

Data: Excel File Lab $2-2$ Alt Data.xlsx$.$

Perform the Analysis: Refer to Lab $2-2$ Alternative in the text for instructions and Lab $2-2$ steps for each of the lab parts.

Share the Story:

Required:

What is the grand total amount owed in past due invoices for Brewed Miracles?

$4,805$

$5,078$

$1,393$

$187$

How many days late is Grandma's Greasy Spoon's oldest invoice $($most days past due$)?$

$159$

$720$

$419$

$84$

How many invoices does Pita Pan have past due?

$4$

$10$

$18$

$5$

Which customer has the highest balance past due?

Planet of the Grapes

One in a Million

Pita Pan

Grandma's Greasy Spoon

Which customer owes $$5,156?$

Thai Tap

The Godfather

We Fry it All

Tequila Taste