Datafile - Business Analytics

This datafile (in d2l) contains 2 worksheets that may be easily linked or joined in Tableau, where necessary. The first table contains 5248 sale transactions over a 2-year period 2012 and 2013. Various attributes for each transaction are shown such as sales amount, costs, profit, market, state, etc. There are two product lines (mowers and tractors) and two product types within each line. The second table contains a list of the ten sales employees. Only one employee is associated with a particular sales transaction.

Highlight the correct answer in this document. Add a single screenshot from Tableau, showing your result beneath each question, if you feel it is necessary.

1. Create a Key Performance Indicator that compares the actual profit to the budgeted profit month by month over the period. In which of the following months was this KPI performance metric best (or largest)?
a. October 2012
b. November 2012
c. January 2013
d. December 2013

2. In which market were sales the largest over the period?
a. Central
b. East
c. South
d. West

3. How many gas (Product Type) mowers were sold in the East (Market) over the period?
a. Less than 50
b. Between 50 and 100
c. Between 101 and 150
d. Between 151 and 200
e. More than 200

4. What were the total sales (dollars) for gas mowers in the East over the period?
a. Less than $50,000
b. Between $50,000 and $75,000
c. Between $75,001 and $100,000
d. Between $101,000 and $125,000
e. Greater than $125,000
5. Which product (if any) was not profitable over the period?
a. GT 54in
b. GM 190cc
c. GM 125cc
d. All were profitable over the period
6. Which product or products (if any) were not profitable in California over the period?
a. GT BX and LT LTX
b. GM 190cc and GM 530cc
c. EM 36Volt
d. All were profitable in California over the period

7. Which product type had a total cost of goods sold of $3,335 September 2013?
a. Electric
b. Garden
c. Gas
d. Lawn

8. Which Employee had the greatest total sales for the 1st Quarter of 2013?
a. MacKay
b. Preston
c. Smith
d. Thornton
e. Schmidt

9. How would the describe the overall sales trend?
a. Growing
b. Shrinking
c. Flat

10. Determine which employee had the largest sales for the entire period. What product did he/she sale the most of?
a. EM iON
b. GM 125cc
c. GM 530cc
d. GT BX
e. LT D105

Attachment:- Data-Sheet.xlsx