Scmt 4633 Kent Final

If a firm is resistant to prescriptive analytics, "Utilizing prescriptive analytics leads to taking actions" is a counter-argument to _____.

"Predictive analytics are already in place"

How many samples are required to reliably use the central limit theorem?

30

What will the calculations ABS (10 % 6) produce?

4

When data clusters are identified, which type of chart or graph can be formed?

A scatter plot

How is a table specifically for DAX measure distinguished from a table of data?

A table specifically for DAX measures shows a small calculator icon next to the table name, while a regular data table just shows up with the table icon.

What does displaying a visualization in a tool tip show?

A visual subset of another worksheet

If you want two tests to both be true, which logical operator should you use?

AND

You already have two groups for your data. What will be included in an "other" group, if you create one?

All items not currently in any group

Your data consists of values between 90 and 100, and you only want to focus on the relative differences. Which axis options would work best?

Automatic range, not including zero

How can you identify a field with a geographic role?

By the globe symbol next to the field name

ABC Corp. sells hand tools in bulk at a lower price. How can you filter your Purchases Pivot Table to show the hand tools that are available at the discounted purchase price, listed by the vendor as Bulk?

Click on the Row Labels cell, then enter Bulk in the Search box.

The Purchase Order Pivot Table has sales for 2018 and 2019, sorted in order when they were added. How can you change the order to show the products alphabetically?

Click the filter arrow to the right of Row Labels, then select Sort A to Z.

Why is it important to be cognizant of issues that color blind people would run into when designing a Power BI dashboard?

Color blind people (one variation of color blind) is that they cannot distinguish between green and red, and therefore using them as primary colors is highly discouraged in the process of creating a Power BI dashboard.

You need to import XML data as a base to your report, where do you go to get that data?

Data tab -> from Other Sources

What is the first step in the prescriptive analytics workflow?

Detect events.

If a firm's analytics timer expires for a particular hypothesis regarding a potential business interruption before the hypothesis can be proved or disproved, how should the firm respond?

Develop a plan of action that is appropriate with what is known.

Creating seperate legends allows you to____.

Distinguish between your data values

Column A of your table is Sales Region with product categories for each Region listed below. Column B is Quarterly Sales. How can you change the table to display the products in columns?

Drag Category from Rows to Columns in the Fields Area.

How can you move a sheet to a different position within a woorkbook?

Drag the sheet tab to a different location

How does employing efficient data strategies help the Power BI dashboard developer out?

Efficient data strategies allow for the user to work faster, smarter, and with fewer mistakes

Data hoarding is contrary to the purposes of prescriptive analytics.

False

Prescriptive analytics is the starting point at which an organization considers actions to be taken.

False

You have a couple of columns in your sheet that need to be separated, one of which is the customer name. Which step do you have to take to seperate the first and last names into their own column?

Hover your cursor over the "Cust name" header, and then select the down arrow and choose split.

What will happen if the user tries to append data where the names of the columns/fields do not match?

If the user tries to append data where the names of the columns/field do not match, then the columns will not append together, even if the names of the columns in the appended tables are very similar.

The Pivot Table for purchases you created was from an external data source. How can you drill down to see the data values for the individual purchase orders of packing boxes in Quarter 2?

If you double-click on the cell, a new worksheet will open and you will see the data for all your purchase orders in Quarter 2.

When you examine your data source, how is the data set organized?

In columns

How is the concept of disconnected tables an ironic name?

In order for disconnected table to work properly, the tables being used in the calculated should not be joined up at all (joined in the Access display screen)- the irony is that they will be connected via formulas but need to be physically disconnected

What is one way to take ha e day of the month, month, and year in seperate columns and combine it to create a date field?

In order to combine the day of the month, month, and year fields into a date field, first make sure that all of these fields are texts values, then create a new column that says [month] &"/"&[day of month]&"/"[year], and then make sure this new field is a dat

When writing a DAX formula using variables, in what sequence does the formula need to be set up to work?

In order to separate this string of characters into state and month, first split columns by the dash "-" character, and then by the forward slash "/" character, then keep only the month column.

Under which tab can you find the option to add a slicer?

Insert

What is a shortcoming of traditional business intelligence?

It only provides a dimensional analysis of facts

Why link Power BI data directly to an online data source?

Linking directly to an online e data source saves having to download the file, save it, and then upload it to Power Query- it is instead done in one step.

To unpivot a crosstab and show it as a list, you can

Move all column dimensions to row dimensions

Your story-telling worksheet shows Products and Purchase Price. One of your managers would like to see total units purchased by product. Which path will you have to take?

Open Pivot Table Fields, drag Total Purchases up to the Fields area, then drag Quantity down into Columns.

How do you connect to an Excel workbook, if you can, from Tableau?

Open Tableau > Connect Pannel > Excel > Select the Workbook

An example of a discrete event that must be categorized is _____.

a production line machinery failure

What analytics lead to a hypothesis that a firm will face a 10% downturn in sales the following year?

Predictive Analytics

The school basketball team consists of 12 players, and they must be ranked by how many minutes per game each of them plays. Which Excel function will rank their time in ascending order?

RANK.AVG

Which Excel function calculates the standard deviation of a sample distribution?

STDEV.S

What is a valid array name in Excel?

Sample_Name

You would like a slicer filtered by product category, but you would like the caption to read Product Category. How can you do this?

Select the Slicer, go to the Options tab, then type Product Category in the text box below Slicer Category.

Which Tableau file type stores a connection to a worksheet in another Tableau workbook?

Tableau bookmark (.tbm)

In which Microsoft programming was the DAX language first introduced?

The DAX language was first introduced in Power Pivot and the language and logic remains the same between Power BI and Power Pivot applications.

Other than creating new query steps, what other programing logic does the M language do?

The M formula language is very similar to the F sharp programing languages

When you select the Manage Metadata button, the remote field is displayed. What does this ne tell you?

The field ne from the original data source

What is one of the most important prerequisits for joining together a table of data with a lookup table?

The lookup table must join up with the table of data using g a matching field and the lookup table must have a unique ID for this field (or in other words, no duplicate values)

Which must be true to carry out complex planned comparisons?

The null hypothesis is rejected.

When you created a Pivot Table in a new worksheet, the table was blank. Why is this?

This is how a Pivot Table in a new worksheet appears.

You want to install a driver that would connect to other data sources outside of Tableau. Where would you go to install such a driver?

To the Tableau.com support page

What is the most logical way to think of DATESBETWEEN in layman's terms?

To think of DATESBETWEEN in layman's terms, first declare the date field to preform this filter functionality on, then refer to the first date when the range starts, and then the last date when the range ends.

What is end outcome of transposing a data table?

Transposing tables reflects a table of data across an imaginary axis, and then rotates the table 90 degrees counterclockwise

Both predictive and discovery analytics are used in forming hypotheses.

True

In Tableau you can add a filter action to your dashboard.

True

What is the fastest way to upload a year of data files with identical columns?

Uploading data by uploading the entire folder allows users to merge all the files together efficiently.

Which scenario is not possible with a calculated field created on a shelf?

Using it in other worksheets

Which of these is an advantage prescriptive analytics has over data warehousing and business intelligence regarding data validation?

Validation takes place simultaneously with initial actions taken as result of an event.

What happens to the row labels, column label, and data values when a table is unpivoted?

When a data table is unpivoted, the values in the row labels remain the same (however they are duplicated and often many times), and columns become their own column, and the data values become their own third column.

When the DAX measure is evaluated, what is meant by an iteration of the formula?

When evaluating a DAX measure, an iteration of the formula for that pivot coordinate means that the steps for calculating the result of the DAX measure are done and the result returned before moving on to the next pivot coordinate.

What is the value or area of caution users should be aware of when utilizing the BLANK() function?

When utilizing the BLANK() function, users should be careful that they know how to distinguish BLANK() from zeros or nulls as these can sometimes get mixed up in calculations.

How do you display the Summary Card of the visualized data in the worksheet?

Worksheet menu > Show Summary

You would like to filter your Pivot Chart from five product rows to three rows. Where do you do this, and are there any changes made to your Pivot Table?

You do this in Categories on the Pivot Chart, and your Pivot Table changes to three product rows as well.

What type of business is most likely to need a prescriptive analytics focus of "Points of Pain"?

a business with a culture of staying the course

Which term is another name for planned comparisons?

a priori comparisons

What is the first step in utilizing prescriptive analytics?

acquiring and processing data

What step must always be taken if a hypothesis is disproven?

appropriate actions must be taken regarding a problem

At what point of the workflow are hypotheses proved or disproved?

as hypotheses make their way through the clearinghouse and are routed to the appropriate facilities

Specific initial actions taken with prescriptive analytics is driven by _____.

business rules

In which action will you use a sequence of four keyboard controls to perform the action?

converting a Pivot Table to a cell range

What can be a pitfall of utilizing Big Data and analytics?

having hypotheses proven but not taking action

What is a correct sequence for writing out a conditional formulas in the query editor?

if, else if, else if, ... , else if, else.

The Excel regression tool works with which type of relationship between x and y?

linear

A graph of five athletes' track scores shows an overall improvement as the amount of trials increases, but after a while, the scores dip, due to fatigue. This single change of trend direction represents which type of equation?

quadratic

At what point in the business hypothesis clearinghouse does a "duty officer" first become involved?

recording data then handling the routing to the appropriate person or system

What step is required after analytics proves a hypothesis?

taking the actions prescribed by the analytics workflow

How can time-lags in receiving critical data be avoided?

utilizing streaming data

When working with Macros, which of the following is the correct file name extension?

xlsm

How do you create a calculated field in Tableau?

Analysis menu>create Calculated Field

Low velocity analytics tend to be volatile in nature.

False

In the instance where the user is trying to move the calculated numbers back six month because of delay from processing for example, what is the best way to do this?

In order to move the calculations back six months because of a delay in processing for example, the DATEADD functions like a filter and set up as DATEADD(date field, -6, MONTH).

What is one approach for splitting a column with the following structure into separate state and month categories? State-Date or can be written as WA-1/3/2018 where the state is Washington (abbreviation WA) and the date is January 3, 2018

In order to separate this string of characters into state and month, first split columns by the dash "-" character, and then by the forward slash "/" character, then keep only the month column.