Power BI Desktop for Business Users Training in Hong Kong

  • Learn via: Classroom
  • Duration: 3 Days
  • Level: Fundamentals
  • Price: From €2,281+VAT
We can host this training at your preferred location. Contact us!

Power BI Desktop is part of the suite of tools from Microsoft which enable data to be analysed and published from a variety of sources.

With Power BI Desktop, you get a report authoring tool that enables you to connect to and query data from different sources using the Query Editor. From the datasets you build with Query Editor you can create reports and add visuals within Power BI Desktop. Reports can then be published.

This course covers the use of Power BI Desktop to connect to data, query the data, add visuals and prepare to publish a report.

Please Note: This course does not cover the use of Power BI in the Power BI Service.

Target audience

Anyone who is familiar with Microsoft Office applications and who needs to work with data to be able to connect, process and analyse the data to produce suitable output at all levels within an organisation.

It is assumed that attendees on the course are already familiar with charts and PivotTable concepts.

Please note that this course is not suitable for new Excel or database users

  • An understanding of basic data concepts
  • Ability to create, format chart outputs
  • Be able to create formulas using standard aggregate functions
  • Able to apply data processing techniques such as filtering and pivot creation

For learners without access to the software required for this event, a remote PC can be provided using GoToMyPC. If you have any questions, contact our Virtual team.

  • Power BI Desktop Concepts and Main Features
  • Data Sources compatible with Power BI Desktop
  • Connecting to Data with Power BI Desktop
  • Apply Common Query Tasks to Shape Data in Power BI Desktop
  • Explore Data Visuals
  • Work with Report formats and elements

Lesson 1: Getting Started with Power BI Desktop

  • Power BI Concepts and Overview
  • Introduction to Main Features
  • Imports
  • Visuals
  • Filters and Queries
  • Reports

Lesson 2: Connecting to Data Sources with Power BI Desktop

  • Data Sources Power BI Desktop will connect to
  • Data Types and Properties in Power BI Desktop
  • Enter Data
  • Get Data and Query Editor
  • Introducing the Query Editor
  • Using the Query Editor to Connect to Data
  • Combining Data Sources
  • Use Append Queries
  • Merge Data Tables
  • Working with Relationships in Data

Lesson 3: Querying and Shaping the Data

  • Activities using Query Editor
  • Filters
  • Clean, Trim, Format and Replace
  • Split Column or Extract Using Delimiters
  • Column from Example
  • UnPivot
  • Creating Custom Calculated Columns
  • Adding Conditional Columns
  • Introduction to DAX Expressions and Formula

Lesson 4: Data Visuals

  • Overview of Data Visuals
  • Tables and Matrix Views
  • Applying Conditional Formats
  • Charts
  • Types
  • Options
  • Analytics Lines in Visuals
  • Forecast
  • Create Measures
  • Create a KPI Visual
  • Interactive Slicers
  • Slicers – dropdowns and searches
  • Number Slicers with value ranges
  • Date Slicers with Relative filters
  • Drill Visuals to see underlying data
  • Create Reusable Field Hierarchies
  • Drill Visuals to see underlying Data
  • Visual Table and Data Point Table
  • Date Hierarchies
  • Data Groups and Binning in Visuals
  • Q&A
  • Decomposition Tree
  • Data Categories, Geo-Data and Maps

Lesson 5: Reports and Output Options

  • Report Elements and Options
  • Working with Pages
  • Visual and Filter Settings
  • Report Themes
  • Edit Interactions
  • Bookmarks


Contact us for more detail about our trainings and for all other enquiries!

Upcoming Trainings

Join our public courses in our Hong Kong facilities. Private class trainings will be organized at the location of your preference, according to your schedule.

Classroom / Virtual Classroom
22 May 2024
Hong Kong, Kowloon, Tsuen Wan
€2,281 +VAT Book Now
Classroom / Virtual Classroom
03 June 2024
Hong Kong, Kowloon, Tsuen Wan
€2,281 +VAT Book Now
Classroom / Virtual Classroom
11 June 2024
Hong Kong, Kowloon, Tsuen Wan
€2,281 +VAT Book Now
Classroom / Virtual Classroom
26 June 2024
Hong Kong, Kowloon, Tsuen Wan
€2,281 +VAT Book Now
Classroom / Virtual Classroom
03 July 2024
Hong Kong, Kowloon, Tsuen Wan
€2,281 +VAT Book Now
Classroom / Virtual Classroom
15 July 2024
Hong Kong, Kowloon, Tsuen Wan
€2,281 +VAT Book Now
Classroom / Virtual Classroom
24 July 2024
Hong Kong, Kowloon, Tsuen Wan
€2,281 +VAT Book Now
Classroom / Virtual Classroom
05 August 2024
Hong Kong, Kowloon, Tsuen Wan
€2,281 +VAT Book Now

Related Trainings

Power BI Desktop for Business Users Training Course in Hong Kong

Hong Kong is officially known as the Hong Kong Special Administrative Region of the People's Republic of China (HKSAR) and is a city and special administrative region of China on the eastern Pearl River Delta in South China. Hong Kong is one of the most densely populated places in the world, with over 7.5 million population. The official languages of the HKSAR are Chinese and English. Hong Kong is a highly developed territory and ranks fourth on the United Nations Human Development Index and the residents of Hong Kong have the highest life expectancies in the world.

The best time to visit Hong Kong is from September to December, since the temperatures, averaging between 19 to 28 degree Celsius. During this outdoor activities-friendly travelling season, you can take a walk along Victoria Harbour, visit the islands of Lantau, Lamma and Cheung Chau and participate in the Mid-Autumn Festival. Top choices of the tourists to visit in Hong Kong are Big Buddha statue, Wong Tai Sin Temple, Repulse Bay and the Beaches and Hong Kong Disneyland.

Explore our diverse range of IT courses, encompassing programming, software development, cyber security, data science, business skills, and Agile/Scrum. Wherever you are in Hong Kong, our seasoned instructors will bring practical training and expert knowledge to your preferred training venue.
By using this website you agree to let us use cookies. For further information about our use of cookies, check out our Cookie Policy.