FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 11: Analyzing Data With Business Intelligence

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 31

True/False

Review LaterAdd Note

Review Later

A data connection is like a pipeline from a data source to two or more locations in the workbook.

Correct Answer

verified

Show Answer

Question 32

Multiple Choice

Review LaterAdd Note

Review Later

You relate tables to one another by using _______ fields.

A)  key
B)  common 
C)  indexed
D)  date

Correct Answer

verified

Show Answer

Question 33

True/False

Review LaterAdd Note

A scatterline is a line fitted to a scatter chart showing the relationship between two numerical variables.

_______ is a database program.

Audra is a manager in the Sales Department for Creative Pastry Gadgets.She needs access to up-to-date financial data and sales reports.Some of this information comes from Excel workbooks,but other information is stored in other software programs.In addition,Creative Pastry Gadgets maintains a database with detailed financial information and sales figures.Audra uses Excel to analyze data from external data sources.​To prevent other users from updating a data source without permission,what should Audra do? 

One way to interact with a database is with a query language.The most popular query language is _______.

The Query Editor also includes tools to:​ 

A ________ is a highly structured collection of data values organized into separate tables.​ 

Power and Exponential trendlines cannot be used if the data contains zero or negative values.​ 

All steps in Power Query are written in the language P.

A delimiter is a symbol that separates one column of data from another.

When no arrow connects a table to any of the other tables in the data model,there is no way to match the records of that table with the other tables.

Which of the following is not a type of trendline?​ 

Power Query is a BI tool used for writing queries to almost any kind of data source,from text files to websites to large database structures.​ 

Most software programs can both save and retrieve data in a(n) _______ file format.

A __________ is a slicer that is applied to date fields.Using the timeline,you can summarize the data for ranges of time intervals from years down to minutes and seconds.​ 

One advantage of forecast sheets is that they can be used to analyze annual data in which the values follow a periodic pattern throughout the calendar year.​ 

When you create a grouping,the query editor adds a new column to summarize the numeric values within each group by calculating the:​ 

Power Map data is placed in tables,which are superimposed on the map.​ 

Database tables can be inserted directly into PivotCharts and PivotFigures.​​