SQL Data Warehouse and Preparing the Analysis

Install and configure an SQL server attach the sample AdventureWorks database to the SQL server prepare and extract data from the AdventureWorks database and then report on your findings and propose a plan to analyze the data.
There are several preliminary steps you must go through before beginning the assignment itself:
Next evaluate the database contents based on the business problem presented below:
You have been hired by XYZ Corporation a multinational company. XYZ Corporation has recently acquired a competitor (AdventureWorks) within the United States. XYZ Corporation management is interested in learning more about AdventureWorks employee base. Specifically they are looking to identify any trends or patterns within the dates of hire demographics performance statistics as well as any interesting or meaningful correlations between any of the data etc. AdventureWorks has provided XYZ Corporation management with a database. This database while containing a plethora of information needs your analysis. Focus on thetablesandviewsthat describe the employees of the organization.
In reviewing the data consider the following questions:
Depending on what your findings are clean the data and apply any necessary pre-processing techniques (e.g. aggregation sampling subset selection binarization discretization or transformation) that you feel are needed in order to better analyze the data later. You may also want to reorganize the data into new tables or views for easy export.
(Note: You will not be conducting analysis on the data in this module so please donotdownload and install the SPSS trial software until Week 8.)
Once the data has been processed and prepared for analysis you will need to review your results and propose the analysis approach or approaches that you feel will yield the best results in order to answer the business problem. These analysis models were discussed in Modules 4 and 5. Your Critical Thinking submission must include the following elements:
Your well-written findings should be 2-4 pages in length and formatted.Include at least two credible outside references: 1) the pre-processing methods used 2) the analysis supporting the pre-processing methods and 3) the proposed analysis approach. The outside references may include credible sources in print or from the internet.