Question 1

A Key Performance Indicator (KPI) is a measure of how well an organization is achieving its most important business objectives. Identify at least three.

Accepted Answer

Answers will vary.
KPIs includ

Question 2

Using Power BI, you can create a new variable from existing variables as long as

Accepted Answer

A)  the new variable is created from variables that exist either in the same data table or data tables that are related with no restriction on how many variables can be combined. 
B)  the new variable is created from new information. 
C)  the new variable is created from existing variables from unrelated data tables. 
D)  the new variable is created from existing variables either in the same data table or data tables that are related with the restriction that no more than two variables can be combined. 
A)  the new variable is created from variables that exist either in the same data table or data tables that are related with no restriction on how many variables can be combined. 
B)  the new variable is created from new information. 
C)  the new variable is created from existing variables from unrelated data tables. 
D)  the new variable is created from existing variables either in the same data table or data tables that are related with the restriction that no more than two variables can be combined.

Question 3

For multiple tables that are related, Power BI can draw from two or more of them at the same time to create

Accepted Answer

A)  visualization tiles. 
B)  reports. 
C)  dashboards. 
D)  All of the above 
A)  visualization tiles. 
B)  reports. 
C)  dashboards. 
D)  All of the above

Question 4

Business intelligence is the process of collecting data from inside or outside an organization that are thought to relate to or influence the performance of the organization.

Accepted Answer

A) True 
 B)False

Question 5

Dashboards display real-time graphic and numerical displays where most commonly, the most important information is the largest visual and most often displayed on the lower corner.

Accepted Answer

A) True 
 B)False

Question 6

Visualizations in Power BI can include the following:

Accepted Answer

A)  Maps 
B)  Tables 
C)  Charts 
D)  All of the above 
A)  Maps 
B)  Tables 
C)  Charts 
D)  All of the above

Question 7

High-level key performance indicator (KPIs) measure the success of an organization's subunits (departments, centers, etc.) while low-level KPIs measure the overall performance of the organization.

Accepted Answer

A) True 
 B)False

Question 8

Predictive analytics is restricted to business forecasting.

Accepted Answer

A) True 
 B)False

Question 9

Thanks to predictive analytics, a retail grocer has a better idea of who his customers are, in terms of behavior and spending power, which can be aligned with promotional campaigns.

Accepted Answer

A) True 
 B)False

Question 10

It is a good idea to include potentially irrelevant data so that the business analytics organization can identify meaningful data and reach proper conclusions.

Accepted Answer

A) True 
 B)False

Question 11

Power BI has five key components. List the components along with a brief description of each.

Accepted Answer

The Power BI key components are:
1. Visu

Question 12

Which of the following are types of data that can be imported into Power BI?

Accepted Answer

A)  a single chart 
B)  html files 
C)  CSV files 
D)  databases including Access, SQL, and Sybase 
A)  a single chart 
B)  html files 
C)  CSV files 
D)  databases including Access, SQL, and Sybase

Question 13

Forecasting methods are applied to data to answer questions about will happen.

Accepted Answer

A) True 
 B)False

Question 14

We define business analytics as the transformation of large and complex data sets into information that is useful for making decisions.

Accepted Answer

A) True 
 B)False

Question 15

One of the disadvantages of business analytics software such as Microsoft Power BI is its inability to pull information from multiple data tables.

Accepted Answer

A) True 
 B)False

Question 16

Business intelligence uses the same methods as business analytics.

Accepted Answer

A) True 
 B)False

Question 17

Fill in the blank: A Power BI report includes ________.

Accepted Answer

A)  single or multiple pages 
B)  visual items that relate to each other 
C)  A & B 
D)  no visual items 
A)  single or multiple pages 
B)  visual items that relate to each other 
C)  A & B 
D)  no visual items

Question 18

We can create new measures in the Power BI desktop from original variables in our data set or from variables that we created earlier. Let's say we need to create a variable in the SalesData table called Order Cost which represents the OrderQty variable from the SalesData table multipled by the StandardCost variable in the related ProductData table. The DAX com-mand to do this is:

Accepted Answer

Order Cost = SalesDa

Question 19

Usually the early output from the business analytics effort generates an "answer".

Accepted Answer

A) True 
 B)False

Question 20

The process of business analytics starts with questions posed by decision makers, followed by more detailed questions until an "answer" is hopefully found.

Accepted Answer

A) True 
 B)False

A Key Performance Indicator (KPI) is a measure of how well an organization is achieving its most important business objectives. Identify at least three.

Using Power BI, you can create a new variable from existing variables as long as

For multiple tables that are related, Power BI can draw from two or more of them at the same time to create

Business intelligence is the process of collecting data from inside or outside an organization that are thought to relate to or influence the performance of the organization.

Dashboards display real-time graphic and numerical displays where most commonly, the most important information is the largest visual and most often displayed on the lower corner.

Visualizations in Power BI can include the following:

High-level key performance indicator (KPIs) measure the success of an organization's subunits (departments, centers, etc.) while low-level KPIs measure the overall performance of the organization.

Predictive analytics is restricted to business forecasting.

Thanks to predictive analytics, a retail grocer has a better idea of who his customers are, in terms of behavior and spending power, which can be aligned with promotional campaigns.

It is a good idea to include potentially irrelevant data so that the business analytics organization can identify meaningful data and reach proper conclusions.

Power BI has five key components. List the components along with a brief description of each.

Which of the following are types of data that can be imported into Power BI?

Forecasting methods are applied to data to answer questions about will happen.

We define business analytics as the transformation of large and complex data sets into information that is useful for making decisions.

One of the disadvantages of business analytics software such as Microsoft Power BI is its inability to pull information from multiple data tables.

Business intelligence uses the same methods as business analytics.

Fill in the blank: A Power BI report includes ________.

Usually the early output from the business analytics effort generates an "answer".

The process of business analytics starts with questions posed by decision makers, followed by more detailed questions until an "answer" is hopefully found.

The Where, Why, and How of Data Collection

Graphs, Charts and Tablesdescribing Your Data

Describing Data Using Numerical Measures

Introduction to Probability

Discrete Probability Distributions

Introduction to Continuous Probability Distributions

Introduction to Sampling Distributions

Estimating Single Population Parameters

Introduction to Hypothesis Testing

Estimation and Hypothesis Testing for Two Population Parameters

Hypothesis Tests and Estimation for Population Variances

Analysis of Variance

Goodness-Of-Fit Tests and Contingency Analysis

Introduction to Linear Regression and Correlation Analysis

Multiple Regression Analysis and Model Building

Analyzing and Forecasting Time-Series Data

Introduction to Nonparametric Statistics

Introduction to Decision Analysis

Introduction to Quality and Statistical Process Control

Filters

Exam 18: Introducing Business Analytics

A Key Performance Indicator (KPI) is a measure of how well an organization is achieving its most important business objectives. Identify at least three.

Using Power BI, you can create a new variable from existing variables as long as

For multiple tables that are related, Power BI can draw from two or more of them at the same time to create

Business intelligence is the process of collecting data from inside or outside an organization that are thought to relate to or influence the performance of the organization.

Dashboards display real-time graphic and numerical displays where most commonly, the most important information is the largest visual and most often displayed on the lower corner.

Visualizations in Power BI can include the following:

High-level key performance indicator (KPIs) measure the success of an organization's subunits (departments, centers, etc.) while low-level KPIs measure the overall performance of the organization.

Predictive analytics is restricted to business forecasting.

Thanks to predictive analytics, a retail grocer has a better idea of who his customers are, in terms of behavior and spending power, which can be aligned with promotional campaigns.

It is a good idea to include potentially irrelevant data so that the business analytics organization can identify meaningful data and reach proper conclusions.

Power BI has five key components. List the components along with a brief description of each.

Which of the following are types of data that can be imported into Power BI?

Forecasting methods are applied to data to answer questions about will happen.

We define business analytics as the transformation of large and complex data sets into information that is useful for making decisions.

One of the disadvantages of business analytics software such as Microsoft Power BI is its inability to pull information from multiple data tables.

Business intelligence uses the same methods as business analytics.

Fill in the blank: A Power BI report includes ________.

Usually the early output from the business analytics effort generates an "answer".

The process of business analytics starts with questions posed by decision makers, followed by more detailed questions until an "answer" is hopefully found.

The Where, Why, and How of Data Collection

Graphs, Charts and Tablesdescribing Your Data

Describing Data Using Numerical Measures

Introduction to Probability

Discrete Probability Distributions

Introduction to Continuous Probability Distributions

Introduction to Sampling Distributions

Estimating Single Population Parameters

Introduction to Hypothesis Testing

Estimation and Hypothesis Testing for Two Population Parameters

Hypothesis Tests and Estimation for Population Variances

Analysis of Variance

Goodness-Of-Fit Tests and Contingency Analysis

Introduction to Linear Regression and Correlation Analysis

Multiple Regression Analysis and Model Building

Analyzing and Forecasting Time-Series Data

Introduction to Nonparametric Statistics

Introduction to Decision Analysis

Introduction to Quality and Statistical Process Control

Filters