easycrm Workbench ( ) 2004.04.02
I. CRM 1. CRM 2. CRM 3. II. easybi(business Intelligence) Framework 1. 2. - easydataflow Workbench - easycampaign Workbench - easypivot Reporter.
1. CRM
1.?! 1.. a. & b. (,, ) 2.?! 2.. 2. CRM? a. Catch, b.
3.?! 3.. 3.. a. / b., (!) 4.?! 4..( ) 4. a. Front ImageBack Process b. / //
2. CRM
< > CRM Position 28% 19% 15% 11% 10% 8% 6% 3% < > 13% 6% 4% 5% 13% 13% 23% 23%, / 0% 50% 100% ( ) :, 2001. 11
,., CRM, KPI / AS/ ( ) etc. CRM Fair 2004 VMD/ etc.
Only,, RFM (Purchase Life Cycle) - ( ) CRM Fair 2004 1 / ( & ) ( ) DB Opinion Leader ( ) ( ) etc.
CRM Fair 2004 DW CRM / / / / (?) (Coverage),, : /, KPI / Online/AS/ VMD VMD/ etc.
3. CRM ( )
3. CRM ( ) < > Existing :, : CRM Process Existing Campaign Data Analysis : :
3. CRM ( )
3. CRM ( ) < Type A : 1 >
EXAMPLE 3. CRM ( ) < Life_Cycle > 1 1
EXAMPLE < Type A : 1 > CRM/ On Line A/S VMD Benefit Feedback
3. CRM ( )
3. CRM ( )
3. CRM ( )
3. CRM ( )
3. CRM ( )
3. CRM ( )
3. CRM ( )
3. CRM ( )
3. CRM ( ) < Type B :, >
EXAMPLE < Type B :, > CRM/ On Line,A/S VMD Benefit Feedback
3. CRM ( )
3. CRM ( )
3. CRM ( )
1.
1. / DataWarehouse(or DataMart) easycampaign Workbench Web-POS ERP Web Web Pos ETC Web Summary - -, - - Home Page Customer easypivot Reporter - - - etc -AS ( ) -
2.
2.
2. easydataflow Workbench easydataflow Workbench,, Data Management. easydataflow Workbench Applications ETL : Building DW/DM End-User data handling Data Preparation Data Cleansing Data Quality Workflow Data Objects Technologies DBMS Middleware Web Process Mgr X-Internet Scheduler Mgr JAVA/ActiveX......
2. II. easybi Framework easydataflow Workbench. 14. Perl. SyncSort Flat File :. Multi-DBMS. (Batch). - : Summary/Verify/Pivot/Scoring Job /Job process. CRM Fair 2004
2. II. easybi Framework easydataflow Workbench DataFlow Workbench (Data Manipulation), (Node) ETL.
2. II. easybi Framework easydataflow Workbench DataFlow Workbench ETL(Extraction,Transformation,Loading).,. OLTP/Legacy Data DBMS SAM File Cleansing & Loading Data Warehouse DBMS Meta Info Extraction Dataflow WorkBench Data Mart DBMS SAM Extraction Cleansing & Loading Design & Mapping Extraction Cleansing & Loading Analyzing &Verification Scheduling &Monitoring Dataflow Workbench JDBC DBMS. Source Flat File. DBMSBULK-COPY Utility.. Cleansing Rule. ETL Summary/OLAP Job. Cleansing Rule Job., Job Process,.. CRM Fair 2004 DataFlow Workbench REFORMAT DBMS Flat File Pivot.,, Viewer... Perl.. DataFlow Workbench16.,.
2. II. easybi Framework easydataflow Workbench DataFlow Workbench Active-X Control 100%. ETL.....
2. II. easybi Framework easydataflow Workbench DataFlow Workbench JDBC DBMS. DBMS Bulk-Load. DataFlow WorkbenchFlat File Data. DataFlat File, Flat File (Key). DBMS : SQL Svr, Oracle,DB2.. :JDBC Bulk-Copy Flat File Flat File Pivot Table & Graph Filtering, Cleansing, Sort, Join, Merge, Aggregation, Verification, Splitting Viewer Flat File Import Flat File Excel DataFlow Workbench Pivot Table,Excel. List View
2. easycampaign Workbench Offering o o o Channel o - o o Customer o o o easycampaign Workbench Process o - o o / / o o (Workflow) o o (Schedule Mgr) o (Process Designer) o (Interactive Exec.) o o X-internet Technology
2. II. easybi Framework easycampaign Workbench Campaign Workbench, (Node). Data Data. DB () DB. Select Node Flat File DB
2. II. easybi Framework easycampaign Workbench Scoring Node. DW(or DM)..
2. II. easybi Framework easycampaign Workbench.. easycampaign Workbench.
2. II. easybi Framework easycampaign Workbench. easycampaign Workbench -, -., 1 (or Multi-Wave). (Cell) -. (Cell) - 1..
2. II. easybi Framework easycampaign Workbench easycampaign Workbench ETL. ETL, System(or DBMS).,.
2. II. easybi Framework easycampaign Workbench,. 1.
2. II. easybi Framework easycampaign Workbench easycampaign Workbench. / / New Start
2. easypivot Reporter easypivot ReportereasyDataFlow Workbench DW(DM) easycampaign Workbench. o o o DBMS Table Text File o DataFlow or Campaign Workbench File EasyPivot Reporter Graph o Graph o SpreadSheetGraph Graph o o o Performance
2. easypivot Reporter. easypivot Reporter DBMSAccess, easydataflow Workbench or easycampaign Workbench SAM File..
2. easypivot Reporter easypivot Reporter, Trend. easypivot Reporter Graph,, Excel.
- : ebusiness CRM :,SFA,Contact Center EKP(Enterprise Knowledge Portal) ERP/WebPOS : CRM CRM, CRM DW, Data Mining Analytical Model Action : CRM : Campaign/SFA/ : AS, Call Center : : : :, DW : SFA KDNET : eservice : [ ] CRM T.G.I. FRIDAY S Point DW LG Fashion CRM CRM Master Plan ( ), DBM, DW Data Mining CJ39 (MASS) CRM Data Mining ecrm (LTV)
Mobile e-mail Mobile e-mail