please make good online research and answer the following,No plagiarism,650 words and mini 5 references
Please be on time
NO PLAGAIRISM
ALL IN-APA FORMAT WITH 650 WORDS MINIMUM
MINIMUM 5 REFERENCES MUST NEEDED
write at-least 650 words that respond to the following questions with your thoughts, ideas, and comments. This will be the foundation for future discussions with your classmates. Be substantive and clear, and use examples to reinforce your ideas.
Story
At Sky Products, the customer service, marketing, sales, and business departments all have separate versions of customer data and corresponding information tied to that customer. For instance, customer service has the customer’s account number, name, address, but no information on products or services marketed, sold, or billed to that customer. There are 4 different versions of a customer record. This makes it difficult for customer service to have the information that it needs need to resolve issues quickly.
Moral of the Story
Without accurate, standardized data, there is no data warehouse.
Assignment
The story that you just read shows how difficult it can be to work with data that are not standardized. For this discussion, focus on the extraction, transformation, and loading (ETL) process that is used in a data warehouse. Consider the difficulties faced in the story and how some of these difficulties were overcome when responding to the questions below.
Using the library and Internet, research and define the extraction, transformation, and loading (ETL) process used in loading data into the data warehouse.
From your research, complete the following tasks:
- What is ETL?
- What steps should be followed to properly load data into the data warehouse?
- Select 1 area of ETL, and describe how data would be handled with and without using this process.
- Discuss the effect on the business as a result.
please understand the story
PLEASE MAKE GOOD ONLINE RESEARCH ON THIS ASPECTS AND ANSWER IN DETAIL AND MENTION THE BEST IN WRITING
Note- No plagiarism,minimum of 700 words and 5 good APA reference
PLEASE BE IN TIME
"You need a similar assignment done from scratch? Our qualified writers will help you with a guaranteed AI-free & plagiarism-free A+ quality paper, Confidentiality, Timely delivery & Livechat/phone Support.
Discount Code: CIPD30
Click ORDER NOW..
