please make it effectively and no plagairism all in apa format and do minimum of 8 pages,5 apa format refs

please make it effectively and make good online research and understand deeply and answer in time

Data Warehouse

Data warehousing allows an organization to methodologically organize and manage its data to provide a trustworthy, consistent, and integrated data foundation for all of its data-driven applications. Data warehousing is both important and necessary in regards to running an enterprise of any size when it comes to making intelligent decisions, avoiding misguided marketing promotions, and enabling competitive advantage. Data warehousing essentially outlines data and their relationships, and it also serves as the foundation for business intelligence (BI) because it clearly draws the distinction between data and information.

please maintain Organization and Project Selection

The first step will be to select a real or hypothetical organization as the target for your Data Warehouse Design Document. This organization will be used as the basis for each of the assignments throughout the course, and it should conform to the following guidelines:

• Sensitivity: The selected organization should be large and should contain sensitive data requiring the implementation of security measures.
• Familiarity: You should be familiar enough with the organization and typical security needs without significant time required for security research and education.
• Accessibility: You should have good access to security officers and management or incident response personnel in the organization, because these resources will provide direction as they progress throughout the development of the report.
• The selected organization must have a need for some kind of data warehouse because of poor data quality modeling in its operations. Therefore, feel free to identify a hypothetical organization that meets the requirements. Any necessary assumptions may be made to fulfill the requirements of organization selection.

Please answer this sections with minimum of 8 pages and 15 APA formatted references (Week 1: Data Warehouse Requirements)

• Give a brief description of the company (can be hypothetical) where the Data Warehouse Design Document will be implemented.
  • Include the company’s size, location(s), and other pertinent information.
• Describe the process that you will use to gather data warehouse requirements during data acquisition (source data and data staging), data storage (data warehouse database management system, data marts and metadata), and information delivery (master data database, data mining, online analytical proccessing [OLAP], and report query).
• The requirements should include the following:
  • Data Acquisition
    • Source data
    • Data staging
  • Data Storage
    • Data warehouse (DW) database management system (DBMS)
    • Data marts
    • Metadata
  • Information Delivery
    • Multidimensional database (MDDB)
    • Data mining
    • OLAP
    • Report and query
  • Management and Control

  Worked ExamplePlease refer to the Worked Example for an example of this assignment based on the Problem-Based Learning Scenario. The Worked Example outlines the Key Assignment using a fictional company called Sky Product. The worked example is not intended to be a complete example of the assignment, but it will illustrate the basic concepts required for completion of the assignment and can be used as a general guideline for your own project. Your assignment submission should be more detailed and specific and should reflect your own approach to the assignment rather than just following the same outline provided in the worked example.Case Study: Problem 1You are a consultant for a company called Sky Product. Currently, the customer service, sales, and marketing departments have customer information stored in their own departments. There is no way for each department to know any customer information outside of its own department. This has led to missed opportunities to cross-market products and services to existing customers and more time needed for customer service to research and resolve customer issues.Customer service vice president (VP) Candy Shores needs marketing and sales information concerning Sky Product’s customers to offer the best customer service. She needs data on new products or services, or understanding where the customers are in the sales process to meet their needs in a timely way. She has urged the committee to have you, the consultant, gather data to store customer, sales, and marketing information in the data warehouse. It is your job to research and collect the customer service information from the various departments to determine the requirements for the data warehouse. The goal is to provide information from all 3 departments in 1 customer view by customer account number.NOTE-PLEASE MAKE IT ON TIME AND NO PLAGIARISM ALL MUST BE IN APA FORMAT(15 REFERENCES,8 PAGES) PLEASE UNDERSTAND THE QUESTIONS DEEPLY AND ANSWER.