Exam 2- Final Flashcards
The VBA Environment
P. 141
What does VBA stand for?
Visual basics for applications p. 141
What are the 2 types of coding mistakes?
Syntax errors and logic errors. p. 143
Which kind of coding mistake is less often caught by the syntax checker?
logical mistakes p. 144
Dim is short for
dimension
Why should you avoid the variant data type?
It increases processing time because the interpreter must take extra steps to figure out what type of data is stored in the variable. p. 147
T/F You must use Dim as for each variable you declare
True You can do Dim J,K,L as long It has to be Dim J as long, K as long, L as long p. 148
What does typing option explicit at the top of your module do?
Forces you to declare variables. (Helps you avoid errors)
p. 148
Workbook Navigation
p. 162
What are the 2 types of objects?
Data-centric objects
Tool-centric objects
p. 162
What is the difference between data-centric objects and tool-centric objects?
Data-centric objects contain data and a set of predefined methods that manipulate the data. (Range of cells, worksheet, a cell)
Tool-centric objects are tools with specific functionality that can be added to a workbook (button, text box)
p.162
In workbook navigation, what are methods?
A set of predefined actions that can be performed on the data contained in the object. p. 162
In workbook navigation, what are properties?
Characteristics of an object. p.162
What 2 kinds of databases are there?
operational and analytical
BI slides
Which kind of database is used for daily business process, accounting, reports?
operational
BI slides
What is data mining?
Predicting the future
BI slides
What is the difference between a data warehouse and a data mart?
A data warehouse has an enterprisewide organizational focus, while a data mart focuses on a subset of information for a given business unit such as finance
BI Slides
What are the 2 primary tools to summarize data and characterize present status in BI?
Cubes
Dashboards
BI slides
What is the common term for the representation of multidimensional information?
Cubes
BI slide 10
What is a small scale, offline version of a data cube?
Excel pivot tables?
BI slide 11
___ allow users (typically managers) to get a high level overview of the organization’s “health” or current status—as told by the data being gathered.
Dashboards
BI slide 12
The data points included in the dashboard are referred to as
Key performance indicators
BI slide 12
Common forms of data-mining analysis capabilities include (5)
Cluster analysis Association detection Statistical analysis Key influencers analysis Time series forecasts
Bi Slide 13
___ is a technique used to divide an information set into mutually exclusive groups such that the members of each group are as close together as possible to one another and the different groups are as far apart as possible
Cluster analysis
Bi slide 15
___ reveals the degree to which variables are related and the nature and frequency of these relationships in the information
Association detection
BI slide 16
___ analyzes such items as Web sites and checkout scanner information to detect customers’ buying behavior and predict future behavior by identifying affinities among customers’ choices of products and services
Market basket analysis
BI slide 16
___ are the factors that can significantly predict (to some degree between 0-100%) or explain the variance in another factor.
key influencers
Bi slide 17
___ is a process that weeds out and fixes or discards inconsistent, incorrect, or incomplete info
Data cleaning
Bi slide 21
A ___ process is program code that is executed at specified intervals (every minute, hour, day, week, month) to
Copy the data from operational DBs and external sources
Clean the data
Insert it into the data warehouse
ETL
BI slide 22
