目录
一、数据清洗 .......................................................................................................................................................2
1.1 Java 程序架构 .......................................................................................................................................2
1.2 清洗规则定义 ......................................................................................................................................2
1.2.1 枚举规则 ...................................................................................................................................2
1.2.2 日期规则 ...................................................................................................................................4
1.2.3 生日和性别 ..............................................................................................................................5
1.2.4 数字规则 ...................................................................................................................................6
1.2.5 其他规则 ...................................................................................................................................6
二、数据导入 .......................................................................................................................................................7
2.1 导入后的数据清洗 .............................................................................................................................7
2.1.1 主键唯一性检查 .....................................................................................................................7
2.1.2 外键合法性检查 .....................................................................................................................7
2.1.3 字段间逻辑检查 .....................................................................................................................7
2.2 完善表格结构 ......................................................................................................................................8
三、维度表和事实表 ..........................................................................................................................................9
3.1 维度表 ....................................................................................................................................................9
3.1.1 年龄维度 ...................................................................................................................................9
3.1.2 信用卡类型维度 .....................................................................................................................9
3.1.3 性别维度 ................................................................................................................................ 10
3.1.4 操作类型维度 ...................................................................................................................... 10
3.1.5 收款订单额维度 .................................................................................................................. 10
3.1.6 收款订单类型维度 ............................................................................................................. 11
3.1.7 地区维度 ................................................................................................................................ 11
3.1.8 交易类型维度 ...................................................................................................................... 11
3.1.9 交易额维度 ........................................................................................................................... 12
3.1.10 余额维度 ............................................................................................................................. 12
3.1.11 年份额度 ............................................................................................................................. 13
3.2 事实表 ................................................................................................................................................. 13
3.2.1 用户数事实表 ...................................................................................................................... 14
3.2.2 操作金额事实表 .................................................................................................................. 14
3.2.3 贷款额事实表 ...................................................................................................................... 15
3.3 维度表与事实表的关系 ................................................................................................................. 17
四、数据分析 .................................................................................................................................................... 17
4.1 用户数量 ............................................................................................................................................ 18
4.2 交易金额 ............................................................................................................................................ 18
4.3 贷款总额 ............................................................................................................................................ 20
评论0