Business, 25.01.2020 05:31 peytonbrien2002

What are the principal tools and technologies for accessing information from databases to improve business performance and decision 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

Answers: 1

Show answers

Answers

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.

Answer from: Quest

Ithink its b hope it ! : )

Answer from: Quest

someone i feel is a leader in my life id have to say would be my mother because she has give me great advice in life and got me out of tough situations. some characteristics she has are creativity, honesty, commitment, respect for others, and communication. one example of a situation when she demonstrated leadership was when i was working late on homework and i started to get stressed and got upset, she asked me if i needed some , and she me with my work. she demonstrated communication and commitment.

i don't know if this is exactly what your looking for but i hope this !

Another question on Business

Business, 22.06.2019 07:30

1 2 3 4 5 6 7 8 9 10time remaining59: 30in the dark game, how does the author develop the central idea that elizabeth van lew was a spymaster during the civil war? 1 2 3 4 5 6 7 8 9 10time remaining59: 30in the dark game, how does the author develop the central idea that elizabeth van lew was a spymaster during the civil war?

Answers: 1

Answer

Business, 22.06.2019 08:20

(05.04 mc) a 2012 report from the u.s. surgeon general stated: "another common practice is strategically locating tobacco-related marketing materials where young children will be exposed to them. tobacco industry executives acknowledge that products and advertising should be placed at eye level (pollay 2007), but in california, 48% of stores had at least one cigarette marketing item at or below 3 feet from the floor (feighery et al. 2001)." it was also noted that 25% of cigarette displays were next to candy. in addition, a national study found that about one-third of the stores had tobacco ads at low heights. after california banned counter displays, some stores place cigarettes in transparent displays so product brands could still be seen. why did some stores use transparent units to display the cigarettes? (3 points) to comply with the new rules while still encouraging cigarette purchases via visual exposure to ensure children and minors are not exposed to cigarettes and their eye-catching packaging to minimize exposure to humidity, extending the shelf life of the cigarettes' tobacco to reduce the occurrence of shoplifting, since cigarettes are high-revenue items

Answers: 3

Answer

Business, 22.06.2019 10:30

When sending a claim to an insurance company for services provided by the physician, why are both icd-10 and cpt codes required to be submitted? how are these codes dependent upon each other? what would be the result of not submitting both codes on a medical claim to an insurance company?

Answers: 2

Answer

Business, 22.06.2019 14:30

crow design, inc. is a web site design and consulting firm. the firm uses a job order costing system in which each client is a different job. crow design assigns direct labor, licensing costs, and travel costs directly to each job. it allocates indirect costs to jobs based on a predetermined overhead allocation rate, computed as a percentage of direct labor costs. direct labor hours (professional) 6,250 hours direct labor costs ($1,800,000 support staff salaries ,000 computer ,000 office ,000 office ,000 in november 2012, crow design served several clients. records for two clients appear here: delicious treats mesilla chocolates direct labor 700 hours 100 hours software licensing $ 4,000 $400 travel costs 8,000 1. compute crow design’s direct labor rate and its predetermined indirect cost allocation rate for 2012. 2. compute the total cost of each job. 3. if simone wants to earn profits equal to 50% of service revenue, how much (what fee) should she charge each of these two clients? 4. why does crow design assign costs to jobs?

Answers: 2

Answer

You know the right answer?

What are the principal tools and technologies for accessing information from databases to improve bu...

Questions