Exam (elaborations)
Chapter 6 - Business Intelligence A+ Q&As 2024
- Course
- Institution
Chapter 6 - Business Intelligence A+ Q&As 2024
[Show more]
Seller
Follow
modocko752
Content preview
Chapter 6 - Business Intelligence A+Q&As 2024
Business Intelligence - ANS-The use of IS to gather and analyze information from both
external and internal sources to make better decisions, and the data derived from these
processes (it is the number one necessities according to CIOs, key players include
independent pure play analytic companies such as SAS and MicroStrategy along with
larger integrated companies such as IBM, SAP, Oracle, and Microsoft)
Continuous planning process - ANS-A strategic business planning process involving
continuous monitoring and adjusting of business processes to enable rapid reaction to
changing business conditions (Monitor → Analyze →Manage → Plan)
Big Data Movement - ANS-Collecting, analyzing, and using internal and external data to
gain and sustain competitive advantage; characterized as being of high volume, variety,
and velocity; there is structured data (ex. transaction data), semi-structured data (ex.
clickstreams/sensors) and unstructured data (ex. audio/video)
Entity - ANS-Something data are collected about, such as people or classes
Tables - ANS-A collection of related records in a database where each row is a record
and each column is an attribute (with unique identifiers such as numbers)
Record - ANS-A collection of related attributes about a single entity (row)
Attribute - ANS-One piece of information about an entity in a database (column)
RDBMS - ANS-A database management system based on the relational model (may
not be able to handle Big Data)
NoSQL - ANS-Highly-scalable databases that do not confirm to RDBMS schemas (offer
much more scalable models with high flexibility)
Data model - ANS-A map or diagram that represents the entities of a database and their
relationships (what data will be captured and how it will be represented)
Data type - ANS-The type of an attribute in a database (helps organize and sort the
, data)
Data dictionary - ANS-A document prepared by database designers to describe the
characteristics of all items in a database (attribute, type, values, business rules)
Business rules - ANS-Policies by which a business runs
Structure Query Language (SQL) - ANS-The most common language used to interface
with databases for non-technical users
Operational systems - ANS-The systems that are used to interact with customers and
run a business in real time; the data is a current representation of the state of the
business; its users are online customers and sales administrators; it performs using
narrow and simple updates and queries
Online transaction processing (OLTP) - ANS-Immediate automatic responses to the
request from multiple concurrent transactions of customers
Informational systems - ANS-A system designed to support decision-making based on
stable point-in-time or historical data; its primary users are managers, business
analysts, and customers; it's easy to access and use and includes broad and complex
queries and analyses
Master data management - ANS-Consolidating master data (most important data in
business operations) so as to facilitate arriving at a single version of the truth
Data warehouses - ANS-A repository containing data from multiple large databases and
other sources that is suitable for direct querying, analysis, or processing
Data mart - ANS-A data warehouse that is limited in scope and customized for the
decision support applications of a particular end-user group; can be deployed on less
powerful hardware (only around 10 gigabytes)
Scheduled Reports - ANS-A report produced at predefined intervals to support the
routine informational needs of managerial-level decision making
Drill-down Reports - ANS-A report that provides details behind the summary values on
key-indicator or exception report
Exception Report - ANS-A report providing users with information about situations
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller modocko752. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $7.99. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
73314 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now