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
Part1
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
Part2
Power Query data normalization
Formalize the content of the data
Collection and application of M language code
Customized report normalization
Manage queries
Part3
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
Instructors
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)