Chat with AIExam 4: Business Intelligence Bifor Data Analysis
Exam 1: Introduction to Business Analytics24 Questions
Exam 2: Describing the Distribution of a Variable73 Questions
Exam 3: Finding Relationships Among Variables56 Questions
Exam 4: Business Intelligence Bifor Data Analysis62 Questions
Exam 5: Probability and Probability Distributions132 Questions
Exam 6: Decision Making Under Uncertainty79 Questions
Exam 7: Sampling and Sampling Distributions78 Questions
Exam 8: Confidence Interval Estimation60 Questions
Exam 9: Hypothesis Testing70 Questions
Exam 10: Regression Analysis: Estimating Relationships80 Questions
Exam 11: Regression Analysis: Statistical Inference69 Questions
Exam 12: Time Series Analysis and Forecasting95 Questions
Exam 13: Introduction to Optimization Modeling70 Questions
Exam 14: Optimization Models87 Questions
Exam 15: Introduction to Simulation Modeling58 Questions
Exam 16: Simulation Models59 Questions
Exam 17: Data Mining30 Questions
Exam 18: Analysis of Variance and Experimental Design24 Questions
Exam 19: Statistical Process Control24 Questions
Select questions type
Microsoft refers to the role of add-ins such as Power Query and Power Pivot as self-service BI because then people who need to analyze data for their jobs do not need to rely on IT departments,but can perform the analysis themselves.
(True/False)
4.9/5 
(33)
(33) The initial step of correcting problems in a data set before you do any serious analysis is called cleansing data.
(True/False)
4.7/5 (34)
(34) In a many-to-many relationship the linking table will have at least how many foreign keys?
(Multiple Choice)
4.9/5 (28)
(28) The DAX function RELATED is used for which of the following?
(Multiple Choice)
4.9/5 (46)
(46) A foreign key resides in the "one" side of a one-to-many relationship whereas a primary key resides in the "many" side of a one-to many relationship.
(True/False)
4.9/5 (43)
(43) A linking table is a table used to transform a many-to-many relationship between tables into two one-to-many relationships; usually composed mostly of foreign keys.
(True/False)
4.8/5 (37)
(37) When you run a query to import external data into Excel,there are several options as to where to store the data.Which of the following is not one of those options?
(Multiple Choice)
4.9/5 (40)
(40) Which of the following is true of a measure in Power Pivot technology?
(Multiple Choice)
4.9/5 (40)
(40) The query language,Structured Query Language (SQL)enables queries to be carried out,but is only relevant for some relational data base management systems.
(True/False)
4.8/5 (35)
(35) The feature that sets Power Pivot apart from regular Excel pivot tables is the relatively new language,Structured Query Language (SQL)for performing calculations.
(True/False)
4.9/5 (27)
(27) Many software companies offer BI software.What does BI stand for?
(Multiple Choice)
4.8/5 (34)
(34) In a database,the number that provides a unique identifier to a record within the table is called the _____ key.
(Multiple Choice)
4.8/5 (45)
(45) Which of the following is not true about data manipulation within Tableau Public?
(Multiple Choice)
4.8/5 (41)
(41) 
Filters
- Essay(0)
- Multiple Choice(0)
- Short Answer(0)
- True False(0)
- Matching(0)