The purpose of this course is to help students to understand the basic concepts of sports data analysis and applications in sports marketing. In order to get an effective marketing forecast, through creating a standard process of data exploration industry and effective assessment method of the model, providing real-time sports analysis to support marketing target, preventing customers’ loss, contributing to the sports developing and effective marketing. The course focuses on how to collect, store, retrieve and analyze sports data from open-source (web site) for making sports decisions based on integrated data sources. It includes introducing the skills of dimensional data modeling for building data warehouses, 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 the use of an 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.