CS7079 Data Warehousing and Big Data

CS7079 Data Warehousing and Big Data

Academic year 2022/2023 Autumn Term

CS7079 Data Warehousing and Big Data

The aim of this coursework is to design, implement, and test a data warehouse based on a given business case scenario, to export data from it and ingest it for further processing on a Big Data platform. It is individual coursework. The coursework contributes 60% to the overall CS7079 module mark.

Coursework Deadlines:

  • Group Work needs to be submitted Friday of Teaching Week 6.
  • Individual Report needs to be submitted Friday of Teaching Week 12.

Late submission will be penalised according to the University regulation.

Coursework Specification:

CASE STUDY SCENARIO: ABC Consumer Electronics Outlet Ltd.

ABC Consumer electronics Outlet Ltd is a multi-channel retailer of consumer electronics, which was founded in 1986. It operates from six stores located in and around London. It also conducts online business across UK and Europe. Currently, the company offers more than ten thousand products organised in about ten categories and in more than 200 brands. These figures are a snap shot at a time. The number of products varies continuously as new product lines are introduced and old products are discontinued.

Consumer electronics retail industry is very dynamic and competitive. Retailers are always under huge pressure to invest in new information and communication technologies to gain competitive advantages and optimise business processes.

ABC Consumer Electronics Outlet Ltd has already invested in information and communication technologies to support its business processes. The company is using a cloud based software called Vend to support many of its retail activities. It is also using Linnworks to automate its online business and Xerox to support its finance department. These software applications are generating a huge transactional data every day. The generated datasets are stored and managed separately by each software application.

Managers at ABC Consumer electronics Retail Company are struggling to produce reports and perform analysis that would enable them to provide information for their decision-making activities. That is why a business analyst recommended to the company to design and implement a data warehouse that will meet all reporting and analysis requirements.

The business analyst team has conducted business requirements gathering and produced a business requirements document. The description, reporting and analysis requirements of only one business area are presented below. The data warehousing solution will focus only on inventory management business process.

Inventory Management:

Inventory management is one of the most important business processes of a company. Its main goal is to produce a good purchase order plan to ensure that product items are available when they are needed. Currently, the company is facing problems in controlling over-stocks and under-stocks of product items. Reducing over-stocks and under-stocks will have a big role in increasing revenue and customer satisfaction.

There are three main business activities:

  1. Sending purchase orders to suppliers when there are product items with minimum levels of inventory. For each sent purchase order, the ordered quantity, sent date, product and supplier details are recorded.
  • Receiving purchase orders and storing stocks in appropriate locations. For each received purchase order, the ordered quantity, received quantity, received date, product and supplier details are recorded.
  • Controlling and maintaining stocks which involves adding new products and adjusting stock levels of existing products. The details of each product are recorded including the current stock level.

Managers responsible for managing inventory are demanding to meet the following reporting and analysis requirements:

  • A daily stock levels of all products for the last month.
    • A weekly report of all products with minimum stock levels.
    • Analysing stock levels by brand or product type or supplier
    • Daily and weekly sent and received stock orders for the last four weeks.
    • Analysing received stock orders by supplier and by month.

Description of Data Sources:

As mentioned in the above, ABC Consumer Electronics Outlet Ltd depends on various software applications such as Vend, Linnworks, and Xerox to support its daily business activities. For this coursework, only data source from Vend is considered. The data source includes supplier details, product details and details about stock movements from suppliers to warehouse location. A sample of data will be provided either as flat files or relational tables. It is part of your task to understand the structure of suppliers, products, and stock movements.

PART A – Group Work:

  1. Analysis & Design of Dimensional Data Model
  1. Identify and define the grain (detail level) of three different central fact tables to represent the three main business activities of the inventory management business area.                                                          (10 Marks)
  1. Identify dimensions of each central fact table based on the available data source that will meet the reporting and analysis requirements mentioned in the business case scenario.                                                            (10 Marks)
  1. Identify attributes of dimensions and measures of fact tables based on the available data source descriptions that will meet the reporting and analysis requirements mentioned in the business case scenario. . (10 Marks)
  1. Use simple star schema to define the structure that shows how the fact tables are related to their dimensions. Create a graphical representation of the four simple star schemas in one page.                                 (10 Marks)

PART B – Individual Work: Continues on Part A; the final report has to include Part A and Part B together.

2.     Create a Relational Database to store dimensions and fact tables using Microsoft SQL Server Management Studio.

  • Create a database.                                                                    (5 Marks)
  • Create dimension tables                                                          (5 Marks)
  • Create fact tables.                                                                    (5 Marks)
  • Add appropriate primary keys and foreign keys constraints. (5 Marks)

3.     Migrate test data from the data warehouse to an Apache Hadoop platform for further analysis of Big Data using Hortonworks Data Platform (HDP)

  • Populate the data warehouse database with some test data.

(5 Marks)

  • Export the data warehouse database data into an external data file.

(5 Marks)

  • Migrate the data file from the file system to Apache HDFS.

(5 Marks)

  • Create a suitable data structure for loading the data file into HIVE

(5 Marks)

  • Demonstrate the use of Apache Pig for manipulating the loaded data

(5 Marks)

  • Written Report

The report, which you will submit, should be well written, structured and well- presented and it must include:

  • An introduction section that summarise the objectives of the course work and business case scenario.                                     (3 Marks)
  • The Analysis and design of a dimension data model.    (3 Marks)
  • The implementation and testing of the data warehouse (include screen shots to show SQL commands and their results).          (3 Marks)
  • The implementation and testing of the BigData storage on HDFS (including the Pig commands and their results).            (3 Marks)
  • Provide a personal reflective conclusion of what you have learnt from your overall coursework.                                                (3 Marks)
Order Now

Get expert help for CS7079 Data Warehousing and Big Data and many more. 24X7 help, plag free solution. Order online now!

Universal Assignment (November 21, 2026) CS7079 Data Warehousing and Big Data. Retrieved from https://universalassignment.com/cs7079-data-warehousing-and-big-data/.
"CS7079 Data Warehousing and Big Data." Universal Assignment - November 21, 2026, https://universalassignment.com/cs7079-data-warehousing-and-big-data/
Universal Assignment July 22, 2023 CS7079 Data Warehousing and Big Data., viewed November 21, 2026,<https://universalassignment.com/cs7079-data-warehousing-and-big-data/>
Universal Assignment - CS7079 Data Warehousing and Big Data. [Internet]. [Accessed November 21, 2026]. Available from: https://universalassignment.com/cs7079-data-warehousing-and-big-data/
"CS7079 Data Warehousing and Big Data." Universal Assignment - Accessed November 21, 2026. https://universalassignment.com/cs7079-data-warehousing-and-big-data/
"CS7079 Data Warehousing and Big Data." Universal Assignment [Online]. Available: https://universalassignment.com/cs7079-data-warehousing-and-big-data/. [Accessed: November 21, 2026]

Please note along with our service, we will provide you with the following deliverables:

Please do not hesitate to put forward any queries regarding the service provision.

We look forward to having you on board with us.

Most Frequent Questions & Answers

Universal Assignment Services is the best place to get help in your all kind of assignment help. We have 172+ experts available, who can help you to get HD+ grades. We also provide Free Plag report, Free Revisions,Best Price in the industry guaranteed.

We provide all kinds of assignmednt help, Report writing, Essay Writing, Dissertations, Thesis writing, Research Proposal, Research Report, Home work help, Question Answers help, Case studies, mathematical and Statistical tasks, Website development, Android application, Resume/CV writing, SOP(Statement of Purpose) Writing, Blog/Article, Poster making and so on.

We are available round the clock, 24X7, 365 days. You can appach us to our Whatsapp number +1 (613)778 8542 or email to info@universalassignment.com . We provide Free revision policy, if you need and revisions to be done on the task, we will do the same for you as soon as possible.

We provide services mainly to all major institutes and Universities in Australia, Canada, China, Malaysia, India, South Africa, New Zealand, Singapore, the United Arab Emirates, the United Kingdom, and the United States.

We provide lucrative discounts from 28% to 70% as per the wordcount, Technicality, Deadline and the number of your previous assignments done with us.

After your assignment request our team will check and update you the best suitable service for you alongwith the charges for the task. After confirmation and payment team will start the work and provide the task as per the deadline.

Yes, we will provide Plagirism free task and a free turnitin report along with the task without any extra cost.

No, if the main requirement is same, you don’t have to pay any additional amount. But it there is a additional requirement, then you have to pay the balance amount in order to get the revised solution.

The Fees are as minimum as $10 per page(1 page=250 words) and in case of a big task, we provide huge discounts.

We accept all the major Credit and Debit Cards for the payment. We do accept Paypal also.

Popular Assignments

Assignment Help Online – Get Expert Academic Support for Better Results

Completing academic assignments can be challenging, especially when students have multiple deadlines, difficult subjects, and limited time. From writing essays to preparing research papers, every academic task requires proper planning, research, and writing skills. If you are finding it difficult to manage your academic workload, assignment help online can provide

Read More »

Assignment Writing Help – Get Professional Academic Writing Support

Writing assignments is an important part of college and university life. Students are expected to complete essays, reports, research papers, case studies, and other academic tasks while following specific guidelines and deadlines. However, writing a good assignment is not always easy. It requires proper research, clear explanations, correct grammar, and

Read More »

Online Assignment Help – Get Reliable Academic Support Anytime

Students today have to manage multiple academic responsibilities, including assignments, exams, research projects, and personal commitments. Completing every task on time while maintaining good academic quality can be difficult. This is where online assignment help becomes useful. It gives students access to academic guidance, subject experts, and writing support from

Read More »

Assignment Help – Get Expert Academic Support Online

Managing multiple academic tasks, meeting deadlines, and preparing quality assignments can be challenging for students. Whether you are studying at a college or university, every assignment requires proper research, clear writing, and a good understanding of the subject. If you are struggling to manage your academic workload, professional assignment help

Read More »

Developing Asia-Pacific Nations Assignment Help

A Survey Assessment 1  Assessment Overview A survey of key features of strategies used by chosen developing Asia-Pacific nations.    1000-1250 words  30% Session 3 Developing Asia-Pacific Nations Assignment Help  Details Choose a middle or upper income country in Asia or Pacific. Examine from the UNDP’s HDI index  between the years 2000 and 2018 for the chosen

Read More »

Academic / Assignment Report Help

Appendix A Part 3 Academic / Assignment Report Help DEFINITIONS OF ELEMENTS PRELIMINARIES PR PRELIMINARIES It INCLUDES preliminary items as defined in Section 2 of the Australian Standard Method of Measurement of Building Works (5th Edition), where ascertainable. SUBSTRUCTURE SB SUBSTRUCTURE – The structurally sound and watertight base upon which

Read More »

Marketing a property for lease: Assignment Help

Points to note: Marketing a property for lease: Assignment Help Task 1: Prepare a marketing plan In this part of your Workplace Project, you are to prepare a marketing plan for a property for lease. You must use the template provided to create your marketing plan. Your marketing plan must

Read More »

Academic & Formal Assignment Help

 Assessment Overview This assessment involves writing a reflective journal capturing your learning experience as you carry out assigned tasks and roles. It is not just a record of what you do at the workplace, but a discussion of skills, practices, and tools you have learned in relation to the learning

Read More »

Science Communication Blog Post Assignment Help

Your TaskAssessment 4 (the end-of-semester assignment) assesses concepts from across Weeks 1 to 12. Throughout these weekly modules, you have completed individual tasks and collaboratively explored (on Ed Discussion) the process and methods of science. These activities will help prepare you to complete the end-of-semester assignment below. Purpose 🎯In this

Read More »

Planning and Learning in Early Childhood Education Assignment Help

Planning and Learning in Early Childhood Education Assignment Help Here is the combined text transcribed from the two screenshots of Assessment 1, arranged in reading order from top to bottom: 1. Assessment 1 Overview Programming (40%) (1500 words) Step 1: Designing your learning experiencesFor this assessment task, you will use

Read More »

Learning Development Presentation Assignment Help

1. Assessment 2 Overview Individual/Group Presentation (30%) (10 min/1500 words). Due: Week Learning Development Presentation Assignment Help Individually or as a small group (2 or 3 participants) imagine you have been asked to present an professional development session to your colleagues in an Early Childhood Service on the EYLFV2.0 assessment

Read More »

Critical Evaluation of Mental Health

Assessment Brief: Subject: Mental Health in Practice Assessment Task: Critical evaluation of an AI-generated supportive conversation script – Written critique Length 2500 words (+/- 10) Appendix: Screenshot Generative AI script (not included in the word count) Due date: 06/11/2026 @8pm Melbourne Time Assessment Task In this assessment, you will create

Read More »

The Climate Crisis in Asia: Who Pays the Price? Assignment Help

A response to debatable and controversial socio-cultural, political and environmental issues confronting a specific country or countries in Asia or the Pacific.  5–8-minute presentation with supporting resources including: Part A) an interactive poster and Part B) an individual report (500 words) Part A 25%Part B 10% 35% Session 7 & 9  Details Choose

Read More »

ATC401A Advanced Therapeutic Communication Assignment Help

ATC401_Assessment 3_15072026 Page 1 ofASSESSMENT 3 BRIEF Subject Code and TitleATC401 Advanced Therapeutic Communication AssessmentCase Study (Report) Individual/GroupIndividual Length2500 +/- 10% Learning OutcomesThe Subject Learning Outcomes demonstrated by successful completion of the task below include:SLO b), SLO e), SLO f) SubmissionDue by 11:55pm AEST Sunday end of Module 11 (Week

Read More »

ATC401A Advanced Therapeutic Communication Assignment Help

ATC401A Advanced Therapeutic Communication Assignment Help ATC401_Assessment 3_15072026 Page 1 ofASSESSMENT 3 BRIEF Subject Code and TitleATC401 Advanced Therapeutic Communication AssessmentCase Study (Report) Individual/GroupIndividual Length2500 +/- 10% Learning OutcomesThe Subject Learning Outcomes demonstrated by successful completion of the task below include:SLO b), SLO e), SLO f) SubmissionDue by 11:55pm AEST

Read More »

ATC401A Advanced Therapeutic Communication Assignment Help

ATC401_Assessment 2_20240603 Page 1 of 10ASSESSMENT 2 BRIEF Subject Code and TitleATC401A Advanced Therapeutic Communication AssessmentReflective Journal Individual/GroupIndividual Length2000 words +/- 10% Learning OutcomesThe Subject Learning Outcomes demonstrated by successful completion of the task below include: SLO a), SLO b), SLO c), SLO d), SLO e) SubmissionDue by 11:55pm AEST

Read More »

ATC401 Advanced Therapeutic Communication Assignment Help

ATC401_Assessment_1_ DueModule_6_17062026 Page 1 of 9three ASSESSMENT 1 BRIEF Subject Code and TitleATC401 Advanced Therapeutic Communication AssessmentDemonstration and Reflection Individual/GroupIndividual Length5 minutes and 500 words +/- 10% Learning OutcomesThe Subject Learning Outcomes demonstrated by successful completion of the task below include:SLO a), SLO b), SLO c), SLO d) SubmissionDue by

Read More »

Laura Medical Case Study Assignment Help

Laura Ash, 65 years old, was brought by her son, Jack, a 40-year-old gentleman, to the local ED at 23:00 hrs. Jack described his mom to the ED nurses as having abdominal pain this morning. Still, the pain progressively worsened throughout the day, even though she took two tablets of

Read More »

 HOS302 Managing Customer Experience and Ethical Practice Assignment help

 HOS302 Managing Customer Experience and Ethical Practice  Assessment 1 – Individual Assessment: Guest Experience  Submission Deadline: Sunday, XX November XXXX, at 11:59 pm (Week 5)  Assessment Weighting: 25%  Overview of this Assignment  Students will describe a recent customer experience they have had in the hospitality sector and identify strategies for

Read More »

Preschool Weekly Curriculum Plan Assignment Help

Learning Intentions – Individual child Interest/Group Interests/Short term goals for learning/Long term goals for learning Link to Service Philosophy and EYLF Learning Outcomes/ Teacher Standards/UN Convention on the Rights of the Child. 1. 2. 3.     (Include link to EYLF outcomes that reflect this week’s learning intentions and/or the

Read More »
Discursive Writing Essay:
Uncategorized
prashantsinha567@gmail.com

Discursive Writing Essay: Complete Guide to Structure, Format & Tips

Introduction Discursive writing is a form of academic writing that explores an issue from different perspectives before reaching a balanced and reasoned conclusion. A discursive essay does not simply tell the reader what the writer believes. Instead, it examines relevant viewpoints, considers supporting evidence, acknowledges opposing ideas, and evaluates the

Read More »

Assessment 1

Helpful Tools for ReflectionDuring the reflective journal process, you may wish to use these helpful templates and decision wheel tools to consolidate thoughts and ideas.Regardless of which framework is chosen, all areas of reflection are to be attempted to complete the full reflective cycle. It is important that any template,

Read More »

Can't Find Your Assignment?