Design a Professional Data Warehouse and Perform Data Analysis for a Retail Store

Task 1: Design and Build Data Warehouse

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.

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

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

Task 2:

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.

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.

5. Skills for Professional Practice

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.