EDX - Analyzing and Visualizing Data with Excel

Which version of Excel was the Excel Data Model FIRST introduced??

2010

Which statement describes an explicit measure?

An explicit measure is a measure that you manually create.

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 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.

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.

You are importing data from four CSV files that are located in the same folder. All four of the CSV files have the same file structure. You are using the "From folder" option of the query. What is the initial step you need to do in the Query Editor before loading the data into the Excel data model?

If all four CSV files have headers, the first step you typically do is to remove the headers from the other three CSV files.

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 two type of relationships are supported in the Excel data model?

One-to-one One-to-many

In the Diagram view of the Excel data model, what does a line between two tables represent?

Table relationship

What does the RELATED function (DAX) return?

The RELATED function returns a single value that is related to the current row from another table.

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.

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

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.

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.

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.

In which two locations can you use Data Analysis Expression (DAX)?

You can use DAX in calculated columns and measures