Process Final SCMT

Both predictive and discovery analytics are used in forming hypotheses.

TRUE

Custom territories is one of the new features of Tableau 10.

TRUE

Floating legends allow for customized dashboard sizes.

TRUE

Which of these methods can be used to create a new report that can be saved in Power BI? A. Copying and editing an existing report B. Downloading a Power BI report from SharePoint and re-uploading C. Using fields from a dataset to create visualizations D. Creating a visualization in Paint or Paint 3D and uploading to Power BI

A, C

You use Add a Tile to add content that doesn't come from Power BI. Using Add a Tile you can add text boxes, streaming content, and what else? (choose more than one) A. Images from the web B. Images from your computer C. Video from YouTube D. Web content for which you have a URL

A, C, D

To find the integer component of a division operation's result, use the _____ function.

DIV

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

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.

Which statement about formatting visualizations is true?

Different visualizations will have different formatting options available.

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.

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

What is an additional step a user must take in order to bring in data directly from a file that was not created in Excel, a CSV file, or Power BI desktop?

Get the data into Excel, a CSV or Power BI desktop model.

How can a user find out who has access to a report or dashboard?

Go to their workspace, click the Share button and choose Access.

Reducing data with the Power Query Editor would not include which of these actions?

Hide rows with null values.

To have Tableau compute the results of a calculation at the level defined by the dimensions displayed in the current view, use the _____ keyword.

INCLUDE

Under which tab can you find the option to add a slicer?

Insert

Interviews and surveys are examples of method input .

Interviews and surveys are ways of gathering input data.

Which statement is true regarding the Power BI Desktop sign-in step?

Microsoft offers a trial period to use Power BI Pro features.

What should you check before changing a text column to a decimal number type?

Negative values use the minus symbol, not a hyphen.

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?

ORDER.RANK

Which option or options are available as a choice in the app workspace?

OneDrive Business

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.

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

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.

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.

The data you selected for a visualization includes geospatial data, so Power BI created a map. You wish to present your data in columns and rows. What should you do?

Select the visualization then click on the Table visualization.

What is an easy way to have Power BI keep a user up to date on the status of critical values in their dashboards?

Set alerts.

Which is true regarding publishing to the web?

Some items, like Arc GIS visualizations, cannot be published

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.

Specific initial actions taken with prescriptive analytics is driven by _____.

Specific initial actions taken with prescriptive analytics is driven by business rules .

Pivoting data is as easy as highlighting columns and selecting 'Pivot' from the column dropdown in the data connection window.

TRUE

Prescriptive analytics requires a formal workflow.

TRUE

Source sheets filter the actions of Target sheets.

TRUE

The 'Drag table to union' tool allows you to join multiple sheets of data.

TRUE

The CEILING function always rounds a number up if the decimal component isn't zero.

TRUE

The EXCLUDE keyword removes a level of detail from an LOD calculation.

TRUE

Use the CONTAINS function to determine if a character sequence occurs within a string.

TRUE

Years can be converted from Dimensions to Measures

TRUE

How does a user create a dashboard?

Take visualizations from reports and pin them as tiles.

_____ colors are made up of one primary and one secondary color.

Tertiary

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.

Which must be true to carry out complex planned comparisons?

The standard deviation is 0.

After you're finished working with a visualization's interaction settings, what is best practice?

Turn off Editing Interactions.

How does a two-way ("two-factor") ANOVA provide results that are more meaningful than a one-way ANOVA?

Two-way ANOVA can show the results of testing two dependent variables.

How can a user remove a "favorite" item from their favorites list?

Unmark it on Favorites list.

Why would you use explicit DAX measures rather than implicit measures in Power BI?

When you create pivot tables, implicit measures are often inaccurate.

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 Power BI?

a self-service business intelligence solution

What is the first step in utilizing prescriptive analytics?

acquiring and processing data

When can a user create a mobile view?

after they've pinned a tile to the dashboard

What does "Data View" show?

all of the data in a dataset

Which workspaces does a user have access to in the Power BI mobile app?

all workspaces

What step must always be taken if a hypothesis is disproven?

appropriate actions must be taken regarding a problem

Reports in Power BI _____.

can include funnel charts, tree maps, geospatial maps and a variety of different visualizations

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've loaded a sample dataset that includes reports and dashboards. If you later delete the sample dataset, Power BI will also _____.

delete the reports and dashboards

If a user wishes to subscribe another user to a dashboard or report, what do they need?

editing permissions to that dashboard/report

Joins can be used to visualize null data and to _____.

extract data merge data across two different databases visualize a list of null data based on a common join field

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

Reference lines can be created from _____

parameters

If a print a report from Power BI Service using Export, the print job will include _____.

the current page

What are the four roles available in Power BI workspaces?

viewers, contributors, members, admins

When will the Replace Values operation generate an error?

when replacing numeric values with letters

When should you always change values in a Pivot Table to the Accounting Number format?

when the values are over 1,000 dollars

You have just deleted Page 1 of your report. When is it permanently deleted?

when you save the report

When working with Macros, which of the following is the correct file name extension?

xlsm

Which equation is an example of a linear relationship between x and y?

y=ax+c

The expression [Revenue] - AVG([Revenue]) returns an error. Within which character pair must you enclose AVG([Revenue]) to fix the error?

{ }

What do you need to consider if you use the BLANK function in Power BI?

BLANK will also pick up values of zero.

Logarithms of base _____ are called common log.

10

Which of the following is a valid base for logarithms?

2

A free subscription to Power BI Pro lasts for how many days?

60

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"

What must be included when publishing an app? (choose one or more) A. Dataset B. Dashboard(s) C. Report(s) D. Owner's profile photo

A

Which statistical chart type would you use to visualize outliers in a data set?

A histogram chart visualizes the frequency of data at certain intervals, but does not actually identify outliers.

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 another way to calculate the means of multiple variables.

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.

Apps for the Power Platform are available from where?

AppSource

If a user wishes to create a dashboard, where tool must they use? A. Power BI Desktop B. Power BI Service C. Power BI Mobile

B

Why would you pin a live report page to a dashboard? (choose more than one) A. to force users to access the dashboard through the report B. to allow users to cross-filter the visualizations as they would in the report C. so the visualizations will automatically update when the report updates D. so that filters added to the report are propagated to the dashboard

B, C, D

When we are creating the data flow, what is the step after Import?

Clean up

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.

To tell Tableau how to handle any values that don't fit other rules in a CASE statement, use the _____ keyword.

ELSE

To signal the end of an IF...THEN statement, use the _____ keyword.

END

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.

Which of the following is true about Tableau's Top-N Analysis?

Parameters can be used to display a range of Top-N values.

Which function returns a separate rank for each row without skipping any numbers?

RANK_UNIQUE

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.

You run a polynomial regression to examine up-and-down changes in your company's business cycle. What is the most important factor to understand regarding your polynomial regression?

Consider the way the y variable changes direction with an increase in your x variable.

In the three layer approach to the templates, where do action items fit?

Control

The data you imported has dates in the format, DailySales_1.1.2020. If you want the dates in your column to display as date only, what should you do?

Create a custom _ delimiter in Sort Column by Delimiter, which will leave only what is after the underscore.

How can a dashboard creator make a dashboard easier to view on a mobile phone?

Create a phone view for the dashboard.

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.

To find the first day in a week, use the week date_part value and the _____ function.

DATETRUNC

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"

Which operator returns the remainder from a division operation?

%

What is the primary difference between creating a new workspace in Power BI vs a classic workspace?

A new workspace does not automatically generate an Office 365 group.

Which statement is true regarding slicers?

A slicer can filter at both the page level and the report level.

Which choices are valid ways to create a dashboard? A. Go to Dashboards and select Create B. Create a dashboard from existing content C. Select New Dashboard from a SharePoint list D. Create a dashboard using visualizations from a report

A, B, D

You are creating a Sales report. The first page includes some visualizations illustrating national sales. Why might you choose to add a second page to this report? A. You have more national sales visualizations than fit well on page B. You need 10 visualizations, and only 6 are allowed per page C. The report will include regional sales visualizations. D. Reports are limited to one page.

A, C

As a general rule of thumb, data used in Power BI should be what? (choose more than one) A. Longer rather than wider B. Wider rather than longer C. More columns than rows D. More rows than columns

A, D

Which statement is false regarding the applied steps showing in Power Query Editor?

Adding a step immediately changes the underlying data source.

Which Excel function would you use to assess the difference between observed frequency data and expected frequency data?

CHISQ.TEST

How can you create a Pivot Chart to display Purchases by Product for 2019?

Click any cell in your Excel table, then in the Pivot Chart Fields task pane, drag Category to Axis and drag Total Price to Values.

How can a user change the criteria by which values are sorted within a column (highest value -> lowest vs. lowest value -> highest)?

Click at the top of the column.

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.

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.

According to the author, total sales by state is an example of when to map data.

FALSE

Continuous data charts require at least one blue pill.

FALSE

Creating a calculated field adds the field to your original data source.

FALSE

Dates are correctly imported when listed as an 'Abc' Dimension.

FALSE

Depth of data to enrich analytics is limited to adding predictive data.

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

The Format Shading tool will also change the background of your maps.

FALSE

There are six different ways to connect to data in Tableau.

FALSE

You may have no more than three ELSEIF conditions within an IF...THEN statement.

FALSE

Which Excel function transforms a correlation coefficient into a z-score?

FISHER

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.

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.

How can you best describe the DAX Calculate function?

It is a supercharged sum-if function that can calculate counts, products, and other functions.

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 a shortcoming of traditional business intelligence?

It only provides a dimensional analysis of facts.

What is the result of using a GENERATESERIES function when you create a table?

It reduces the potential for human error.

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.

Which function helps you to determine the number of characters in a string?

LEN

Which Excel function is used to determine the natural logarithm of a number?

LN

How can a user keep a visual generated as a result of a Power BI Q&A session?

Pin it to their dashboard.

If a user wishes to work with multiple data sources and connect them through relationships, which tool is best-suited?

Power BI Desktop

Use _____ to display your Power BI report in presentation mode with live filtering.

Power BI app for Windows 10

To find the largest value in a table column down to the current row, use the _____ function.

RUNNING_MAX

What can you NOT do from the Power BI mobile app?

Remove a tile from a dashboard.

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.

What does the mobile app's Quick Access tab display?

Reports and dashboards

Why might a user wish to start their reports in Power BI Desktop vs Power BI Service?

Reports started in Power BI Desktop are "portable" and can be worked on in Power BI Service.

To divide a string into parts based on the occurrence of a specific character, use the _____ function.

SPLIT

Which Excel function calculates the standard deviation of a sample distribution?

STDEV.S

Sales per capita replaces these two measures.

SUM(sales) and SUM(population)

What is a valid array name in Excel?

Sample_Name

You would like to print a Pivot Chart you have moved to its own chart sheet. If you click a Pivot Chart 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.

To filter out the first initial of a person's name, you should use _____.

Split

Which data type is used to store text values?

String

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

When connecting to a data source in Power BI, _____ is found under the Databases category and _____ is found under Online Services.

Sybase; GitHub

A calculated field must be created to select dimensions.

TRUE

A calculation error will be produced if the Duration value units do not match the Measure value units.

TRUE

A visual highlighter acts as a filtering tool for users.

TRUE

How is previewing a CSV file before loading it different than previewing an Excel file?

The CSV preview allows controlling the data type detection

How can adding a card visualization to your map help?

The card can show more details on data selected in the map.

What happens when you publish a PBIX file with a name that is already used?

The system will ask whether you want to replace the data set.

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.

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 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).

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)).

When you share a report with other users, what access do they have, assuming there are no low-level security restrictions?

Users have the same access as you.

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 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.

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.

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.

To return a zero if a calculation returns a null value, use the _____ function.

ZN

In order to share within their organization, a user needs at least _____.

a Power BI Pro license

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

What is generated when you click "Publish"?

a link that can be sent in email, and an HTML link that can be pasted into a blog or website

At what point of the workflow are hypotheses proved or disproved?

as hypotheses make their way through the clearinghouse and are routed to the appropriate facilities

Why would you create a custom list to sort products in a Pivot Table?

because it is quicker and safer than manually sorting the products

Which term is another name for planned comparisons?

beta testing comparisons

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?

box & whisker

How can a user view their uploaded data immediately in Power BI?

by clicking "View Dataset"

You are interested in seeing the contribution of each of your five products to the total yearly sales over the past three years. How can you do this?

by selecting % of Grand Total under Show Values as in Value Fields Settings

How can a user create a refreshable data source?

by storing their file in the cloud

What is an example of a Monte Carlo situation?

flipping a coin

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

Geospatial visualizations need geospatial data.

geospatial data (latitude, longitude)

What do geospatial visualizations require?

geospatial data (latitude, longitude)

What can be a pitfall of utilizing Big Data and analytics?

having hypotheses proven but not taking action

Which of the following is a URL action option?

hover

When will a user see their default dashboard?

immediately upon opening Power BI

Tooltips allow you to _____.

include custom formatting see information about each point on a chart add information when you need it

What is the central purpose of a Tableau filter?

include or exclude data from a view

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

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?

linear

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

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

The _____ value of a data set is the value that appears in the middle of the list when it is sorted into ascending or descending order.

median

Which should you always avoid doing when you are defining your Pivot Tables layouts?

merging and centering cells with labels

Power BI Mobile can be downloaded onto _____.

mobile devices, smartphones, tablets

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

You can change the percentile cutoff value in a visualization by using a _____.

parameter

Tableau 10 requires that you create a _____ and a _____ to display a single State across two separate databases.

parameter; calculated field

What does a correlation coefficient of -1 represent?

perfect negative correlation

Which statistical method is used to remove the association of two variables with a third variable, to determine the true correlation between the first two variables?

positive correlation

One attribute of Power BI reports is that they are _____.

printable and exportable by users

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

Which users have the ability to apply a filter to all pages of a report?

report creator/owner

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

The standard deviation of a population is the _____ of its variance.

square root

What step is required after analytics proves a hypothesis?

taking the actions prescribed by the analytics workflow

What step is required after analytics proves a hypothesis?

taking the actions prescribed by the analytics workflowtaking the actions prescribed by the analytics workflow

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

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

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

Which of the following is true about Tableau data extracts?

they are created by right-clicking the data source to be effective they need time stamps to be included in the title they enable a fast user experience

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

Why would an analyst use colors to highlight data?

to communicate impartial data

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

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

Why is it beneficial to color your backgrounds when designing layout containers?

to quickly confirm you've positioned the charts in the correct place

Where are the buttons located?

under the Developer tab

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