You are required to complete both parts A and B. Part A: Complete Lab 5-1 Create a Common Data Model (pp. 215 – 217) in your textbook. Part B: 1. Your analysis should be written as an essay and should...

1 answer below »

You are required to complete both parts A and B.



Part A:


Complete Lab 5-1 Create a Common Data Model (pp. 215 – 217) in your textbook.



Part B:


1. Your analysis should be written as an essay and should include the following:



  • Introduction

  • Analysis

    • Headings - Part 1 Part 2 (i.e., Part 1: Identify the Questions) – headings are shown in the Lab.



  • Communicate your findings to the Board of Directors and then write a brief paragraph of your analysis in layman’s terms. (For example, what were the key findings from your analysis?)

  • Conclusion.


2. Submit your analysis as a Word document and submit any additional requirements noted in the Lab (i.e., Excel files, tables, etc.).

Your paper should be 3 pages in length--not including the required cover and references pages or other requirements of the Lab such as Excel files and tables and include 2 references.
Answered 11 days AfterMay 06, 2021

Answer To: You are required to complete both parts A and B. Part A: Complete Lab 5-1 Create a Common Data Model...

Ali Asgar answered on May 18 2021
145 Votes
(
Transformation of Data in Common Data Model
)
Contents
Introduction    3
Working    3
Part 1: Impo
rt and Validate Data    3
Part 2: Write SQL Query to transform your Data    4
Findings:    4
Conclusion    5
Introduction
The state of Oklahoma has assigned us a task to analyse the purchase card transaction information captured by each of its state agencies and determine where resources are used. Our primary objective is to transform the raw data provided to us into a common data model based on AICPA’s Audit Data Standard. This will enable us to map any new data to the common fields without rewriting the analysis.
The data provided to us contains 420,595 purchase transactions worth a total of $166,285,071.06 for FY2018.
Working
We will be performing our task in two parts.
Part 1: Import and Validate Data
The data is provided in a csv format which needs to be imported into the database. Once the data is imported, we run two queries, first to count the...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here