商業智慧數據分析與視覺化
Business Intelligence Data Analytics and Visualization
| 節 | 週六 |
|---|---|
2 09:00–09:50 | 商業智慧數據分析與視覺化 A701 3 節連堂 |
3 10:10–11:00 | |
4 11:10–12:00 |
* 根據陽明交大上課時間表所列
With the advent of the era of big data, a variety of data analysis software has emerged. How to process and visualize big data has become a topic that many people care about. Although many data analysis tools emerged at the historic moment, with the launch of Microsoft Power BI software and its increasing market share, Power BI has become a data analysis object favored by many large enterprises. This course is based on Powe BI software, which explains the basic technical knowledge of Power BI from the shallow to the deep. Even the readers who are not basic can quickly get started. This course also provides a detailed introduction to the smart analysis of fast data implementation. Through the study of this course, you will get rid of the tedious data processing and report preparation in the past, and realize the analysis and sharing of the internal business data of the company, so as to gain insight into the meaning of the data, realize the value of management, and greatly improve management capabilities and management standards.
統計學、EXCEL
Homework reports: 1. Students must hand in 3 homework reports to make sure they indeed comprehend the lectures. 2. Invite the students who work out excellent homework to share on the classes. Each time is contributed 8% to the final score.
1學期作業:Case Report 2.考試狀況:No Test 3.評量方法 Attendance and class discussion 70% Homework reports and presentation 30%
- Power BI Data Analytics
- The Presentation and Practical Implications of Data Analytics
- Apply Power BI Analytic in Sales Department Conditions
- Apply Power BI Analytic in Product Department Conditions
- Apply Power BI Analytic in Finance Department Conditions
- Apply Power BI Analytic in Human Resource Department Conditions
- What is Power BI
| 週次 | 主題 |
|---|---|
| 第 1 週 | The introduction of Power BI |
| 第 2 週 | The manipulation of Power BI |
| 第 3 週 | Input and connect database |
| 第 4 週 | Edit and organize the Big Data |
| 第 5 週 | Manage the Big Data |
| 第 6 週 | Define principles of the Big Data |
| 第 7 週 | Process the Big Data by using Power BI initially |
| 第 8 週 | Define principles of the Big Data |
| 第 9 週 | Model the Big Data Analytics |
| 第 10 週 | Establish DAX for data relationships |
| 第 11 週 | How to present the results of the Big Data Analytics |
| 第 12 週 | Apply Power BI Analytic in Sales Department Conditions |
| 第 13 週 | Apply Power BI Analytic in Product Department Conditions I |
| 第 14 週 | Apply Power BI Analytic in Product Department Conditions II |
| 第 15 週 | Apply Power BI Analytic in Finance Department Conditions |
| 第 16 週 | Apply Power BI Analytic in Human Resource Department Conditions |
| 第 17 週 | Student homework demonstration I |
| 第 18 週 | Student homework demonstration II |
1. Roger F. Silva (2018). Power BI - Business Intelligence Clinic: Create and Learn. Independently Published. 2. Drew Bentley (2017). Business Intelligence and Analytics. Larsen and Keller Education: NY. 3. Bert Brijs (2016). Business Analysis for Business Intelligence. CRC Press: FL. 4. Marco Russo, Alberto Ferrari (2020). The Definitive Guide to DAX: Business intelligence for Microsoft Power BI, SQL Server Analysis Services, and Excel Second Edition (Business Skills). Pearson Education: London. 5. Zhaohao Sun (2019). Managerial Perspectives on Intelligent Big Data Analytics. IGI Global: Hershey, Pa.