ActiveData Graded Homework Assignment

The attached Excel workbook contains data that has been extracted from NetSuite (via the Export to CVS file function at the bottom right of all reports).  Use the data and the workbook to complete the following homework questions.  Perform all analyses in this Excel workbook and answer the narrative questions on the same page as the analysis (use Insert Text Box) so that you only submit ONE file to your Assignment Folder according to the date in the Syllabus. Remember to rename the workbook under your name so that it can be easily identified for grading.

Part 1 - Purchase Order Summary/Pivot Analysis

Go to the Tab named PO Register.  "Clean" the data according to the following instructions.  Note:  The concept of how data should be presented inorder for Active Data commands to work, applies all the time.  This process of "cleaning" or preparing data for analysis is common in many data analysis packages.

a.       Most of ActiveData's commands require that the column names be in row 1 and that row 2 and beyond contain the data. In addition to this, ActiveData (and often Excel) looks at the first couple of rows of each column to determine what type of data the column contains (text, numbers or dates).

Your csv file has 5 rows before the column names and an extra row after the column names with a title in it and then the raw data rows.

Remove the first 5 rows and row 7:

 Remove Grand Total rows

a.     As the CFO, you would like to see this report summarized by vendor, with amount totals, displayed in a pivot table that shows Status across the top, with Vendors down the left side, with amounts and grand totals.  (Check your pivot totals to your data totals as a last step.)

b.    Question:  As CFO, verbally describe in a narrative whether there are any things Ramsey PO Clerks should be looking out for or doing better in their data entry. 

c.     Question:  As CFO, verbally describe the results, and do you have any concerns in the summary that you see?