Preview

Data Mining and Data Warehouse

Powerful Essays
Open Document
Open Document
2521 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Data Mining and Data Warehouse
Information Systems Management
Research Project
ON
Data Warehousing and Data Mining
Submitted in Partial fulfilment of requirement of award of MBA degree of
GGSIPU, New Delhi

Submitted By: Swati Singhal (12015603911) Saba Afghan (11415603911) 2011-2013 Northern India Engineering College
(Affiliated to GGSIPU)
FC-26, Shastri Park, Delhi-110053
ABSTRACT
Data mining, the extraction of hidden predictive information from large databases, is a powerful new technology with great potential to help companies focus on the most important information in their data ware houses. Data mining tools predict future trends and behaviors, allowing businesses to make proactive, knowledge- driven decisions systems.
Data warehouse is a computer system designed to give business decision-makers instant access to information. The warehouse copies its data from existing systems like order entry, general ledger, and human resources and stores it for use by executives rather than programmers. Data warehouse users use special software that enables them to create and access information when they need it, as opposed to a reporting schedule defined by the information systems (IS) department.
This paper describes the meaning of data warehouse and data mining basic architecture of data warehousing and data mining, functions and working of data mining. It also presents data mining from data warehouse

INTRODUCTION:
Modern organizations are under enormous pressure with recent development of the technology. Clearly we need a rapid access to all kinds of information. To assist this we need to consider the past and to identify relevant trend analysis. So to perform any trend analysis we must have a database.
In most organizations you will

You May Also Find These Documents Helpful

  • Satisfactory Essays

    Database Concepts Pt2520

    • 326 Words
    • 2 Pages

    5. TRUE Data mining uses business intelligence tools and techniques on a variety of data sources brought together in a data warehouses.…

    • 326 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Pepsi America Case Study

    • 578 Words
    • 2 Pages

    | 1. Used customers’ data for competitive asset, and collecting information.2. Helped in management and control of the business process flow.3. Predict business flow.…

    • 578 Words
    • 2 Pages
    Satisfactory Essays
  • Better Essays

    Business Level 3 Unit 3 M3

    • 1132 Words
    • 5 Pages

    Data mining systems are a very useful tool to business although they are similar to Ai and expert systems these systems are used to detect patterns. This can be used in shops because they can see what certain products are more popular on certain days or weeks. Data mining systems can also be used to sort information into certain categories. This makes things a whole lot easier for the user and makes the system more user friendly.…

    • 1132 Words
    • 5 Pages
    Better Essays
  • Good Essays

    True False

    • 378 Words
    • 2 Pages

    5. Data mining uses business intelligence tools and techniques on a variety of data sources brought together in a data warehouse.…

    • 378 Words
    • 2 Pages
    Good Essays
  • Good Essays

    | * The data warehouse of St George bank supports the integrated data among different departments * Data from different departments can be accessed freely * Integrated data from the data warehouse is more beneficial and creates more opportunities and BI for all departments (1+1=3) * “Most departments extract what they need from the warehouse using customer relationship management and BI applications without intervention.” * “They have access to all the data, can create their own filters, their own campaigns.”…

    • 341 Words
    • 1 Page
    Good Essays
  • Good Essays

    Bis Midterm Sheet

    • 1467 Words
    • 6 Pages

    A data warehouse is to extract and clean data from operational systems and other sources to store and catalog that data for processing by BI tools. Data warehouses can include external data purchased from outside sources. Meta data is kept in the data warehouse. Physically, a data warehouse consists of a few fast computers with very large storage devices.…

    • 1467 Words
    • 6 Pages
    Good Essays
  • Good Essays

    The most important aspect of having data warehousing is the fact that it allows for data storage and presentation of this data enabling executives to make sound decisions. Another important use of data warehousing is it takes the separate areas the company is divided up in and takes it all and lumps it in to one single entity. One great benefit of data warehousing is that Huffman will be able to handle server task connected to all queries which is not commonly found in all systems. “Another powerful benefit of data warehouses is that they allow companies to use data modeling for querying tasks that are quite difficult for transaction processing” (Exforsys, 2007). Huffman trucking is already successful but by implementing a success data warehousing system they would be able to understand and analyze all data coming in and leaving the system better and at a more efficient rate. Attached to this report is a…

    • 891 Words
    • 3 Pages
    Good Essays
  • Powerful Essays

    Many companies are successful in understanding how to meet customer expectations, gain new customers and increase productivity and efficiency by using business intelligence and data analytics. The tools and techniques used by business intelligence give real time insight so that companies can identify opportunities, risks and track trends quickly. Collecting data alone is useless until it is analyzed. This is where data analytics come in. Data analytics is the process of obtaining and evaluating data using specialized software with the purpose of extracting useful information. (4) Data analytics is used in many industries to allow companies and organizations to make better business decisions quickly. The speed at which data is collected, organized and evaluated is critical given the speed at which technology continues to change. I believe more and more companies are utilizing data analytics so they can gain advantages over their competitors. Technology is obtaining more data than in the past so companies are seeking better ways to receive value from that data. The term business…

    • 1233 Words
    • 4 Pages
    Powerful Essays
  • Powerful Essays

    A data warehouse is a database that stores current and historical data of potential interest to decision makers throughout the company. [1] After the events of September 11, 2001, the US Government determined the need for a comprehensive single source to identify and deter all persons either suspected to engage in terrorist activities against the US. Thus, the Terrorist Watch List and Database were created, bringing together all the information from various government agencies who had previously been maintaining separate lists of persons, into the Watch List in a standard format and available to all. This database is an example of data warehousing.…

    • 1645 Words
    • 7 Pages
    Powerful Essays
  • Good Essays

    A data warehouse is a database that stores current and historical data of potential interest to decision makers throughout the company.[1] In the Terrorist Watch List Database case, the information about suspected terrorists are consolidated and standardized from multiple government agencies so that the information can be centralized into a single list, from which different agencies can communicate and share information with each other. This centralized database is a specific example of data warehouse. In this case, the data warehouse containing the relevant information of individuals from each agency’s list enhancing effectiveness of communication between agencies as well as increase the consistency of information from separate databases.…

    • 860 Words
    • 4 Pages
    Good Essays
  • Good Essays

    Data Mining Information

    • 4559 Words
    • 16 Pages

    Data mining has many definitions because it’s been stretched beyond those limits by some software vendors to include most forms of data analysis in order to increase sales using the popularity of data mining.…

    • 4559 Words
    • 16 Pages
    Good Essays
  • Satisfactory Essays

    Designations used by companies to distinguish their products are often claimed as trademarks. In all instances…

    • 166945 Words
    • 668 Pages
    Satisfactory Essays
  • Powerful Essays

    [1] Bhasin, M. L. (2006). The Chartered Accountant, Banking and Finance, Data Mining: A Competitive Tool in the Banking. Oman.…

    • 2794 Words
    • 12 Pages
    Powerful Essays
  • Best Essays

    Data Warehousing and Olap

    • 2507 Words
    • 11 Pages

    A data warehouse is a “subject-oriented, integrated, time varying, non-volatile collection of data that is used primarily in organizational…

    • 2507 Words
    • 11 Pages
    Best Essays
  • Good Essays

    Chapter 6: Multiple Linear Regression Data Mining for Business Intelligence Shmueli, Patel & Bruce © Galit Shmueli and Peter Bruce 2010 Topics Explanatory vs. predictive modeling with regression Example: prices of Toyota Corollas Fitting a predictive model Assessing predictive accuracy Selecting a subset of predictors (variable selection) Explanatory Modeling Goal: Explain relationship between predictors (explanatory variables) and target  Familiar use of regression in data analysis  Multiple linear regression – linear relationship between a dependent variable Y (response) and a set of predictors X1,…,Xp  Model Goal: Fit the data well and understand the contribution of explanatory variables to the model – model performance assessed by residual analysis  Model fitted to the entire dataset Predictive Modeling Goal: Predict target values in new data where we have predictor values, but not target values Classic data mining context Model Goal: Optimize predictive accuracy – how accurately can the fitted model predict new cases Model trained on training data and performance is assessed on validation or test data Explaining role of predictors is not the primary purpose (although useful)…

    • 921 Words
    • 8 Pages
    Good Essays

Related Topics