Assignment 01 Instructions

Assignment-01-Instructions

Assignment-01-Instructions

User Manual:

Open the PDF directly: View PDF .
Page Count: 1

The following tasks should be fulfilled by you:

a) Connect Power BI to the attached source files using the

New Source

function in the

QueryEditor

b) Turn the first row in both queries into the column names

c) Delete blank rows and filter rows which include values named XX in the two queries

d) Create a new query named

Apple-Combined

. This query should be a combination of the

two initial queries

Hint: Remember how to merge and append queries. You will need one of those functions

e) Delete unrequired columns in the newly created query. The only remaining columns

should be:

Date

,

Open

and

Close

f) Rename the remaining columns as follows:

a. Date: No change necessary

b. Open:

Price-Start of day

c. Close:

Price-End of day

g) Format the data according to the content of the corresponding columns.

Hint: You may need Date/Time as one formatting type

h) Create a new table named

Weekdays

. This table should include two columns:

a. Column 1 should be named

Weekday-Nr

and include seven rows with the

following values:

1, 2, 3, ..., 7

b. Column 2 should be named

Weekday-Name

and include seven rows with the

following values:

1 Monday, 2 Tuesday, 3 Wednesday, ..., 7 Sunday

Hint: Remember the Enter Data function in the QueryEditor

i) Disable the "Enable load" function for the two initial queries. "Enable load" should only

be allowed for the

Apple-Combined

and the

Weekdays

queries.

j) Load the queries into the data model.

I hope you enjoy this assignment. See you in the solution video.