Project Assignment:
The project applies all the concepts of data warehouse design and data mart applications learned in this course. You should illustrate at least four different data sources. Please note the data should have at least 250 or more records. Illustrate these sources with different relational models. Normalize the models to come up with a reconciled schema. Once reconciled, illustrate a suitable fact schema with rationale for denormalization. Give details of data staging. You can use star schema and snowflake schema. Give details of the dimensions, aggregates, and other measures. Implement the main schema in Oracle 12c. Illustrate the applications with suitable two aggregate queries, two join queries, two-three groupings, three materialized views in Oracle. Illustrate any two applications of artificial intelligence, robotics, Internet of Things, machine learning, Hadoop or any other business analytics technique studied in the course. You should present your application with an example or illustration discussion.
