Scribd Logo
Upload

Welcome to Scribd!

  • 37 views

    Business Intelligence (BI) / Datawarehouse

    Uploaded by

    Manish Rajak
    Rajesh Math is currently the director of Adroit IT Network Solutions and has 15 years of experience delivering IT solutions. He has an MS in computer science and an MBA. The document defines a data warehouse as a central repository for enterprise data used for decision making. It distinguishes data warehouses from operational databases, noting that data warehouses contain historical data for analysis rather than transactional data. Business intelligence is described as using data to help users make better business decisions through activities like reporting, analytics, and data mining.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as PPT, PDF, TXT or read online from Scribd

    Business Intelligence (BI) / Datawarehouse

    Uploaded by

    Manish Rajak
    37 views11 pages
    Rajesh Math is currently the director of Adroit IT Network Solutions and has 15 years of experience delivering IT solutions. He has an MS in computer science and an MBA. The document defines a data warehouse as a central repository for enterprise data used for decision making. It distinguishes data warehouses from operational databases, noting that data warehouses contain historical data for analysis rather than transactional data. Business intelligence is described as using data to help users make better business decisions through activities like reporting, analytics, and data mining.

    Original Title

    Dwbi Intro

    Copyright

    © Attribution Non-Commercial (BY-NC)

    Available Formats

    PPT, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Rajesh Math is currently the director of Adroit IT Network Solutions and has 15 years of experience delivering IT solutions. He has an MS in computer science and an MBA. The document defines a data warehouse as a central repository for enterprise data used for decision making. It distinguishes data warehouses from operational databases, noting that data warehouses contain historical data for analysis rather than transactional data. Business intelligence is described as using data to help users make better business decisions through activities like reporting, analytics, and data mining.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as PPT, PDF, TXT or read online from Scribd
    Download as ppt, pdf, or txt
    37 views11 pages

    Business Intelligence (BI) / Datawarehouse

    Uploaded by

    Manish Rajak
    Rajesh Math is currently the director of Adroit IT Network Solutions and has 15 years of experience delivering IT solutions. He has an MS in computer science and an MBA. The document defines a data warehouse as a central repository for enterprise data used for decision making. It distinguishes data warehouses from operational databases, noting that data warehouses contain historical data for analysis rather than transactional data. Business intelligence is described as using data to help users make better business decisions through activities like reporting, analytics, and data mining.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as PPT, PDF, TXT or read online from Scribd
    Download as ppt, pdf, or txt
    You are on page 1of 11

    Business Intelligence (BI) /

    Datawarehouse

    Rajesh Math

    12/07/21 DW/BI Introduction - Rajesh Math 1


    Introduction
     Currently Director Adroit IT Network
    Solutions specializing in Financial applications
     MS(CS),Boston University
     MBA(Systems) from Pune University
     15 years IT experience delivering IT solutions

    12/07/21 DW/BI Introduction - Rajesh Math 2


    Datawarehouse(DW)

    DEFINITION: A data warehouse is a central


    repository for all or significant parts of the data that
    an enterprise's various business systems collect. The
    term was coined by W. H. Inmon.

    aka Data Stores, Data warehousing, Data Ware-


    house, Data warehouse, Data Warehousing,
    Knowledge Warehouse, and Dataware House

    12/07/21 DW/BI Introduction - Rajesh Math 3


    Database V/S Datawarehouse
     Distinguish
     Operational Database
     Data needed and updated constantly to directly support business
    operations
     Focus on OLTP (on-line transaction processing): Transactional
    access & modification of relatively small # of data points at a time
     Data Warehouse & Data Mart
     Copious amounts of relatively static data, culled & integrated
    across enterprise, cleansed & summarized, maintained historically,
    used for decision support
     Focus on OLAP (on-line analytical processing): Querying large
    amounts of data, scheduled modifications

    12/07/21 DW/BI Introduction - Rajesh Math 4


    BI Definition

    Business intelligence (BI) is a broad category


    of applications and technologies for
    gathering, storing, analyzing, and providing
    access to data to help enterprise users make
    better business decisions. BI applications
    include the activities of decision support
    systems, query and reporting, online
    analytical processing (OLAP), statistical
    analysis, forecasting, and data mining.
    12/07/21 DW/BI Introduction - Rajesh Math 5
    Data Mining
    Discovering Knowledge based on Data
     Descriptive Models
     Discovery of patterns & relationships in the underlying data
     e.g. A customer who purchases diapers is 3 times more likely to buy
    beer.
     e.g. There is a cluster of households w $60-80K incomes and 2 cars
    (more than ($60-$80k and 1 or 3 cars, or 2 cars w $40-60K or $80-
    100k) who have recently bought life insurance.
     Predictive Models & Anomaly Detection
     Predictions of trends & behaviors;
    Noticing deviations from those predictions
     e.g. How much profit will this customer generate? Is this credit card
    stolen?
     Uses
     Sales & Marketing, Diagnosis, Fraud Detection, …

    12/07/21 DW/BI Introduction - Rajesh Math 6


    BI Applications
    Business intelligence applications can be:
    Mission-critical and integral to an enterprise's
    operations or occasional to meet a special
    requirement
    Enterprise-wide or local to one division,
    department, or project
    Centrally initiated or driven by user demand

    12/07/21 DW/BI Introduction - Rajesh Math 7


    BI Goal
    Main business intelligence goal is to provide
    sufficient information for making business
    decisions. Depending on the aim of the
    business decision, business intelligence
    methods can provide information about
    company customers, market trends,
    effectiveness of marketing campaigns,
    companies competitors, or even predict future
    activities.
    12/07/21 DW/BI Introduction - Rajesh Math 8
    BI/DW Architecture

    12/07/21 DW/BI Introduction - Rajesh Math 9


    BI/DW Tools

    12/07/21 DW/BI Introduction - Rajesh Math 10


    QUESTIONS ???

    12/07/21 DW/BI Introduction - Rajesh Math 11

    You might also like