Analyzing and Visualizing Data with Excel Flashcards
Which version of Excel was the Excel Data Model FIRST introduced??
2010
In the Diagram view of the Excel data model, what does a line between two tables represent?
Table relationship
When you create a calculated column on a table in the Excel data model, which two sources of data can the calculated column be based on?
You can create a calculated column in the Excel data model based on data in the current table or on data in another table that is related to the current table.
Which two type of relationships are supported in the Excel data model?
- One-to-one
- One-to-many
WHAT IS DAX?
Data Analysis Expressions (DAX) is a collection of functions, operators, and constants that can be used in a formula, or expression, to calculate and return one or more values. Stated more simply, DAX helps you create new information from data already in your model.
In which two locations can you use Data Analysis Expression (DAX)?
You can use DAX in calculated columns and measures
What are measures in Excel?
Measures in Excel is a calculation created for the purpose of measuring an outcome or result relative to other factors.
Which statement describes an implicit measure?
An implicit measure is one that Excel generates for you when you add fields to the Values area of a pivot table.
Which statement describes an explicit measure?
An explicit measure is a measure that you manually create.
What does the RELATED function (DAX) return?
The RELATED function returns a single value that is related to the current row from another table.
What are two ways of loading data into Excel by using queries in Excel 2016?
You can load data to Excel table and/or to Excel data model.
Where are data pre-processing steps recorded in the Query Editor?
The pre-processing steps are recorded in the list of Applied Steps section in the Query Editor.
Using the Replace Values step, how many distinct values can be replaced at a time?
You can replace one distinct value at a time using the Replace Values step.
Which are two purposes of using a calendar table in a data model?
- To filter by year, month, or week.
- To perform advanced calculations such as year-over-year comparison.
Which are two ways to create a calendar table in Excel 2016 that will be used with the data model?
- Create a calendar table in the worksheet and add it to the Excel data model.
- Use the New Date Table function from the Design tab of the Power Pivot for Excel window.