Skip to main content

Data Analytics for Modern Trade Business

Course for : นักศึกษา
Enrollment is Closed

About This Course

In today’s technology world, data has been produced increasingly in various fields such as education, healthcare, and business. Actually, data itself is important. However, data is useless and meaningless without processing and analyzing. Therefore, data should be processed and analyzed to become useful and meaningful information that can help organization, e.g., business, to understand consumer behavior, make better decision, and improve productivity and profit, etc. For this issue, Microsoft Excel is one of the most popular tools to help process, analyze, and visualize data. As a result, this course aims to provide the students with in-depth understanding how to do data processing, data analytics, and data visualization by Microsoft Excel for business.

In this course, you will learn about using Excel for financial functions, What-if analysis, break even analysis, marketing data analysis functions, forecasting analysis functions, pivot table, excel charts, marketing media selection, project management, linear programming problem, and transportation problem, etc. After learning this course, you will be able to apply the best practices what you have learnt in the future careers such as Data Engineer, Data Analyst, Business Analyst, Database Specialist, etc.

Learning Outcome

The main learning outcome of this course is to be able to apply Microsoft Excel for data processing, data analytics, and data visualization in business application.

Learning Hours

3 hours


English language and computer skill (intermediate level) will be required since this course will be delivered in English version how to use Microsoft Excel for business application.

Evaluation and Assessment Criteria

Firstly, students need to take a pre-test before learning the course. Then, the assignments will be given for each chapter during the course period. Finally, students need to take a post-test again after finishing the course.


 Course Instructor

Dr. Nay Myo Sandar

received the B.Eng and M.Eng degrees in Information Technology from Myanmar in 2007 and 2010; and the Ph.D. degree in Information Technology from Shinawatra University, Thailand, in 2017. Since January 2019, she has been a Lecturer at International College of Panyapiwat Institute of Management. She is a self-motivated and active researcher. She is the author of 1 international journal, 1 international journal with Impact Factor, 1 international journal indexed in Scopus, and 3 conference papers. Her research interests include operations research, cloud computing, wireless sensor network, Internet of Things, and other networking technologies. She was also awarded Best Presentation Award in 2013. Email:

พัฒนาโดย โครงการพัฒนาสื่อการสอนออนไลน์ระบบเปิดของสถาบันการจัดการปัญญาภิวัฒน์ (PIM MOOC)


  1. Course Number

  2. Classes Start

  3. Classes End

  4. Estimated Effort