datawherehous in R

1. Develop a proof of concept data warehouse with more than one fact table by capturing data from an existing data source(s). Document your reasons for selecting the subject area(s), identify key stakeholders, formalise the vision and goals and requirements for developing the data warehouse. (12 marks) 2. Develop and present a suitable schema for the data warehouse. Discuss your reasons for the design. (18 marks) 3. Using Microsoft SQL Server, implement your tables and extract, transform and load data from the operational source(s) into the data warehouse. This can be done using any available tool or by writing SQL statements. (17 marks) 4. Produce four reports in support of the requirements outlined in section 1 using SSRS. Also produce four visualisations using R programming language and discuss them. (20 marks) 5. “A good data warehousing professional is always scouting for new sources of data that can be applied to business intelligence … Plus, analysis can be richer and more open ended if you work with original XML documents, the same way you’d work with any detailed source data”. In this spirit and to understand XML in a better way, develop an XML Schema based on the data warehouse data that a cube may capture and apply it to develop an XML document. (18 marks) 6. Implement a part of your source database or data warehouse as graph database using Neo4j technologies. Discuss the use of graph databases in comparison to relational databases.