Deck 13: Excels Data Model, Power-pivot, and Power View

Question 1

A(n)________ field is created when a formula is typed in the Calculation Area of the PowerPivot window.

A)bidirectional
B)explicit calculated
C)implicit calculated
D)vertical multiple

Answer 1

B

Question 2

One of the primary goals of a dashboard is to ensure that managers have ways to quantifiably measure the progress toward short-term and long-term goals.This is an example of the ________ design concept.

A)Making Sure It Is Well Defined
B)Keeping It Simple
C)Knowing Your Users
D)Defining Crucial KPIs

Answer 2

D

Question 3

The Microsoft ________ is a cloud computing platform offering a variety of features and services to individuals and businesses.

A)Silverlight
B)Azure Marketplace
C)SkyDrive
D)Outlook Live

Answer 3

B

Question 4

All of the following statements are TRUE about business intelligence EXCEPT:

A)Business intelligence is a variety of software applications that are used to analyze an organization's data.
B)The role of BI has increased over the last decade because the amount of data being collected by businesses continues to grow at a rapid rate.
C)The most recent trend, which appears that it will be short-lived, is the desire for digital dashboards.
D)Dashboards provide management with a "big picture" view of the business, usually from multiple perspectives using various charts and other graphical representations.

Question 5

Calculated fields can be extended to become ________.

A)target values
B)status thresholds
C)KPIs
D)base values

Question 6

All of the following statements are TRUE about the basics of dashboard design EXCEPT:

A)Dashboard components typically consist of tables, PivotTables, PivotCharts, conditional formatting, and other features available in Excel.
B)How a dashboard is designed has just as much of an impact on its effectiveness as the data displayed.
C)Dashboards that do not include multi-screen, visually oriented user interfaces are poorly designed.
D)Typically, dashboards are also oriented around specific business activities, such as sales analysis, cash flow, employee productivity, and customer service.

Question 7

In Excel,the ________ is displayed with a graphic providing a visual indicator of the status of the base value compared to the target value.

A)target value
B)status threshold
C)KPI
D)base value

Question 8

All of the following statements are TRUE about the Microsoft Azure Marketplace EXCEPT:

A)There are a variety of categories based on development date and price.
B)One of the many services the Microsoft Azure Marketplace provides is access to very large data sets for use in analysis.
C)There are several data sets available for free, and they can be accessed in the PowerPivot window.
D)Having access to large data sets allows you to explore all the analysis tools available in Excel 2013.

Question 9

All of the following statements are TRUE about the new data model EXCEPT:

A)Data can be added to the data model from a variety of sources.
B)Many organizations store data inside a relational database such as MySQL, Oracle, or a DBMS like Microsoft Access.
C)Most organizations store their data in a relational database in order to ensure their data are secure, accurate, and consistent.
D)Prior to Excel 2010, it would be very complicated and time consuming to integrate relational data into an analysis.

Question 10

All of the following statements are TRUE about the current business drivers for dashboard initiatives EXCEPT ________.

A)the need to recruit the best employees
B)the need to gain visibility into key business processes
C)the need for one view of the business date
D)improved timeliness and accuracy of business decisions

Question 11

A ________ is a calculated field that resolves to a value.

A)target value
B)status threshold
C)vertical multiple
D)base value

Question 12

One of the primary goals of a dashboard is to help the user navigate and interpret a large quantity of data at a glance.This is an example of the ________ design concept.

A)Making Sure It Is Well Defined
B)Keeping It Simple
C)Knowing Your Users
D)Designing with White Space

Question 13

You can increase the success of your dashboard by taking personal preferences into account whenever possible.This is an example of the ________ design concept.

A)Making Sure It Is Well Defined
B)Designing with White Space
C)Knowing Your Users
D)Defining Crucial KPIs

Question 14

Following the ________ model can provide the necessary guidance to creating an effective dashboard.

A)KPI
B)SDLC
C)BI
D)white space

Question 15

One of the primary goals of a dashboard is to stay focused on a specific business problem.This is an example of the ________ design concept.

A)Making Sure It Is Well Defined
B)Keeping It Simple
C)Knowing Your Users
D)Defining Crucial KPIs

Question 16

Which of the following is not a category of DAX functions?

A)Date and Time
B)Information
C)Parent/Child
D)Mathematical and Geometric

Question 17

A ________ can be the aggregate of 2013 Profit or a monthly sales goal that every employee should meet.

A)target value
B)status threshold
C)KPI
D)base value

Question 18

All of the following statements are TRUE about the benefits to using Microsoft Excel to create digital dashboards EXCEPT:

A)Because companies can get free copies of the full version of Excel for all of their employees, leveraging the capabilities of Microsoft Excel is a very cost-effective solution.
B)People will spend less time learning how to use the dashboard and more time getting value from what is displayed.
C)With the appropriate know-how, Excel can be much more flexible in the variety of analytics it can provide in a dashboard than many off-the-shelf solutions.
D)Having the capability of creating your own reporting mechanisms in Excel can reduce your reliance on the IT department's resources.

Question 19

Excel 2013 not only gives you the ability to conduct analyses on data from multiple sources,but you can also do more advanced data modeling ________.

A)with slicers
B)with sparklines
C)in PowerPivot
D)in Silverlight

Question 20

A(n)________ field is a field where a calculation takes place,but a new calculated field is not being created.

A)bidirectional
B)explicit calculated
C)implicit calculated
D)vertical multiple

Question 21

All of the following statements are TRUE about preparing a dashboard for production EXCEPT:

A)Once a dashboard has been designed to meet the business requirements, it is ready for use.
B)Because dashboards are designed for the specific needs of an end user, it is important to ensure once the dashboard contains all the required data that certain protections are in place to avoid accidental deletion of various objects or incorrect modifications.
C)To be able to manipulate Slicers, you must allow users to Edit Objects, which does allow changes to the PivotCharts.
D)It is preferable to hide any unnecessary objects that may distract the user from the dashboard's content.

Question 22

All of the following statements are TRUE about using apps for Office for data visualizations EXCEPT:

A)The apps for Office platform allows app developers to create new and engaging consumer and enterprise experiences within the Office applications.
B)Other apps for Word provide advanced analytic capabilities or data visualizations.
C)An app for Office is essentially a web page that is hosted inside an Office application.
D)An app for Office can be used to extend the functionality of the application.

Question 23

________ are a series of identical charts with the same x- and y-axes but that contain different values.

A)Multiples
B)Vertical multiples
C)Horizontal multiples
D)Bidirectional multiples

Question 24

Which of the following is NOT a pane that is visible when you first insert a Power View report sheet?

A)Silverlight pane
B)Design pane
C)Power View pane
D)Filters pane

Question 25

________ is a powerful tool that creates engaging,interactive user experiences.

A)Sparklines
B)Power View
C)Slicers
D)Silverlight

Question 26

All of the following statements are TRUE about creating PivotTables and PivotCharts with PowerPivot EXCEPT:

A)PowerPivot gives you the same options as a Pivot Table except you can use relational data to build it.
B)PivotTables and PivotCharts are a major component in any dashboard.
C)PivotTables and PivotCharts can be created with data from multiple sources without any additional software or add-ins as long as it is relational data.
D)Not only can you create a single PivotTable or PivotChart on a worksheet with PowerPivot, but you can also create a PivotTable and PivotChart on the same worksheet as well as two PivotCharts arranged vertically or horizontally, or four PivotCharts on the same worksheet.

Question 27

Digital dashboards are mechanisms that deliver business intelligence in tabular form.

Question 28

A typical manager engages in over 300 different tasks and decisions each day.

Question 29

________ will expand across the width of the container and wrap down the container in the available space and a vertical scroll bar may also be added.

A)Multiples
B)Vertical multiples
C)Horizontal multiples
D)Bidirectional multiples

Question 30

________ expand across the available space in the container,and if additional space is needed a horizontal scroll bar is added.

A)Multiples
B)Vertical multiples
C)Horizontal multiples
D)Bidirectional multiples

Question 31

The temperature for storing a particular product where damage could occur if the temperature gets too cold or too hot is an example of a ________.

A)positive KPI
B)negative KPI
C)KPI
D)bidirectional KPI

Question 32

A company's profit is an example of a ________.

A)positive KPI
B)negative KPI
C)KPI
D)bidirectional KPI

Question 33

The role of BI has increased over the last decade because the amount of data being collected by businesses continues to grow at a rapid rate.

Question 34

If a company is using a previous version of Excel without PowerPivot,they can use Conditional Formatting ________ instead to indicate proximity to various KPI goals.

A)Highlight Cells Rules
B)Data Bars
C)Color Scales
D)Icon Sets

Question 35

The number of sick days in a specific time period is an example of a ________.

A)positive KPI
B)negative KPI
C)KPI
D)bidirectional KPI

Question 36

According to Aberdeen Group,Inc.,the top factor driving dashboard initiatives is the need for one view of the business date at 37%.

Question 37

________ is an interactive data visualization,exploration,and presentation experience that encourages the creation of ad-hoc reports.

A)PivotTable
B)Power View
C)PowerPivot
D)PivotChart

Question 38

All of the following statements are TRUE about Power View EXCEPT:

A)Power View reports are created from data that have been added to the data model.
B)Power View uses metadata in the data model to understand the relationships between the different tables and fields used in the report.
C)Power View also allows for easy sorting of data and switching to full-screen mode for some visualizations.
D)Sparklines allow you to easily filter the data in multiple visualizations.

Question 39

________,or miniature charts,provide a way to graphically summarize a row or column of data in a single cell.

A)PivotChart
B)Sparklines
C)PowerPivot
D)Silverlight

Question 40

The ________ window has options to create multiple PivotCharts on the same worksheet using data from all connected data sources.

A)PivotTable
B)Power View
C)PowerPivot
D)PivotChart

Question 41

When naming cells,avoid names that have already been given to calculated columns within the same workbook.

Question 42

The systems development life cycle (SDLC)provides a structure for managing complex IT projects.

Question 43

A bidirectional KPI is when the greater the value the better the KPI,such as a company's profit.

Question 44

A target value is a calculated field that resolves to a value.

Question 45

If users cannot easily interpret your dashboard,then you may have made it too complicated.

Question 46

Successful dashboards should help summarize complex data so users can interpret the information at a glance.

Question 47

An implicit calculated field is created when a formula is typed in the Calculation Area of the PowerPivot window.

Question 48

A positive KPI is when the value becomes worse as it deviates too far from the target value in either direction.

Question 49

The Microsoft Azure Marketplace is a cloud computing platform offering a variety of features and services to individuals and businesses.

Question 50

PowerPivot allows you to create calculated columns,calculated fields,and establish KPIs all outside of Excel.

Question 51

A base value can either be another calculated field that resolves to a value or an absolute value.

Question 52

A data model is a collection of tables and their relationships reflecting the real-world relationships between business functions and processes.

Question 53

A status threshold is defined by the range between a high and low value.

Question 54

An explicit calculated field is created when you drag a field like Sales or Quantity Sold into the Values area of a PivotTable.

Question 55

Calculated Fields can be created in any of the cells in the Calculation Area of the PowerPivot window.

Question 56

You can increase the success of your dashboard by taking personal preferences into account whenever possible.

Question 57

A KPI is a quantifiable measure that helps managers define progress toward both short-term and long-term goals.

Question 58

White space is white and void of content.

Question 59

A negative KPI is when the greater the value the worse the KPI,such as the number of sick days in a specific time period.

Question 60

As a general rule,the less defined you can make your dashboard theme,the more useful your users will find it.

Question 61

Tiles provide a dynamic navigation strip allowing you to navigate through a series of charts based on a particular value

Question 62

A(n)________ value is a calculated field that resolves to a value.

Question 63

A(n)________ is a quantifiable measure that helps managers define progress toward both short-term and long-term goals.

Question 64

The ________ provides a structure for managing complex IT projects.

Question 65

A(n)________ calculated field is created when a formula is typed in the Calculation Area of the PowerPivot window.

Question 66

Because dashboards are designed for the specific needs of an end user,it is important to ensure once the dashboard contains all the required data that certain protections are in place to avoid accidental deletion of various objects or incorrect modifications.

Question 67

The Microsoft Azure ________ is a cloud computing platform offering a variety of features and services to individuals and businesses.

Question 68

You can expand and collapse the ribbon by pressing Alt+F1.

Question 69

There are three different types of sparklines: line,pie,and win/loss.

Question 70

Sparklines provide a way to graphically summarize a row or column of data in a single cell.

Question 71

An app for Office is essentially a web page that is hosted inside an Office application.

Question 72

A(n)________ is a collection of tables and their relationships reflecting the real-world relationships between business functions and processes.

Question 73

To be able to manipulate Slicers,you must allow users to Edit Objects,which does allow changes to the PivotCharts.

Question 74

A(n)________ calculated field is created when you drag a field like Sales or Quantity Sold into the Values area of a PivotTable.

Question 75

The role of ________ has increased over the last decade because the amount of data being collected by businesses continues to grow at a rapid rate.

Question 76

The Bing Maps app is more accurate if the state abbreviation is used as opposed to the full name of the state.

Question 77

A typical manager engages in over ________ different tasks and decisions each day.

Question 78

Power View is an interactive data visualization,exploration,and presentation experience that encourages the creation of ad-hoc reports.

Question 79

Successful ________ should help summarize complex data so users can interpret the information at a glance.

Question 80

Once a dashboard has been designed to meet the business requirements,there are several steps you need to take to get it ready for use.