Business intelligence
1 / 17

Business Intelligence - PowerPoint PPT Presentation

  • Updated On :

Business Intelligence. Andrew Davis Andria Zippler Jana Krinsky Tiffany Ferris. What is Business Intelligence? . Business Intelligence, or BI, has recently become a hot topic in business information technology. Do you know anything about BI? What comes to mind in relation to this term?.

I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
Download Presentation

PowerPoint Slideshow about 'Business Intelligence' - lindsey

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.

- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
Business intelligence

Business Intelligence

Andrew Davis

Andria Zippler

Jana Krinsky

Tiffany Ferris

What is business intelligence
What is Business Intelligence?

  • Business Intelligence, or BI, has recently become a hot topic in business information technology.

  • Do you know anything about BI? What comes to mind in relation to this term?

Bi fundamentals
BI Fundamentals

  • Business Transactions

  • Data Bases

  • Data Warehouses

  • Data Marts

  • Data Mining

Data bases db or dbms
Data bases (DB or DBMS)

  • “A collection of information organized in such a way that a computer program can quickly select desired pieces of data.”

  • An electronic filing system

  • Organized by

    • Fields: a single piece of information

    • Records: one complete set of fields

    • Files: a collection of record

Data warehouse dw
Data warehouse (DW)

  • “Contain a wide variety of data that present a coherent picture of business conditions at a single point in time.”

  • “A database system which contains periodically collected samples or summarized (aggregated) transactional data; e.g., daily totals, or monthly averages”

  • Typically a compilation of information from multiple transactional databases

Data mart
Data mart

  • “A database, or collection of databases, designed to help managers make strategic decisions about their business.”

  • A smaller and more focused form of a data warehouse.

    • Usually created for a particular department or position

    • A data mart created as a subset of data warehouse data are referred to as a “dependent data mart”.

Business intelligence bi
Business intelligence (BI)

  • ‘”The tools and systems that play a key role in the strategic planning process of the corporation. These systems allow a company to gather, store, access and analyze corporate data to aid in decision making .”

  • Common applications:

    • customer profiling

    • customer support

    • market research

    • market segmentation

    • product profitability

    • statistical analysis

    • inventory and distribution analysis

Data mining
Data mining

  • “A class of database applications that look for patterns in data to be used to predict and direct future behavior.”

  • Increasingly being used by marketers to find consumer data through the web and store purchases.

The bi chain
The BI Chain

Database info is periodically summarized (aggregated) and put into the data warehouse


Data are stored in the database

Interpretation of information is used to make strategic decisions

Data mining takes place to identify useful information through a search for patterns

Summary data are further condensed into a data mart for specific department or executives

What does bi seek to find
What does BI seek to find?

  • Patterns

  • What kind of patterns?

    • Sales

    • Stocks

    • Anything useful

Techniques for finding patterns



Correlation (searching for a best fit)

Techniques for Finding Patterns

Patterns continued
Patterns continued

  • Combinatorial

    • If-then relationships

  • Example

    • If we put chips on sale on a Friday, then we also sell more soda.

The shakeout

The Gartner BI Matrix

Compares the completeness of a company’s vision to its ability to execute that vision.

The “Shakeout”

Leading the industry
Leading the Industry

  • Cognos

    • BI software company (most recently Cognos 8)

  • Software

    • Used for reporting, analysis, scorecarding, dashboards, business event management, and data integration


  • Multiple Solutions

    • Industry

      • Banking

      • Education

      • Defense

      • Government

    • Department

      • Executive Management

      • Finance

      • Marketing

Who uses bi
Who uses BI?

  • Businesses

  • The Government

  • ?

  • ?

  • What are some ethical implications of the use of BI?