Question 1

Two things you can do in the Power Pivot window is add calculated columns and add measures using DAX formulas.

Accepted Answer

A) True 
 B)False

Question 2

Which of the following is not an important strength of Power Query relative to the previous Excel importing tools?

Accepted Answer

A) It lets you choose the type of graphical display that best suits the data. 
B) You can import data from more sources than before. 
C) Once you locate data of interest,you can use the new Query Editor to "shape" the data to be imported. 
D) Your queries are stored in step-by-step fashion so that they can be modified and reused later. 
A) It lets you choose the type of graphical display that best suits the data. 
B) You can import data from more sources than before. 
C) Once you locate data of interest,you can use the new Query Editor to "shape" the data to be imported. 
D) Your queries are stored in step-by-step fashion so that they can be modified and reused later.

Two things you can do in the Power Pivot window is add calculated columns and add measures using DAX formulas.

Which of the following is not an important strength of Power Query relative to the previous Excel importing tools?

Introduction to Business Analytics

Describing the Distribution of a Variable

Finding Relationships Among Variables

Probability and Probability Distributions

Decision Making Under Uncertainty

Sampling and Sampling Distributions

Confidence Interval Estimation

Hypothesis Testing

Regression Analysis: Estimating Relationships

Regression Analysis: Statistical Inference

Time Series Analysis and Forecasting

Introduction to Optimization Modeling

Optimization Models

Introduction to Simulation Modeling

Simulation Models

Data Mining

Analysis of Variance and Experimental Design

Statistical Process Control

Filters

Exam 4: Business Intelligence Bifor Data Analysis

Two things you can do in the Power Pivot window is add calculated columns and add measures using DAX formulas.

Which of the following is not an important strength of Power Query relative to the previous Excel importing tools?

Introduction to Business Analytics

Describing the Distribution of a Variable

Finding Relationships Among Variables

Probability and Probability Distributions

Decision Making Under Uncertainty

Sampling and Sampling Distributions

Confidence Interval Estimation

Hypothesis Testing

Regression Analysis: Estimating Relationships

Regression Analysis: Statistical Inference

Time Series Analysis and Forecasting

Introduction to Optimization Modeling

Optimization Models

Introduction to Simulation Modeling

Simulation Models

Data Mining

Analysis of Variance and Experimental Design

Statistical Process Control

Filters