{"course":{"id":"110122701P02","name":"商業智慧","enroll_type":"選修","general_type":"","dept":"四技經管系","grade":4,"class_group":"甲","teacher":"劉集中","credit":3,"hour":3,"time":[{"day":2,"section":[9,10,11]}],"classroom":"","max":60,"min":10,"remark":"跨領域課程專班(限外系)","alt_for":"","courses":""},"detail":[["指定教材","1.  洪錦魁，Power BI入門 大數據視覺化 + 智慧決策 + 雲端分享 王者歸來(全彩印刷)，最新版，深智數位 ，中華民國，2021\n2. 王作桓，Excel工作現場實戰寶典，第二版，碁峰，中華民國，2021 (Excel沒基礎的，可以加買這本)"],["參考教材","1. Gil Raviv(陳亦苓譯)，Power BI終極實戰寶典｜使用Power Query與PowerBI進行資料分析，最新版，碁峰，中華民國，2019\n2. Wayne L. Winston , Ingram，Microsoft Excel 2019 Data Analysis and Business Modeling，最新版，Microsoft Press，美國，2019 (真心要打好基礎的人可自行購買來看或跟圖書館借閱)"],["成績評量標準","1. 準時出勤: 15%\n2. 電子筆記: 15% (抄襲者，本科成績0分)\n3. 期中考試: 20% Open Book (作弊者，本科成績0分)\n4. 期末考試: 35% Open Book (作弊者，本科成績0分)\n5. 課堂表現: 15%\n6. Extra: 額外表現及主動學習: Extra 1%~15% \n7. 上述項目加總後總分超過100分者，最終成績100分"],["教學方法","個人實驗(實作)"],["教學目標","1. 理解職場之資料分析手法與方式\n2. 能將資料進行整併與清理(ETL)\n3. 能依據需求對資料進行統計與計算\n4. 可透過大小數據工具來對資料進行視覺化呈現\n5. 能依資料分析之結果來改善決策與行動\n6. 教學生解決問題之想法、系統架構、改善流程與實務技術"]],"office_time":[["劉集中","1. 理論講授: 9 Hrs\n2. 實務講授: 10 Hrs\n3. 個案分析: 10 Hrs\n4. 遠距教學(若疫情防疫需要，隨時可改遠距或實體上課)\n5. 個人實作: 19 Hrs\n6. 測驗考試: 6 Hrs"]],"schedule":[["2021/09/14","9","11","3","劉集中","商業智慧基礎、Excel資料合併","電子筆記#01","課程說明、BI基礎、Excel建立資料表，使用PQ彙總資料，使用VBA彙總資料",""],["2021/09/21","9","11","3","劉集中","","","","中秋連假"],["2021/09/28","9","11","3","劉集中","Excel資料計算","電子筆記#03，Extra Homework#1","資料分析四部曲，Excel公式函數實務",""],["2021/10/05","9","11","3","劉集中","Excel資料統計","電子筆記#04","依據需求使用Excel公式函數進行資料統計",""],["2021/10/12","9","11","3","劉集中","Excel資料視覺化","電子筆記#05，Extra Homework#2","美化資料、格式化條件、資料轉換符號",""],["2021/10/19","9","11","3","劉集中","Excel報表製作","電子筆記#06","企業常見報表製作",""],["2021/10/26","9","11","3","劉集中","Excel週期分析","電子筆記#07，Extra Homework#3","週期: 年月日季週，差異比較分析",""],["2021/11/02","9","11","3","劉集中","Excel樞紐及圖表分析","電子筆記#08","以樞紐分析驗證計算公式，將表傳換為圖",""],["2021/11/09","9","11","3","劉集中","期中考","","",""],["2021/11/16","9","11","3","劉集中","PBD: Case Study1: Coffee","電子筆記#09","Power BI Desktop下載安裝，PBD學習資源、咖啡案例實作，PQ進行 Data ETL",""],["2021/11/23","9","11","3","劉集中","PBD: Case Study1: Coffee","電子筆記#10，Extra Homework#4","資料建模、量值收納盒、量值撰寫、視覺化效果、報告上船雲端與分享",""],["2021/11/30","9","11","3","劉集中","PBD: Case Study 2: Fruit","電子筆記#11","水果案例資料下載，PQ資料彙整與資料ETL",""],["2021/12/07","9","11","3","劉集中","PBD: Case Study 2: Fruit","電子筆記#12，Extra Homework#5","頁面連結、工具提示、資料鑽研、資料篩選",""],["2021/12/14","9","11","3","劉集中","PBD: Case Study 3: Log","電子筆記#13","檢測資料案例，PQ切分資料，資料ETL",""],["2021/12/21","9","11","3","劉集中","PBD: Case Study 3: Log","電子筆記#14，Extra Homework#6","不良雲因分析、視覺化呈現",""],["2021/12/28","9","11","3","劉集中","PBD: Case Study 4: Traffic","電子筆記#15","交通事故案例，依據表單逐一轉換資料袋碼",""],["2022/01/04","9","11","3","劉集中","PBD: Case Study 4: Traffic","電子筆記#16","分析交通事故相關屬性，檢視其關聯性",""],["2022/01/11","9","11","3","劉集中","期末考","","",""]]}