SCMT 4633- Kent Final
What is the fastest way to upload a year of data files with identical columns?
B. Uploading data by uploading the entire folder allows users to merge all the files together efficiently.
What happens to the row labels, column label, and data values when a table is unpivoted?
B. 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.
What is the end outcome of transposing a data table?
D. Transposing tables reflects a table of data across an imaginary axis, and then rotate the table 90 degrees counterclockwise.
When are scatter plots typically used?
when you have two numerical measures
To create a calculated field, which menu do you use?
the Analysis menu
Which of the following is a valid base number?
2
How many samples are required to reliably use the central limit theorem?
30
Both predictive and discovery analytics are used in forming hypotheses.
true
What will the calculation ABS(10 % 6) produce?
4
How does a DAX measure filter compared to actually manually filtering data?
A. A filter in DAX works on a data table, not as a calculation, but simply as a filter that in layman's terms goes through the data row by row to determine if row should be included in the calculation later because criteria is met.
How do you calculate the percentage that each cell in a column contributes to the whole?
Analysis menu > Percentage of > Column
When creating calculated column that combines the values in two columns, how does this fit the ideal data setup?
B. Creating a calculated column and eliminating the two columns added together that this data comes from creates a tall vertical table of data.
What will happen if the user tries to append data where the names of the columns/fields do not match?
B. 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.
What is one way to take have day of the month, month, and year in separate columns and combine it to create a date field?
B. In order to combine the day of the month, month, and year fields into a date field, first make sure that all these fields are text values, then create a new column that says [month]&"/"&[day of month]&"/"&[year], and then make sure this new field is a dat
After creating a new DAX measure in a table of data, how is this measure seen in the table view of Power BI
B. The new DAX measure shows up in the name of the column, but the fields themselves are empty.
What is one of the prerequisites for making the fill up or fill down function work
C. 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?
C. 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).
How does the query editor work like a programming language?
C. The query editor is backed by the M formula language, which according to Microsoft is very similar to the F sharp programming language.
What does it mean by saying that all DAX measures are calculated independently?
C. 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.
Which Excel function calculates the P value in a distribution?
CHISQ.TEST
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 save a file in Tableau?
Ctrl+s
How is a table specifically for DAX measure distinguished from a table of data?
D. 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 is the most efficient way to get SQL data in Power Query?
D. 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.
When adding filters to a function like CALCULATE, why would the FILTER function need to be used instead of simply writing out the filters?
D. 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.
Other than creating new query steps, what other programming logic does the M language do?
D. The M formula language is very similar to the F sharp programming language.
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.
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 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.
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.
Raziel needs to drill down on a specific visualization she wants to use. Which option should she select in this menu?
Open Help
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 panel > Excel > Select the workbook
What worksheet object should you create to let a user modify a visualization filter by changing a worksheet control?
Parameter
What analytics lead to a hypothesis that a firm will face a 10% downturn in sales the following year?
Predictive Analytics
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.
Halavani combined two customer names, currently called Boulder Oil Group. Now she wants to ungroup them. Which step should Halavani take?
Selet the paperclip with the X on the top ribbon panel
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.
Which must be true to carry out complex planned comparisons?
The null hypothesis is rejected.
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.
If you cannot remember which changes you made, and you do not know how to undo the changes, how can you retrieve the most recent saved workbook?
Use Revert to Saved in the File menu
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.
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.
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 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
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
What is the first step in utilizing prescriptive analytics?
acquiring and processing data
You can convert a regular column chart to a stacked column chart by _____.
adding a category for the color mark
Which action can you perform on a color legend?
all of these answers
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
How do you connect to a data file?
by going to the navigation bar, and then selecting the type of file you want
How do histograms summarize data?
by using a vertical bar chart
In which action will you use a sequence of four keyboard controls to perform the action?
converting a Pivot Table to a cell range
When implementing a Level of Detail (LOD) expression, what do you use to indicate the calculation that is occurring at the different level of detail?
curly brackets
Data hoarding is contrary to the purposes of prescriptive analytics.
false
Depth of data to enrich analytics is limited to adding predictive data.
false
Prescriptive analytics is the starting point at which an organization considers actions to be taken.
false
You can't convert a stacked column chart visualization directly to a crosstab without recreating it.
false
Which Excel function transforms a correlation coefficient into a z-score?
fischer
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
What can be a pitfall of utilizing Big Data and analytics?
having hypotheses proven but not taking action
Under which tab can you find the option to add a slicer?
insert
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
You have data showing the amount of time a student driver spends with an instructor, and whether or not the student passes the driving test. This is an example of which type of regression?
logistic
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
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
What step is required after analytics proves a hypothesis?
taking the actions prescribed by the analytics workflow
What will the data display if you apply a filter to show the one field with the bottom value?
the record with the minimum value of this field
Why would you create a selection filter?
to limit the data that appears in your worksheet to chosen values
To make an image clickable in your dashboard, right-click the image and select Set URL, insert the URL info and click OK.
true
What best defines the content of dynamic correlations?
unplanned or unprecedented findings
How can time-lags in receiving critical data be avoided?
utilizing streaming data
