Suspension of Class on 29-Sept

Please note that tonight's class has been suspended due to the Typhoon 8 signal earlier this day.

You may download the course materials for tonight's lesson from SOUL. The topic is Digital Marketing.

Let me know your group member list (3 to 4 people per group) for the assignment by next week.

How to view our Class Videos

If you can't see the videos on this page due to technical problems, click on the links below to view them directly on Youtube. The latest exercises are shown on top of the list.

Pivot Table Exercise 1
Pivot Table Exercise 2
Pivot Table Exercise 3

ACCESS - Building Product Order Report
ACCESS - Building Product Order Summary
ACCESS - Building Customer Analysis Report

ACCESS - Building Product Order Query
ACCESS - Building Product Order Summary
ACCESS - Building Customer Analysis Query

Session 2: Demo of Online Analytical Processing Tool (OLAP)

This demo tool can create ad-hoc reports based on a data cube built from a data warehouse.

http://demos3.dundas.com/olapdemostaging55/

Try using the demo to build a report that shows Internet Order Quantity by Product Line (Product dimension), Fiscal Year (Date dimension) and Yearly Income (Customer Demographic dimension).

Session 3: EXCEL Pivot Tables - Understanding Target Customers by Household Income

Session 3: Excel Pivot Tables - Understanding Target Customers by Household Size

Session 3: EXCEL Pivot Tables - Comparing Purchase Amount for Homeowners vs Renters

We will explore the structure of a relational database in the section of the lab.

The file can be downloaded from General Documents folder under our course - Information Technology in Marketing - on SOUL.

If you're unable to log into SOUL, you can also download the file from here.

Session 2: ACCESS - Build Customer Analysis Report

Session 2: ACCESS - Build Product Order Summary Report

Session 2: ACCESS - Build Product Order Report

Session 2: ACCESS - Build Customer Analysis Query

Session 2: ACCESS - Build Product Order Summary Query

Session 2: ACCESS - Build Product Order Query

Session 2: ACCESS - Exploring a Database

We will explore the structure of a relational database in the section of the lab.

The file can be downloaded from General Documents folder under our course - Information Technology in Marketing - on SOUL.

You can also download the file from here if you cannot access it on SOUL.

Session 1: Review Questions

Here are some review questions for our first lesson:

1. How has the marketing function changed now that we are living in a digital, information age ?
2. What are the steps businesses should follow when deciding which technology to use ?
3. What is the difference between data, information and business intelligence ? Give examples of each.
4. Information, people and information technology are the three resources in the firm's MIS department. Among the three, people are the most important. Explain why.
5. What are the objectives of business intelligence ? Why is it difficult to acquire business intelligence ?

1. 我們現在正處在一個數字化，信息化時代的生活. 目前的Marketing (營銷) 專業有什麼變化?
2. 企業應該遵循什麼步驟來決定採用何種技術來使用？
3. 數據，信息和商業情報之間有什麼區別?每一個給例子.
4. 信息，人員和信息技術是MIS部門的三種資源. 三者之中，人是最重要的。解釋為什麼。
5. 什麼是 business intelligence (商業智能) 的目標 ? 為什麼更難獲得商業智能?

Answers to the TVB case study are now posted on SOUL.