SCMT 4633 Quiz Questions
If a firm is resistant to prescriptive analytics, "utilizing prescriptive analytics leads to taking actions" is a counter-argument to ___________.
"prescriptive analytics are already in place"
As the T.DIST.2T formula does not accept negative numbers as arguments, which additional formula should be used to calculate absolute value?
ABS
If you want two tests to both be true, which logical operator should you use?
AND
Compared to doing calculations with dates in Excel, why is the DATEDIFF function in DAX helpful?
In Excel, dates are stored as number values, but in DAX they are stored as actual dates thus DATEDIFF allows us to figure out the days between two dates for example.
How do you create a calculated field in Tableau?
Analysis Menu > Create Calculated Field
Mo has some irregular formatting within his data. What can he use to clean up his source data?
Data Interpreter
T/F: Prescriptive analytics is the starting point at which an organization considers actions to be taken.
FALSE
When creating calculated column that combines the values in two columns, how does this fit the ideal data setup?
Creating a calculated column and eliminating the two columns added together that this data comes from creates a tall vertical table of data.
T/F: depth of data to enrich analytics is limited to adding predictive data.
FALSE
What is one of the prerequisites for making the fill up or fill down function work?
In order for the fill-up or down functionality to work, the blank rows in the column to be filled must be null values.
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.
When unsure of how to set up a dynamic measure, what is the best course of action to take to set one up?
In order to set up a dynamic measure, first set up two measures that we want to calculate, then set up an IF statement that says if one option is chosen (need to create a slicer for this) then return the first measure, otherwise return the second measure
Which Excel function is used to determine the natural logarithm of a number?
LN
What is the most efficient way to get SQL data in Power Query?
Linking directly to an SQL database saves having to run query, save file, and then upload it to Power Query - instead done in one step.
If you want to know the scale your map is showing, which option should you choose?
Map options
How does the query editor work like a programming language?
The query editor is backed by the M formula language, which according to Microsoft is very similar to the F sharp programming language.
What is one of the distinct advantages of using Power BI over Tableau?
Power BI handles data in a much more flexible and intuitive way.
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
Your Pivot Table has sales by product in Rows B7 through G7, with 2017 in Row A6. How can you view sales by month?
drag Date of Purchase into rows in the fields list area
Which Excel function calculates the standard deviation of a sample distribution?
STDEV.S
When you are making filter selections in the rows of your Pivot Table, what does a solid square box in Select All tell you?
Some, but not all, of the rows have been selected in your filter.
What is an example of a Monte Carlo situation?
flipping a coin
Select the correct macro that shows the details when clicking a button.
Sub m_Data() Sheets ("Data").SelectRange("A13"). SelectSeletion.ShowDetail = True End Sub
T/F: A limitation of Tableau is that if it does not recognize a location in a visualization it won't be able to map it, so you need to make sure that your data can be mapped
TRUE
T/F: Both predictive and discovery analytics are used in forming hypotheses.
TRUE
T/F: prescriptive analytics requires a formal workflow.
TRUE
Which Tableau product can you use to clean and prepare data?
Tableau Prep
What is the most helpful way to think of how to leverage the ALL function?
The ALL function can be leveraged and thought of a function that literally clears all the filters already applied in the formula or the tabular pivot table (for example).
When adding filters to a function like CALCULATE, why would the FILTER function need to be used instead of simply writing out the filters?
The FILTER functionality needs to be used in filters that operate a certain way, like FILTER that references a measure or a FILTER that references another table.
When developing a Power BI Pro dashboard, where is the best place to initially develop the dashboard?
The best way to create a dashboard in Power BI is to first develop the dashboard in Power BI Desktop and then upload this fully developed dashboard into Power BI Pro.
What is one of the most important prerequisites for joining together a table of data with a lookup table?
The lookup table must join up with the table of data using a matching field and the lookup table must have a unique ID for this field (or in other words no duplicate values).
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
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 perform 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 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.
If you are using the Pan feature in maps, what are you doing?
moving side to side without changing resolution
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 more 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
An example of a discrete event that must be categorized is ______________.
a production line machinery failure
What does the Excel function RAND generate?
a random number between 0 and 1
You want the rows in your dashboard to show fields A, B, and C, in this order. How should you arrange them>
add fields A, B, and C in the Rows shelf in this order
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
Why would you create a custom list to sort products in a Pivot Table?
because it is quicker and safer than manually sorting the products
You are interested in seeing the contribution of each of your five products to the total yearly sales over the past three years; how can you do this?
by selecting % of Grand Total under Show Values as in Value Fields Settings
How do histograms summarize data?
by using a vertical bar chart
When we are creating the data flow, what is the step after Import?
clean up
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
An insurance company has a set of data showing the number of claims paid per year from 1950 to 2015. Which Excel tool should be used to predict future events based on this historical data?
forecast sheet
At what point in using prescriptive analytics should the question "so what?" and "then what?" be used?
from initial data capture until the point where action is taken
What can be a pitfall of utilizing Big Data and analytics?
having hypotheses proven but not taking action
Pablo is comparing data on bottles and cases. What is he doing that is highlighting the Bottle section in a yellow color?
he is choosing to do the computation using Pane
You have a set of test scores with values ranging from 1 to 100, and want to plot the scores in 5 intervals of 20 points each. Which Excel chart should you use?
histogram
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
If you created a packaged workbook and want to share it with others who do not have the full version of Tableau, where can they view it?
in the Tableau Viewer
You have a data set of six values but want to show more. Which parameter do you need to change in order to display additional values?
increase the maximum range of values
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
The Excel regression tool works with which type of relationship between x and y?
linear
Which model should be used to describe a relationship where a multiplicative change in x will result in an additive change in y?
logarithmic regression
If you want to change the summary operation, what should you select from the menu that appears when you click the down arrow of a field positioned on a shelf?
measure
Which of the following data sources does Tableau allow you to connect to?
open data server text files Excel All of the answers
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.
What worksheet object should you create to let a user modify a visualization filter by changing a worksheet control?
parameter
Which statistical method is used to remove the associate of two variables with a third variable, to determine the true correlation between the first two variables?
partial correlation
What analytics lead to a hypothesis that a firm will face a 10% downturn in sales the following year?
predictive analytics
Your data shows the ages and hair colors (black, blonde, or gray) of 5,000 men. How do you calculate the probability that a 40-year-old man will have black hair?
probability of the age range times the probability of black hair
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
Which of these is an event trigger?
receiving defective parts from a supplier
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
How can you start to edit or remove an existing reference line?
right click the vertical axis
What step is required after analytics proves a hypothesis?
taking the actions prescribed by the analytics workflow
To create a calculated field, which menu do you use?
the analysis menu
What are line charts best used for in Tableau?
to analyze trends of time that data sets reveal
Where are the buttons located?
under the Developer tab
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 take as result of an event
When is saving your workbook as a PDF file beneficial?
when you want to send your documents but not have any interaction
When working with Macros, which of the following is the correct file name extention?
xlsm
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.
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.
T/F: Data hoarding is contrary to the purposes of prescriptive analytics.
FALSE
T/F: low velocity analytics tend to be volatile in nature.
FALSE
Why link Power BI data directly to an online data source?
Linking directly to an online data source saves having to download the file, save it, and then upload it to Power Query - it is instead done in one step.
How does Microsoft push out the Power BI Desktop updates?
Microsoft updates Power BI Desktop through free upgrades available for the Desktop application roughly every month.
What is the end outcome of transposing a data table?
Transposing tables reflects a table of data across an imaginary axis, and then rotate the table 90 degrees counterclockwise.
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.
You can convert a regular column chart to a stacked column chart by ____________.
adding a category for the color mark