You are asked to produce a Prism data source, which is going to be used in a matrix report that should display the minimum, maximum, total, average, and the median purchase order amount by location and month. What should you do to achieve the desired result?
Using three different source files, you want to load rows of data into an empty table through a Data Change task. What needs to be the same about the three source files?
You have to blend two sources of data. Your matching field is Employee ID, which is a text-type field in Pipeline 1, but is numeric in Pipeline 2. How do you prepare your data for blending?
You want to import a Workday custom report into the data catalog. You have already enabled it as a web service and enabled it for Prism Analytics. What other configuration is required?
