培訓材料DAY2NCR數(shù)據(jù)倉庫事業(yè)部.ppt

FS-LDM培訓材料（DAY 3）,NCR數(shù)據(jù)倉庫事業(yè)部 2005-03,2,FINANCE,ASSET,PARTY,Not all relationships are shown,LOCATION,A geographical area, physical or electronic address.,An individual or group of individuals.,EVENT,Financial or non-financial event which may involve contact with the customer.,INTERNAL ORGANIZATION,A unit of business within the financial institution or insurance company.,AGREEMENT,An arrangement between the customer and financial institution or insurance company for a product.,PRODUCT,Any marketable product or service including terms and conditions.,CAMPAIGN,A strategy, plan or promotional event for the purpose of acquiring retaining, or expanding usage by customers.,CHANNEL,The vehicle by which a customer interacts with the Financial institution/insurance company.,The internal accounting of the business,Things that Parties have an interest in and has value,FS-LDM (第一級),3,議程安排,Event Channel Campaign Finance Summary,4,議程安排,Event Channel Campaign Finance Summary,5,FINANCE,ASSET,PARTY,Not all relationships are shown,LOCATION,A geographical area, physical or electronic address.,An individual or group of individuals.,EVENT,Financial or non-financial event which may involve contact with the customer.,INTERNAL ORGANIZATION,A unit of business within the financial institution or insurance company.,AGREEMENT,An arrangement between the customer and financial institution or insurance company for a product.,PRODUCT,Any marketable product or service including terms and conditions.,CAMPAIGN,A strategy, plan or promotional event for the purpose of acquiring retaining, or expanding usage by customers.,CHANNEL,The vehicle by which a customer interacts with the Financial institution/insurance company.,The internal accounting of the business,Things that Parties have an interest in and has value,FS-LDM (第一級),6,EVENT主題,事件是銀行與客戶或潛在客戶之間的聯(lián)系或交易活動，它記錄了詳細的行為和交易數(shù)據(jù)，包括存取款、收費、計息、咨詢投訴、查詢、市場調(diào)查、網(wǎng)上交易等。 可能需要也可能不需要銀行與客戶的直接接觸；可能與帳戶相關(guān)，也可能與帳戶無關(guān)；可能與資金相關(guān)，也可能與資金無關(guān)。 通過事件可以幫助了解哪些客戶使用哪些渠道做哪種交易事件，交易金額多少、什么時間、在什么地點、與金融機構(gòu)的哪位員工或部門打交道。,7,Event (including Claims) Something that happened that is of interest.,Examples: Deposit, Withdrawal, Credit/debit card charge, Interest and fee charges, Complaint/Inquiry, Address Change, Balance Inquiry, Campaign solicitation/response, Internet page view, Brokerage buy/sell, Premium Payment, Payment Request (claim) Major Features: Financial and non-financial events Customer or financial institution initiated Information about insurance claims and relationship to parties and policies. Automatic transactions (e.g. interest/fee charges) Events grouped into sessions - e.g internet session Event-related currency code - multi-currency environment Activity classifications May trigger journal vouchers (debit and credit) Related to Channel, Parties, other Events, Ledger, Campaign, and Agreements,8,EVENT主題-關(guān)鍵實體和關(guān)系,事件 事件活動種類 事件關(guān)系 事件成本 事件分類 事件產(chǎn)品關(guān)系,事件地區(qū)關(guān)系 信用卡-購買、授權(quán)、結(jié)算 催收和還款事件,9,EVENT主題- 概貌,賬戶事件,事件,金融事件,聯(lián)系事件,賬戶組事件,互不排斥！,10,EVENT主題-事件,事件實體記錄了銀行的所有交互活動。 這些事件可能與金錢相關(guān)，也可能與金錢無關(guān)?？赡芘c帳戶相關(guān)，也可能與帳戶無關(guān)。 事件屬性中保留業(yè)務(wù)系統(tǒng)的交易碼Transaction Id。 事件包含存款、取款、查詢、付款、利息入帳等交易，屬性Event Activity Type Cd區(qū)別不同種類的事件活動。 與事件相關(guān)的當事人記錄在EVENT PARTY中，一個事件可能與多個當事人相關(guān)，包括引發(fā)事件的客戶、聯(lián)系客戶的員工、處理事件的金融機構(gòu)、購買事件的商戶、提供電話服務(wù)的呼叫中心。 客戶與金融機構(gòu)聯(lián)系的渠道信息記錄在CONTACT EVENT。,11,EVENT主題-事件活動種類,事件,活動種類交易類型,活動類型交易碼,12,EVENT主題-事件組,EVENT GROUP記錄了對于金融機構(gòu)來說具有某種特定含義的事件，如一個客戶在同一臺ATM上連續(xù)進行的查詢余額、存款、轉(zhuǎn)帳交易，以上三個交易將稱為一個session而被包含進相同的EVENT GROUP。金融機構(gòu)可為不同的目的對事件進行多種方式的分組。 EVENT GROUP ASSOC實體將事件和事件組進行關(guān)聯(lián)，一個事件可能和很多事件組關(guān)聯(lián)，一個事件組包含多個事件。,事件,事件組,事件和事件組關(guān)系,事件關(guān)系,13,EVENT主題信用卡購買/授權(quán)/結(jié)算,實例：假設(shè)持卡人帳戶行和商戶行是同一家銀行。 客戶使用信用卡在商戶購物，商戶請求銀行授權(quán)。 假如授權(quán)被銀行批準，則商戶允許客戶購買。 日終，商戶向銀行送出所有信用卡購物的結(jié)算請求。 銀行結(jié)算信用卡回單并向商戶支付款項。 以上例子引發(fā)的事件如下表：,14,EVENT主題信用卡購買/授權(quán)/結(jié)算,15,EVENT主題信用卡購買/授權(quán)/結(jié)算,16,PARTY、ACCOUNT、EVENT的關(guān)系,事件,當事人,事件和當事人,協(xié)議和當事人,協(xié)議,17,議程安排,Event Channel Campaign Finance Summary,18,FINANCE,ASSET,PARTY,Not all relationships are shown,LOCATION,A geographical area, physical or electronic address.,An individual or group of individuals.,EVENT,Financial or non-financial event which may involve contact with the customer.,INTERNAL ORGANIZATION,A unit of business within the financial institution or insurance company.,AGREEMENT,An arrangement between the customer and financial institution or insurance company for a product.,PRODUCT,Any marketable product or service including terms and conditions.,CAMPAIGN,A strategy, plan or promotional event for the purpose of acquiring retaining, or expanding usage by customers.,CHANNEL,The vehicle by which a customer interacts with the Financial institution/insurance company.,The internal accounting of the business,Things that Parties have an interest in and has value,FS-LDM (第一級),19,CHANNEL主題,用戶通過渠道向金融機構(gòu)獲取關(guān)金融機構(gòu)或金融機構(gòu)產(chǎn)品信息以及使用金融產(chǎn)品。金融機構(gòu)通過渠道向用戶銷售產(chǎn)品或提供服務(wù)。 渠道與當事人、產(chǎn)品、帳號等其他實體存在各種關(guān)系。 渠道分為若干渠道類型。,20,Channel A vehicle for interaction with the financial institution,Examples: ATM, Branch workstation, Telephone, Web site/internet address, Call center, Voice Response Unit, Point of Sale terminal, Television, Radio, Mail Major Features: Includes specific channel devices Multiple channel types Channel characteristics and capacities Related to Events, Parties and Campaigns,21,CHANNEL主題 業(yè)務(wù)規(guī)則,渠道分為若干類型，例如ATM渠道。 當事人可以和渠道之間存在一種或多種關(guān)系，也可以不存在任何關(guān)系。 一個帳戶可以屬于一個渠道或者通過一個渠道來進行管理。 渠道有自己的一些相關(guān)信息，例如功能，特征或地理位置。 一個渠道有其最大容量，例如每小時可以處理的業(yè)務(wù)筆數(shù)。,22,CHANNEL主題 主要實體和關(guān)系,渠道 渠道類型 當事人/渠道 渠道/AGREEMENT 渠道/渠道事件 渠道成本 渠道收益 渠道事件 渠道容量 物理郵件 ATM，POS，街亭，電子 電話，柜面，電臺 電視，印刷，呼叫中心,關(guān)系 渠道 - 當事人 渠道 - 帳戶 渠道 - 渠道事件,23,CHANNEL主題 主要實體,渠道,渠道類型,渠道事件,渠道描述信息,渠道容量,賬戶和渠道,當事人和渠道關(guān)系,渠道營業(yè)時間,24,CHANNEL主題 - 渠道,實體CHANNEL標識了所有金融機構(gòu)用來與用戶進行銷售或服務(wù)聯(lián)系時所使用的渠道。 一個渠道是用戶用來接受有關(guān)金融機構(gòu)或金融機構(gòu)產(chǎn)品信息以及使用金融產(chǎn)品時的載體。 在實體CHANNEL 中每一個特定的渠道都有一個ID號相對應(yīng)。例如，一臺ATM機有一個ID號，一個POS終端也有一個ID號。 實體CHANNEL也包含了外部渠道。例如其他機構(gòu)的ATM機器。,25,CHANNEL主題分類,物理郵件 ATM 街亭 電子 電話 柜面 電臺 電視 印刷 呼叫中心 LOCK BOX POS終端,26,議程安排,Event Channel Campaign Finance Summary,27,FINANCE,ASSET,PARTY,Not all relationships are shown,LOCATION,A geographical area, physical or electronic address.,An individual or group of individuals.,EVENT,Financial or non-financial event which may involve contact with the customer.,INTERNAL ORGANIZATION,A unit of business within the financial institution or insurance company.,AGREEMENT,An arrangement between the customer and financial institution or insurance company for a product.,PRODUCT,Any marketable product or service including terms and conditions.,CAMPAIGN,A strategy, plan or promotional event for the purpose of acquiring retaining, or expanding usage by customers.,CHANNEL,The vehicle by which a customer interacts with the Financial institution/insurance company.,The internal accounting of the business,Things that Parties have an interest in and has value,FS-LDM (第一級),28,CAMPAIGN主題概述,營銷活動是為了獲取、維護、增強銀行與客戶的關(guān)系而開展的一些促銷的活動； 營銷活動是一些有組織的活動，其目的可以是為了把某些產(chǎn)品推向市場，也有可能是為了樹立銀行在市場上的形象； 完整的營銷活動應(yīng)該包括營銷策略、營銷行為以及營銷活動的反饋信息； 收集營銷活動的信息可以幫助銀行發(fā)現(xiàn)最有效的營銷方式，了解不同類型客戶對營銷活動的反饋；,29,Campaign A communication plan to deliver a message,Examples: Direct mail campaign, TV, Radio, Print Advertisement, Telemarketing, Internet Major Features: Multiple levels of campaigns from strategy to execution Multiple functions (Marketing & Collection/Recovery) Costs, revenues and dates Mass, micro and targeted campaign Advertisement message, offer and composition Related to Channels, Customer Segments, Products, Events,30,CAMPAIGN主題業(yè)務(wù)規(guī)則,營銷活動的策略可能是很多層次的； 一個營銷活動可能會導(dǎo)致實施一個或多個實際的促銷事件； 一個營銷活動可以通過和其他主題的關(guān)系，實現(xiàn)一些特別的活動，如只針對某些地區(qū)（LOCATION）；只涉及某些產(chǎn)品（PRODUCT）、只在某些機構(gòu)進行（內(nèi)部組織機構(gòu)）或者只和某類賬戶（ACCOUNT）相關(guān)； 一些外部的市場信息（如市場細分等）可以服務(wù)一些特定的營銷活動； 高層營銷策略會針對多種渠道設(shè)計，但是具體的一個營銷事件只涉及一種渠道； 營銷事件的結(jié)果可能會導(dǎo)致開立一個賬戶； 一個營銷活動可能有多種優(yōu)惠措施和條件；,31,CAMPAIGN主題主要實體和關(guān)系,營銷活動策略 營銷活動的分類 營銷活動事件 目標營銷 營銷活動的優(yōu)惠條件 營銷活動的市場計劃信息 廣告的放置 廣告活動的實施,營銷活動和賬戶的關(guān)系 營銷活動和內(nèi)部機構(gòu)的關(guān)系 營銷活動和產(chǎn)品、當事人的關(guān)系 營銷活動和location的關(guān)系,32,CAMPAIGN主題概貌,自關(guān)聯(lián)，可存放所有層次的營銷策略，主要記錄營銷活動計劃收入、預(yù)計成本等；,“大眾營銷”實體主要記錄電視廣告、報刊雜志廣告等類型的營銷活動；,“目標營銷”實體主要記錄以目標客戶為對象的營銷活動，而目標客戶的獲得是依賴于對客戶信息的分析結(jié)果；,營銷活動實際實施的一些結(jié)果的記錄；,33,CAMPAIGN主題目標營銷,目標營銷,營銷活動,營銷策略,目標營銷活動的細分群,當事人細分,市場細分,細分標準,34,CAMPAIGN主題優(yōu)惠條件,營銷活動的優(yōu)惠條件，包括需滿足的條件以及提供的優(yōu)惠；,優(yōu)惠條件和營銷活動的關(guān)系,營銷活動優(yōu)惠條件的期限、條件等具體特征,優(yōu)惠條件和 產(chǎn)品的關(guān)系,優(yōu)惠條件和 廣告的關(guān)系,35,CAMPAIGN主題廣告,廣告的簡單描述,廣告的放置,廣播廣告,電視廣告,傳單,網(wǎng)絡(luò)廣告,促銷活動,36,CAMPAIGN主題和EVENT的關(guān)系,促銷活動,營銷策略,目標營銷,目標營銷事件,接觸事件,37,CAMPAIGN主題和其他主題的關(guān)系,營銷活動和賬戶的關(guān)系,營銷活動和內(nèi)部機構(gòu)的關(guān)系,營銷活動和產(chǎn)品的關(guān)系,和地理位置的關(guān)系,營銷策略和渠道類型的關(guān)系,38,議程安排,Event Channel Campaign Finance Summary,39,FINANCE,ASSET,PARTY,Not all relationships are shown,LOCATION,A geographical area, physical or electronic address.,An individual or group of individuals.,EVENT,Financial or non-financial event which may involve contact with the customer.,INTERNAL ORGANIZATION,A unit of business within the financial institution or insurance company.,AGREEMENT,An arrangement between the customer and financial institution or insurance company for a product.,PRODUCT,Any marketable product or service including terms and conditions.,CAMPAIGN,A strategy, plan or promotional event for the purpose of acquiring retaining, or expanding usage by customers.,CHANNEL,The vehicle by which a customer interacts with the Financial institution/insurance company.,The internal accounting of the business,Things that Parties have an interest in and has value,FS-LDM (第一級),40,Major Features Tracks General Ledger and Journal Voucher information GL Subtyping - Assets, Liabilities, Equity, Revenue and Expense GL Balance over time - for budget and actual Link to Transaction Event and customer Account/Policy To provide for drill down from GL to Agreement and to transaction Event Exam