Assignment 02 Instructionsx Instructions

Assignment-02-Instructions

User Manual:

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

DownloadAssignment-02-Instructionsx Assignment-02-Instructions
Open PDF In BrowserView PDF
The following tasks should be fulfilled by you:
a) Disable “Auto Date/Time” in the options to prevent automatic date formatting. You can
find the option as shown in lecture 12 (https://www.udemy.com/powerbi-completeintroduction/learn/v4/t/lecture/7036512?start=95) => Just untick the box below “Time
intelligence”
b) Open the Query Editor and use the advanced editor to connect Power BI to the source
files. You learned how to do this in the first module
c) Go back to the data model and open the data view to create a new table. In this table,
create a calendar (the name of the formula should also be Calendar) for the period we
have stock data for (04. January 2010 until 11. May 2017). With that, a column named
Date should be created automatically
Hint: Remember the calendar function we learned and use the modeling ribbon
d) Format the calendar. Only the date should be visible in the columns (no weekday)
e) With the calendar being formatted, we can turn “Auto Date/Time” back on again (see
point a) => Tick the box below “Time intelligence”
f) Create a new column named Year: This column should retrieve the corresponding year
out of the column Date in the Calendar table
g) Create a new column named Quarter: This column should retrieve the corresponding
quarter out of the column Date in the Calendar table
h) Create a new column named Year-Quarter: In this column, you should combine the
column Year and the column Quarter with a space in between (i.e. the result should look
like this: 2010 Qtr. 1)
Hint: Remember the Concatenate formula we learned
i) Create a new column named Weekday-Nr which should retrieve the corresponding
number of the weekday of the column Date in the Calendar table
Hint: We didn't talk about that specific formula. But if you take a look at the official
documentation, you should be able to create this column: Also make sure that the
weeks are numbered as follows: 1 = Monday, 2 = Tuesday, 3 = Wednesday and so on:
https://msdn.microsoft.com/en-us/library/ee634550.aspx
j) Go to the relationship view and create a 1:1 (one to one) relationship between the
columns Date in the tables Apple-Combined and Calendar
k) Create a *:1 (many to one) relationship between the columns Weekday-Nr in the tables
Calendar and Weekdays
l) Go back to the data view and open the Apple-Combined table. Create a calculated
column named End-vs-Start which calculates the % change (also formatted as %)
between the column Price-End of day and the column Price-Start of day
Hint: We learned how to divide the values of two columns and how to format columns
m) Create a measure named Measure-AveragePrice-End, which calculates the average of
the values in the column Price-End of day
n) Create two measures named Measure-MinimumPrice and Measure-MaximumPrice
which calculate the minimum/maximum value of the column Price-End of day
Have fun in the data model and see you in the solution video.



Source Exif Data:
File Type                       : PDF
File Type Extension             : pdf
MIME Type                       : application/pdf
PDF Version                     : 1.6
Linearized                      : Yes
Author                          : Manuel Lorenz
Create Date                     : 2019:03:18 15:10:22+01:00
Modify Date                     : 2019:03:18 15:10:22+01:00
XMP Toolkit                     : Adobe XMP Core 5.6-c016 91.163616, 2018/10/29-16:58:49
Creator Tool                    : PScript5.dll Version 5.2.2
Producer                        : Acrobat Distiller 19.0 (Windows)
Format                          : application/pdf
Title                           : Microsoft Word - Assignment-02-Instructions.docx
Creator                         : Manuel Lorenz
Document ID                     : uuid:3ad54a46-98e0-42b4-a552-60a6049a02df
Instance ID                     : uuid:85361f68-1032-46dc-8ea8-1b23d97279ed
Page Count                      : 1
EXIF Metadata provided by EXIF.tools

Navigation menu