Course Information
Registration period
Year-round Recruitment
Price
HKD 8,800
(上課收費 : 每班最多20人，每班收費$8,800)
(上課收費 : 每班最多20人，每班收費$8,800)
Course Level
Study Mode
Duration
6 Hour(s)
Language
Cantonese
Location
九龍佐敦德興街11-12號興富中心5樓501室(佐敦港鐵站E出口)
10 views
Course Overview
課程簡介
PowerBI 能將企業中現有的數據進行有效的整合，快速準確地提供報表並提出決策依據，幫助企業做出明智的業務經營決策。作為一個大數據時代的資訊工作者，掌握Power BI 將對你的工作有決定性的優勢。 本課程為一個 Excel 進階課程，專為有志加強 Excel知識的人士而設。學習課程後，學員可利用 Power BI加強 Excel各項分析功能，超越 Excel的資料分析限制 。
What You’ll Learn
UNDERSTANDING POWERBI
- Installing and running PowerBI Desktop
- Applying PowerBI Service free account
- Installing PowerBI Mobile Apps
- Understanding the PowerBI Desktop and Query Editor
- IMPORTING DATA TO POWERBI
- Importing Excel data into PowerBI Desktop
- Importing Access database into PowerBI Desktop
- Importing CSV text files into PowerBI Desktops
- Importing data from other data sources
DATA CLEANSING AND TRANSFORMATION
- Define data types for different columns
- Transform existing columns (text,number,date)
- Adding and removing columns or rows
- Unpivot data by transposing columns and rows
- Modifying query and undoing steps)
ADVANCED TRANSFORMATION
- Appending multiple queries
- Merging queries by different join types
- Query from a folder
- Understanding M language
- Conditional columns and Add Column from Example
DESIGN A DATA MODEL
- Understanding Star schema and Snowflake schema
- Building the 1 to many and 1 to 1 relationships between tables
- Understanding filter context and its flow direction
- Understanding active and inactive relationships
- Adding a Date table for time intelligence functions
REPORT AND VISUALIZATIONS
- Buidling various reports by using the visuals
- Choosing various visuals for presenting data
- Introducing Matrix,Columm,Stack,Bar,Pie,Waterfall,KPI,Gauge,Maps
- Grouping and binning data
- Applying various filters (Visual,Page,Report,Drillthrough)
POWERBI SERVICES AND MOBILE
- Uploading data and reports from PowerBI Desktop
- Building a PowerBI dashboard
- Preparing data sets for Q&A natural language queries
- Sharing dashboard to other PowerBI accounts
- Accessing the reports through PowerBI Mobile
DAX FUNCTIONS
- Creating calculated columns and measures using DAX functions
- Understanding implicit and explicit measures
- Using CALCULATE functions to alter the filter context
- Using FILTER functions to filter data
- Introduction to Time Intelligence functions
- Understanding implicit and explicit measures
- Using RELATED and RELATEDTABLES functions to relate data
- Understanding SUMX,COUNTX,AVERAGEX,MAXX,MINX functions to summarize data
- Creating calculated table by using SUMMARIZE functions
【自我增值】被譽為21世紀最性感職業？！數據分析師8個必備技能
【自我增值】IT創科行業職位逆市增長 自學進修有錢途！
【自我增值】想學好Microsoft Office？ 而家喺屋企都有得上堂！
