电信行业数据挖掘培训(Teradata miner).pptx

数据挖掘项目交流;目录;Why?;应用: 运用模型辅助决策，制定营销策略;Data Mining is for power users to follow a proven methodology to discover action-oriented insights from detail operations data to improve business. 数据挖掘是分析专家用已验证的方法在业务细节数据中 发掘出可采取行动的洞察力，从而改善企业运营。;数据 = 储藏室 数据 + 工具 = 网吧 数据 + 工具 + 方法 = 信息 数据 + 工具 + 方法 + 目标 = 知识 数据 + 工具 + 方法 + 目标 + 行动 = 价值;客户;数据挖掘典型应用;分析专题示例;目录;What is Teradata Warehouse Miner?;;TWM－场内挖掘的优势;单变量统计 Count/Minimum/Maximum/Mean Standard Deviation Standard Mean Error Variance Coefficient of Variance Skewness Kurtosis Uncorrected Sum of Squares Corrected Sum of Squares Modes 基本数据质量分析 Data Types Count # NULL Values # Positive Values # Negatives Values # Zeros # Blanks # Unique Values ;相关???析 Quickly view correlations across variables 数据探索器 Performs basic statistical analysis on a set of tables and selected columns within any Teradata database Intelligent decisions about which functions to perform Values Analysis - Every column in the set of input tables Univariate Statistical Analysis - Every column of numeric or date type Frequency Analysis - Every column that has less than or equal to a number of unique values Histogram Analysis - Every numeric or date type column that has more than a number of unique values;变量生成 Aggregations Count, Average, Sum etc. Windowed Aggregates/OLAP Rank, Quantililes, Moving Sums, etc. Arithmetic operators/functions : +, -, *, /, MOD, ** ABS, EXP, LN, LOG, SQRT, etc. Trigonometric Hyperbolic functions COS, SIN, TAN, ACOS, etc. COSH, SINH, TANH, ACOSH, etc. CASE expressions and NULL operators valued and searched types NULLIF, COALESCE Comparison operators =, , , , =, = Logical predicates BETWEEN…AND…, IN (expression list), etc.;变量变换 Bin Coding Design Coding Recoding Rescaling Derive Hook to Variable Creation Statistical Transformations Z-Score Sigmoid NULL Value Replacement Literal value Mean value Median value Mode Imputed values;Normality/Equality Tests Kolmogorov-Smirnov Lilliefors Test Shapiro-Wilk D’Agostino Pearson Omnibus Smirnov 分