Answer & Explanation:Refer to the attachment and read the scenario for reference.No plagiarism please.
datawearhouse2.docx
Unformatted Attachment Preview
The student is positioned as the chief information officer (CIO) and is asked to lead an
initiative to merge the data infrastructures of both insurance companies into a single
consolidated data warehouse.
For this you will submit your implementation plan. Review the scenario for the final
assessment. Using the scenario, develop this portion of the project plan.
To meet requirements you should include four aspects in the implementation plan:
1) Timeline, 2) resources, 3) training, and 4) security policy.
The following critical elements will be addressed in this submission:
Implementation Plan:
a) Timeline: Include a reasonable timeline for implementation. Considerations include: Is
there sufficient time between milestones? What milestones and key deliverables will be
required to complete the data warehouse from start to finish?
b) Resources: What resources will be required for implementing the warehouse? Will you
use your local IT department or an external vendor? What are the approximate costs for this
project? Why are the resources you have identified necessary? Provide examples to support
your claims.
c) Training: Propose a logical training plan for employees. Be sure to specify the level of
training needs for various positions and explain your reasoning.
d) Security Policy: Craft a policy for maintaining security that meets organization needs.
Considerations include, but are not limited to: Who will have access to the data warehouse?
Who will you work with to determine access rights for users? Will employees have access to
the records from both companies?
Guidelines for Submission: Written components of projects must follow these formatting
guidelines when applicable: double spacing, 12-point Times New Roman font, one-inch
margins, and discipline-appropriate citations and references.
Reference:
Scenario:
Refer to the following scenario for the background and basis for your data warehouse design:
Imagine you are the chief information officer (CIO) for Virtual World Insurance Company,
an organization located in San Diego, California. It provides auto insurance coverage to more
than 100,000 customers across the United States and currently has 100 employees. Virtual
World Insurance Company has recently acquired Maxon Insurance Company, located in
Ontario, Canada. Maxon Insurance Company has 10 employees and provides auto insurance
to 10,000 customers in Canada. As a result of this merger, the chief executive officer (CEO)
has asked you to look at a data warehouse as a viable solution for merging both information
technology (IT) infrastructures. After doing research, you decide to create a data warehouse
that will combine the customer information from both companies into one centralized
location. Maxon Insurance Company does not have a relational database. In fact, the
company currently stores its data in multiple data sources. As a result, Maxon Insurance
Company’s data does not have any unique identifiers. Also, customers with multiple
insurance policies have duplicate records. Each spreadsheet repeats the customer’s
demographic information. Each insurance company utilizes a distinct customer relationship
management (CRM) system.
The CRM systems are used to keep a record of all customers and any communications that
are sent to customers. The CRM systems tie into an in-house billing system that is used to bill
for insurance premiums, insurance deductibles, and any other billable items. To manage
organizational operations, each company uses a different enterprise resource planning (ERP)
system. The ERP systems are used to manage human resources (hires, terminations, etc.),
payroll, budgeting, accounting, and fixed assets. To streamline operations and reduce
maintenance costs, all data systems (ERP, CRM, billing, etc.) will need to be consolidated
into a data warehouse. This will avoid duplicated information and data redundancy.
…
Purchase answer to see full
attachment
Order a plagiarism free paper now. We do not use AI. Use the code SAVE15 to get a 15% Discount
Looking for help with your ASSIGNMENT? Our paper writing service can help you achieve higher grades and meet your deadlines.
Why order from us
We offer plagiarism-free content
We don’t use AI
Confidentiality is guaranteed
We guarantee A+ quality
We offer unlimited revisions