1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
elena-14-01-66 [18.8K]
4 years ago
6

What are the principal tools and technologies for accessing information from databases to improve business performance and decis

ion making?
a. Define a data warehouse, explaining how it works and how it benefits organizations.
b. Define business intelligence and explain how it is related to database technology.
c. Describe the capabilities of online analytical processing (OLAP).
d. Define data mining, describing how it differs from OLAP and the types of information it provides.
e. Explain how text mining and Web mining differ from conventional data mining.
f. Describe how users can access information from a company’s internal databases through the Web
Business
1 answer:
slamgirl [31]4 years ago
8 0

Answer:

There are many principal tools and technologies for accessing information from databases that help make business performance and decision making better.

Data warehouse:

  • A data warehouse is a big database that houses all the data that is needed to make decisions throughout the whole organization.

How a data warehouse works:

  • The data warehouse first takes all the data from the company's operational systems and combines it with the data that is pulled from outside sources.
  • This collection of data is reformatted into one database that is used for management reporting analysis.

How it benefits organizations:

  • A data warehouse benefits organizations by making data available for anyone to access as needed.
  • This keeps the data information secure and can prevent redundancies or inconsistencies.
  • It ultimately helps management make decisions that will help the company move forward.

Business intelligence:

  • Business intelligence is the term used to describe the data and software tools for organizing, analyzing, and providing access to data in order to help a company make better decisions.
  • The tools give user the opportunity to analyze data in hopes of seeing new patterns and relationship that are useful for better decision making.

How it relates to database technology:

  • The tools for business intelligence consist of software that performs database querying and reporting, multidimensional data analysis, and data mining.
  • The data can be analyzed by the company once it is made available in the data warehouse. Online analytical processing (OLAP):
  • OLAP allows end users to view data in many ways through the support of multidimensional data analysis.
  • Different information on a certain piece of data would be represented in a different dimension. Comment

OLAP capabilities:

  • A multidimensional model can be designed to represent products, regions, actual sales, and projected sales.
  • A matrix of actual sales is put on top of a matrix of projected sales in order to form a cube consisting of six faces.
  • Rotating the cube 90 degrees one way will show the product versus actual and projected sales.
  • Rotating the cube 90 degrees again will show the region versus actual and projected sales.
  • Rotating the cube 180 degrees from the original view will show the projected sales and product versus region.

Data mining:

  • Data mining is defined as a process that provides a business with insights into company data through the searching of patterns and relationships that will help better foresee future behavior.
  • Data mining helps make better decisions and predicts the effects that may result from those said decisions.

How it is different from OLAP:

  • OLAP requires the user to have a good idea about the information for which they are looking.
  • Data mining doesn't require the need to have a good idea about the information for which they are looking.
  • Also, OLAP doesn't have the capabilities to search for hidden patterns and relationships in large databases.

The type of information that data mining provides:

Associations:

  • Occurrences that are connected to a single event.
  • Patterns in sales can be analyzed to provide managers with better decision making.

Sequences:

  • Occurrences when events are connected over time.

Classifications:

  • The recognition of patterns and relationships that define the group to which an item belongs.
  • Classification helps discover the characteristics of a customer so that managers will be able to come up with ways to keep those customers from leaving.

Clusters:

  • Similar to how classifications operate except for the fact that groups haven't been defined.
  • Clusters make it possible to discover different groupings in the company data.

Forecasts:

  • Forecasts make predictions by using existing values to predict what other values will be.
  • Forecasting provides a way for the company to predict the values of their sales figures.

Text mining:

  • Tools for analyzing data that work by obtaining important elements from unorganized data sets, finding patterns, and summarizes the data so that a company can make better decisions for the business.

Web mining:

  • Web mining is defined as the analysis of patterns and relationships from the World Wide Web.  

How they differ from conventional data mining:

  • Conventional data mining finds patterns and relationships in information that is structured.  

The way that users can access information from a company's internal databases through the Web:

  • A user can access information from a company's internal databases through the Web is by using Web browser software on their PC.
  • The requests are done by using HTML commands to communicate with the Web server.
  • The Web server passes the requests for data to software that translates HTML commands into structured query language (SQL) so that they can be processed by the DBMS working with the database.
  • The DBMS receives the SQL requests and provides the needed data.

You might be interested in
Puedes enviar documentos escaneados o Digitalizados desde el Celular​
love history [14]

<em>Cierto </em>

<em>Solo depende del tipo de teléfono que se utilice para enviar el documento. Creo que hay algunos teléfonos que se configuran más como computadoras que te permiten enviar documentos. Sin embargo, hay muchos teléfonos que no cuentan con esta función y es probable que la mayoría de los teléfonos celulares que usa la gente en la actualidad no realicen esta acción.</em>

<em>Espero que esto te ayude y que tengas un buen día.</em>

<em>-R3TR0 Z3R0</em>

4 0
3 years ago
In the recent years, prices of basic food commodities such as corn, rice, and wheat have increased sharply. A recent article in
TiliK225 [7]

Answer:

I, II and III.

Explanation:

Price ceiling refers to the price control policy that is used by the government to protect the customers who are not able afford goods at the prevailing price.

If government of a nation sets a price ceiling below the equilibrium price level then this will increase the quantity demanded for the product because now goods become more affordable to the consumers and decreases the quantity supplied because it will become less profitable for the producers.

Hence, the demand for goods exceeds the supply of goods, this will create a shortage of goods in an economy.

6 0
3 years ago
Select the situation that will occur when a shortage of bread exists, and consumers pressure producers to change their actions.
love history [14]
The answer is : Producers respond by supplying more bread

When shortage of breads increases, the demand of the product will jump through the roof, which will also increase its price

To gain the maximum profit, the producers will respond by supplying more bread until the shortage is eliminated
7 0
4 years ago
The trial balance of Woods Company includes the following balance sheet accounts. Identify the accounts that might require adjus
White raven [17]

Answer:

Woods Company

Accounts Requiring Adjustment, Type of Adjusting Entry, and the Related Account:

 Account                         Type of Adjustment           Related Account

a) Account receivable  Accrued revenue              Service revenue

b) Prepaid insurance  Prepaid expense              Insurance expense

c) Equipment                   Not required                      Not required  

d) Accumulated depreciation Accrued expense       Depreciation expense

e) Notes Payable             Not required                      Not required

f) Interest Payable          Accrued expense              Interest expense

g) Unearned service revenue Unearned revenue Service revenue

Explanation:

End of period adjustments are made to accounts in order to bring them in line with the accrual concept and matching principle of accounting.  These principles require that expenses and revenues for the period are matched in order to determine the appropriate profit generated for the period.  The implication is that transactions are recorded when they are incurred and not when cash is exchanged.  For example, if rent expense is incurred for the year and payment is made in the following year, the expense must be recognized in the current year.  The same applies to revenue.

4 0
3 years ago
Which force in​ porter's competitive forces model would describe an organization that loses customers due to its product prices
Alexxandr [17]

I guess the correct answer is Substitute products and services

A substitutе is a prοduct that pеrfοrms thе samе οr similar functiοn as anοthеr prοduct. Micrοеcοnοmics tеachеs that thе mοrе substitutеs a prοduct has, thе dеmand fοr thе prοduct bеcοmеs mοrе еlastic. Еlastic dеmand mеans incrеasеd cοnsumеr pricе sеnsitivity which еquatеs tο lеss cеrtainty οf prοfits. Fοr еxamplе, public-transpοrtatiοn is a substitutе fοr driving a car, and е-mail is a substitutе fοr writing lеttеrs.

4 0
3 years ago
Other questions:
  • A sponsor proposes research to evaluate reengineering a commercially available pacemaker. It is hoped that the new pacemaker wil
    10·1 answer
  • The nation of Newbie is establishing its monetary system and is designing its currency. The first proposal is to issue the Newbi
    12·1 answer
  • Which of the following statements indicates a disadvantage of using the regular, or conventional, payback period for capital bud
    8·1 answer
  • are the preserved remains of organisms, and they provide evidence to support Darwin’s theory of evolution. will give brainlyist
    5·2 answers
  • Explain how people manage financial risk through transfer.
    7·1 answer
  • The evms term that represents the value of work actually accomplished is:
    13·1 answer
  • Which of the following is NOT an end goal of BOTH quality improvement programs and continuous process improvement? Select one: a
    9·1 answer
  • The stock of raw materials, inputs, and component parts that an organization has on hand at a particular time is called ________
    14·2 answers
  • Managers place a high priority on internal control systems because the systems assist managers in all of the following except: a
    13·1 answer
  • After a bank reconciliation has been completed these transactions are listed as ____ to the cash balance? ? need help taking A p
    6·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!