10 telecommunications and utilities
This presentation is the property of its rightful owner.
Sponsored Links
1 / 48

บทที่ 10 Telecommunications and Utilities PowerPoint PPT Presentation


  • 52 Views
  • Uploaded on
  • Presentation posted in: General

บทที่ 10 Telecommunications and Utilities. สมาชิกกลุ่ม นายจิรพงษ์ วัฒนธรรม 49050909 นายนที เสงี่ยม 49051022 นายพนัส สุนทรไพบูลย์กุล 49051113 นายสุกิจ เบญจางจารุ 49051253 นายธนภัทร สุวรรณนิกรกุล 49054190. Introduce. Design Dimensional Model จากจุดที่มีความผิดปกติ

Download Presentation

บทที่ 10 Telecommunications and Utilities

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


10 telecommunications and utilities

10Telecommunications and Utilities

49050909

49051022

49051113

49051253

49054190


Introduce

Introduce

  • Design Dimensional Model

  • Whats wrong with this picture.

  • Billing Telecommunication Basis Case Study

  • Geographic Location Dimension


Telecommunication case study

Telecommunication Case Study

  • Data Warehouse

  • Data Warehouse

  • Core Business Process Dimension


Data warehouse bus matrix

Data Warehouse Bus Matrix


Business process

Business Process

    • Rate Plan

    • Data Warehouse Bus Matrix Business Process


Billing every month

Billing Every Month

Bill

Service Line 1RatePlan1

Service Line 2RatePlan1

Service Line 3RatePlan2

Service Line 4RatePlan3


Fact table

Fact table

  • Grain 1 1 Bill


10 telecommunications and utilities


Granularity

Granularity

  • Q:

  • A: Grain


Granularity1

Granularity

  • Granularity Business Process

  • *


Fact granularity

Fact Granularity

  • Q: Fact Table

  • A: additive ( //) Bill year-to-date


Dimension granularity

Dimension Granularity

  • Q:Snowflaking Normalization DimensionTable Query

  • A: Dimension Fact 1 Attribute Key


Date dimension

Date Dimension

  • Q: Fact

  • A: Fact

    • Date Dimension

    • Date DateDimension


Fixed time series bucket date dimension

Fixed Time-Series Bucket Date Dimension

  • Date Dimension

    • month fact

    • 12

      • Database Application

      • Date Dimension

      • Fixed Slot ()


Degenerate dimension

Degenerate Dimension

  • Q: Dimension Fact

  • A: Degenerate Dimension Dimension


Degenerate dimension1

Degenerate Dimension

  • (Transaction)

  • Degenerate Dimension

  • Dimension


Dimension decodes and descriptions

Dimension Decodesand Descriptions

  • Dimension Table


Surrogate keys

Surrogate Keys

  • Key ID Database Surrogate Keys Dimension

    • 2


Dimension

Dimension ?

  • Dimension 5 15 Dimension

  • 2-3 Dimension 9

  • 25-30 Dimension 2 5 Dimension


Draft design exercise discussion

Draft Design Exercise Discussion

  • Granularity Fact Table

    • Service Line Bill

    • Bill Dimension Service Line Service Line Number

      * Service Line Bill


Draft design exercise discussion1

Draft Design Exercise Discussion

  • Service Line Key Fact Table

  • Bill Fact Table Bill Date Dimension

  • Bill Date Dimension Fact Table

  • Bill Date Dimension Degenerate Dimension


10 telecommunications and utilities

  • Sale Rep Dimension Sale Org Dimension

  • Sale Rep Snowflaked

  • Snowflaked

  • 2 Attributes Sale Rep Dimension Sale Org Key Fact Table


10 telecommunications and utilities

  • RatePlan

  • Fact Table Surrogate Key

  • Attribute RatePlanDimension Table


10 telecommunications and utilities

  • Surrogate Key (ID Key)

  • Table System Key Primary Key

  • Surrogate Key Dimension

  • Primary Key Foreign Keys Fact Table


10 telecommunications and utilities

  • Year-to-Date Fact Table

  • Attribute Year-to-Date

  • Year-to-Date Update error

  • Attribute Year-to-Date Date Dimension


Finally

Finally

  • Attributes Dimension


Geographic location dimension

Geographic Location Dimension

  • Location

  • Dimension Location


Geographic location dimension1

Geographic Location Dimension

  • Single Master Location Table Dimension Role-Playing

  • LocationTable

    • service line telephone number

    • service location


Location outrigger

Location Outrigger

  • Location Snowflakes Outriggers

  • Dimension Location

  • join Dimension Location Clone Location Table Location Clone 5 Date Role-Playing Dimension


Location outrigger1

Location Outrigger

  • Geographic Dimension

  • Location Dimension

  • Performance Location Dimension


Leveraging geographic information system

Leveraging Geographic Information System

  • Data Warehouse

  • GIS Tool

  • GIS

  • GIS Tool


Leveraging geographic information system1

Leveraging Geographic Information System

  • Database


Leveraging geographic information system2

Leveraging Geographic Information System

  • GIS Tool

    • parsed form (parsed address)

    • Geocoder parsed address standard street network database

    • location object plot


10 telecommunications and utilities

What is the IBM Telecommunications Data Warehouse?

IBMs Telecommunications Data Warehouse (TDW) enables Operators to build data warehouse solutions to suit their specific needs. TDW includes all of the key components required for the core of a data warehousing solution.

The TDW comprises a flexible and scalable data warehouse infrastructure, enabling Operators to build a comprehensive data warehouse solution through phased development. This solution enables the rapid delivery of high business value by initially focusing on the business areas offering the greatest returns and feasibility, while building within a proven technical warehousing architecture.


What is the telecommunications data warehouse model

What is the Telecommunications Data Warehouse Model?

  • The Telecommunications Data Warehouse Model (TDWM) provides Operators with both the content and the infrastructure to support the provision of clean, rationalized and easily accessible data from a central information repository. It allows Operators to exploit the potential of information previously locked in legacy systems and summarized in distributed data marts in accessible to most business users.


10 telecommunications and utilities

The Four Business AreasThe TDW Solution contains more than 20BSTs covering four businessareas.


  • Login