Design and Build a Data Warehouse for a Retail Store

In the main body of your submission you must give credit to authors on whose research your work is based. Append to your submission a reference list that indicates the books, articles, etc. that you have read or quoted in order to complete this assignment (e.g. for books: surname of author and initials, year of publication, title of book, edition, publisher: place of publication)

Design, build and professionally document a small data warehouse suitable for use with Big Data

· Professional document describing the Star or Snowflake schema for the retail store. Report justifying the tools used to work in the assignment.

· Successfully extract the retail store data and perform data analysis.

2. Perform data analysis and reporting on complex data within a Big Data warehouse

3. Demonstrate a creative use of appropriate data mining and data visualisation techniques within

a Big Data context. Apply appropriate data mining concepts and generate reports.

Design and produce professional-standard reports based upon an example Big Data, data warehouse using appropriate tools and techniques. Select and apply appropriate data mining processes to Big Data within a given problem domain and produce effective visualisations of the results.

Problem Domain: A retail store which has many branches all over the country wanted to implement a data warehouse to keep track of their sales.

· Design and develop an appropriate data warehouse structure. You should justify all of your design decisions.

· Upload the data into your data warehouse, documenting the ETL process in a professional manner.

· Design, develop and critically evaluate reports that can be run to retrieve and display the following data:

The most popular products based on number of orders.

Sales details of each store

Most potential customers

Two or more business intelligence report of your choice

Write 1500 words report discuss the nature of the data that retail industry will handle. Recommend, whether your choice of selected retail store needs big data analytics. Justify your decision. Include what characteristics you have considered in your decision making and problems and challenges involved. Submission Requirements:

A word document or PDF file to support your documentation.

Create a folder, name it as ACUA6002_Studentid. Copy your database dump, dataset and visualisation reports into your assignment folder. Zip it and upload it on Moodle. If file size is too big to fit in, submit it in a pen drive to the Exams Office before the deadline.

1. Research-informed Literature

Extent of research and/or own reading, selection of credible sources, application of appropriate referencing conventions. Submit a professional document for a data warehouse schema design. Justify your choice of tools to build the data warehouse and ETL process.

2. Knowledge and Understanding of Subject

Exhibiting knowledge and understanding of concepts and underlying principles associated with the discipline. How efficiently the tools were used.

3. Analysis

Analysis, evaluation and synthesis; logic, argument and judgement; analytical reflection; organisation of ideas and evidence Choice of appropriate data warehouse design and choice of the tools to work on this task.

4. Practical Application and Deployment

Deployment of methods, materials, tools and techniques; application of concepts; formulation of innovative and creative solutions to solve problems. Successfully build a DW and process the data to produce the reports.

Attributes in professional practice: individual and collaborative working; deployment of appropriate media; presentation and organisation.

1. Research-informed Literature

Extent of research and/or own reading, selection of credible sources, application of appropriate referencing conventions.

2. Knowledge and Understanding of Subject

Extent of knowledge and understanding of concepts and underlying principles associated with the discipline.

3. Analysis

Analysis, evaluation and synthesis; logic, argument and judgement; analytical reflection; organisation of ideas and evidence.

4. Practical Application and Deployment

Deployment of methods, materials, tools and techniques; application of concepts; formulation of innovative and creative solutions to solve problems.

5. Skills for Professional Practice

Attributes in professional practice: individual and collaborative working; deployment of appropriate media; presentation and organisation.