培訓(xùn)材料DAY2NCR數(shù)據(jù)倉(cāng)庫(kù)事業(yè)部.pptVIP

FS-LDM培訓(xùn)材料（DAY 3）,NCR數(shù)據(jù)倉(cāng)庫(kù)事業(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 (第一級(jí)),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 (第一級(jí)),6,EVENT主題,事件是銀行與客戶或潛在客戶之間的聯(lián)系或交易活動(dòng)，它記錄了詳細(xì)的行為和交易數(shù)據(jù)，包括存取款、收費(fèi)、計(jì)息、咨詢投訴、查詢、市場(chǎng)調(diào)查、網(wǎng)上交易等。 可能需要也可能不需要銀行與客戶的直接接觸；可能與帳戶相關(guān)，也可能與帳戶無(wú)關(guān)；可能與資金相關(guān)，也可能與資金無(wú)關(guān)。 通過(guò)事件可以幫助了解哪些客戶使用哪些渠道做哪種交易事件，交易金額多少、什么時(shí)間、在什么地點(diǎn)、與金融機(jī)構(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)鍵實(shí)體和關(guān)系,事件 事件活動(dòng)種類 事件關(guān)系 事件成本 事件分類 事件產(chǎn)品關(guān)系,事件地區(qū)關(guān)系 信用卡-購(gòu)買、授權(quán)、結(jié)算 催收和還款事件,9,EVENT主題- 概貌,賬戶事件,事件,金融事件,聯(lián)系事件,賬戶組事件,互不排斥！,10,EVENT主題-事件,事件實(shí)體記錄了銀行的所有交互活動(dòng)。 這些事件可能與金錢相關(guān)，也可能與金錢無(wú)關(guān)?？赡芘c帳戶相關(guān)，也可能與帳戶無(wú)關(guān)。 事件屬性中保留業(yè)務(wù)系統(tǒng)的交易碼Transaction Id。 事件包含存款、取款、查詢、付款、利息入帳等交易，屬性Event Activity Type Cd區(qū)別不同種類的事件活動(dòng)。 與事件相關(guān)的當(dāng)事人記錄在EVENT PARTY中，一個(gè)事件可能與多個(gè)當(dāng)事人相關(guān)，包括引發(fā)事件的客戶、聯(lián)系客戶的員工、處理事件的金融機(jī)構(gòu)、購(gòu)買事件的商戶、提供電話服務(wù)的呼叫中心。 客戶與金融機(jī)構(gòu)聯(lián)系的渠道信息記錄在CONTACT EVENT。,11,EVENT主題-事件活動(dòng)種類,事件,活動(dòng)種類交易類型,活動(dòng)類型交易碼,12,EVENT主題-事件組,EVENT GROUP記錄了對(duì)于金融機(jī)構(gòu)來(lái)說(shuō)具有某種特定含義的事件，如一個(gè)客戶在同一臺(tái)ATM上連續(xù)進(jìn)行的查詢余額、存款、轉(zhuǎn)帳交易，以上三個(gè)交易將稱為一個(gè)session而被包含進(jìn)相同的EVENT GROUP。金融機(jī)構(gòu)可為不同的目的對(duì)事件進(jìn)行多種方式的分組。 EVENT GROUP ASSOC實(shí)體將事件和事件組進(jìn)行關(guān)聯(lián)，一個(gè)事件可能和很多事件組關(guān)聯(lián)，一個(gè)事件組包含多個(gè)事件。,事件,事件組,事件和事件組關(guān)系,事件關(guān)系,13,EVENT主題信用卡購(gòu)買/授權(quán)/結(jié)算,實(shí)例：假設(shè)持卡人帳戶行和商戶行是同一家銀行。 客戶使用信用卡在商戶購(gòu)物，商戶請(qǐng)求銀行授權(quán)。 假如授權(quán)被銀行批準(zhǔn)，則商戶允許客戶購(gòu)買。 日終，商戶向銀行送出所有信用卡購(gòu)物的結(jié)算請(qǐng)求。 銀行結(jié)算信用卡回單并向商戶支付款項(xiàng)。 以上例子引發(fā)的事件如下表：,14,EVENT主題信用卡購(gòu)買/授權(quán)/結(jié)算,15,EVENT主題信用卡購(gòu)買/授權(quán)/結(jié)算,16,PARTY、ACCOUNT、EVENT的關(guān)系,事件,當(dāng)事人,事件和當(dāng)事人,協(xié)議和當(dāng)事人,協(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 (第一級(jí)),19,CHANNEL主題,用戶通過(guò)渠道向金融機(jī)構(gòu)獲取關(guān)金融機(jī)構(gòu)或金融機(jī)構(gòu)產(chǎn)品信息以及使用金融產(chǎn)品。金融機(jī)構(gòu)通過(guò)渠道向用戶銷售產(chǎn)品或提供服務(wù)。 渠道與當(dāng)事人、產(chǎn)品、帳號(hào)等其他實(shí)體存在各種關(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渠道。 當(dāng)事人可以和渠道之間存在一種或多種關(guān)系，也可以不存在任何關(guān)系。 一個(gè)帳戶可以屬于一個(gè)渠道或者通過(guò)一個(gè)渠道來(lái)進(jìn)行管理。 渠道有自己的一些相關(guān)信息，例如功能，特征或地理位置。 一個(gè)渠道有其最大容量，例如每小時(shí)可以處理的業(yè)務(wù)筆數(shù)。,22,CHANNEL主題 主要實(shí)體和關(guān)系,渠道 渠道類型 當(dāng)事人/渠道 渠道/AGREEMENT 渠道/渠道事件 渠道成本 渠道收益 渠道事件 渠道容量 物理郵件 ATM，POS，街亭，電子 電話，柜面，電臺(tái) 電視，印刷，呼叫中心,關(guān)系 渠道 - 當(dāng)事人 渠道 - 帳戶 渠道 - 渠道事件,23,CHANNEL主題 主要實(shí)體,渠道,渠道類型,渠道事件,渠道描述信息,渠道容量,賬戶和渠道,當(dāng)事人和渠道關(guān)系,渠道營(yíng)業(yè)時(shí)間,24,CHANNEL主題 - 渠道,實(shí)體CHANNEL標(biāo)識(shí)了所有金融機(jī)構(gòu)用來(lái)與用戶進(jìn)行銷售或服務(wù)聯(lián)系時(shí)所使用的渠道。 一個(gè)渠道是用戶用來(lái)接受有關(guān)金融機(jī)構(gòu)或金融機(jī)構(gòu)產(chǎn)品信息以及使用金融產(chǎn)品時(shí)的載體。 在實(shí)體CHANNEL 中每一個(gè)特定的渠道都有一個(gè)ID號(hào)相對(duì)應(yīng)。例如，一臺(tái)ATM機(jī)有一個(gè)ID號(hào)，一個(gè)POS終端也有一個(gè)ID號(hào)。 實(shí)體CHANNEL也包含了外部渠道。例如其他機(jī)構(gòu)的ATM機(jī)器。,25,CHANNEL主題分類,物理郵件 ATM 街亭 電子 電話 柜面 電臺(tái) 電視 印刷 呼叫中心 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 (第一級(jí)),28,CAMPAIGN主題概述,營(yíng)銷活動(dòng)是為了獲取、維護(hù)、增強(qiáng)銀行與客戶的關(guān)系而開展的一些促銷的活動(dòng)； 營(yíng)銷活動(dòng)是一些有組織的活動(dòng)，其目的可以是為了把某些產(chǎn)品推向市場(chǎng)，也有可能是為了樹立銀行在市場(chǎng)上的形象； 完整的營(yíng)銷活動(dòng)應(yīng)該包括營(yíng)銷策略、營(yíng)銷行為以及營(yíng)銷活動(dòng)的反饋信息； 收集營(yíng)銷活動(dòng)的信息可以幫助銀行發(fā)現(xiàn)最有效的營(yíng)銷方式，了解不同類型客戶對(duì)營(yíng)銷活動(dòng)的反饋；,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ī)則,營(yíng)銷活動(dòng)的策略可能是很多層次的； 一個(gè)營(yíng)銷活動(dòng)可能會(huì)導(dǎo)致實(shí)施一個(gè)或多個(gè)實(shí)際的促銷事件； 一個(gè)營(yíng)銷活動(dòng)可以通過(guò)和其他主題的關(guān)系，實(shí)現(xiàn)一些特別的活動(dòng)，如只針對(duì)某些地區(qū)（LOCATION）；只涉及某些產(chǎn)品（PRODUCT）、只在某些機(jī)構(gòu)進(jìn)行（內(nèi)部組織機(jī)構(gòu)）或者只和某類賬戶（ACCOUNT）相關(guān)； 一些外部的市場(chǎng)信息（如市場(chǎng)細(xì)分等）可以服務(wù)一些特定的營(yíng)銷活動(dòng)； 高層營(yíng)銷策略會(huì)針對(duì)多種渠道設(shè)計(jì)，但是具體的一個(gè)營(yíng)銷事件只涉及一種渠道； 營(yíng)銷事件的結(jié)果可能會(huì)導(dǎo)致開立一個(gè)賬戶； 一個(gè)營(yíng)銷活動(dòng)可能有多種優(yōu)惠措施和條件；,31,CAMPAIGN主題主要實(shí)體和關(guān)系,營(yíng)銷活動(dòng)策略 營(yíng)銷活動(dòng)的分類 營(yíng)銷活動(dòng)事件 目標(biāo)營(yíng)銷 營(yíng)銷活動(dòng)的優(yōu)惠條件 營(yíng)銷活動(dòng)的市場(chǎng)計(jì)劃信息 廣告的放置 廣告活動(dòng)的實(shí)施,營(yíng)銷活動(dòng)和賬戶的關(guān)系 營(yíng)銷活動(dòng)和內(nèi)部機(jī)構(gòu)的關(guān)系 營(yíng)銷活動(dòng)和產(chǎn)品、當(dāng)事人的關(guān)系 營(yíng)銷活動(dòng)和location的關(guān)系,32,CAMPAIGN主題概貌,自關(guān)聯(lián)，可存放所有層次的營(yíng)銷策略，主要記錄營(yíng)銷活動(dòng)計(jì)劃收入、預(yù)計(jì)成本等；,“大眾營(yíng)銷”實(shí)體主要記錄電視廣告、報(bào)刊雜志廣告等類型的營(yíng)銷活動(dòng)；,“目標(biāo)營(yíng)銷”實(shí)體主要記錄以目標(biāo)客戶為對(duì)象的營(yíng)銷活動(dòng)，而目標(biāo)客戶的獲得是依賴于對(duì)客戶信息的分析結(jié)果；,營(yíng)銷活動(dòng)實(shí)際實(shí)施的一些結(jié)果的記錄；,33,CAMPAIGN主題目標(biāo)營(yíng)銷,目標(biāo)營(yíng)銷,營(yíng)銷活動(dòng),營(yíng)銷策略,目標(biāo)營(yíng)銷活動(dòng)的細(xì)分群,當(dāng)事人細(xì)分,市場(chǎng)細(xì)分,細(xì)分標(biāo)準(zhǔn),34,CAMPAIGN主題優(yōu)惠條件,營(yíng)銷活動(dòng)的優(yōu)惠條件，包括需滿足的條件以及提供的優(yōu)惠；,優(yōu)惠條件和營(yíng)銷活動(dòng)的關(guān)系,營(yíng)銷活動(dòng)優(yōu)惠條件的期限、條件等具體特征,優(yōu)惠條件和 產(chǎn)品的關(guān)系,優(yōu)惠條件和 廣告的關(guān)系,35,CAMPAIGN主題廣告,廣告的簡(jiǎn)單描述,廣告的放置,廣播廣告,電視廣告,傳單,網(wǎng)絡(luò)廣告,促銷活動(dòng),36,CAMPAIGN主題和EVENT的關(guān)系,促銷活動(dòng),營(yíng)銷策略,目標(biāo)營(yíng)銷,目標(biāo)營(yíng)銷事件,接觸事件,37,CAMPAIGN主題和其他主題的關(guān)系,營(yíng)銷活動(dòng)和賬戶的關(guān)系,營(yíng)銷活動(dòng)和內(nèi)部機(jī)構(gòu)的關(guān)系,營(yíng)銷活動(dòng)和產(chǎn)品的關(guān)系,和地理位置的關(guān)系,營(yíng)銷策略和渠道類型的關(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 (第一級(jí)),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