100% satisfaction guarantee Immediately available after payment Both online and in PDF No strings attached
logo-home
Previously searched by you
Previously searched by you
logo
BSAN 160 Test Questions and Answers $13.39
Add to cart
Quickly navigate to
Preview
  2.  
  3. BSAN 160
  4.  
  5. BSAN 160

Exam (elaborations)

BSAN 160 Test Questions and Answers

 0 purchase
  • Course
  • BSAN 160
  • Institution
  • BSAN 160

BSAN 160 Test Questions and Answers Four components of BI - Answer-1. Data Warehouse 2. Business Analytics 3. Business Performance Management 4. User Interface Online Transaction Processing (OLTP) Systems - Answer-handles a company's routine ongoing business Goal: capture the data accura...

[Show more]

Preview 3 out of 23  pages

Document information

  • August 16, 2024
  • 23
  • 2024/2025
  • Exam (elaborations)
  • Questions & answers

Subjects

Written for

  • BSAN 160
  • BSAN 160

Seller

avatar-seller
Perfectscorer

Reviews received

Content preview

BSAN 160 Test Questions
and Answers
Four components of BI - Answer-1. Data Warehouse
2. Business Analytics
3. Business Performance Management
4. User Interface

Online Transaction Processing (OLTP) Systems - Answer-handles a company's routine
ongoing business

Goal: capture the data accurately and store it reliably

Online Analytical Processing (OLAP) Systems - Answer-gives management the ability
to scour data for information about the business and support/guide decisions

uses data warehouses

Goal: make relevant data available quickly and conveniently (single repository) for
analysis

Data (definition) - Answer-facts (plural of datum)

collections of observations, transactions, or experiences, as measurements of a set of
variables

Data (consists of) - Answer-numbers, words, and images

Raw Data (consists of) - Answer-errors, uncertainty, nuances, and biases

Descriptive Analytics - Answer-provides knowledge of what's happening in and around
an organization and can enable identification of underlying patterns, causes, and effects

ex. in hospitals:

patterns in variables - likely values of hospitalization cost, trend in patient volume.

relationship between variables - patient volume vs waiting time

Contemporary Data Visualization Tools - Answer-facilitates powerful insights in a firm's
operations or business environment

,Predictive Analytics - Answer-the use of statistical techniques and data mining to predict
what is going to happen (future/unknown values of an outcome of interest) using current
and past data

Predictive Model (PM)

Prescriptive Analytics - Answer-aims to not only predict what is going to happen but
compare different actions/decisions and select best decisions based on certain
performance criteria

Prescriptive Model

Structured Data - Answer-1. easier for computers to process
2. categorical vs numerical

organized in tabular arrays with variables, observations, and values.

ex. a spreadsheet

Unstructured Data - Answer-easier for humans to process/digest

Semi-structured Data - Answer-XML, HTML, Log files, etc.

Categorical Variables - Answer-classifies information into categories

ex. nationality, college major, animal breed, etc.

A variable is numerical if... - Answer-meaningful arithmetic can be performed on it

ex. age, income, service duration, etc.

Variable - Answer-characteristic of members of a population

ex. age, gender, etc.

Observation - Answer-conceptually, what is observed for a variable with respect to a
member of the dataset

Value - Answer-the specific datum (number, letters, etc.) observed for one variable with
respect to a member of the dataset

Summary Measures - Answer-describes how a set of data 'looks' and thereby answers
common questions of interest

, Business Intelligence (BI) - Answer-concerned with managing and using complex,
multidimensional data to support business decisions and improve performance

Business Analytics - Answer-component of BI

the process of developing actionable decisions or recommendations for actions based
on insights generated from historical data

Data Visualization - Answer-the use of visual representations to explore, interpret, and
communicate data or information derived from the data

Goal: presents key insights from data in ways that reduce the cognitive burden for the
audience

facilitates the generation and presentation of insights to support decisions

Traditional Reporting - Answer-entails manual collection and processing/analysis of
data to obtain information for decisions

time consuming and adapts slowly

Decision Support System (DSS) - (later known as BI systems) - Answer-combines
human expertise with computer capabilities, utilizing data and models to solve problems

BI Systems (formerly DSS) - Answer-combines databases, analytical tools, and
advanced software applications to produce interactive reports and analyses.

based on the transformation of data to information, then information to decisions and
actions

possibility to perform arithmetic on numerical variables allows for summary measures

Mean - Answer-a set of numerical values is the arithmetical average of all values in the
set

large outliers will have a large effect (positive or negative)

Mode - Answer-a set of numerical values that appears most frequently

there can be one mode or no mode. it depends on the data.

Median - Answer-the middle observation when data are sorted from smallest to largest

if odd, there is one median. if even, there are two medians.

it is more robust to outliers than the mean

The benefits of buying summaries with Stuvia:

Guaranteed quality through customer reviews

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

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

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 Perfectscorer. Stuvia facilitates payment to the seller.

Will I be stuck with a subscription?

No, you only buy these notes for $13.39. You're not tied to anything after your purchase.

Can Stuvia be trusted?

4.6 stars on Google & Trustpilot (+1000 reviews)

69052 documents were sold in the last 30 days

Founded in 2010, the go-to place to buy study notes for 15 years now

Start selling
$13.39
  • (0)
Add to cart
Added