BEA1010 Business Finance For Accountants Assessment Solution

BEA1010 Business Finance For Accountants Assessment Answer:

Answer 1: Tableau Workbook Sheets For Analyzing The Data Within Financial Sample.Xlsx.

Details of the sheets in the Tableau workbook as B00421392 Financial Sample.

1) Segmentwise Sales>31000000:

2) Productwise Profile For Each Year/Month:

3) Countrywise Average Sales against Each Product:

Answer 2: Co-occurrence Visualization Using A Parameter, Calculated Fields, And A Set:

Here, we have used financial_sample.xlsx file as a dataset which has details of product selling against country.

By using of co-occurrence visualization, we can select one field value and then see which other fields values co-occur with and how repeatedly.

Data mining is the procedure of finding Patterns in data. So as per our dataset, we try to find the new pattern for sold units against product because our dataset shows the product selling information only.

Here for doing co-occurrence visualization, we have created the tableau sheet with some new fields.

For Co-Occurrence Visualization of Product Unit Sold Against Selected Product sheet, we have created following parameters and fields to get the solution.

We have created Country Contains parameters as below and connect it with products. It will create a reference of product against country.

Then we have created 2 calculated fields as below.

1) Country Contains Product:

It will show the non-selected product of country contains parameter.

2) Product Matches:

It will use to match the products. If product available in country contains parameter then it will count 1.

Then we have created a set for country field as below. Here, we set the sum of product matches field as greater or equal to 0.