Do My Assignment!

Are coursework assignment or deadlines stressing you?

We can assist you, we solve problems, answer questions and write papers for top grades

Check our clients testimonials and rest assured you’ll get a high quality, plagiarism-free paper, 100% according to your instructions and deadline!

Special offer! Get 20-30% discount on all orders - Check Coupons Section

Posted: December 7th, 2022

DE4004FP

Module Code
DE4004FP
Duration
5 hours
Copyright © ITE 2020
Module
Data Processing
Higher Nitec in Data Engineering
Assignment 1
1
Title :
Apply data transformation and merging methods to a given dataset.
Tools, Equipment and Materials:
• Personal Computer with Internet access
• Data Processing Software
Instructions & Guidelines:
1. Submissions should be made via the myConnexion by the stated
deadline.
2. No marks will be awarded, if the work is copied or you have
allowed others to copy your work.
Submission:
3. Submission should include the following items:
• Processed Excel dataset_Your name
• Microsoft Power BI file_Your name
• Data Profile.jpg
• Relationship.jpg
Module Code
DE4004FP
Duration
5 hours
Copyright © ITE 2020
Module
Data Processing
Higher Nitec in Data Engineering
Assignment 1
2
Task Requirements
Dataset:
It contains customer treadmill purchase information.
The meaning of the data columns is given in the Excel file.
List of any Excel functions can be used in this assignment:
AND
IF or CountIF
Sort
PivotTable
Pivot Table’s Calculated field
Vlookup
Provide your answers in the given Excel spreadsheet.
Part (A): Data transformation
Use Excel functions on the dataset to answer the following
questions:
(NB : If Excel function does not work, ensure the data type columns
are correct)
1. Display top 10 customers according to income and marital status
showing “Partnered” status.
2. Identify customers who have fitness level 4 and above, with a
usage level of 4 and above. Tag this group of people as
“Reward”, and, “No Reward” who does not meet these
requirements.
Sample Result:
3. Count the number of customers whose age are less than 21
years old?. ( Hint: Same method as question 2.)
Module Code
DE4004FP
Duration
5 hours
Copyright © ITE 2020
Module
Data Processing
Higher Nitec in Data Engineering
Assignment 1
3
4. Use the Figure 1 table, add on this new information in the
dataset. The new colum will show when the product is created.
Figure 1:
Sample Result:
5. Use Figure 2 table, Replace the income into astericks to hide this
sensitive data
Figure 2
Sample Result:
Module Code
DE4004FP
Duration
5 hours
Copyright © ITE 2020
Module
Data Processing
Higher Nitec in Data Engineering
Assignment 1
4
6. Use Pivot Table function, create a report which display the total
sum usage of the product by gender, marital status.
7. Use Pivot Table function, create a report which display on the
count of customers by Reward or No Reward over a list of
products.
8. Use Pivot Table function, create a report which display the list of
customers who prefer “No paperless billing”.
9. Use Pivot Table’s Calculated field function, create a report which
display gender, product and miles per usage. ( Formula miles
divided by usage)
10. Use the Pivot Table’s Calculated field function, create a report
which display a list of customer, gender is Male, Usage is 4 and
above and miles per usage.
Part (II): Tables Merging using Microsoft Power Bi
1. Load the Part 1 completed processed Excel file and
countryExcel files into Microsoft BI.
2. On countryExcel data file, ensure product column is in the
correct data format.
3. Use product column in countryExcel file, create a data profile
and screenshot the result, name it as Data Profile.jpeg
file, copy and paste it on the Part 1 Excel file.
4. In Microsoft Power BI, create new relationship tables merging
for these two datasets. Select the correct cardinality
relationship and cross filter direction. Screenshot the result,
name it as relationship.jpeg file, copy and paste it on the
Part 1 Excel file.
Module Code
DE4004FP
Duration
5 hours
Copyright © ITE 2020
Module
Data Processing
Higher Nitec in Data Engineering
Assignment 1
5
Part (III): Flowchart
1. Refer to the “Flowchart” tab in the Processed Excel file.
2. Complete the missing entry in the flowchart.
3. Save and submit these files :
• Processed Excel dataset_Your name
• Microsoft Power BI file_Your name
• Data Profile.jpg
• Relationship.jpg
– END –

Check Price Discount

Order for this Paper or Similar Assignment Help

Fill a form in 3 easy steps - less than 5 mins.

Why Opt for Custom Writing Services

You Want Quality and That’s What We Deliver

Top Essay Writers

To join our team, we choose only the best writers. They each have expertise in specific topic fields and experience in academic writing.

Affordable Prices

We offer student friendly prices while still having maintaining  the best writing standard. Compared to other writing services, our prices are fair and reasonable..

100% Plagiarism-Free

You will never receive a product that contains any plagiarism. We scan every final draft before releasing it to be delivered to a customer.

How it works

When you decide to place an order with Write my Nursing Paper, here is what happens:

Complete the Order Form

You will complete our order form, filling in all of the fields and giving us as much instructions detail as possible.

Assignment of Writer

We analyze your order and match it with a custom writer who has the unique qualifications for that subject, and he begins from scratch.

Order in Production and Delivered

You and your writer communicate directly during the process, and, once you receive the final draft, you either approve it or ask for revisions.

Giving us Feedback (and other options)

We want to know how your experience went. You can read other clients’ testimonials too. And among many options, you can choose a favorite writer.

Expert paper writers are just a few clicks away

Place an order in 3 easy steps. Takes less than 5 mins.

Calculate the price of your order

You will get a personal manager and a discount.
We'll send you the first draft for approval by at
Total price:
$0.00