Scribd Logo
Upload

Welcome to Scribd!

  • 20 views

    Day01 Business Intelligence - Iti

    Uploaded by

    kirolosmagdy

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd

    Day01 Business Intelligence - Iti

    Uploaded by

    kirolosmagdy
    20 views16 pages

    Original Title

    Day01 Business Intelligence- iti

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    20 views16 pages

    Day01 Business Intelligence - Iti

    Uploaded by

    kirolosmagdy

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    You are on page 1of 16

    Why we study data?

    Data Intuition
    Data

    ● Collection of facts about something that can be used in calculating, reasoning,


    or planning

    Information
    ● Processed data used to make decisions and take actions
    Data Life cycle
    ● Planning:
    ○ Type of data, How it going to be managed, who is the responsible for it.
    ● Capture
    ○ Collecting data (outside resources, inside resources)
    ● Manage
    ○ Data caring: store and maintain data, where it going to be stored,
    ● Analyze
    ○ Make use of data, help in solving problems, gain insights.
    ● Archive:
    ○ Stored in a place (might or might not be used again)
    ● Destroy
    ○ To protect data privacy and users' privacy
    So, why we study data?

    ● Improve people’s lives


    ● Make informed decision
    ● Find Solutions
    ● No more guessing
    ● Be strategic with a free experience
    ● Know your baselines and identify goals
    Business Intelligence 01

    Hady Khaled Hammad, MEng


    Faculty of Engineering, University of Ottawa - Canada
    What is Business Intelligence?

    ● Make use of firm’s data


    ● Create Dashboards and Reports
    ● Highlighting the problems and its causes

    “Business strategy for more proactive decisions”

    Reading list
    BI importance

    ● Create KPIs and Measurements based on historic data


    ● Identify and set business baselines and goals
    ● Identify market trends and spot business problems
    ● Identify the areas that need attention
    ● Gives an overall view of the business’ process
    BI Process

    1. Data Sources
    2. Data Integration
    3. Data Analysis
    4. Data Reporting
    Data Warehouse

    ● Integrating data from multiple sources (Denormalized)


    ● Relational database that is designed for query and analysis (OLAP)
    ● Subject oriented, Time variant & Non-volatile
    ● Schemas: Star, Snowflake schemas, Galaxy schema (Fact constellation)
    ● Using cubes for analysis

    Reading list
    Star schema Snowflake schema
    Tools
    OLTP Vs OLAP

    ● OLTP: Online Transactional Processing


    ○ Enable the execution of a large volume of database transactions, performed by
    multiple people.

    ● OLAP: Online Analytical Processing


    ○ Systems that are optimized for performing analyses on large volumes of data

    Reading list
    OLTP: OLAP:

    ● Insert, Update, Delete for daily transactions ● Report & analyze data, no daily transactions
    ● Uptodate (Volatile data) ● Historical data (Non-volatile data)
    ● Insert in real time ● Insert by a schedule
    ● Simple queries ● Very complex Queries (Cube)
    ● Should be highly available ● Less availability requirement
    ● Less processing time (handle large amount of ● More processing time (handle small amount of
    simple queries) complex queries)
    ● Schema (Relational Database) ● Schema (High Dimensional Schema)
    ● Normalized ● Denormalized
    ● Application oriented ● Subject oriented
    SSIS
    Variables

    Precedence constraints:
    - On Success
    - On Failure
    - On Complete
    Data Viewer

    Join, union, remove null,


    sort, aggregates

    Connection manager

    You might also like