What Is the Most Common Frequency Identified for The Audit Procedures Data Analysis
Description
Unformatted Attachment Preview
In-Class Assignment eek 5
Answer Sheet
Lab 2-2 Prepare Data for Analysisìnte
Lab 5-4 (Static) Identify Audit Data Requirementsìnte
Lab 2-2 Prepare Data for Analysisìnte
Part 1: Identify the Questions
Q1. Given Slnteàrequest, identify the data attributes and tables needed to answer the question.
1. Product_Description. From FGI_product table.
2. Sales_Order_Date from Sales_Subset table
3. Sales_order_Quantity sold. From Sales_subset table.
Q2. What are the primary key/foreign key relationships?
A primary key/foreign key relationship defines a one-to-many relationship between two tables in a relational
database. For example, Product code in the FGI_product table is related to the product code in sales_subset
table.
Part 2: Master your data and prepare it for analysis in Excel.
Alternate 1: Do nothing to join tables – We can only analyze things in one table.
Using Excel (open the Slainte_Subset.xlsx file)
Q3. How many items where sold? What were total sales (need to calculate sales first) ?
Q4. How would you determine number of items sold for each product code description?
Alternate 2: Using Excel internal data model. 7e can join the tables together
Q5. How many active relationships are there?
Alternate 4: Use SQL Queries (access or SQLite)
Q6. What is the SQL code (include create table)
CREATE TABLE MERGEDATA AS
SELECT *
FROM FGI_Product
INNER JOIN Sales_Subset
ON FGI_Product.Product_Code = Sales_Subset.Product_Code
JOIN Customer
ON Customer.Customer_ID = Sales_Subset.Customer_ID;
Note: we created and exported a table. You do not need to turn it in.
Part 3: Perform an Analysis Using PivotTables and Queries Use Excel and SQLite created file to
summarize the data.
Now we can use Pivot tables.
Q7. Create a report of Sales by product name.
How many units were sold for Imperial IPA using Alt 4?
Q8. Create a report of Sales by Zip Code
How many units were sold in zip code 50320 using Alt 2?
How many units were sold in zip code 50320 using Alt 4?
Lab 5-4 (Static) Identify Audit Data Requirementsìnte
Part 1 (Static) Microsoft: Look for Audit Procedures That Evaluate Data
OQ1. How many attributes/fields are available in the dataset?
45
OQ2. What is the most common attribute that you identified to evaluate?
PO_Amount
PO_Number
Supplier_ID
Invoice_Amount
OQ3. Where are most of these attributes located?
Supplier_Listing
Purchase_Orders
Invoice Received
Employee Listing
Purchase answer to see full
attachment
Answer Sheet
Lab 2-2 Prepare Data for Analysisìnte
Lab 5-4 (Static) Identify Audit Data Requirementsìnte
Lab 2-2 Prepare Data for Analysisìnte
Part 1: Identify the Questions
Q1. Given Slnteàrequest, identify the data attributes and tables needed to answer the question.
1. Product_Description. From FGI_product table.
2. Sales_Order_Date from Sales_Subset table
3. Sales_order_Quantity sold. From Sales_subset table.
Q2. What are the primary key/foreign key relationships?
A primary key/foreign key relationship defines a one-to-many relationship between two tables in a relational
database. For example, Product code in the FGI_product table is related to the product code in sales_subset
table.
Part 2: Master your data and prepare it for analysis in Excel.
Alternate 1: Do nothing to join tables – We can only analyze things in one table.
Using Excel (open the Slainte_Subset.xlsx file)
Q3. How many items where sold? What were total sales (need to calculate sales first) ?
Q4. How would you determine number of items sold for each product code description?
Alternate 2: Using Excel internal data model. 7e can join the tables together
Q5. How many active relationships are there?
Alternate 4: Use SQL Queries (access or SQLite)
Q6. What is the SQL code (include create table)
CREATE TABLE MERGEDATA AS
SELECT *
FROM FGI_Product
INNER JOIN Sales_Subset
ON FGI_Product.Product_Code = Sales_Subset.Product_Code
JOIN Customer
ON Customer.Customer_ID = Sales_Subset.Customer_ID;
Note: we created and exported a table. You do not need to turn it in.
Part 3: Perform an Analysis Using PivotTables and Queries Use Excel and SQLite created file to
summarize the data.
Now we can use Pivot tables.
Q7. Create a report of Sales by product name.
How many units were sold for Imperial IPA using Alt 4?
Q8. Create a report of Sales by Zip Code
How many units were sold in zip code 50320 using Alt 2?
How many units were sold in zip code 50320 using Alt 4?
Lab 5-4 (Static) Identify Audit Data Requirementsìnte
Part 1 (Static) Microsoft: Look for Audit Procedures That Evaluate Data
OQ1. How many attributes/fields are available in the dataset?
45
OQ2. What is the most common attribute that you identified to evaluate?
PO_Amount
PO_Number
Supplier_ID
Invoice_Amount
OQ3. Where are most of these attributes located?
Supplier_Listing
Purchase_Orders
Invoice Received
Employee Listing
Purchase answer to see full
attachment
User generated content is uploaded by users for the purposes of learning and should be used following our honor code & terms of service.
Have a similar assignment? "Place an order for your assignment and have exceptional work written by our team of experts, guaranteeing you A results."
Complete the 
Complete the order payment after filling in the order form. We’ll receive your order and assign it to a writer.
The assigned writer will complete your paper and forward it to our Editing Team for review and approval.
Once approved by the editor, the completed paper will be uploaded to your account for you to download, review and approve.