Solved by verified expert:please make it on timeNO PLAGIARISM ALL IN APA FORMAT700 WORDS AND 5 REFERENCESwrite 700 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: Designing Conceptual, Logical, and Physical Design Based on the RequirementsCurrently at Sky Products, the customer service, sales, marketing, and billing departments each have their own data marts used to track customers. They have no idea what customers in each other’s departments are doing. They have no standard customer record format for all departments, making it hard to match customer records in each of the departments. The creation of a data warehouse would give them the ability to track customer behavior from initial contact to sales and billing as well as help provide ideal customer service and identify other products to cross market their customer.Moral of the StoryWithout a data warehouse, there are no standardized data stored in one place for all departments to query information needed for better decision making based on accurate information. Customer data existing in silos by customer service, marketing, and sales and billing departments will not enable the organization to cross-market to customers, be aware of customer loyalty to offer special discounts, or know when they are about to lose a primary customer who uses several of the company’s products and services.AssignmentThe story you just read shows how difficult it can be to get started with standardized data in 1 location. 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, search for information about the conceptual, logical, and physical design of a data warehouse.What are the differences between the conceptual, logical, and physical design of a data warehouse?What steps should be followed to design the conceptual, logical, and physical design of a data warehouse?Select 1 of the most likely problem areas of an organization’s data warehouse design, and discuss how the difficulties could be overcome.please understand the story PLEASE MAKE GOOD ONLINE RESEARCH ON THIS ASPECTS AND ANSWER IN DETAIL AND MENTION THE BEST IN WRITINGNote- No plagiarism,minimum of 700 words and 5 good APA referencePLEASE BE IN TIME
