SCMT 4633 Final
To signal the end of an IF...THEN statement, use the _____ keyword.
END
In a standard card visualization, a field added to the card is added at the _____.
right
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
Which term is another name for planned comparisons?
a priori comparisons
What step must always be taken if a hypothesis is disproven?
appropriate actions must be taken regarding a problem
How do you view and open your dashboards and reports on a mobile device?
by selecting Quick Access on your mobile device
What is an example of a Monte Carlo situation?
flipping a coin
What does a correlation coefficient of -1 represent?
perfect negative correlation
Which of these is a reason to relate tables in Power BI?
so you can examine relationships between different datasets
Why would you create an app workspace?
so you can have collaboration in creating and sharing data, reports, and dashboards
Why would an analyst use colors to highlight data?
to communicate impartial data
When will the Replace Values operation generate an error?
when replacing numeric values with letters
What analytics lead to a hypothesis that a firm will face a 10% downturn in sales the following year?
Predictive Analytics
To filter out the first initial of a person's name, you should use _____.
Split
_____ colors are made up of one primary and one secondary color.
Tertiary
Two-way ANOVA is the only way you can test more than one independent variable.
Two-way ANOVA can produce interaction effects you would not see with a one-way ANOVA.
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.
Continuous data charts require at least one blue pill.
FALSE
Where are the buttons located?
under the Developer tab
When we are creating the data flow, what is the step after Import?
Clean up
How can you create portable reports?
Create the report in Power BI Desktop, and then work with it in Power BI service.
Why would you store Excel files in OneDrive for Business for use with Power BI?
Excel files will be refreshable using OneDrive for Business.
As you are working in a workspace on your iPad, you receive a notification. What is the notification about?
A collaborator is sending you a notification about your work together.
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.
When adding filters to a function like CALCULATE, why would the FILTER function need to be used instead of simply writing out the filters?
The FILTER functionality needs to be used in filters that operate a certain way, like FILTER that references a measure or a FILTER that references another table.
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).
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.
What is the value or area of caution users should be aware of when utilizing the BLANK() function?
When utilizing the BLANK() function, users should be careful that they know how to distinguish BLANK() from zeros or nulls as these can sometimes get mixed up in calculations.
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 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?
Your email address has to be a business email, not a Hotmail personal email address.
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
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
You would like a hierarchical visualization that shows total sales in Canada, then sales by province. Which visualization will provide this?
a treemap
Joins can be used to visualize null data and to _____.
all of these answers: extract data merge data across two different databases visualize a list of null data based on a common join field
Tooltips allow you to _____.
all of these answers: include custom formatting see information about each point on a chart add information when you need it
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
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
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
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
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
Your visualization is a table. How can you add alt text?
by selecting it from the Formatting options in the Visualizations pane.
In which action will you use a sequence of four keyboard controls to perform the action?
converting a Pivot Table to a cell range
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
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
Interviews and surveys are examples of _____.
method input
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
Reference lines can be created from _____.
parameters
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?
partial correlation
Your data shows the ages and hair colors (black, blonde, or gray) of 5,000 men. How do you calculate the probability that a 30-to-40-year-old man will have black hair?
probability of the age range times the probability of black hair
A graph of five athletes' track scores shows an overall improvement as the amount of trials increases, but after a while, the scores dip, due to fatigue. This single change of trend direction represents which type of equation?
quadratic
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
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
Why would you want to create a shared workspace?
so your users can collaborate and create their own dashboards and reports
The standard deviation of a population is the _____ of its variance.
square root
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
You are doing a research project on population changes, and the U.S. Census website has the data you want. Which data type should you download so you have the easiest format to read?
the 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
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
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
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
Which choice best describes how Power BI is used at a basic level?
to create models from which you will utilize other Power BI features
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
Why is it beneficial to color your backgrounds when designing layout containers?
to quickly confirm you've positioned the charts in the correct place
What is the primary reason to use the Add a comment feature with tiles?
to start a conversation among your colleagues about the tile
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
Chan, new to your team, does not have a Power BI Pro license. What is the only role you can assign to him?
viewer
Which visualizations can you pin to a dashboard?
visualizations from different reports and different datasets
Which of the following date_part values is not usable with the DATEPART function?
weekendday
When should you always change values in a Pivot Table to the Accounting Number format?
when the values are over 1,000 dollars
When would you use Power BI service rather than Power BI Desktop?
when you are creating dashboards
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
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?
{ }
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"
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.
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.
In the three layer approach to the templates, where do action items fit?
Control
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.
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.
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.
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 exactly do external filters work in DAX and Power BI?
External filters in Power BI can be set up as a slicer or filter based on data in the table being filtered or can even be another table, as long as the connection (using a function like SELECTEDVALUE for example) establishes that connection.
According to the author, total sales by state is an example of when to map data.
FALSE
Creating a calculated field adds the field to your original data source.
FALSE
Data hoarding is contrary to the purposes of prescriptive analytics.
FALSE
Depth of data to enrich analytics is limited to adding predictive data.
FALSE
Low velocity analytics tend to be volatile in nature.
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.
How can adding a card visualization to your map help?
The card can show more details on data selected in the map.
Dates are correctly imported when listed as an 'Abc' Dimension.
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
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.
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.
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 the result of using a GENERATESERIES function when you create a table?
It reduces the potential for human error.
How does the query editor work like a programming language?
The query editor is backed by the M formula language, which according to Microsoft is very similar to the F sharp programming language.
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
Which function returns a separate rank for each row without skipping any numbers?
RANK_UNIQUE
To find the largest value in a table column down to the current row, use the _____ function.
RUNNING_MAX
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.
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. This is a valid array name. It has no spaces and no special characters except for the underscore.
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.
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.
What is the most helpful way to think of how to leverage the ALL function?
The ALL function can be leveraged and thought of a function that literally clears all the filters already applied in the formula or the tabular pivot table (for example).
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.
When comparing DAX logic to Excel logic, what is the most closely related Excel function to the CALCULATE function?
The CALCULATE function works like powerful SUMIF, AVERAGEIF, COUNTIF, etc. function in that the arithmetic calculation is performed based on what rows meet the filter criterias (and yes there can be more than one).
How is previewing a CSV file before loading it different than previewing an Excel file?
The CSV preview allows controlling the data type detection.
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.
What must you do if you want users to see a tile using a QR code you shared with them?
Share your dashboard with users whom you want to see the tile.
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.
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.
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
You are conducting a large meeting in which you want to make a presentation of a report on a screen. How can you do this with the Windows app?
Switch to full screen in the application so you will automatically go into Presentation mode, which displays all your visualizations.
Custom territories is one of the new features of Tableau 10.
TRUE
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
You can use the plus sign (+) to add days to a date.
TRUE
You want to embed a report in SharePoint Online. Before you actually embed the report, what must you add to SharePoint?
a web part
Which of the following is true about Tableau data extracts?
all of these answers: they enable a fast user experience they are created by right-clicking the data source to be effective they need time stamps to be included in the title
Specific initial actions taken with prescriptive analytics is driven by _____.
business rules
Which of the following is a valid base for logarithms?
2
How does a DAX measure filter compared to actually manually filtering data?
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.
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.
Which statement is false regarding the applied steps showing in Power Query Editor?
Adding a step immediately changes the underlying data source.
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.
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.
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.
What is a shortcoming of traditional business intelligence?
It only provides a dimensional analysis of facts.
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.
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.
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.
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
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.
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.
Which data type is used to store text values?
String
When connecting to a data source in Power BI, _____ is found under the Databases category and _____ is found under Online Services.
Sybase; GitHub
Both predictive and discovery analytics are used in forming hypotheses.
TRUE
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.
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.
The dataset you are working in is a PivotTable. What will happen if you select the first column, Sales Region, then you click Unpivot Other Columns?
The other columns will change from a PivotTable to rows of data.
Floating legends allow for customized dashboard sizes.
True
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.
To return a zero if a calculation returns a null value, use the _____ function.
ZN
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
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
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
To tell Tableau how to handle any values that don't fit other rules in a CASE statement, use the _____ keyword.
ELSE
How does employing efficient data strategies help the Power BI dashboard developer out
Efficient data strategies allow for the user to work faster, smarter, and with fewer mistakes.
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.
Under which tab can you find the option to add a slicer?
Insert
Which operator returns the remainder from a division operation?
%
Logarithms of base _____ are called common log.
10
Which statement is true regarding slicers?
A slicer can filter at both the page level and the report level.
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 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.
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.
What do you need to consider if you use the BLANK function in Power BI?
BLANK will also pick up values of zero.
You want to allow users inside your organization to share your dashboard, and to edit your dashboard by adding tiles. How will you do this?
By creating a dashboard in a group.
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 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.
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.
To find the first day in a week, use the week date_part value and the _____ function.
DATETRUNC
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.
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
You have a filtered dataset for Customer Sales with some null value rows. You want to remove these rows completely. How will you do this?
Deselect (null) in the pull-down menu for Customer Sales in the Power Query Editor.
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.
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.
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
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
What will happen if the user tries to append data where the names of the columns/fields do not match?
If the user tries to append data where the names of the columns/field do not match, then the columns will not append together, even if the names of the columns in the appended tables are very similar.
You are creating a Pivot Table for quarterly sales. Which advice should you keep in mind if you create a Pivot Table from a data list rather than from an Excel table?
If you add a row or a column, the change will not be added to the Pivot Table.
The Pivot Table for purchases you created was from an external data source. How can you drill down to see the data values for the individual purchase orders of packing boxes in Quarter 2?
If you double-click on the cell, a new worksheet will open and you will see the data for all your purchase orders in Quarter 2.
Your Pivot Table shows purchases by quantity for the five products you bought from ABC Corp. in 2019. How can you see the total dollar purchases for each product?
In Insert Calculated Field, define the formula =Quantity*Unit Price, then click Okay.
What is an advantage of creating a table using a DAX formula rather than importing the table?
In creating a table using a DAX formula instead of importing the table (where this is possible), this saves potentially time consuming and potentially erroneous processes, that are often manually done.
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?
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
In the instance where the user is trying to move the calculated numbers back six month because of delay from processing for example, what is the best way to do this?
In order to move the calculations back six months because of a delay in processing for example, the DATEADD functions like a filter and set up as DATEADD(date field, -6, MONTH).
What is one approach for splitting a column with the following structure into separate state and month categories? State-Date or can be written as WA-1/3/2018 where the state is Washington (abbreviation WA) and the date is January 3, 2018
In order to separate this string of characters into state and month, first split columns by the dash "-" character, and then by the forward slash "/" character, then keep only the month column.
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.
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
What is the most efficient way to get SQL data in Power Query?
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 the month of the year changes from March to April, how does this impact the MTD, QTD, and YTD calculations that can be done using the DAX language?
MTD calculations do not matter because DAX automatically does the calculations that way.
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.
What should you check before changing a text column to a decimal number type?
Negative values use the minus symbol, not a hyphen.
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.
Which of the following is true about Tableau's Top-N Analysis?
Parameters can be used to display a range of Top-N values.
What does the Unpivot feature in a dataset allow you to do?
Retrieve the underlying rows of data from a pivot table
To divide a string into parts based on the occurrence of a specific character, use the _____ function.
SPLIT
Other than creating new query steps, what other programming logic does the M language do?
The M formula language is very similar to the F sharp programming language.
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.
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.
What is the end outcome of transposing a data table?
Transposing tables reflects a table of data across an imaginary axis, and then rotate the table 90 degrees counterclockwise.
Which of these is an advantage prescriptive analytics has over data warehousing and business intelligence regarding data validation?
Validation takes place simultaneously with initial actions taken as result of an event.
What does it mean by saying that all DAX measures are calculated independently?
When DAX measures are calculated independently, this means that in a pivot table of measure calculations (for example) the calculations of the measure is not dependent on other measures or values being in the table.
What happens to the row labels, column label, and data values when a table is unpivoted?
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.
When the DAX measure is evaluated, what is meant by an iteration of the formula?
When evaluating a DAX measure, an iteration of the formula for that pivot coordinate means that the steps for calculating the result of the DAX measure are done and the result returned before moving on to the next pivot coordinate.
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.
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.
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.
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.
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.
How does a dashboard differ from a report?
You can use a natural language query with a dashboard.
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.
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
Which of the following is a URL action option?
hover
What is the central purpose of a Tableau filter?
include or exclude data from a view
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
The Excel regression tool works with which type of relationship between x and y?
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
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
