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.
Sheet Name
|
Chart Type
|
Dimensions used
|
Measures looked at or used
|
What is being explored
|
Segmentwise Sales 31000000
|
Bar chart
|
Segment
|
Sales, segment_sale 31000000
|
It will show the segment wise sale data and also show the segment whose sale data more than 3,10,00,000.
|
Product-wise Profile For Each Year/Month
|
Area/Line chart
|
Product, Date
|
Profit
|
It will show the profit details of each product against each month for year 2013 and 2014.
|
Countrywise Average Sales against Each Product
|
Scatter plot
|
Product, Country
|
Sales
|
It will show the average sales against each product for each country.
|

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.
