Assignment World

Assignment World logo


Home / Big Data and Analytics



Big Data and Analytics ITECH1103 will enable the students to learn about the theories and applications of Big data and demonstrate from data to decisions.

Students will also understand how to transform, visualise, model, and convey the insights buried in the data using Big data in multiple formats, data processing platforms, and data analytics tools, enabling end users with timely knowledge to support decision making.

SQL Database

1.You are to design a scenario of your choosing. This scenario will be modelled initially as an ERD, and then implemented in SQL statements. As well as creating the requisite SQL

Tables, you will need to manufacture data that is imported into these Tables. You will then be required to develop several SQL queries to provide key functionality for your database.

Analytical Report

The purpose of this task is to provide students with practical experience in working in teams to write a Data analytical report to provide useful insights, patterns and trends in the RETAILDEMO_2 dataset. This dataset is located in SAS Viya archives of datasets. This activity will give students the opportunity to show innovation and creativity in applying SAS Analytics, and designing useful visualisation and predictive solutions for various analytics problems.
Learning Outcomes

Explorer techniques, tools and applications of Big Data.
Identify the Australian Computer Society`s (ACS) Core Body of Knowledge (CBOK) and where it is represented in industry practice.
Conduct critique research and industry practice to determine your place in the spectrum of career possibilities.
Utilise Analytical tools

Guided Questions

1. GROUP TASK: Create a data dictionary for the data source for use by the group.
2. How much is marketing and marketing budget allocated to each industry ?
3. What are the top and bottom 5 cities with respect to the number of customers?
4. What is the distribution of customers by department in each country?
5. What is the distribution of customers by group chain in each country? Add animation of the Date.
6. What is the trend of transactions over months for each brand?
7. For each store chain, which is the most and least popular class?
8. What are the top and bottom 10 products ID in terms of Sales?
9. What are top and bottom 5 classes with respect to the number of transactions?
10. What is the popular brand with respect to frequency in each department in different countries?

Video Presentation

The purpose of the video presentation is to provide an opportunity for students to present the data analysis results to everyone and to share their knowledge while practising their verbal communication skills. Students should use PPT to present their findings and recommendations.
Learning Outcomes
Learn the diverse types of contemporary Big data (e.g. IoT, social data).
Communicate and present the results of the Data Analytics process.
Learn to apply Big Data Analytics technology to a real-world dataset.


The presentation must include:
An introduction of the topic and team members
The findings made from the analysis of the data including images to support these findings
The recommendations you will make in your report
A conclusion


Will you be able to complete my assignment?
Yes, we have professional experts on board who can complete your assignment smoothly.

How long will it take you to complete the assignment?
You must state the deadline at the time of making an order.

Will you be able to provide the assignment to me before the deadline?
Yes, we can, but you must specify the duration when making the order.

Is it true that some answers may require a Student ID, and that my personal information will be safe with you?
Yes, we will keep all of your personal information secure and confidential.

If my classmate also gets the assignment done with you, how will you make sure that the solution is completely different?
Our writers pay attention to detail and make every assignment from scratch ensuring originality of the work.

Will you give the Turnitin Report?
Yes, we always give Turnitin Report with the assignments and that too free of cost.

What if I need to make modifications to the work after receiving feedback from the professor?
Yes, we can make changes to the assignment based on the feedback until it meets the original standards.

What is the payment process?
We always request to make payment in advance & the writer starts working once the payment is confirmed.