SCMT 4633 Final
How many samples are required to reliably use the central limit theorem?
30
Which of the following is a valid base number?
2
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"
What type of business is most likely to need a prescriptive analytics focus of "Points of Pain"?
A. a business with a culture of risk-taking B. a business seeking enterprise-wide change C. a transformational business D. a business with a culture of staying the course D. a business with a culture of staying the course
How can time-lags in receiving critical data be avoided?
A. utilizing big data B. utilizing batch data C. utilizing streaming data D. utilizing always-on analytics C. utilizing streaming data
As the T.DIST.2T formula does not accept negative numbers as arguments, which additional formula should be used to calculate absolute value?
ABS
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 to the Rows shelf in this order
How do you create a calculated field in Tableau?
Analysis menu>create Calculated Field
In the Device Preview screen, what is similar between the desktop and mobile device types?
Both allow for element resizing
Which of the following built-in functions will round a number up to the next integer?
CEILING
Your Pivot Table shows Yearly Sales Dollars in columns and Products in Row A. You would like to see quarterly sales dollars. How will you do this?
Click on +/- Buttons in the Analyze contextual tab on the Ribbon, and then you can click the plus sign next to the year to show more detail.
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.
What is the keyboard shortcut to create a new worksheet in Tableau?
Ctrl+m
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
How exactly do external filters work in DAX and Power BI?
External filters in Power BI can be set up as a slicer or filter based on data in the table being filtered or can even be another table, as long as the connection (using a function like SELECTEDVALUE for example) establishes that connection.
Which Excel function transforms a correlation coefficient into a z-score?
FISHER
Data hoarding is contrary to the purposes of prescriptive analytics. (True/False)
False
Depth of data to enrich analytics is limited to adding predictive data.
False
Low velocity analytics tend to be volatile in nature.
False
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.
You are creating a Pivot Table for quarterly sales. Which advice should you keep in mind if you create a Pivot Table from a data list rather than from an Excel table?
If you add a row or a column, the change will not be added to the Pivot Table
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.
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.
Your Pivot Table shows purchases by quantity for the five products you bought from ABC Corp. in 2019. How can you see the total dollar purchases for each product?
In Insert Calculated Field, define the formula =Quantity*Unit Price, then click Okay.
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.
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)
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 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 worksheet object should you create to let a user modify a visualization filter by changing a worksheet control?
Parameter
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 programming logic does the M language do?
The M formula language is very similar to the F sharp programming language.
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.
If you set a worksheet's tab color to green, what will happen when you switch to another worksheet?
The first worksheet remains green
Which must be true to carry out complex planned comparisons?
The null hypothesis is rejected
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.
Your dashboard includes a certain worksheet. You delete this worksheet, then save the dashboard. What will happen if you then use the Revert to Saved action?
There is actually no worksheet to revert to since last save.
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.
Both predictive and discovery analytics are used in forming hypotheses. (True/False)
True
Prescriptive analytics is the starting point at which an organization considers actions to be taken. (True/False)
True
Prescriptive analytics requires a formal workflow.
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.
What is the equivalent of copying and pasting data into Power BI except not directly?
Using Power Query window to import an Excel or text file allows users to bring an Excel sheet in before editing it
What does it mean by saying that all DAX measures are calculated independently?
When DAX measures are calculated independently, this means that in a pivot table of measure calculations (for example) the calculations of the measure is not dependent on other measures or values being in the table.
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.
Can you add all subtotals to data with sets?
Yes; the subtotals will show the total of every set
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
When data clusters are identified, which type of chart or graph can be formed?
a scatter plot
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
How do pie charts display your data?
as several parts contribution to a total
Which value will not match a wildcard filter set to match on anything containing "ap"?
banana
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
Specific initial actions taken with prescriptive analytics is driven by _____.
business rules
How will Tableau calculate the median if you have a data set of 20 values?
by taking the average of the tenth and eleventh value
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
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
Creating top and bottom filters lets you _____ the largest and smallest values within a list.
isolate
Interviews and surveys are examples of _____.
method input
To unpivot a crosstab and show it as a list, you can _____.
move all column dimensions to row dimensions
If you are using the Pan feature in maps, what are you doing?
moving side to side without changing resolution
What does a correlation coefficient of -1 represent?
perfect negative correlation
Your data shows the ages and hair colors (black, blonde, or gray) of 5,000 men. How do you calculate the probability that a 30-to-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
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
Why would you use the new Tableau feature for creating calculations in dialog boxes?
to build formula-based filters to focus the data
What are Tableau stories used for?
to convey a persuasive narrative abouth the user's insights
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
Which Tableau file type stores a connection to a worksheet in another Tableau workbook?
Tableau bookmark (.tbm)
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).
After creating a new DAX measure in a table of data, how is this measure seen in the table view of Power BI
The new DAX measure shows up in the name of the column, but the fields themselves are empty.
When writing a DAX formula using variables, in what sequence does the formula need to be set up to work?
When setting up a DAX formula using variable, first declare the variables (and yes there can be many of them), and then write the function that uses the variables and return the result.
