Business Intelligence Exam 1 Question and Answers

database development life cycle - Answer- initiation analysis design implementation maintenance entity - Answer- aggregation of # of data elements that naturally belong together relationship - Answer- association between 2+ entities that is of particular interest attribute - Answer- each data element cardinality - Answer- number of instances that entity can be associated with each instance of another entity identifiers - Answer- key attributes that identify particular facts in an entity primary key - Answer- attribute that can uniquely ID a complete record within an entity foreign key - Answer- copy of a primary key that exists in another entity in order to form a relationship between the entities OLAP - Answer- user queries system and conducts analysis and examines many data types looks for trends and patterns OLTP - Answer- processes repetitive transactions simple manipulations data visualization - Answer- graphical view of data ID trends web analytics - Answer- clickstream data trail of user activity and browsing patterns BA/BI failures - Answer- cross org projects suck weak sponsor lack BI skills no methodology unmotivated data warehouse - Answer- physical repository where relational data are organized to provide enterprise wide, cleansed data in standardized format data mart - Answer- departmental warehouse that stores only relevant data metadata - Answer- date about data contents of datawarehouse and manner of its use star schema - Answer- central table and outlying tables grain - Answer- highest level of detail in data warehouse data mining - Answer- specific objectives translation data examination refinement and reformulation predictive modeling - Answer- supervised modeling text mining model chosen to predict probability of outcome exploratory analysis - Answer- cluster association rules analyze data sets to summarize main characteristics and seeing what data can tell us beyond formal modeling decision trees - Answer- lay out options to choose between several courses of action delta - Answer- data enterprise leadership targets analysts