top of page

Big data analysis without programming
Power BI Desktop

14 hours of master class

You can become a data analyst without knowing programming


​why learn
Power BI Desktop

In recent years, due to the birth of "Power BI Desktop", enterprises in Taiwan can quickly upgrade to the application and analysis stage of big data. The most important thing is that Power BI Desktop is a "free" tool and can accept all data in Excel, so that most companies that cannot import development resources can get started with data application and analysis faster and easier.


In addition, Power BI Desktop can also support different types of data sources, and you can easily handle mixed data without function settings. The most powerful thing is that it can display stunning visual reports. As long as you use a computer, mobile phone, or tablet, you can Can clearly grasp the sales dynamics anytime, anywhere. 


Complete example diagram

​course features

Fourteen-time MVP re-elected by Microsoft

The world's most valuable experts serve as lecturers.

Practical orientation, providing rich and complete cases for easy review after class.

Suitable for different industries and different sectors,

Learners with no programming background at all.

​Course Outline


Power Pivot data modeling

  • Basic concepts of big data

  • Download and install Power BI Desktop

  • Import data into Power Pivot

  • Relationships and Hierarchy Settings of Data Tables

  • The Concept and Establishment of Quantity


Power Query data normalization

  • Formalize the content of the data

  • Collection and application of M language code

  • Customized report normalization

  • Manage queries


Power View builds visuals

  • Construction and application of visual effects

  • Drill-up and drill-down of multi-layer visual effects

  • Integrate visuals into reports

​Who is this class for?

  • Marketing planner/supervisor

  • Accountant/Supervisor

  • Corporate decision maker/senior executive

  • Product Manager/Project Manager

  • Salesperson/Supervisor

  • Those who do not know how to write programs but are interested in big data analysis


不寫程式做大數據分析 POWER BI DESKTOP(FB).png
  • Microsoft MVP Microsoft Global Most Valuable Expert (2005~2019), 14 consecutive terms

  • Microsoft Office 2016 Master (Master)

  • MCT (Microsoft Certified Trainer) Microsoft Certified Trainer (2008~2021)

  • Senior Lecturer of Microsoft Office Internal Training and Support Large Customer Training in Taiwan

  • Public agency designated training instructor

  • A number of Taiwan listed OTC companies (such as: ASUS, Hon Hai), foreign companies (such as: VISA International Organization) designated training instructor

  • Information Policy Association, Dingxin Knowledge College, Digital Marketing College, Manager Business College, Yulon Prospective College, Hsinchu Science Park Association, Central Science Park, Southern Science Park... Special lecturer

​Course Information

  • Course Units: 3 Chapters 12 Units

  • Course hours: 2 days and 14 hours in total

  • Class dates: 11/13 (Saturday), 11/14 (Sunday).

  • Class time: 9:00-17:00 (one hour break at noon)

  • Class location: ZOOM cloud classroom (the classroom link will be sent to students' mailboxes three days before the class starts)

​Course price

​Original price of the course



​Early Bird Discount

(Deadline: 2021/11/4)


​Double group newspaper

​The two-person group is cheaper


bottom of page