{"course":{"id":"107225804101","name":"商業智慧","enroll_type":"選修","general_type":"","dept":"工管系碩士班","grade":1,"class_group":"甲","teacher":"葉神丑","credit":3,"hour":3,"time":[{"day":2,"section":[5,6,7]}],"classroom":"","max":25,"min":5,"remark":"","alt_for":"","courses":""},"detail":[["課程大綱","商業智慧為目前數據應用的重大趨勢，隨著軟體技術的發達，雲端應用、大數據分析等的興起，BI分析愈顯其重要，然國內對於該等人才的缺乏，使得國內應用的拓展有限，本課程期透過一系列的講授與實務操作，以養成學生具備BI分析能力，進而對企業、研究有所助益。"],["指定教材","Alberto Ferrari, Building Data Model with PowerPivot, Microsoft Press, 2015"],["參考教材","謝邦昌, Excel 2013 資料採礦完全手冊, CDMS, 2015\n王仲麒, Excel 2013 商業智慧分析, 碁峯, 2013"],["成績評量標準","作業#1  20%\n期中報告  40%\n期末報告 40%"]],"office_time":[],"schedule":[["1/22","","","","","課程介紹","","目標、上課方式、評分、環境設定",""],["1/29","","","","","資料模式與資料庫","","ER models、案例初探",""],["2/12","","","","","關聯式資料庫操作","","SQL command",""],["2/19","","","","","SQL","","",""],["2/26","","","","","可視化BI建置(1)","","\tBI介紹 \tBI導入架構 \tPower BI 應用教學",""],["3/5","","","","","可視化BI建置(2)","","\tBI介紹 \tBI導入架構 \tPower BI 應用教學",""],["3/12","","","","","案例探討- 農業數據","","\t農業數據分析背景 \tITC介紹  \t產銷履歷介紹 \tOpenData來源",""],["3/19","","","","","案例探討- 商業數據","","\t商業數據分析背景 \t案例公司介紹 \t消費者OpenData來源",""],["3/26","","","","","期中報告(1)","期中報告","\t選定主題，透過SQL清理資料、Power BI元件，建立可視化圖表，並練習解釋圖表表現",""],["4/2","","","","","期中報告(2)","期中報告","\t選定主題，透過SQL清理資料、Power BI元件，建立可視化圖表，並練習解釋圖表表現",""],["4/9","","","","","案例探討- 國際貿易資訊","","\t國際貿易數據分析背景 \t案例公司介紹 \t消費者OpenData來源",""],["4/16","","","","","案例探討- 輿情分析(1)","","輿情分析介紹 \t常見應用工具 \t案例探討",""],["4/23","","","","","案例探討- 輿情分析(2)","","輿情分析介紹      常見應用工具 \t案例探討",""],["4/30","","","","","預測模型","作業#1","簡易數據分析模型",""],["5/7","","","","","預測模型與R語言","","R語言基本介紹 \t簡易數據分析模型 \tSQL+R",""],["5/14","","","","","數據預測與Power BI","","\tPower BI的數據預測可視化元件 \t案例探討",""],["5/21","","","","","期末報告(1)","期末報告","數據分析分組案例實作與發表",""],["5/28","","","","","期末報告(2)","期末報告","數據分析分組案例實作與發表",""]]}