module 1 introduction
play

Module 1: Introduction Deriving Business Information Deriving - PDF document

Jun 21, 2023 •281 likes •345 views

Raw Data vs. Business Information Capturing Raw Data Gathering data recorded in everyday operations Module 1: Introduction Deriving Business Information Deriving meaningful information from raw data to Data Warehousing Turning

  1. Raw Data vs. Business Information � Capturing Raw Data � Gathering data recorded in everyday operations Module 1: Introduction � Deriving Business Information � Deriving meaningful information from raw data to Data Warehousing � Turning Data into Information and OLAP � Implementing a decision support system OLTP Source Systems Data Warehouse Characteristics � OLTP System Characteristics � Provides Data for Business Analysis Processes � Processes real-time transactions of a business � Integrates Data from Heterogeneous Source Systems � Contains data structures optimized for entries and edits � Combines Validated Source Data � Provides limited decision support capabilities � Organizes Data into Non-Volatile, Subject-Specific Groups � OLTP Examples � Stores Data in Structures that Are Optimized for � Order tracking � Service-based sales Extraction and Querying � Banking functions � Customer service � Point-of-sales � Defining OLAP Solutions Data Warehouse System Components Data Warehouse User Data Data Marts Data Access Staging Sources � OLAP Databases Area � Common OLAP Applications � Relational Data Marts and OLAP Cubes � OLAP in SQL Server 2000 Data Input Data Access 1

  2. OLAP Databases Common OLAP Applications � Executive Information Systems � Financial Applications � Optimized Schema for Fast User Queries � Performance measures � Reporting � Robust Calculation Engine for Numeric Analysis � Exception reporting � Planning � Analysis � Conceptual, Intuitive Data Model � Multidimensional View of Data � Sales/Marketing Applications � Operations Applications � Drill down and drill up � Booking/billing � Manufacturing � Product analysis � Customer service � Pivot views of data � Customer analysis � Product cost Relational Data Marts and OLAP Cubes OLAP in SQL Server 2000 Relational Relational Relational OLAP Cube OLAP Cube � Microsoft Is One of Several OLAP Vendors OLAP Cube Data Mart Data Mart Data Mart � Analysis Services Is Bundled with Microsoft SQL Server Relational N-dimensional Relational N-dimensional Data Storage 2000 Data Storage Data Structure Data structure Data Structure Data structure � Analysis Services Include Detailed and Detailed and Data Content Summarized Data Data Content Summarized Data Summarized Data Summarized Data � OLAP engine Relational and Relational and Relational and Relational and Data Sources � Data mining technology Data Sources Non-relational Sources Non-relational Sources Non-relational Sources Non-relational Sources Fast Performance for Faster Performance for Fast Performance for Faster Performance for Data Retrieval Data Retrieval Data Extract Queries Data Extract Queries Data Extract Queries Data Extract Queries � Understanding Data Warehouse Design The Star Schema Employee_Dim Employee_Dim Employee_Dim EmployeeKey EmployeeKey EmployeeID EmployeeID ... ... � The Star Schema Dimension Table � Fact Table Components Fact Table Time_Dim Time_Dim Time_Dim Product_Dim Product_Dim Product_Dim � Dimension Table Characteristics TimeKey Sales_Fact Sales_Fact ProductKey TimeKey ProductKey TheDate TimeKey TheDate TimeKey ProductID ProductID � The Snowflake Schema ... EmployeeKey ... EmployeeKey ... ... ProductKey ProductKey CustomerKey CustomerKey ShipperKey ShipperKey Sales Amount Sales Amount Unit Sales ... Unit Sales ... Shipper_Dim Shipper_Dim Shipper_Dim Customer_Dim Customer_Dim Customer_Dim ShipperKey CustomerKey ShipperKey CustomerKey ShipperID ShipperID CustomerID CustomerID ... ... ... ... 2

  3. Fact Table Components Dimension Table Characteristics Dimension Dimension Tables Tables sales_fact Table customer_dim customer_dim customer_dim 201 ALFI Alfreds Foreign Keys Foreign Keys Measures Measures 201 ALFI Alfreds customer_key product_key product_key time_key quantity_sales quantity_sales amount_sales customer_key time_key amount_sales product_dim product_dim product_dim 201 25 134 400 10,789 25 123 Chai 25 123 Chai � Describes Business Entities � Contains Attributes That Provide Context to Numeric time_dim time_dim time_dim Data 134 1/1/2000 134 1/1/2000 The grain of the sales_fact table is defined by the lowest � Presents Data Organized into Hierarchies level of detail stored in each dimension � Understanding OLAP Models The Snowflake Schema � OLAP Database Components � OLAP Dimensions vs. Relational Dimensions � Dimension Fundamentals � Dimension Family Relationships � Cube Measures � Defines Hierarchies by Using Multiple Dimension Tables � Relational Data Sources � Is More Normalized than a Single Table Dimension � Is Supported within Analysis Services OLAP Database Components OLAP Dimensions vs. Relational Dimensions OLAP Relational � Numeric Measures REGION REGION � Dimensions West West � Cubes East CA OR STATE REGION East CA West MA OR West NY MA East NY East 3

  4. Dimension Fundamentals Dimension Family Relationships USA is the parent of North West and � South West USA USA USA USA USA USA USA USA � North West and South West are North West North West North West North West North West North West North West North West children of USA Oregon Oregon Oregon Oregon Oregon Oregon Oregon Oregon Washington Washington Washington Washington Washington Washington Washington Washington � North West and California are South West South West South West South West South West South West South West South West descendants of USA California California California California California California California California � North West and USA are ancestors of Washington � North West and South West are siblings Oregon and California are cousins � � All are dimension members Cube Measures Relational Data Sources � Star and Snowflake Schemas � Are the Numeric Values of Principle Interest � Are required to build a cube with Analysis Services � Correspond to Fact Table Facts � Fact Table � Intersect All Dimensions at All Levels � Contains measures � Are Aggregated at All Levels of Detail � Contains keys that join to dimension tables � Form a Dimension � Dimension Tables � Must exist in same database as fact table � Contain primary keys that identify each member � Applying OLAP Cubes Defining a Cube � Defining a Cube � Querying a Cube Atlanta � Defining a Cube Slice n o i s � Working with Dimensions and Hierarchies n Chicago e m i D � Visualizing Cube Dimensions t Denver e Products Dimension k Grapes r � Connecting to an OLAP Cube a Cherries M Detroit Melons Apples Q4 Q1 Q2 Q3 Time Dimension 4

  5. Querying a Cube Defining a Cube Slice Sales Atlanta Atlanta n n Fact o o i i s s n n e Chicago e Chicago m m i i D D s s t t Denver Denver e e k k Grapes r r Grapes a a M Cherries M Products Dimension Products Dimension Cherries Dallas Detroit Melons Melons Apples Apples Q4 Q4 Q1 Q2 Q3 Q1 Q2 Q3 Time Dimension Time Dimension Working with Dimensions and Hierarchies Visualizing Cube Dimensions � Dimensions Allow You to � Slice � Dice � Hierarchies Allow You to � Drill Down � Drill Up Connecting to an OLAP Cube Review State USA Sales Units � Introducing Data Warehousing 6000 Level 02 5000 � Defining OLAP Solutions Year Quarter 4000 Sheri Now mer - 2001 - Quarter 4 � Understanding Data Warehouse Design Sheri Now mer - 2001 - Quarter 3 3000 Sheri Now mer - 2001 - Quarter 2 Sheri Now mer - 2001 - Quarter 1 � Understanding OLAP Models 2000 Sheri Now mer - 2000 - Quarter 4 Sheri Now mer - 2000 - Quarter 3 � Applying OLAP Cubes 1000 Sheri Now mer - 2000 - Quarter 2 Sheri Now mer - 2000 - Quarter 1 0 Bagels Muffins Sliced Bread Cheese Deli Meats Frozen Chicken Bread Dairy Meat Category Subcategory 5

Recommend

MODERATE SEDATION MODULE MODERATE SEDATION MODULE MODERATE SEDATION MODULE Introduction

MODERATE SEDATION MODULE MODERATE SEDATION MODULE MODERATE SEDATION MODULE Introduction

1100 S. Van Dyke Bad Axe, Michigan 48413 989-269- 9521 Fax: 989 -269-7948 www.huronmedicalcenter.org MODERATE SEDATION MODULE MODERATE SEDATION MODULE MODERATE SEDATION MODULE Introduction Introduction Introduction The purpose of this

383 views • 25 slides
JOBS IN VALUE CHAINS ANALYSIS INTRODUCTION Roadmap: Why are we here today? Agenda for the

JOBS IN VALUE CHAINS ANALYSIS INTRODUCTION Roadmap: Why are we here today? Agenda for the

JOBS IN VALUE CHAINS ANALYSIS INTRODUCTION Roadmap: Why are we here today? Agenda for the program Introduction Module 1a Module 1b Module 2a Module 2b Module 3a Module 3b Module 3c Module 3d Module 3e Module 4 INTRODUCTION: WHY ARE

853 views • 52 slides
1 MODULE SPECIFICATION Module Aims The module aims to deliver knowledge of the essential

1 MODULE SPECIFICATION Module Aims The module aims to deliver knowledge of the essential

MODULE SPECIFICATION Project Management and Credit Module Title: Level : 5 20 Presentation Techniques Value : Is this a Code of module Module code : ENG543 new NO being replaced : module? Cost Centre : GAME JACS3 code : F311

261 views • 4 slides
Introduction to training offering by EMA Training Module PhV-M0 This module provides an overview

Introduction to training offering by EMA Training Module PhV-M0 This module provides an overview

Introduction to training offering by EMA Training Module PhV-M0 This module provides an overview of all training offerings planned by EMA in the area of EudraVigilance, EVDAS, ADR reporting and signal detection providing learning paths for new

341 views • 23 slides
Specifications Introduction to the Module This module is dedicated to specifications The

Specifications Introduction to the Module This module is dedicated to specifications The

Module 7 Specifications Introduction to the Module This module is dedicated to specifications The docstring at start of a function (DEMO) Also the website documentation (DEMO) Useful for knowing how a function works What if you

501 views • 31 slides
WebEOC Training 1 Topics Module 1 WebEOC Overview Module 2 Getting Started Module 3

WebEOC Training 1 Topics Module 1 WebEOC Overview Module 2 Getting Started Module 3

WebEOC Training 1 Topics Module 1 WebEOC Overview Module 2 Getting Started Module 3 Status Boards Position Log Request for Assistance Mission/Task Significant Events Module 4 Forms Module 5 Links Module 6

847 views • 72 slides
Vector Space Models Module Introduction CS6200: Information Retrieval In the first module, we

Vector Space Models Module Introduction CS6200: Information Retrieval In the first module, we

Vector Space Models Module Introduction CS6200: Information Retrieval In the first module, we introduced Vector Space Models as an alternative to Boolean Retrieval. This module discusses VSMs in a lot more detail. By the end of the module, you

252 views • 21 slides
Canadian Bioinformatics Workshops www.bioinformatics.ca Module #: Title of Module 2 Module bio

Canadian Bioinformatics Workshops www.bioinformatics.ca Module #: Title of Module 2 Module bio

Canadian Bioinformatics Workshops www.bioinformatics.ca Module #: Title of Module 2 Module bio informatics .ca Module 7 Data Visualization Anamaria Crisan Learning Objectives of Module Understand the process of encoding and decoding

1.31k views • 79 slides
Module 3 Supervisory Transition Module 3: Superivsory Transition 1 Objectives Learn about

Module 3 Supervisory Transition Module 3: Superivsory Transition 1 Objectives Learn about

Module 2 was an overview about leadership. But, how do we or did we gain an opportunity to lead? Module 3 gives us insight into transitioning from an employee into a supervisor and/or manager. 0 Module 3 Supervisory Transition Module 3:

1.03k views • 18 slides
EudraVigilance Components & Functionality Introduction Training Module EV-M2 This module

EudraVigilance Components & Functionality Introduction Training Module EV-M2 This module

EudraVigilance Components & Functionality Introduction Training Module EV-M2 This module outlines the EudraVigilance system components and system functionalities An agency of the European Union Content Summary Introduction EudraVigilance

542 views • 24 slides
Module 12 Effective Communication, The Who Stakeholder Identification & Engagement 1 Module

Module 12 Effective Communication, The Who Stakeholder Identification & Engagement 1 Module

As you learned to take your leadership vision and create a progressive strategy in Module 11, it should be apparent that our stakeholders are a priority. Module 12 identifies how to effectively communicate with our stakeholders. 0 Module 12

473 views • 15 slides
Agenda Module 1 - Risk, Volatility & Timescale Module 2 - Asset Allocation Module 3 -

Agenda Module 1 - Risk, Volatility & Timescale Module 2 - Asset Allocation Module 3 -

Agenda Module 1 - Risk, Volatility & Timescale Module 2 - Asset Allocation Module 3 - Identifying the Building Blocks Module 4 - Reviewing a portfolio This Module Active vs Passive investing Off the shelf solutions Trackers and ETFs and

648 views • 32 slides
Module 9 Undecidability What computers cannot do. CS 360: Introduction to the Theory of

Module 9 Undecidability What computers cannot do. CS 360: Introduction to the Theory of

Module 9 Undecidability What computers cannot do. CS 360: Introduction to the Theory of Computing Winter 2015 Collin Roberts University of Waterloo 1 Topics for this module An undecidable language Other undecidable languages

848 views • 68 slides
COURSE Risk Assessment Guidance for Superfund (RAGS) MODULE Orientation and Introduction TIME

COURSE Risk Assessment Guidance for Superfund (RAGS) MODULE Orientation and Introduction TIME

COURSE Risk Assessment Guidance for Superfund (RAGS) MODULE Orientation and Introduction TIME LIMIT 30 minutes MODULE GOALS At the completion of this module, students will be able to describe applicable legislation for U.S. EPA Superfund

773 views • 53 slides
TRI Training Module Agendas Basic Concepts Module 1. Introduction 2. Covered Sectors R

TRI Training Module Agendas Basic Concepts Module 1. Introduction 2. Covered Sectors R

T R I R E P O R T I N G R E Q U I R E M E N T S T R I R E P O R T I N G R E Q U I R E M E N T S T R I R E P O R T I N G R E Q U I R E M E N T S T R I R E P O

467 views • 34 slides
Module 1 Concepts and Elements of Wildlife Crime Overview of this module Introduction

Module 1 Concepts and Elements of Wildlife Crime Overview of this module Introduction

Wildlife and Criminal Law Module 1 Concepts and Elements of Wildlife Crime Overview of this module Introduction International and Regional Dimension Elements of Criminal Liability Wildlife Offences Relationship with Other Crimes I

848 views • 57 slides
1 The objectives of this e-module are to learn how to register for a Data Universal Numbering

1 The objectives of this e-module are to learn how to register for a Data Universal Numbering

Welcome to our e-module series on How to Work with USAID. This e- module is the first part on Registering for Federal Award Systems and focuses on DUNS registration. This e-module is geared towards non- governmental organizations

498 views • 22 slides
6.15 Module 15: Research and Presentation Module Title Research and Presentation Module NFQ

6.15 Module 15: Research and Presentation Module Title Research and Presentation Module NFQ

6.15 Module 15: Research and Presentation Module Title Research and Presentation Module NFQ Level (only if an NFQ level can be 7 demonstrated) Module number/Reference BAAMT206 Parent Programme BA (Hons) in Audio and Music Technology Stage

340 views • 6 slides
Emergency Management Roles and Responsibilities Joe Myers Agenda MODULE 1 WHAT IS MODULE

Emergency Management Roles and Responsibilities Joe Myers Agenda MODULE 1 WHAT IS MODULE

Emergency Management Roles and Responsibilities Joe Myers Agenda MODULE 1 WHAT IS MODULE 2 MODULE 3 LAWS MODULE 4 UTILIZING MODULE 5 BLUE MODULE 6 FUNDING EMERGENCY COURTHOUSE AND AUTHORITIES THE UNIFIED

654 views • 40 slides
Camp Marine Module Camp Marine Module April 2015 Version 1.0 Slide: 1 Camp Marine Module Agenda

Camp Marine Module Camp Marine Module April 2015 Version 1.0 Slide: 1 Camp Marine Module Agenda

Camp Marine Module Camp Marine Module April 2015 Version 1.0 Slide: 1 Camp Marine Module Agenda Course Classroom Topics 9. Basic Seamanship 1. Introduction 10. Vessel Stability 2. Canada Shipping Act 2001 and Regulations 11. Manoeuvering a Vessel

1.24k views • 103 slides
CPSC 121: Models of Computation Module 0: Course Introduction UBC's Vancouver campus is located

CPSC 121: Models of Computation Module 0: Course Introduction UBC's Vancouver campus is located

CPSC 121: Models of Computation Module 0: Course Introduction UBC's Vancouver campus is located on the traditional, ancestral, unceded territory of the Musqueam People. Today's learning goals By the end of this module, you should be able to:

559 views • 23 slides
Module 13 Introduction to Semantic Technology, Ontologies and the Semantic Web Module 13 Outline

Module 13 Introduction to Semantic Technology, Ontologies and the Semantic Web Module 13 Outline

Module 13 Introduction to Semantic Technology, Ontologies and the Semantic Web Module 13 Outline 10.30-12.30 Introduction to the Semantic Web Ontologies Semantic Web related standards 12.30-14.00 Lunch break 14.00-16.00 Semantic

1.14k views • 85 slides
Basic Mechatronics Workshop Module 3: Introduction to PLC LAB-5 PLC Hardware Configure (Power

Basic Mechatronics Workshop Module 3: Introduction to PLC LAB-5 PLC Hardware Configure (Power

Basic Mechatronics Workshop Module 3: Introduction to PLC LAB-5 PLC Hardware Configure (Power and CPU, Base, Input, Output, Special Module) (Conference of Presentation) Dr. Mohamed Abdalbar Lecturer, Mechatronics Department, Egyptian-Korean

326 views • 15 slides
Digital Media Analytics January 30, 2014 Agenda Introduction Module 1: Brief Overview

Digital Media Analytics January 30, 2014 Agenda Introduction Module 1: Brief Overview

Digital Media Analytics January 30, 2014 Agenda Introduction Module 1: Brief Overview of Digital Media Ecosystem Module 2: Competencies and Technology Needed to Succeed Module 3: Discussion of Data Created within Ecosystem

1.19k views • 114 slides

More recommend