English Course Description The course focuses on how to collect, store, retrieve and analyze business data from enterprise information system for making business decisions based on integrated data sources. It includes introducing the skills of dimensional data modeling for building data warehouses, the key performance indexes for major business function departments, and other data analyzing tools. In addition, this course will also teach Excel's pivot analysis for big data analysis. Data processing and analysis concepts are mentioned, including data sorting, screening, group subtotals, multiple worksheets, and operations, data table and the traditional report analysis, the correct use of reports and data tables. The problems can be solved through use of analysis table and pivot analysis chart tool, a cross-analysis of the various purposes and the combination of different reports and charts. By studying and operating practice cases, students can start immediately to develop the ability to filter summary reports and analyze data even if students are completely unfamiliar with the pivot analysis table.
- Teacher: 徐明龍 Ming-Lung Hsu