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]
3 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]3 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
Firms send information about their products or services directly to a set of targeted consumers as part of viral marketing. this
Lilit [14]

Firms send information about their products or services directly to a set of targeted consumers as part of viral marketing. this process is called Direct marketing.

Direct marketing is a form of advertising dedicated to individuals or companies for the purpose of generating new business, promoting an organization or product, or selling. Direct mail, telemarketing, and email marketing are common types of direct marketing.

Direct marketing is a form of sales communication in which an organization engages directly with pre-selected customers and provides a direct response method. Among medical practitioners, it is also called direct response marketing. Advertisements, on the other hand, have mass message characteristics.

Learn more about Direct marketing here: brainly.com/question/2632159

#SPJ4

3 0
1 year ago
Incremental costs - Initial and terminal cash flow
Black_prince [1.1K]

Answer:

c. $504,000

Explanation:

Total cost of new equipment = Price of equipment + Shipping & Installation costs = $3,200,000 + $160,000 = $3,360,000

Increase in working capital = Increase in inventories & account receivables - Increase in accounts payable = $640,000 - $256,000 = $384,000

Total Initial net investment outlay = $3,744,000 ($3,360,000+$384,000)

Project terminal cash-flow = Sale value of equipment (after tax) + Recovery of working capital = $200,000*(1-0.40) + $384,000 = $120,000 + $384,000  = $504,000

5 0
2 years ago
Using money to try to make more money is called
nekit [7.7K]
I think its called an investment.
6 0
2 years ago
Read 2 more answers
According to the Federal Housing Finance Board, the mean price of a single-family home two years ago was $299,500. A real estate
Tems11 [23]

Answer: A.There is sufficient evidence to conclude that the mean price of a single-family home has increased from its level two years ago of $299,500

Explanation:

From the question, we are informed that according to the Federal Housing Finance Board, the mean price of a single-family home two years ago was $299,500 and that a real estate broker believes that due to recent credit crunch, the mean price has increased since then and the result is that the null hypothesis is not rejected.

The conclusion based on the results of the test is that since the null hypothesis has been rejected, it simply means that there are sufficient evidence that there has been an increase in the mean price since two years ago.

Therefore, option A is the correct answer.

3 0
3 years ago
You work for a company that manufactures prescription eyeglasses and want to create a piece of content for your buyer persona. y
Svet_ta [14]

Answer: A checklist on how to determine if it's time to get a new pair of eyeglasses

A set of predefined checks can let the customer know if there could be changes in his lens and if its time for another visit to the eye specialist. This would make the customer more happy and lean towards towards your businesses for future needs and make him a loyal customer

6 0
2 years ago
Other questions:
  • Holly's ham, inc. sells hams during the major holiday seasons. during the current year 11,000 hams were sold resulting in $220,0
    8·1 answer
  • Prepare entries to record the sale of the copiers, the related warranty costs, and any accrual on December 31, 2020. Actual warr
    14·1 answer
  • Q-mart wants to know what safety stock should be maintained for its jumbo flyer if j. flyer's daily demand is normally distribut
    9·1 answer
  • Alonzo decides to have a yard sale to sell some of his personal items. At the sale, Alonzo sells Ralph a big screen television f
    5·2 answers
  • How are issues such as customer theft and spoilage addressed at year-end?
    5·1 answer
  • What is a saturated market like for sellers
    7·1 answer
  • ABC Broadcasting Company is comprised of two divisions: Music and News. A summary of expected operations in 2019 for each divisi
    14·1 answer
  • 7.Consider two metropolitan areas, one that has many small school districts and one that has only a few large school districts.
    12·1 answer
  • Third World Gamer Inc. manufactures components for computer games within a relevant range of 500,000 to 1,000,000 disks per year
    5·1 answer
  • Question 1 A small company manufactures three different electronic components for computers. Component A requires two hours of f
    8·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!