Home > Ask the Data Management Experts > Business intelligence and analytics Questions & Answers > The roles of data warehousing, data mining and OLAP in knowledge discovery
Ask The Data Management Expert: Questions & Answers
EMAIL THIS

The roles of data warehousing, data mining and OLAP in knowledge discovery

William McKnight EXPERT RESPONSE FROM: William McKnight

Pose a Question
Other Data Management Categories
Meet all Data Management Experts
Become an Expert for this site


Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us   


>
QUESTION POSED ON: 20 August 2004
Can you provide an overview of knowledge discovery and how data warehousing, data mining and OLAP factor into it?

>
EXPERT RESPONSE

The data warehouse provides the data foundation for the data - the place where the data that goes into the process of knowledge discovery is stored. Data mining may be used to automatically perform knowledge discovery by giving the mining algorithm loose cues about potential relationships and letting the algorithm work on the data to discover the relationships and items to focus on further. OLAP is complimentary to data mining and is most likely the first, and most preferred, manner of discovering knowledge. OLAP works through a user performing specific, rather than general, interactive analysis with the data. If a data warehouse is present in the environment, either it or a data mart, would be the database used by OLAP.

For example, if you were analyzing sales, the data warehouse could contain 3 years of item level detail. Data mining could perform the advanced analytics required to determine what items are generally purchased together (market basket analysis) or what shopper demographics lead to the highest sales volume. These pieces of knowledge could lead to better product placement and marketing strategies. Likewise, an analyst could perform OLAP on the data warehouse to determine what products sell the most and what customers buy the most. While this information lacks the correlations that data mining would yield, it is nonetheless still valuable. This could also drive promotions strategy as well as vendor management strategies.

FOR MORE INFORMATION:

Browse through our business intelligence stories from around the Web.


Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us   


RELATED CONTENT
Business intelligence and analytics
Data warehouse and business intelligence team reporting structure
Who should the business intelligence team report to?
Do business intelligence tools require a data warehouse?
Starting a business intelligence career from a financial background
Data warehousing, data mining and data querying: Terms and definitions
Business intelligence career through Web development
Do you need managed reporting tools and business intelligence (BI) tools?
How to transition to real-time business intelligence and data warehousing
Business intelligence information management (BIIM) vs. BI
Application design for OLAP servers: Considerations and advice

Data warehouse management
Business intelligence, data mining maximize direct marketing for Intellidyn
Data warehouse and business intelligence team reporting structure
Three data warehouse project management metrics
Data warehouse appliances -- in a nutshell
Microsoft to acquire data warehouse appliance specialist DATAllegro
On-demand business intelligence takes aim at the midmarket
Data warehousing five-year outlook: Technology trends and tips
Do business intelligence tools require a data warehouse?
How to evaluate data warehouse software in five steps
Data quality management for data warehouses

Business intelligence software
Pervasive business intelligence: Are organizations really ready?
SAP acquisition opens up world of opportunities for Business Objects, according to execs
SAP unveils Microsoft Excel transformation tool, provides Crystal Reports to Business One customers
SAS buys revenue management firm to complement its business intelligence practice
On-demand business intelligence takes aim at the midmarket
Rankings of customer data mining market show shift to user-friendly tools
Business intelligence vendors, users embrace location-based analysis
Do business intelligence tools require a data warehouse?
Gartner: Business intelligence software market grew 13% in 2007
Business intelligence, performance management spending to top $57 billion

RELATED GLOSSARY TERMS
Terms from Whatis.com − the technology online dictionary
data modeling  (SearchDataManagement.com)
extract, transform, load  (SearchDataManagement.com)
OLAP  (SearchDataManagement.com)
tree structure  (SearchDataManagement.com)

RELATED RESOURCES
2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems
Search Bitpipe.com for the latest white papers and business webcasts
Whatis.com, the online computer dictionary



Search and Browse the Expert Answer Center
Search and browse more than 25,000 question and answer pairs from more than 250 TechTarget industry experts.
Browse our Expert Advice

About Us  |  Contact Us  |  For Advertisers  |  For Business Partners  |  Site Index  |  RSS
SEARCH 
TechTarget provides enterprise IT professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective IT purchase decisions and managing their organizations' IT projects - with its network of technology-specific Web sites, events and magazines.

TechTarget Corporate Web Site  |  Media Kits  |  Reprints  |  Site Map




All Rights Reserved, Copyright 2005 - 2008, TechTarget | Read our Privacy Policy
  TechTarget - The IT Media ROI Experts