MySQL

1，Mysql彻底卸载干净并重装方法怎么操作? https://www.cda.cn/discuss/post/details/61604bdf977c04705c1273c7

2，MYSQL安装时,starting the server出现红色叉号. https://www.cda.cn/discuss/post/details/61978c262531444211a5c65c

3, MySQL 8.0 安装教程（带安装包） https://edu.cda.cn/my/course/5013

4, CDA L1 mysql报错Error Code: 1175. You are using safe update mode

https://www.cda.cn/discuss/post/details/63a4110de1840060d6346421

5, Mysql MAC版设置文件安全路径目录 https://www.cda.cn/discuss/post/details/64fb36b1e518fe26c1def8f6

6，mysql报错 Error Code: 1175. You are using safe update mode

https://www.cda.cn/discuss/post/details/618d021321531d7654184ddb

7，CDA 数据分析师level1 学习笔记分享和学习资料分享 https://www.cda.cn/discuss/post/details/630c7b8e16506a5735ec622f

8， MySQL 8.0 安装教程（带安装包） https://edu.cda.cn/my/course/5013

9，mysql阶段测试代码操作题的建表语句 https://www.cda.cn/discuss/post/details/631594bcd115607f262f6c10

10，安装MySQL时在Initializing database步骤报错 https://www.cda.cn/discuss/post/details/620cc51ccbeca03310eadf32

11, CDA 数据分析学习笔记 Mysql Error Code: 1046. No database selected

如何探索解决问题 三大方法论法宝 https://www.cda.cn/discuss/post/details/64226824e8194e566a31c195

12, CDA学习之关于MySQL建表后批量导入数据的示例说明(以CDA一级考试教材中的emp员工表导入为例)

https://www.cda.cn/discuss/post/details/64f980b7a7006e15447fa39c

13，CDA数据分析 L1模拟题 之SQL别名不能用于（　)什么子句中?

https://www.cda.cn/discuss/post/details/64898eeaa6be163b8e288f77

14，CDA学习之SQL中子查询可以出现在以下（　)什么子句中？

https://www.cda.cn/discuss/post/details/652a5dc91a87b518465db4e2

15，CDA学习模拟题之SQL句子select deptid,avg(sal) from employee group by deptid HAVING job='clerk

https://www.cda.cn/discuss/post/details/6538e57d32d996713fe054ee

16，CDA一级SQL学习之要查询“计算机” 系的没有不及格成绩的学生学号和姓名

https://www.cda.cn/discuss/post/details/65421437132c9c302d40d1d4

17,mysql系列学习35--开窗函数之mysql开窗函数默认情况

https://www.cda.cn/discuss/post/details/638763a040c7872f8fdf75b2

18, CDA学习之mysql报错error 2013.Lost connection to MySQL server during query

https://www.cda.cn/discuss/post/details/65029dbe4985eb404bad66ef

Excel

1, microsoft office安装包(含exel) https://www.cda.cn/discuss/post/details/63709c5078e45138b580ba06

2，Excel:此数据透视表字段已被组合。不能向组合字段中添加计算项。

https://www.cda.cn/discuss/post/details/617626974eb98e2dc4278ecd

3，CDA数据分析学习之电子表格Excel OFFSET函数 https://www.cda.cn/discuss/post/details/64916fb2ead2ec45bf91b8cf

4，excel 当月有效工作天数=当月应工作天数–全无薪假期 https://www.cda.cn/discuss/post/details/633329d042da6b7f6b3165d9

5，Adventure works公司分析报告 https://www.cda.cn/discuss/post/details/631aba1a0e5bd02eedd06e7b

6， CDA 数据分析师level1 优质学习笔记分享和学习资料分享 https://www.cda.cn/discuss/post/details/630c7b8e16506a5735ec622f

7,

CDA 数据分析学习之 Excel阶段测试-[Excel材料实操式选择题组合] 学生成绩表和用户消费表材料

https://www.cda.cn/discuss/post/details/650bf21c3985890a0fdcd10f

8，Excel可以是表结构处理工具吗? https://www.cda.cn/discuss/post/details/661f87b422ffe46e409a718f

Python

1，关于jupyter notebook无法自动跳转chrome浏览器的处理方法

https://www.cda.cn/discuss/post/details/618cd50f21531d7654184da7

2 , python给jupyter安装目录插件时报错:Jupyter command `jupyter-contrib-nbextension` not found.

https://www.cda.cn/discuss/post/details/62b32191694342173bc68f74

3, Anaconda(学python用)安装包以及安装教程 https://edu.cda.cn/my/course/5014

4, python报错,ERROR: Failed building wheel for xxx 和 Could not build wheels for xxx

https://www.cda.cn/discuss/post/details/643cfc810a60533776b07d09

5, CDA学习之python jupyter notebook安装后, 输入python代码执行没反应,而且in[ ]没有*

https://www.cda.cn/discuss/post/details/64b3ada7f6b83a33b072c62f

6, Anaconda Python 配置环境变量 https://www.cda.cn/discuss/post/details/6294243702dd332204c7fa7f

7, CDA数据分析学习之jupyter启动后打开网页会导致cmd黑色命令框闪退从而导致jupyter网页不能执行代码 (涉及电脑用户名中文改为英文)

https://www.cda.cn/discuss/post/details/64b65ef72fcc3e19ee620ede

BI

1,CDA答疑社区如何发帖?发帖后获得积分如何兑换书籍礼品? https://www.cda.cn/discuss/post/details/634bbb0d877c307f4085ceff

2, 在CDA答疑社区如何发帖?发帖后获得积分如何兑换书籍礼品 https://www.cda.cn/discuss/post/details/634bbb0d877c307f4085ceff

3, CDA L1 BI多维数据模型各种类型（星型、雪花、星座、交叉连接）https://www.cda.cn/discuss/post/details/63725d19939bb5764f6c642a

4, CDA L1 BI多维数据透视分析时表的连接(赵大7000,9000问题) https://www.cda.cn/discuss/post/details/63ac6811793659505be1d391

5，Window7电脑安装PowerBI新版本出现报错提示“AS Process PID=12552 has exited with ExitCode=-1073741511”问题如何解决？

https://www.cda.cn/discuss/post/details/61cea78c6276b453ec6fa08b

统计学

1, CDA L1 设随机变量X~N(1,4),则P(-1<X<3)等于多少？ https://www.cda.cn/discuss/post/details/62b19b4b694342173bc68dd7

2, CDA level 1 题目学习笔记：正态分布与卡方分布的关系 https://www.cda.cn/discuss/post/details/630f65e4d763935cdf3dfdf4

3, CDA level 1 题目学习笔记：卡方分布除以卡方分布是F分布 https://www.cda.cn/discuss/post/details/630f732cd763935cdf3dfe1d

4，CDAlevel1模拟题--计算相关系数的方法 https://www.cda.cn/discuss/post/details/63142021d115607f262f6af3

5, CDA L1模拟题--某地区成年男子的体重X（kg)服从正态分布N（μ，σ2), 若已知P{X≤70}=0.5，P{X≤60}=0.25.

https://www.cda.cn/discuss/post/details/63a86915793659505be1d123

6, CDA L1学习笔记 关于四分位数与百分位数的计算 https://www.cda.cn/discuss/post/details/61e00e07191ad85df65eabc6

其他1

1, CDA L1 学习笔记，在RFM用户分类中,在有限资金下为提高收入,应重点对哪一类用户进行营销？

https://www.cda.cn/discuss/post/details/63e1ffc732d6675b731e6933

2, CDA L1学习笔记 维度 度量 与指标 https://www.cda.cn/discuss/post/details/629420ea02dd332204c7fa7a

3，CDA L1 当WHERE子句的（表子查询中）查询条件是聚合函数时，子查询不能替换为连接查询

https://www.cda.cn/discuss/post/details/6239d402bb49d9411dd4bc85

4, CDA L1 学习笔记 Mysql Error Code: 1046. No database selected 如何探索解决问题？三大方法论法宝

https://www.cda.cn/discuss/post/details/64226824e8194e566a31c195

其他2

1, graphviz应用程序的安装 https://www.cda.cn/discuss/post/details/60191f6ab137f15823a966d9

2, 如何探索解决问题 三大方法论法宝https://www.cda.cn/discuss/post/details/64226824e8194e566a31c195

3 CDA学习 office安装 KMS主机地址 https://www.cda.cn/discuss/post/details/6565bfbc37f889640b521d9f

4,英伟达chat with rtx 大模型本地部署安装教程 https://www.cda.cn/discuss/post/details/65eeff3bb2900e3836d129c4

其他3 CDA持证人会员俱乐部
1,欢迎报名参加CDA数据分析师持证人会员分享和会员专访活动，成功参与后可得500元现金及500CDA积分
https://www.cda.cn/discuss/post/details/671b0749dea3a15858f6d893

其他4

博客文章备份链接
https://www.cda.cn/discuss/post/details/65029dbd4985eb404bad66ec