ark final scmt
If you want the fastest way of importing data into Power BI, which type of data will you use?
live data
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
To find the month name of dates listed in table A, you build a lookup table B that lists the month name for every date. Which relationship do you have between table A and table B?
many to one
Which term represents the middle number in an ordered set of numbers?
median
Which should you always avoid doing when you are defining your Pivot Tables layouts?
merging and centering cells with labels
Interviews and surveys are examples of _____.
method input
The _____ is the most frequently occurring number in a set of numbers.
mode
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
How can you start the process of renaming a set?
n the Side Bar, right-click the set pill you want to rename.
Can you disable map panning but keep map zooming enabled?
no
Which data type uses numbers as identifiers with no real meaning?
nominal
Which cardinality will you use to represent a bank customer in one table related to different bank accounts in a different table?
one to many
Which formula represents the probability of A given B?
p(A|B)
Attempting a quick replacement of sheet A with sheet B will _____.
place sheet B in sheet A's location
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
In a standard card visualization, a field added to the card is added at the
right
When merging tables in Power BI Desktop, which join kind shows all rows from the second table, and matching from the first table?
right outer
How do you edit the axes of your visualization?
right-click the axis > Edit Axis
How do you duplicate a worksheet that Tableau workbooks stores data in?
right-click the worksheet tab > Duplicate
Which term signifies the distribution of all possible values of a statistic for a given sample size?
sampling distribution
Saving your JSON data file as a text file allows you to _____.
save room on your disc
In Tableau, how do you sort a column based on the values in that column?
select the Column > toolbar > click the ascending or sort ascending button
How do you create a set within your visualization sheet?
select the data in multiple rows > right-click one of them > choose Create Set
What step is required after analytics proves a hypothesis?
taking the actions prescribed by the analytics workflow
You would like to provide some instructions to users of your dashboard. Where should you go in Add Tile to do this?
text box
What does a z-Score of zero indicate?
that the corresponding score is exactly average
To create a calculated field, which menu do you use?
the Analysis menu
To create calculations in dialog boxes, which tab do you select in the Filter dialog box?
the Condition tab
To create a nested sort, which feature should you change in the Sort dialog box?
the Sort By feature
Which Tableau feature introduce in 2019 helps users include visualizations in presentations?
the ability to export a visualization directly to PowerPoint
Which Power BI Desktop feature lets you combine data from two or more datasets, such as one table with postal codes and another table with longitude and latitude for the postal codes?
the ability to relate data
Which two tables, in order, will a DAX CALCULATE formula draw from to connect a loan period table to a dates table?
the data tables, and the pivot coordinates of the dates table
A solution in the example requires the delivery of 3 items from Amarillo and 397 from Kansas City. What is a better solution?
the delivery of all items from a single center
When you select the Manage Metadata button, the remote field name is displayed. What does this name tell you?
the field name from the original data source
In a standard normal distribution, which value is the probability density?
the height of the distribution
What does the formula =COUNTIFS(A1:A10,E1,B1:B10,F1) return?
the number of rows between 1 and 10 in which the cell in column A matches cell E1 and the cell in column B matches F1
If you do not set a featured dashboard, what is displayed when you open Power BI?
the state of the Power BI service the last time you left it
What is the cyclic component in a trend line when you are using a time-series for forecasting?
the way peaks and valleys vary around the trend line
None of the visualizations you have will be useful to illustrate your data, so you go to Power BI Visuals. What will you find there?
third-party visuals, some of which are free, as well as visuals your organization has already selected
What are line charts best used for in Tableau?
to analyze trends of time that data sets reveal
Nora has a sheet of a company's products from which to extract the top sellers. Why might she copy the sheet, rename it RAW, and color its tab red?
to back up her source data and warn herself if she returns to that sheet
Why would you use the new Tableau feature for creating calculations in dialog boxes?
to build formula-based filters to focus the data
Why would you use the DATEDIFF measure function with mortgage loan pivot table data?
to calculate the difference between two dates, both of which must be measures, by an interval such as months
What are Tableau stories used for?
to convey a persuasive narrative about the user's insights
Although efficiency means taking as few steps as possible, why should you first test an SQL query in an application such as Visual Studio.
to make sure the SQL code works
You are the creator and owner of a report involving purchases by customers in your various sales regions. Why would you add filters to visuals?
to make working with the filtered data easier for users when they might not know all the details about the regions and customers
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
To _____ your data, is to transform your data from a text table or crosstab to a data list.
unpivot
What best defines the content of dynamic correlations?
unplanned or unprecedented findings
Which scenario is not possible with a calculated field created on a shelf?
using it in other worksheets
How can time-lags in receiving critical data be avoided?
utilizing streaming data
Which visualizations can you pin to a dashboard?
visualizations from different reports and different datasets
When will the Replace Values operation generate an error?
when replacing numeric values with letters
When is there a negligible difference between the t-distribution and the standard normal distribution?
when the degrees of freedom are at least 30
When should you always change values in a Pivot Table to the Accounting Number format?
when the values are over 1,000 dollars
When are scatter plots typically used?
when you have two numerical measures
When is filtering your data using parameters helpful?
when you want to change a single control, instead of editing the entire filter
Which type of probability distribution does not contain a countable number of outcomes?
continuous
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
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
Which sample space contains the results of an experiment where a coin is flipped?
heads and tails
When you examine your data source, how is the data set organized?
in columns
If you want to sort a list of sales values from highest to lowest, how should you sort your list?
in descending order
If you create 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
What appears on the x-axis of a frequency polygon?
interval midpoints
What will you find in Favorites & Frequents on your Power BI service home page?
items you have set as favorites, or have used often by count
A scatter plot shows the average life expectancy for each country in the United Nations. After creating a regression line for this plot, which combination of F and P values indicate that the line is a close fit to the data?
large F and small P
What do darker colors represent in a highlight table with built-in coloring?
larger values
For this sheet, how would you write the total cost?
= SUMPRODUCT(C15:E22,H15:J22)*C24
You need to add another column to your data that simply sets all values to the text "complete". Which custom column formula should you use?
="complete"
How can you move a sheet to a different position within a workbook?
Drag the sheet tab to a different location.
Raziel needs to drill down on a specific visualization she wants to use. Which option should she select in this menu?
Open Help
Which tool is used to clean up source data in Tableau?
the Data Interpreter tool
When exporting visualizations to PowerPoint, which extension should you select?
.pptx
What is the standard deviation in any z-score distribution?
1
What is the minimum sample size required to use the central limit theorem?
30
What is the first step in the prescriptive analytics workflow?
Detect events.
Which keyboard shortcut will take you into presentation mode?
F7
What is the keyboard shortcut to create a new worksheet in Tableau?
Ctrl+M
Which of the following is a valid base for logarithms?
2
How should you write the date April 29, 2020, to avoid sorting problems?
20200429
Halavani combined two customer names, currently called Boulder Oil Group. Now she wants to ungroup them. Which step should Halavani take?
Select the paperclip with the X on the top ribbon panel.
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"
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
When is saving your workbook as a PDF file beneficial?
when you want to send your documents but not have any interaction
You selected the Retail Analysis Sample from the available samples. What will be the result?
A dashboard, reports with visualizations, and a dataset of real data that has been anonymized will be added to your workspace.
Which term is another word for average?
mean
_____ colors are made up of one primary and one secondary color.
Tertiary
Chan, new to your team, does not have a Power BI Pro license. What is the only role you can assign to him?
viewer
For this sheet, how would you write the constraint that the demand of each city is met?
$K$15:$K$22 = $D$3:$D$10
Nico created a pie chart, and now he wants to work with multiple pie charts. What will he need to do?
Add another dimension to the existing pie chart.
Which of the following built-in functions will round a number up to the next integer?
CEILING
Where did you go to add the information displayed in the legend and on the map?
Data Layers
Like a pie chart, a treemap also uses shades of color to help indicate the value.
FALSE
Low velocity analytics tend to be volatile in nature.
FALSE
Prescriptive analytics is the starting point at which an organization considers actions to be taken.
FALSE
What does the formula =IF(B1<C1,"B","C") mean?
If cell B1 is less than cell C1, return the character B; otherwise, return the character C.
You have some Excel data stored in OneDrive for Business you want to analyze in Power BI. Which step must you do first?
Make sure the data is formatted as a table.
If you want to know the scale your map is showing, which option should you choose?
Map Options
How do you disable pan and zoom in maps?
Map menu > Map Options > un-check Allow Pan and Zoom
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
How can you quickly set all the values in an array to 9?
Select the cell range, type 9, and then select Ctrl+Enter.
In Tableau you can add a filter action to your dashboard.
TRUE
You created a scatter plot chart for a set of data, but you only see a single dot. What has happened, and what should you do in order to see more clusters for your data set?
The data is aggregated, and the Aggregate Measures under Analysis should be unchecked.
Of the various statistics available when you perform a multiple regression in Excel, which statistic indicates how well your regression equation fits the data when you have multiple factors?
the R-squared, which is the square of the correlation coefficient between one variable and the combination of other variables
Why would you create a selection filter?
to limit the data that appears in your worksheet to chosen values
Where are the buttons located?
under the Developer tab
When flipping two coins, what is the probability that they will both come up heads?
1/4
Logarithms of base _____ are called common log.
10
What is the keyboard shortcut to save a file in Tableau?
Ctrl+S
If you think something is out of the ordinary and it actually is not, which type of error has been committed?
type I
Which Excel tool lets you find the cost per mile that produces a specified total cost?
Goal Seek
What is the primary reason to use the Add a comment feature with tiles?
to start a conversation among your colleagues about the tile
Which statement is true regarding slicers?
A slicer can filter at both the page level and the report level.
If you want two tests to both be true, which logical operator should you use?
AND
You first selected a 2D line chart for your data range. You would like to see how the data would display with other charts. How can you do this?
Click inside the chart, go to Charts on the ribbon, click the arrow to the right of a chart type, and hover your mouse over the charts.
You want to test goodness of fit with a data set of actual outcomes in cells C3 to C10, and expected outcomes in cells E3 to E10. What is the quickest way to do this in Excel?
Compute the p-value directly by using Excel's chi-square function.
Which Excel function is used to determine the critical value of F?
F.INV.RT Correct
If you hide the Filters and Marks cards to make more room for your visualization, how can you unhide them?
Go to Worksheet, point to Show Cards, and then select Reset Cards.
In a transshipment model, how would the total cost change if you doubled only the outbound cost?
It would increase, but less than double.
You would like to print a PivotChart you have moved to its own chart sheet. If you click a PivotChart you have moved to its own chart sheet, then press Ctrl+P, which action will you take next?
Select Print Active Sheet from the options under Settings.
Which sorting option is not directly available to choose in the Sort dialog box?
Sort by the dimension text length.
Boyd wants to highlight the cells in A1 through C5 whose value exceeds cell F2's value with a light red fill. What should he do after selecting Conditional Formatting?
With the cell range selected, select Highlight Cells Rules > Greater Than, select cell F2, and then choose Light Red Fill.
How do pie charts display your data?
as several parts contributing to a total
Which path would you take to add Grand Totals to this data sheet?
Go to Analysis, choose Totals, and then select Show Row Grand Totals.
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 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.
How do you connect to an Excel workbook, if you can, from Tableau?
Open Tableau > Connect panel > Excel > Select the workbook.
Your first estimate has a 95-percent confidence interval. What will happen if you increase N in your sampling?
The standard error will decrease, and the confidence interval will narrow.
The Sales Manager has moved Pennsylvania from the Midwest Region to the East Region. How can you change the regional sales data so your dashboard reflects the new data?
Update the data through the Pin Manager under the Power BI tab in Excel.
If you modify a report by adding filters, does it update a dashboard tile from that report?
Yes, it will update a tile, provided you create the tile using Pin a Live Page in the More menu.
Can you add all subtotals to data with sets?
Yes; the subtotals will show the total of every set.
What is the first step in utilizing prescriptive analytics?
acquiring and processing data
When combining two sets, which combining option results in an intersection between sets?
shared members in both sets
Why would you want to create a shared workspace?
so your users can collaborate and create their own dashboards and reports
In the Device Preview screen, what is similar between the desktop and mobile device types?
Both allow for element resizing. Correct
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
Under which tab can you find the option to add a slicer?
Insert
Which equation is an example of a linear relationship between x and y?
y=ax+c
Which statistical test should be run when the Central Limit Theorem applies to the data?
z-test
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.
What happens if you are not logged in to Facebook and try to connect to public information there?
Facebook requires you to log in first.
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
You have a sample set of the heights of twelve-year-old sixth-grade students. Why will you use standard deviation to meaningfully understand the variability In this sample set?
It puts the variability in a set of numbers into the same units as the original measure.
You are uploading an Excel workbook. How do Excel workbooks differ from CSV files that you might upload?
The Excel data sources you upload will be formatted as tables.
How would the solution to a transportation model change if the cost per mile doubled?
The total cost would double.
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.
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 connecting Power BI Desktop to a web data source pointing to a webpage with multiple tables, what can you preview?
You can preview all tables individually.
Why would you use the Annotation Tool available in Power BI for Mobile with a report you want to share?
You can say something about the dashboard and not have to write an email.
How does a dashboard differ from a report?
You can use a natural language query with a dashboard.
How do you view and open your dashboards and reports on a mobile device?
by selecting Quick Access on your mobile device
How do tree maps indicate value?
by shades of color
What does the conservation of flow constraint state?
Every item that enters a distribution center must also leave it.
How can you start to edit or remove an existing reference line?
Right-click the vertical axis
How can adding a card visualization to your map help?
The card can show more details on data selected in the map.
How would you create a date table in Power BI for mortgage loan calculations, rather than loan periods that will use dates as the pivot coordinates?
Use the formula GENERATESERIES(DATE(start year, start month, start day), DATE(end year, end month, end date)).
You are creating formulas to calculate the remaining balance on a mortgage loan. Why would you use a parameter-harvesting function?
to convert a naked loan period column into a measure you can reference
In the three layer approach to the templates, where do action items fit?
Control
You want to embed a report in SharePoint Online. Before you actually embed the report, what must you add to SharePoint?
a web part
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
When working with Macros, which of the following is the correct file name extension?
xlsm
You are working on your mobile device, and you would like to send a dashboard to Kimora for her to review. How can you do this?
with the Share button on the bottom of the app screen
How do you tell Tableau to recognize that the property state field contains in fact geographic information about states?
Data tab > select Property State > click down arrow> Geographic Role > click State/Province
What worksheet object should you create to let a user modify a visualization filter by changing a worksheet control?
Parameter
What is a shortcoming of traditional business intelligence?
It only provides a dimensional analysis of facts.
What is a recommended process for working with Power BI Desktop and Power BI Pro?
Create your work in Power BI Desktop, and then upload the file to Power BI Pro.
How can you best describe the DAX Calculate function?
It is a supercharged sum-if function that can calculate counts, products, and other functions.
What do you get as a result when you apply SUMPRODUCT to cells J12:J14 containing 4,5, and 6 and cells K4:M4 containing 7,3, and 1?
#VALUE!
If alpha is the amount of uncertainty that is acceptable, how do you calculate confidence?
1 minus alpha
What will the calculation ABS(10 % 6) produce?
4
You have a transportation problem with 5 distribution centers and 7 destinations. To determine which centers to keep open and the deliveries from each center, how many variables should you consider?
40
What is the SUMPRODUCT of these two arrays?
75
You have 4 factories, 5 distribution centers, and 11 destinations in a transshipment model. How many decision variables are there?
75
Which formula calculates the mode, as a single mode, with a range of cells C1 through C13?
=MODE.SNGL(C1:C13)
What is a constant?
A constant is a quantity that cannot change.
As the T.DIST.2T formula does not accept negative numbers as arguments, which additional formula should be used to calculate absolute value?
ABS
What is the purpose of using ANOVA?
ANOVA provides an analysis of the variance between means to test a null hypothesis.
What step should you perform before adding data from more tables, if you need to eventually aggregate the data by which table it originally came from?
Add a custom column to each table, set to the table name.
If you want to see the average and sum at the same time, what will you need to do?
Add a second calculation.
How do you calculate a mean?
Add all the numbers in a number set, then divide the sum by the total count of the number set.
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.
Which statement is false regarding the applied steps showing in Power Query Editor?
Adding a step immediately changes the underlying data source.
You have five values in a row of six cells. How can you efficiently add these values and show the result on the sheet?
Type =SUM( in any empty cell, highlight the range of values, and type Enter.
How can you start to determine the radius of the circle that would encompass several locations?
Under Options, point at the right-pointing triangle at the bottom, and then select the round selection tool.
How do you incorporate facilities that can be opened or closed into a Solver model?
Use binary variables.
You want to copy one of your model matrices and transpose it for easier use in model formulation. How can you transpose without too much effort?
Use the T option when pasting.
You decide the dashboard you created is not in the order you would like them to appear in the final report. How can you rearrange the pages?
Use the drag-and-drop feature to arrange the pages in the order you would like them to appear.
Your simulation mean is in cell F9, simulation variance in F10, and simulation standard deviation in F11. How can you find the simulation standard deviation with a Monte Carlo simulation?
Use the formula =SQRT(F10).
Which Excel function calculates the variance with n-1 in the denominator?
VAR.S
When you have multiple columns in a list, what effect does this have on sorting your data?
You can select which column you want to sort by.
What can you customize in the summary card?
You can select which items will appear.
Why would you add a Timeline of months to the Pivot Table on a worksheet?
You can show a clickable summary of data without changing your Pivot Table.
Which limitation do you have when you create Pivot Tables from data models?
You cannot define a calculated field.
In the Ginny's Biscuits example, what would happen if you closed the two distribution centers with the longest average delivery distances?
You could not meet demand.
Which situation is an example of a Type II error?
You decide not to go to the hot new restaurant in town, because the only review on a social media website was negative.
You are trying to sign up for the free 60-day trial of Power BI Pro with your personal email, [email protected]. Why won't you be able to sign up for the free trial?
You do not have any Microsoft accounts connected to your email address.
You would like to filter your PivotChart 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 PivotChart, and your Pivot Table changes to three product rows as well.
Which scenario is best handled with a drop-down list?
You want to specify which company site an employee works at.
Why should you take some time to experiment with different degrees of freedom ("df") in a t-distribution visualization?
You will be able to visualize and understand just about any distribution you will come across in your work.
If you want to get Power BI on a mobile device, how will this be done?
You will receive a download link via email.
You have created a new dashboard with tiles from other dashboards. Your sales manager asks you to pin an element from Excel to the dashboard. When would you do this?
You would do this to pin a PivotTable to your dashboard.
Which statistical chart type would you use to visualize outliers in a data set?
a box-and-whisker chart
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
You would like a visualization that shows how much of your third quarter sales goal has been reached. Which visualization will you choose?
a gauge
If you ask a question in Power BI Q&A, what will be returned?
a list of responses you can select, with visuals you can use to create tiles
in Power BI, what is the principal printing unit for a report?
a page
You created and downloaded a QR code. How would you want to share the QR code?
a presentation slide that will display long enough for someone to scan the code
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
When data clusters are identified, which type of chart or graph can be formed?
a scatter plot
What is Power BI?
a self-service business intelligence solution
Within the Describe Clusters dialog box, what does the tab "Models" display?
a statistical rundown of the data in the clusters
You would like a hierarchical visualization that shows total sales in Canada, then sales by province. Which visualization will provide this?
a treemap
What does displaying a visualization in a tooltip show?
a visual subset of another worksheet
Which value will not match a wildcard filter set to match on anything containing "ap"?
banana
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 does Tableau let users join data sources with inconsistent field names?
by identifying the fields that each sheet has in common
How do you unpivot the data in a crosstab to create a list?
by rearranging the pills on the column's row shelves
Your visualization is a table. How can you add alt text?
by selecting it from the Formatting options in the Visualizations pane.
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
How can you identify a field with a geographic role?
by the globe symbol next to the field name
How do histograms summarize data?
by using a vertical bar chart
Hugo has a table ranging from B5 to F50, including a header row that he wants to keep visible when scrolling vertically. Which cell should he select before selecting Freeze Panes?
B6
What do you need to consider if you use the BLANK function in Power BI?
BLANK will also pick up values of zero.
How can you create a mobile view when you add a new tile to a dashboard?
Choose More (...) > Mobile View, then size all the tiles so they are most helpful for mobile users to see.
How do you constrain variables to only having values of 0 or 1?
Choose bin for the constraint operator.
When we are creating the data flow, what is the step after Import?
Clean up
How can you create a PivotChart to display Purchases by Product for 2019?
Click any cell in your Excel table, then in the PivotChart Fields task pane, drag Category to Axis and drag Total Price to Values.
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.
How can you find the controls to change the size of the screen using a range of fixed sizes in Tableau?
Click the second controls down arrow.
You are presenting year-end sales results in a conference with all your salespeople. They all have mobile devices. How can you most easily share a tile with them?
Create a QR code.
You would like to analyze data contained in an on-premises Access database. How will you do this with Power BI service?
Create a data model with Power BI Desktop, then connect the data model to the Power BI service.
Your data is from an Excel file. How can you tweak the data to provide a better experience with Power BI Q&A?
Create column names that match the names your users are using.
You have a pivot table of three measures, with Measure 3 being the sum of Measures 1 and 2. Which statement is accurate about the way DAX measure logic will deal with them?
DAX will calculate Measure 3 independently of the other two measures.
Mo has some irregular formatting within his data. What can he use to clean up his source data?
Data Interpreter
How do you view the data that underlies the visualization you've created in Tableau?
Data menu > Data Source name > View Data
You need to import XML data as a base to your report, where do you go to get that data?
Data tab -> from Other
How do you create a selection filter to limit the data that appears in your sheet?
Data tab > click down arrow for the field you're filtering by > Show Filter
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.
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.
The visualization you are creating has four tiles. How can you rearrange them so a particular tile is at the upper left?
Drag and drop the visualization to the desired location.
When you are creating conditional formulas, what is the only component in the formula that can have multiple conditions?
Else if
How do you enter three variables (one predicted variable, and two predictor variables) into Excel's Regression Analysis tool?
Enter one variable as the Y range, and the other two variables as the X range.
Why would you store Excel files in OneDrive for Business for use with Power BI?
Excel files will be refreshable using OneDrive for Business.
What does it mean when a cell contains #N/A?
Excel was sent to look for something that it could not find.
What is the shortcut to access the Presentation mode in Tableau?
F7
Data hoarding is contrary to the purposes of prescriptive analytics.
FALSE
Depth of data to enrich analytics is limited to adding predictive data.
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?
FISHER
You have a top filter that limits the number of items shown, and this limit is set by a parameter. What happens when you decrease this parameter?
Fewer top items will show.
You do not want viewers of your datasheet to sort your data. What can you do to prevent this?
Go to the Worksheet menu, and then select Show Sort Controls to clear it.
Mishik created a highlight action on a dashboard. Why did he choose All Fields under the Target Highlighting?
He wanted the results of the action to appear on all the target sheets in the dashboard.
You have a couple of columns in your sheet that need to be separated, one of which is the customer name. Which steps do you have to take to separate the first and last names into their own columns?
Hover your cursor over the "Cust Name" header, and then select the down arrow and choose Split.
Which statement is accurate regarding the Central Limit Theorem?
If N is ≥ 30, the sampling distribution of the mean is approximately a normal distribution, even if the population is not normally distributed.
You run z-scores on your warehouse employees' production for the last quarter. What does a positive z-score tell you about an individual employee's corresponding performance score?
If the z-score is positive, the employee's performance score is above average.
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.
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.
You have a range of values on a fees sheet and want to add the total fees to a summary sheet. What is the best way to do this?
In a summary sheet cell, type =SUM(, highlight the range of values on the fees sheet, and type Enter.
In a column of ages, how would you prohibit entering values under 18 and over 34?
In the Data Validation dialog, set Allow to Whole number, Data to between, Minimum to 18, and Maximum to 34.
Why should a report owner be cautious about changing the default behaviors for a report?
It can be confusing for a user to drill into a report and not have it behave as they expect it to.
When dealing with the different types of data in statistics, what is ordinal data?
It has a meaningful order. A higher number means more of a certain property, but the differences between numbers have no significance.
Why is a regression line known as the "line of best fit"?
It is the line that best minimizes the sum of the squared distances of the residuals from the data points on a scatterplot.
What is the result of using a GENERATESERIES function when you create a table?
It reduces the potential for human error.
What is meant by internal validity when undertaking a study?
It refers to the different levels of the independent variable that are the only cause of differences in the dependent variable.
Your company is tracking sales data in Excel. What would be your recommendation on how to arrange this data for a multiyear analysis?
Keep all the data in one big sheet, with columns to denote the sale date and year.
What must you consider when creating a report you know users will print out?
Keep visualizations that should be printed together on the same page.
What will the formula =IFNA(VLOOKUP(A1,$M$1:$O$10,3,FALSE),"Not Found") return if cells A1 and M5 contain 22-7, N5 contains 15, and O5 contains LAX?
LAX
Which statement is true regarding the Power BI Desktop sign-in step?
Microsoft offers a trial period to use Power BI Pro features.
One reason to create reports is to share them with other users in print fashion, such as a PDF or PowerPoint. However, what often happens when you want to export a report to one of these file types?
Most of the custom Power BI visuals that you use in reports do not survive the exporting process.
How can you start to add an annotation to a specific part of a visualization?
Move your mouse pointer over the part of the visualization that you want to annotate, and then right-click.
How do you calculate the expected value of a discrete probability distribution?
Multiply each outcome times its probability, then add the resulting products.
Which Excel function can be used to calculate the area under a standard normal distribution?
NORM.S.DIST
Which Excel function calculates the critical value to the left in a standard normal distribution?
NORM.S.INV
What should you check before changing a text column to a decimal number type?
Negative values use the minus symbol, not a hyphen.
In the example, what does it mean to have a level of service that is 0.7?
No more than 30% of the items delivered travel more than the maximum distance.
Which limitation do you have with your workspaces when you use the Power BI app on a mobile device?
None, because you have access to all of your workspaces.
Renata is a business analyst who spends significant time modeling and transforming data. Which Power BI tool, a free download software, will Renata most often be using?
Power BI Desktop
How does Quick Insights provide you with additional and valuable information?
Power BI churns through your data and tells you what it learned about your data.
You are creating a new report and your first step is to select the Districts checkbox in the Fields pane. What will happen?
Power BI will immediately generate a visualization.
Why is importing a PDF's data into Power BI considered a "hack" method?
Power Query does not directly support uploading PDFs, so you can instead open it as a Word document and save it as an HTML file.
What analytics lead to a hypothesis that a firm will face a 10% downturn in sales the following year?
Predictive Analytics
An event is defined as an elementary outcome. How does probability relate to events?
Probability is based on the likelihood of an event occurring.
You are interested in examining the effect of a new work schedule on employee productivity. You design your test with two different sets of employees. How would you appropriately create your samples?
Put the names of the employees in a box, and while blindfolded pull names out for assignment to sample groups.
When you perform correlation testing, why do you need both a correlation coefficient and an R value?
R values can only be a positive number, but correlations can be negative.
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
When you are transposing data tables, what do you need to do with promoted headers?
Remove them, perform the Transpose function, and then promote the headers again.
How do you add a text box to a chart?
Right-click anywhere on the chart where there is no data. > Annotate > Area
Which Excel function calculates the standard deviation of an entire population?
STDEV.P
Which Excel function calculates the standard deviation of a sample distribution?
STDEV.S
What is a valid array name in Excel?
Sample_Name
How can you quickly replace Sheet 1 with Sheet 3 in a dashboard?
Select Sheet 1, and then move your mouse pointer over Sheet 3 and click.
How can you create multiselect slicers to display data for the Territories of Ohio, Michigan, and Indiana?
Select each of them from the Territory List while holding down the Ctrl key.
How do you define groups which let you combine multiple items into a single item in your visualization?
Select items to group. > Toolbar > Group Members
Petra wants to modify the appearance of her data sheet by showing seven different colors of blue, starting with the lighter shade for the highest value data point. What does she need to do?
Select the Color icon in the Marks card, choose Edit Colors, check the Stepped Color and enter 7, check the Reversed box, and select OK.
Nasim exported data to a .csv file and then displayed it in Excel. However, now there is data loss. What should he do next?
Select the Don't show again button to have all the data visible.
Your report has four visualizations, including a filled map and a column chart for your four sales regions. How can you quickly filter the report to display data only from the Northwest Region?
Select the Northwest Region of the column chart.
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.
The loan payment chart you created on your dashboard has two separate time periods, and they are both being filtered by the same Select Date. If this is not what you want, how should you change it?
Select the chart, go to the Format bar, select Edit Interactions, and then select the cross-through icon.
Thai has created this Prod Category data chart. He uses the function COUNTD, but the data is not showing. What should he do to make the data show?
Select the icon next to the pill on the Marks card, and then select Text.
Suki has never used the Show Me feature. How would you explain Show Me to Suki?
Selecting the Show Me icon displays available visualizations, based on the type of data you want to visualize.
Which Solver method should you choose for a transshipment problem?
Simplex LP
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.
Can you use the "Show Me" options to change the type of an existing chart to any other type?
Sometimes. The "Show Me" list is always available, but will only allow certain chart types based on the current data.
Audra has a data column formed like Smith, John, ORD. With the column selected in Power Query Editor, how can she create two columns formed like Smith, John and ORD?
Split the column by right-most delimiter with a comma followed by a space as the custom delimiter.
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
Which statement about the transportation problems presented in this course is true?
Supply and demand are constant.
When connecting to a data source in Power BI, _____ is found under the Databases category and _____ is found under Online Services.
Sybase; GitHub
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
Both predictive and discovery analytics are used in forming hypotheses.
TRUE
If you want to add colors to each of the vertical bars in a visualization, you need to drag the field that will be used as the base for those colors to the Marks card and, specifically, onto the Color box.
TRUE
Prescriptive analytics requires a formal workflow.
TRUE
Tableau allows you to create a visualization based on three or more link tables so you can analyze your data.
TRUE
The Show Me button on the toolbar allows you to create a horizontal or vertical bar charts for your visualization sheet.
TRUE
To make an image clickable in your dashboard, right-click the image and select Set URL, insert the URL info and click OK.
TRUE
Which Tableau product can you use to clean and prepare data?
Tableau Prep
Which Tableau file type stores a connection to a worksheet in another Tableau workbook?
Tableau bookmark (.tbm)
Which of the following Tableau file types stores a visualization without source data?
Tableau workbook (.twb)
How do you create a Dashboard in Tableau?
Task Bar > New Dashboard > from Dashboard Tab drag sheet onto the Dashboard sheet area
How is previewing a CSV file before loading it different than previewing an Excel file?
The CSV preview allows controlling the data type detection.
You want a visualization that shows the contribution of each of your 12 sales regions to total sales for the quarter. Why is a tree map a better choice than a pie chart?
The contribution of each segment is easier to see and understand.
What must you keep in mind when you are creating dashboards?
The data you select must be the data that tells the most compelling story.
In the example, what does a 0 indicate in the Distance < Maximum array?
The distance between the corresponding destination and center is greater than the target maximum.
If you set a worksheet's tab color to green, what will happen when you switch to another worksheet?
The first worksheet remains green.
Your Pivot Table shows products you purchase under headings in Column A, and 2019 in Column B. If you have not changed any settings, what happens when you select Show in Outline Form?
The individual products will move a column to the right.
If you drag a pill on top of another pill, rather than changing the organization, what happens?
The new pill will replace the previous pill.
What is the main difference between the new Power BI workspace experience and the classic Power BI workspace experience?
The new workspace experience does not automatically create an Office 365 group.
Which must be true to carry out complex planned comparisons?
The null hypothesis is rejected.
You can convert a regular column chart to a stacked column chart by _____.
adding a category for the color mark
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
Which action can you perform on a color legend?
all of these answers
Which of the following data sources does Tableau allow you to connect to?
all of these answers
You have a table consisting of two columns, and you convert it to show the percentage of the table. What will add up to 100 percent?
all the items in the table
A Permissions setting option is Allow all users to connect to the app's underlying datasets using the Build permission. If you select this, what are you doing?
allowing users to add their own reports for their own app experience
Which hypothesis states that the observation is something new and important?
alternative
What step must always be taken if a hypothesis is disproven?
appropriate actions must be taken regarding a problem
You are creating a visualization. The first item you selected from the Fields list has a calculator icon next to it. The next item selected does not have an icon next to it. In which type of visualization will the second item appear?
as a chart
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
Where is every cell in a crosstab located?
at the intersection of a row and a column
You publish a report to the web, but then decide you do not want to publish it. You delete the embed codes in Manage embed codes. When are the embed codes actually deleted from Power BI?
at the next scheduled update
Your data consists of values between 90 and 100, and you only want to focus on relative differences. Which axis options would work best?
automatic range, not including zero
What does "security through obscurity" mean, as applied to publishing reports to the web?
Anyone with Power BI can read a report, so the only security is to make a report name so obscure that others are not likely to view it.
How do you calculate the percentage that each cell in a column contributes to the whole?
Analysis menu > Percentage Of > Column
The visualization you want is based on your sales by state. When you select State in the Values option to create a list of states, what will happen?
A map will be created.
How can you quickly set the values in the rightmost column to the sum of the values in the corresponding row?
Alt+=
How do you create a calculated field in Tableau?
Analysis menu > Create Calculated Field
How does a two-way ("two-factor") ANOVA provide results that are more meaningful than a one-way ANOVA?
Two-way ANOVA can produce interaction effects you would not see with a one-way ANOVA.
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 pin a tile from another dashboard into the dashboard you are modifying?
Open the dashboard you want to pin from, select the tile, select Pin Tile under More, and select the dashboard you want to pin the tile to.
How can you tell whether an element is showing and not hidden?
There is a checkmark to the left of the element in the Worksheet drop-down menu.
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.
You are interested in joining data tables to show inflation rate by country within specified geographic regions. In order to join the tables, what must you have?
There must be a unique ID for each country in the Region key.
Why should you investigate solutions with level-of-service constraints?
They can suggest qualitative insights for improvement.
What is the function of linking constraints in a transport model with optional facilities?
They ensure facilities that handle items are open.
How do transshipment problems differ from transportation problems?
They use distribution centers.
If you do not send an email notification to recipients when you share a report, what will occur?
They will not be able to access the report unless you copy the link and send it to them.
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.
How do you change the visual summary type to a pie chart type?
Toolbar > Show Me button > select pie chart
How do you display the Summary Card of the visualized data in the worksheet?
Worksheet menu > Show Summary
Why would you use explicit DAX measures rather than implicit measures in Power BI?
When you create pivot tables, implicit measures are often inaccurate.
After creating reports for each of your regional sales managers from national sales data, you find that for the Midwest Region only data for Indiana is showing. What did you likely do?
When you created the report, you selected Indiana under Report level filters.
You are an independent contractor, so you do not have an organizational email address. Can you still sign up for a Power BI trial subscription?
Yes, you can get a trial subscription to Office 365, and then use that account to sign up for a Power BI trial.
When you are creating reports using Power BI to share data with other users, what are you ultimately doing?
You are creating a dashboard for users to access the information in the visuals you place in the report.
Creating separate legends allows you to _____.
distinguish between your data values