Option #1: Northwind Data Mining and Statistical Analysis – Data Warehouse The purpose of this milestone assignment is to complete the tasks described below in preparation for your final project delivery. Data Warehouse: Create a data warehouse database, including the fact and dimension tables (star schema). Create the schema for each table. Populate the tables using either ETL (Pentaho) or SQL (PostgreSQL). Preprocessing for SAS: Extract data from the data warehouse, creating a file for input into SAS. The format of the file is your choice. Ensure SAS University Edition accepts your selected format. You should use the plan formulated in Milestone 1 of Module 3 for the detailed steps you intend to follow. For this milestone assignment, you are expected to submit: Screenshots of the populated data warehouse Star schema design, either a drawing or screenshot Row counts for the fact and dimension tables Brief description of your key learnings from completing this assignment Option #2: Clothing Store Data Mining and Statistical Analysis – Data Warehouse The purpose of this milestone assignment is to complete the tasks described below in preparation for your final project delivery. Data Warehouse: Create a data warehouse database, including the fact and dimension tables (star schema). Create the schema for each table. Load the Clothing Store csv into a database (which you will need to create), including the tables and the schema, or retain the data in csv format. Populate the tables using either ETL (Pentaho) or SQL (PostgreSQL). Preprocessing for SAS: Extract data from the data warehouse, creating a file for input into SAS. The format of the file is your choice. Ensure SAS University Edition accepts your selected format. You should use the plan formulated in Milestone 1 of Module 3 for the detailed steps you intend to follow. For this milestone assignment, you are expected to submit: Screenshots of the populated data warehouse Star schema design, either a drawing or screenshot Row counts for the fact and dimension tables Brief description of your key learnings from completing this assignment

This project is divided into several parts, each with a deliverable. The first four parts are drafts. These documents should resemble business reports in that they are organized by headings, include source citations (if any), be readable, and be free from typos and grammatical errors. However, they are not final, polished reports.Please see the attached requirements.Project Part 5: Final Risk Management PlanCompile all project parts into a single risk management plan document. Reduce redundant text, if any. Incorporate instructor feedback on the previous submissions in the final risk management plan.Submission RequirementsFormat: Microsoft Word (or compatible)Font: Arial, size 12, double-spaceCitation style: Your school’s preferred style guideEstimated length: 14–20 pagesI have attached part 1 and part 2 that I submitted. The one I submitted on part 3 and 4 are wrong. Professor comments are below:Part 3 - The part 3 project is all about mitigating risks identified in Health Network Inc's IT infrastructure. For example, “Loss of company’s information on lost or stolen company-owned assets, such as mobile device and Laptop.” What type of control are you implementing to mitigate the risk? You need to use those risks you identified in the early part of the project and recommend a control.Part 4 - This part of the project should focus on the analysis of Business Impact in case of a disaster for Health Network inc. The purpose of Business impact assessment is to be prepared in case of a disaster. You should have focused on the critical business resources of the Heath Network and analyze the impact of the critical infrastructure if it were to go off. As you can see, you were writing in general terms instead of performing the analysis. For example, what is the maximum acceptable outage MAO, recovery time objective RTO for the Heath Network inc? You need to state how many hours or days that the organization can accept. Please, ensure that you.

Each student should read at least three (3) academically reviewed articles on Management Information Systems and/or a company you're interested in, then complete the following activities:(Wikipedia articles will not be accepted. Professor will check originality of all posts).1. Summarize all three (3) articles in 300 words or more. Please use your own words. No copy-and-paste2. Discuss at least 3 different concepts presented in the articles. As an IT professional, how would you apply the three (3) concepts you identified.