Course Information
Schedules
- 6 May 2021 (Thu) 10:00 AM - 5:00 PM
- 16 Jun 2021 (Wed) 10:00 AM - 5:00 PM
Registration period
9 Mar 2021 (Tue) - 11 Jun 2021 (Fri)
Price
HKD 1,780
Course Level
Study Mode
Duration
6 Hour(s)
Language
Cantonese
Location
Room 603 Dominion Centre, 43-59 Queen's Road East Wanchai, Hong Kong
7 views
Course Overview
The course targets those users who want to create reports or dashboards. Power BI desktop is a free application which prebuilds a lot of professional charts and visuals. Users can expand their library by using visuals from third parties which makes the dashboards even more presentable.
In the course, students will learn how to import data from various sources, link and transform all the data , and constructing dashboards using different visuals.
What you'll learn
What you’ll learn
Understanding Microsoft Business Intelligence Service
- What is Microsoft PowerBI service and the related products
- PowerBI vs Excel's Business Intelligence tools
Creating data models
- Knowing different kinds of joins
- Normalization
- Creating connections to data sources
- Editing table properties
- Defining data Tables
- Knowing data types
- Creating relationships (auto detect and manual)
Working with Query Editor
- Importing Excel, csv, text, Access and data from SQL server
- Creating tables
- Diagram view vs. data view
- Transformation GUI
- Row transformations
- Column transformations
- Text Transformations
- Adding and removing columns or rows
Working with filters
- Slicer for labels
- Slicer for Date information
- Visual level filters
- Page level filters
- Report level filters
Power BI Dashboards and Data Visualizations
- Power BI Desktop visualization
- Formatting visuals in Power BI Desktop
- Waterfall chart, donut chart, scatter chart
- cluster column chart and line and area chart
- sorting and advanced sorting
- Funnel, KPIs, card, multi-rows card, guage
- Working with matrix and report
- Rows / Columns / Values settings
- Adding buttons, images and bookmarks to dashboards
- Adding images
