Chapter 6 Data: Business Intelligence1) Information granularity refers to the extent of detail within the information (fine and detailed or coarse and2) Information quality refers to the extent of detail within the information (fine and detailed or coarse and3) Organizational information has three characteristics including levels, formats, and granularities.Answer:TRUE4) The four primary traits of the value of information include type, timeliness, quality, and governance.Answer:TRUE5) Organizational information has three characteristics including timeliness, quality, and governance.Answer:FALSE6) The four primary traits of the value of information include levels, formats, granularities, and type.Answer:FALSE7) There are only two main primary traits that help you determine the value of information including timeliness and8) If a manager identifies numerous information integrity issues he should consider the reports generated from that9) Real-time information refers to the extent of detail within the information (fine and detailed or coarse and10) Information granularity means immediate, up-to-date information.Answer:FALSE11) Real-time systems provide real-time information in response to requests.Answer:TRUE12) Information integrity issues occur when the same data element has different values.FALSE13) Information integrity issues occur when a system produces incorrect, inconsistent, or duplicate data.Answer:TRUE14) Data governance refers to the overall management of the availability, usability, integrity, and security of15) Transactional information is used when performing operational tasks and repetitive decisions such as analyzing16) Timely information must be up-to-the-second to be accurate.Answer:FALSE17) Organizational information comes at the same level, formats and granularities.Answer:FALSE18) Reports for each sales person, product, and part are examples of detail or fine information granularities.Answer:TRUE19) Master data management (MDM) is the practice of gathering data and ensuring that it is uniform, accurate,consistent, and complete, including such entities as customers, suppliers, products, sales, employees, and othercritical entities that are commonly integrated across organizational systems. MDM is commonly included in data Show
the extent of detail within the information (fine and detailed or coarse and abstract) 4 primary traits that determine the value of information information type: transactional and analytical information timeliness information quality information governance transactional information encompasses all of the information contained within a single business process or unit of work primary purpose: to support daily operational tasks (ie: sales receipt, packing slip) encompasses all organizational information primary purpose: to support the performing of managerial analysis tasks (ie: trends, future growth) means immediate, up-to-date information provide real-time information in response to requests the biggest pitfall associated with real-time information continual change, information an analysis is based on is constantly changing occurs when the same data element has different values occur when a system produces incorrect, inconsistent, or duplicate data 5 characteristics common to high-quality information accuracy, completeness, consistency, timeliness, uniqueness 4 primary reasons for low quality information 1. online customers intentionally enter inaccurate info to protect privacy 2. diff systems have diff info entry standards 3. data-entry personnel enter abbreviated info to save time 4. 3rd party and external info contains inconsistencies and errors is there an incorrect value in the information? (ie: name spelled incorrectly?, dolar amount recorded properly?) is a value missing from the information (ie: is the address complete including street, city, state, zipcode) is aggregate or summary information on agreement with detailed information? (ie: do all the total columns equal the true total of the individual item is the information current with respect to business needs? (ie: is information updated weekly, daily or hourly?) is each transaction and event represented only once in the information problems that occur using low-quality information 1. inability to accurately track customers 2. difficulty identifying the organization's most valuable customers 3. inability to identify seeing opportunities 4. lost revenue opportunities from marketing to nonexistent customers refers to te overall management of the availability, usability, integrity ad security of company data maintains information about various types of objects (inventory), events (transactions), people (employees), and places (warehouses) database management system (DBMS) creates, reads, updates, and deletes data in a database while controlling access and security query-by-example (QBE) tool tool that helps users graphically design the answer to a question against a database structured query language (SQL) that asks users to write lines of code to answer questions against a database data element (data field) the smallest or basic unit of information (ie: customers name, address, email, discount rate, preferred shipping method) logical data structures that detail the relationships among data elements using graphics or pictures provides details about data; the descriptions for data elements compiles all of the metadata about the data elements in the data model three primary models for organizing information hierarchical, network, and relational database (most prevalent) relational database model stores information in the form of logically related two-dimensional tables relational database management system allows users to create, read, update, and delete data in a relational database (also referred to as a table) stores information about a person, place, thing, transaction, or event (also called columns or fields) the data elements associated with an entity a collection of related data elements; each one in an entity occupies one row in the respective table a field (or group of fields) that uniquely identifies a given record in a table; provides a way of distinguishing each record in a table a primary key of one table that appears as an attribute in another table and acts to provide a logical relationship between the two tables advantages of a relational database increased flexibility, increased scalability and performance; reduced info redundancy; increased info integrity (quality); increase info security deals with the physical storage of informatin on a storage device focuses on how individual users logically access information to meet their own particular business needs. the duplication of data, or the storage of the same data in multiple places a measure of the quality of information rules that help ensure the quality of information two types: 1. relational 2. business critical relational integrity constraints rules that enforce basic and fundamental information-based constraints business critical integrity constraints enforce business rules vital to an organization's success and often require more insight and knowledge than relational integrity constraints an interactive website kept constantly updated and relevant to the needs of its customers using a database a logical collection of information, gathered from many different operational databases, that supports business analysis activities and decision-making tasks primary purpose: to combine information, more specifically, strategic information, throughout an organization into a single repository in such a way that the people who need that information can make decisions and undertake business analysis Extraction, transformation, and loading (ETL) a process that extracts information from internal and eternal databases, transforms it using a common set of enterprise definitions, and loads it into a data warehouse contains a subset of data warehouse information; has a functional focus unlike the organizational focus of a data warehouse the common term for the representation of multidimensional information information cleansing or scrubbing a process that weeds out and fixes or discards inconsistent, incorrect, or incomplete information determines the accuracy and completeness of its data the process of analyzing data to extract information not offered by the raw data alone use a variety of techniques to find patterns and relationships in large volumes of information that predict future behavior and guide decision making; help users uncover business intelligence in their data data that are already in a database or a spreadsheet data that do not exist in a fixed location and can include text documents, PDFs, voice messages, emails, and so on analyzes unstructured data to find trends and patterns in words and sentences analyzes unstructured data associated with websites to identify consumer behavior and website navigation a technique used to divide information sets 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 (ie analyzing customers' zip codes) reveals the relationship between variables along with the nature and frequency of the relationships; create rules to determine the likelihood of events occurring together at a particular time or following each other in a logical progression form of association detection; analyzes such items as websites and checkout scanner information to detect customers' busying behavior and predict future behavior by identifying affinities among customers' choices of products and services performs such functions as information correlations, distributions, calculations, and variance analysis time stamped information collected at a particular frequency ex: web visits per hour, sales per month, calls per day predictions based on time-series information What are rules that help ensure the quality of data?Relevancy: the data should meet the requirements for the intended use. Completeness: the data should not have missing values or miss data records. Timeliness: the data should be up to date. Consistency:the data should have the data format as expected and can be cross reference-able with the same results.
What refers to the extent of detail within the data multiple choice question real time data data timeliness real time systems data granularity?Data granularity: The extent of detail within the data (fine and detailed or coarse and abstract).
Which of the following refers to the extent of details within the data?Refers to the extent of detail within the information (fine and detailed or coarse and abstract).
What is the term for the tests and evaluations used to determine compliance?Conformance testing — an element of conformity assessment, and also known as compliance testing, or type testing — is testing or other activities that determine whether a process, product, or service complies with the requirements of a specification, technical standard, contract, or regulation.
|
Accurate data asks if the aggregate or summary data is in agreement with the detailed data
zusammenhängende Posts
Urheberrechte © © 2024 ihoctot Inc.
