Upgrade to remove ads
SCMT 4633 Final
Terms in this set (80)
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.
Prescriptive analytics requires a formal workflow.
What can be a pitfall of utilizing Big Data and analytics?
having hypotheses proven but not taking action
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"
At what point in using prescriptive analytics should the questions "So what?" and "Then what?" be used?
from initial data capture until the point where action is taken
Depth of data to enrich analytics is limited to adding predictive data.
Data hoarding is contrary to the purposes of prescriptive analytics.
Which of these is an event trigger?
receiving defective parts from a supplier
An example of a discrete event that must be categorized is _____.
a production line machinery failure
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
Prescriptive analytics is the starting point at which an organization considers actions to be taken.
What analytics lead to a hypothesis that a firm will face a 10% downturn in sales the following year?
How can time-lags in receiving critical data be avoided?
utilizing streaming data
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 is the first step in the prescriptive analytics workflow?
What is the first step in utilizing prescriptive analytics?
acquiring and processing data
Both predictive and discovery analytics are used in forming hypotheses.
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
Low velocity analytics tend to be volatile in nature.
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
What does a correlation coefficient of -1 represent?
perfect negative correlation
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.
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?
Select the correct macro that shows the details when clicking on a button.
Sub m_Data() Sheets("Data").Select Range("A13").Select Seletion.ShowDetail = True End Sub
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?
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
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
Which should you always avoid doing when you are defining your Pivot Tables layouts?
merging and centering cells with labels
In which action will you use a sequence of four keyboard controls to perform the action?
converting a Pivot Table to a cell range
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
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.
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.
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.
How many samples are required to reliably use the central limit theorem?
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
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 P value in a distribution?
Which Excel function transforms a correlation coefficient into a z-score?
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.
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.
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 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.
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.
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.
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.
How is the concept of disconnected tables have an ironic name?
In order for disconnected tables to correctly work, the tables being used in the calculated should not be joined up at all (joined in the Access display screen) - the irony is that the will be connected via formulas but need to be physically disconnected
What is an advantage of creating a table using a DAX formula rather than importing the table?
In creating a table using a DAX formula instead of importing the table (where this is possible), this saves potentially time consuming and potentially erroneous processes, that are often manually done.
When the month of the year changes from March to April, how does this impact the MTD, QTD, and YTD calculations that can be done using the DAX language?
MTD calculations do not matter because DAX automatically does the calculations that way.
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.
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.
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.
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 one of the distinct advantages of using Power BI over Tableau?
Power BI handles data in a much more flexible and intuitive way.
Why is the DIVIDE function an example of a conditional function?
The DAX DIVIDE function divides a numerator by a denominator, and if that result is undefined, then it returns another result defined by the user - thus not only making the formulas cleaner to read but also working around the error results.
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.
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.
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 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.
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 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.
Why would an analyst use colors to highlight data?
to communicate impartial data
Dates are correctly imported when listed as an 'Abc' Dimension.
Years can be converted from Dimensions to Measures
To filter out the first initial of a person's name, you should use _____.
To find the integer component of a division operation's result, use the _____ function.
The expression [Revenue] - AVG([Revenue]) returns an error. Within which character pair must you enclose AVG([Revenue]) to fix the error?
The EXCLUDE keyword removes a level of detail from an LOD calculation.
Which operator returns the remainder from a division operation?
A calculated field must be created to select dimensions.
Tableau 10 requires that you create a _____ and a _____ to display a single State across two separate databases.
parameter; calculated field
Reference lines can be created from _____.
You may have no more than three ELSEIF conditions within an IF...THEN statement.
Continuous data charts require at least one blue pill.
To return a zero if a calculation returns a null value, use the _____ function.
What is the central purpose of a Tableau filter?
include or exclude data from a view
To divide a string into parts based on the occurrence of a specific character, use the _____ function.
Source sheets filter the actions of Target sheets.
Custom territories is one of the new features of Tableau 10.
Tooltips allow you to _____.
All of the above
Floating legends allow for customized dashboard sizes.
OTHER SETS BY THIS CREATOR
remko exam 3
SCMT final exam
SCMT exam 2
OTHER QUIZLET SETS
toxicologie générale : chapitre 4
Property II: Final Exam
questões de educação permanente em Saúde na Aps en…
KC 5/6 Review- APUSH