Assignment 01 Instructions

Assignment-01-Instructions

Assignment-01-Instructions

User Manual:

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

DownloadAssignment-01-Instructions
Open PDF In BrowserView PDF
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.
Source Exif Data: 
File Type                       : PDF
File Type Extension             : pdf
MIME Type                       : application/pdf
PDF Version                     : 1.3
Linearized                      : No
Page Count                      : 1
Title                           : Microsoft Word - Assignment-01-Instructions.docx
Producer                        : Mac OS X 10.12.5 Quartz PDFContext
Creator                         : Word
Create Date                     : 2017:06:25 20:27:24Z
Modify Date                     : 2017:06:25 20:27:24Z
EXIF Metadata provided by EXIF.tools

Navigation menu