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

ملء الشاشة (f)
exit full mode
سؤال
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
استخدم زر المسافة أو
up arrow
down arrow
لقلب البطاقة.
سؤال
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
سؤال
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
سؤال
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.
سؤال
Calculated fields can be extended to become ________.

A)target values
B)status thresholds
C)KPIs
D)base values
سؤال
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.
سؤال
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
سؤال
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.
سؤال
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.
سؤال
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
سؤال
A ________ is a calculated field that resolves to a value.

A)target value
B)status threshold
C)vertical multiple
D)base value
سؤال
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
سؤال
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
سؤال
Following the ________ model can provide the necessary guidance to creating an effective dashboard.

A)KPI
B)SDLC
C)BI
D)white space
سؤال
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
سؤال
Which of the following is not a category of DAX functions?

A)Date and Time
B)Information
C)Parent/Child
D)Mathematical and Geometric
سؤال
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
سؤال
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.
سؤال
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
سؤال
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
سؤال
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.
سؤال
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.
سؤال
________ 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
سؤال
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
سؤال
________ is a powerful tool that creates engaging,interactive user experiences.

A)Sparklines
B)Power View
C)Slicers
D)Silverlight
سؤال
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.
سؤال
Digital dashboards are mechanisms that deliver business intelligence in tabular form.
سؤال
A typical manager engages in over 300 different tasks and decisions each day.
سؤال
________ 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
سؤال
________ 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
سؤال
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
سؤال
A company's profit is an example of a ________.

A)positive KPI
B)negative KPI
C)KPI
D)bidirectional KPI
سؤال
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.
سؤال
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
سؤال
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
سؤال
According to Aberdeen Group,Inc.,the top factor driving dashboard initiatives is the need for one view of the business date at 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
سؤال
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.
سؤال
________,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
سؤال
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
سؤال
When naming cells,avoid names that have already been given to calculated columns within the same workbook.
سؤال
The systems development life cycle (SDLC)provides a structure for managing complex IT projects.
سؤال
A bidirectional KPI is when the greater the value the better the KPI,such as a company's profit.
سؤال
A target value is a calculated field that resolves to a value.
سؤال
If users cannot easily interpret your dashboard,then you may have made it too complicated.
سؤال
Successful dashboards should help summarize complex data so users can interpret the information at a glance.
سؤال
An implicit calculated field is created when a formula is typed in the Calculation Area of the PowerPivot window.
سؤال
A positive KPI is when the value becomes worse as it deviates too far from the target value in either direction.
سؤال
The Microsoft Azure Marketplace is a cloud computing platform offering a variety of features and services to individuals and businesses.
سؤال
PowerPivot allows you to create calculated columns,calculated fields,and establish KPIs all outside of Excel.
سؤال
A base value can either be another calculated field that resolves to a value or an absolute value.
سؤال
A data model is a collection of tables and their relationships reflecting the real-world relationships between business functions and processes.
سؤال
A status threshold is defined by the range between a high and low value.
سؤال
An explicit calculated field is created when you drag a field like Sales or Quantity Sold into the Values area of a PivotTable.
سؤال
Calculated Fields can be created in any of the cells in the Calculation Area of the PowerPivot window.
سؤال
You can increase the success of your dashboard by taking personal preferences into account whenever possible.
سؤال
A KPI is a quantifiable measure that helps managers define progress toward both short-term and long-term goals.
سؤال
White space is white and void of content.
سؤال
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.
سؤال
As a general rule,the less defined you can make your dashboard theme,the more useful your users will find it.
سؤال
Tiles provide a dynamic navigation strip allowing you to navigate through a series of charts based on a particular value
سؤال
A(n)________ value is a calculated field that resolves to a value.
سؤال
A(n)________ is a quantifiable measure that helps managers define progress toward both short-term and long-term goals.
سؤال
The ________ provides a structure for managing complex IT projects.
سؤال
A(n)________ calculated field is created when a formula is typed in the Calculation Area of the PowerPivot window.
سؤال
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.
سؤال
The Microsoft Azure ________ is a cloud computing platform offering a variety of features and services to individuals and businesses.
سؤال
You can expand and collapse the ribbon by pressing Alt+F1.
سؤال
There are three different types of sparklines: line,pie,and win/loss.
سؤال
Sparklines provide a way to graphically summarize a row or column of data in a single cell.
سؤال
An app for Office is essentially a web page that is hosted inside an Office application.
سؤال
A(n)________ is a collection of tables and their relationships reflecting the real-world relationships between business functions and processes.
سؤال
To be able to manipulate Slicers,you must allow users to Edit Objects,which does allow changes to the PivotCharts.
سؤال
A(n)________ calculated field is created when you drag a field like Sales or Quantity Sold into the Values area of a PivotTable.
سؤال
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.
سؤال
The Bing Maps app is more accurate if the state abbreviation is used as opposed to the full name of the state.
سؤال
A typical manager engages in over ________ different tasks and decisions each day.
سؤال
Power View is an interactive data visualization,exploration,and presentation experience that encourages the creation of ad-hoc reports.
سؤال
Successful ________ should help summarize complex data so users can interpret the information at a glance.
سؤال
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.
فتح الحزمة
قم بالتسجيل لفتح البطاقات في هذه المجموعة!
Unlock Deck
Unlock Deck
1/96
auto play flashcards
العب
simple tutorial
ملء الشاشة (f)
exit full mode
Deck 13: Excels Data Model, Power-pivot, and Power View
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
B
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
D
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
B
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.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 96 في هذه المجموعة.
فتح الحزمة
k this deck
5
Calculated fields can be extended to become ________.

A)target values
B)status thresholds
C)KPIs
D)base values
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 96 في هذه المجموعة.
فتح الحزمة
k this deck
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.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 96 في هذه المجموعة.
فتح الحزمة
k this deck
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
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 96 في هذه المجموعة.
فتح الحزمة
k this deck
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.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 96 في هذه المجموعة.
فتح الحزمة
k this deck
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.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 96 في هذه المجموعة.
فتح الحزمة
k this deck
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
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 96 في هذه المجموعة.
فتح الحزمة
k this deck
11
A ________ is a calculated field that resolves to a value.

A)target value
B)status threshold
C)vertical multiple
D)base value
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 96 في هذه المجموعة.
فتح الحزمة
k this deck
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
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 96 في هذه المجموعة.
فتح الحزمة
k this deck
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
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 96 في هذه المجموعة.
فتح الحزمة
k this deck
14
Following the ________ model can provide the necessary guidance to creating an effective dashboard.

A)KPI
B)SDLC
C)BI
D)white space
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 96 في هذه المجموعة.
فتح الحزمة
k this deck
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
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 96 في هذه المجموعة.
فتح الحزمة
k this deck
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
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 96 في هذه المجموعة.
فتح الحزمة
k this deck
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
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 96 في هذه المجموعة.
فتح الحزمة
k this deck
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.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 96 في هذه المجموعة.
فتح الحزمة
k this deck
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
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 96 في هذه المجموعة.
فتح الحزمة
k this deck
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
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 96 في هذه المجموعة.
فتح الحزمة
k this deck
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.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 96 في هذه المجموعة.
فتح الحزمة
k this deck
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.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 96 في هذه المجموعة.
فتح الحزمة
k this deck
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
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 96 في هذه المجموعة.
فتح الحزمة
k this deck
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
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 96 في هذه المجموعة.
فتح الحزمة
k this deck
25
________ is a powerful tool that creates engaging,interactive user experiences.

A)Sparklines
B)Power View
C)Slicers
D)Silverlight
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 96 في هذه المجموعة.
فتح الحزمة
k this deck
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.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 96 في هذه المجموعة.
فتح الحزمة
k this deck
27
Digital dashboards are mechanisms that deliver business intelligence in tabular form.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 96 في هذه المجموعة.
فتح الحزمة
k this deck
28
A typical manager engages in over 300 different tasks and decisions each day.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 96 في هذه المجموعة.
فتح الحزمة
k this deck
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
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 96 في هذه المجموعة.
فتح الحزمة
k this deck
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
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 96 في هذه المجموعة.
فتح الحزمة
k this deck
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
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 96 في هذه المجموعة.
فتح الحزمة
k this deck
32
A company's profit is an example of a ________.

A)positive KPI
B)negative KPI
C)KPI
D)bidirectional KPI
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 96 في هذه المجموعة.
فتح الحزمة
k this deck
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.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 96 في هذه المجموعة.
فتح الحزمة
k this deck
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
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 96 في هذه المجموعة.
فتح الحزمة
k this deck
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
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 96 في هذه المجموعة.
فتح الحزمة
k this deck
36
According to Aberdeen Group,Inc.,the top factor driving dashboard initiatives is the need for one view of the business date at 37%.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 96 في هذه المجموعة.
فتح الحزمة
k this deck
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
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 96 في هذه المجموعة.
فتح الحزمة
k this deck
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.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 96 في هذه المجموعة.
فتح الحزمة
k this deck
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
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 96 في هذه المجموعة.
فتح الحزمة
k this deck
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
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 96 في هذه المجموعة.
فتح الحزمة
k this deck
41
When naming cells,avoid names that have already been given to calculated columns within the same workbook.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 96 في هذه المجموعة.
فتح الحزمة
k this deck
42
The systems development life cycle (SDLC)provides a structure for managing complex IT projects.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 96 في هذه المجموعة.
فتح الحزمة
k this deck
43
A bidirectional KPI is when the greater the value the better the KPI,such as a company's profit.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 96 في هذه المجموعة.
فتح الحزمة
k this deck
44
A target value is a calculated field that resolves to a value.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 96 في هذه المجموعة.
فتح الحزمة
k this deck
45
If users cannot easily interpret your dashboard,then you may have made it too complicated.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 96 في هذه المجموعة.
فتح الحزمة
k this deck
46
Successful dashboards should help summarize complex data so users can interpret the information at a glance.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 96 في هذه المجموعة.
فتح الحزمة
k this deck
47
An implicit calculated field is created when a formula is typed in the Calculation Area of the PowerPivot window.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 96 في هذه المجموعة.
فتح الحزمة
k this deck
48
A positive KPI is when the value becomes worse as it deviates too far from the target value in either direction.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 96 في هذه المجموعة.
فتح الحزمة
k this deck
49
The Microsoft Azure Marketplace is a cloud computing platform offering a variety of features and services to individuals and businesses.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 96 في هذه المجموعة.
فتح الحزمة
k this deck
50
PowerPivot allows you to create calculated columns,calculated fields,and establish KPIs all outside of Excel.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 96 في هذه المجموعة.
فتح الحزمة
k this deck
51
A base value can either be another calculated field that resolves to a value or an absolute value.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 96 في هذه المجموعة.
فتح الحزمة
k this deck
52
A data model is a collection of tables and their relationships reflecting the real-world relationships between business functions and processes.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 96 في هذه المجموعة.
فتح الحزمة
k this deck
53
A status threshold is defined by the range between a high and low value.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 96 في هذه المجموعة.
فتح الحزمة
k this deck
54
An explicit calculated field is created when you drag a field like Sales or Quantity Sold into the Values area of a PivotTable.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 96 في هذه المجموعة.
فتح الحزمة
k this deck
55
Calculated Fields can be created in any of the cells in the Calculation Area of the PowerPivot window.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 96 في هذه المجموعة.
فتح الحزمة
k this deck
56
You can increase the success of your dashboard by taking personal preferences into account whenever possible.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 96 في هذه المجموعة.
فتح الحزمة
k this deck
57
A KPI is a quantifiable measure that helps managers define progress toward both short-term and long-term goals.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 96 في هذه المجموعة.
فتح الحزمة
k this deck
58
White space is white and void of content.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 96 في هذه المجموعة.
فتح الحزمة
k this deck
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.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 96 في هذه المجموعة.
فتح الحزمة
k this deck
60
As a general rule,the less defined you can make your dashboard theme,the more useful your users will find it.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 96 في هذه المجموعة.
فتح الحزمة
k this deck
61
Tiles provide a dynamic navigation strip allowing you to navigate through a series of charts based on a particular value
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 96 في هذه المجموعة.
فتح الحزمة
k this deck
62
A(n)________ value is a calculated field that resolves to a value.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 96 في هذه المجموعة.
فتح الحزمة
k this deck
63
A(n)________ is a quantifiable measure that helps managers define progress toward both short-term and long-term goals.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 96 في هذه المجموعة.
فتح الحزمة
k this deck
64
The ________ provides a structure for managing complex IT projects.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 96 في هذه المجموعة.
فتح الحزمة
k this deck
65
A(n)________ calculated field is created when a formula is typed in the Calculation Area of the PowerPivot window.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 96 في هذه المجموعة.
فتح الحزمة
k this deck
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.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 96 في هذه المجموعة.
فتح الحزمة
k this deck
67
The Microsoft Azure ________ is a cloud computing platform offering a variety of features and services to individuals and businesses.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 96 في هذه المجموعة.
فتح الحزمة
k this deck
68
You can expand and collapse the ribbon by pressing Alt+F1.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 96 في هذه المجموعة.
فتح الحزمة
k this deck
69
There are three different types of sparklines: line,pie,and win/loss.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 96 في هذه المجموعة.
فتح الحزمة
k this deck
70
Sparklines provide a way to graphically summarize a row or column of data in a single cell.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 96 في هذه المجموعة.
فتح الحزمة
k this deck
71
An app for Office is essentially a web page that is hosted inside an Office application.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 96 في هذه المجموعة.
فتح الحزمة
k this deck
72
A(n)________ is a collection of tables and their relationships reflecting the real-world relationships between business functions and processes.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 96 في هذه المجموعة.
فتح الحزمة
k this deck
73
To be able to manipulate Slicers,you must allow users to Edit Objects,which does allow changes to the PivotCharts.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 96 في هذه المجموعة.
فتح الحزمة
k this deck
74
A(n)________ calculated field is created when you drag a field like Sales or Quantity Sold into the Values area of a PivotTable.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 96 في هذه المجموعة.
فتح الحزمة
k this deck
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.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 96 في هذه المجموعة.
فتح الحزمة
k this deck
76
The Bing Maps app is more accurate if the state abbreviation is used as opposed to the full name of the state.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 96 في هذه المجموعة.
فتح الحزمة
k this deck
77
A typical manager engages in over ________ different tasks and decisions each day.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 96 في هذه المجموعة.
فتح الحزمة
k this deck
78
Power View is an interactive data visualization,exploration,and presentation experience that encourages the creation of ad-hoc reports.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 96 في هذه المجموعة.
فتح الحزمة
k this deck
79
Successful ________ should help summarize complex data so users can interpret the information at a glance.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 96 في هذه المجموعة.
فتح الحزمة
k this deck
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.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 96 في هذه المجموعة.
فتح الحزمة
k this deck
locked card icon
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 96 في هذه المجموعة.