覆之前個post
讀緊business intelligence and analytics, 除左business analyst 仲有咩前景？
兩樣嘢嚟架喎
BI 係講data
BA 睇 requirement 同project
脷伸 兩樣都有做
想問下BI 實際上做啲咩？
做BI 即係將data變成report 或analysis
首先就係ETL - extract transformation and load
Extract 就係從唔同data source 拎data
主要係Structured database, 但亦會有flat filed, excel, nosql database等. 寫sql 一定要識
Transformation 就係data modelling, mapping, data quality 等. 執靚啲data﹐做normalisation join 埋一個data model。
Load 就係寫入data warehouse。
成個ETL 要諗啲job 幾時做幾密做﹐要啲咩data﹐啲data可唔可靠
最大路就係ibm informatica﹐亦有talend 呢啲open source 野
跟住就係Analytics﹐主要就係重data warehouse 拎data 整report同visualisation﹐搵下insight﹐user會問你啲嘢然後你就要自己喺data度分析
common 嘅 tool有 SAS, Qlikview, Tableau
勁嘅可以寫 R, Python 去做statistical analysis
唔使stat 好勁但冇理由連standard deviation都唔識
stat + programming 勁 = data scientist
仲要有 strong business sense and good presentation skills
所以qualified嘅人好少..
利：做緊類似嘢..
have top u stat master degree and good programming skills and exp in business side
巴打好勁下, 仲要人工猛加
我讀書果陣都偏向data mining, data analytics 果d
但而家做緊廢廢BA
想轉番做data
data 好玩d
，唔知點行落去個方向
