Power BI for Business Users

Course Outline (6 hours)
Topic 1: Introduction of Power BI
· What is Power BI?
· Data modeling and visualizations
· Security and administration
· Customer case study
· Power BI in action
Topic 2: Power BI dashboard
· What can I do with Power BI service as a consumer?
· View content in Power BI service
· Explore with dashboards, reports, and apps in Power BI
· Collaborate and share in Power BI
· Find and view dashboards and reports
Topic 3: Analyze data with Power BI
· Filter data with Power BI
· View your data
· Ask questions of your data
· Apply filters to reports
· Analyze in action
Topic 4: Building blocks in Power BI
· Building blocks of Power BI
· Uses of the Power BI services
· Case study
Topic 5: Use of Power BI Desktop
· Overview of Power BI Desktop
· Explore Power BI Desktop
· Connect to data sources
· Get data from Excel, Pivot tables
· Transform data to include in a report
· Combine data from multiple sources
· Clean data to include in a report
Topic 6: Data Model in Power BI
· Introduction to modeling your data
· How to manage your data relationships
· Create calculated columns
· Optimize data models
· Create measures
· Create calculated tables
· Explore time-based data
PROFESSIONAL TRAINERS
Guidance, Inspiration and Support
PATRICK TSOI
Lead Trainer
As the lead trainer of FreshLinker Academy, Patrick has 20+years in the IT training field. Patrick’s work include complex projects applying data science, and software development to different aspect of value chains as well as participating with research teams, on field such as Internet of Things, Natural Language Processing and Digital Signal Processing. He has extensive experience in designing and building computer vision solutions and real-time applications.
Patrick is a frequent visiting lecturer/part time trainer at HKPC, SCOPE, The City University of Hong Kong, IVE, HKU Space, CITA and SPARE Learning Centers.
Patrick is also the Chief Data Scientist of Shen Zhen City Data Services Limited Engineering Management
Patrick’s academic Background:
Doctor in Education (In progress) IT Education, HKBU (2019)
BSc System Engineering and Engineering Management, CUHK (1997)
MSc IT Education, HKU (2004)
Standard Class
Weekday Class
Time: 20:00 – 22:00
Number of lessons required: 3
Total number of hours required: 6 hours
Date: TBC
Price: $1,800
Whatsapp 98887317 for any enquiry