只提供英語內容
This course is designed to arm participants with knowledge on using the most highly rated Data Analytics and Business Intelligence Tool, Power BI to go from data to insights! We will cover:
- Discover data analysis
- Advance features of Power BI
- Data Modelling
- Visualization and Dashboards
- Datasets management
Course Objectives
- Participants will be able to analyse data from different data sources and create their own datasets
- Participants will be able to comfortably work with the different tools of the Power BI universe and know how the different tools work together
- Participants will have the required knowledge to dive deeper into Power BI and find out more about its advanced features
Course Outline
Online Session*: Explore what Power BI can do for you (69 mins)
Topic 1: Discover data analysis
- Overview of data analysis
- Roles in data
- Tasks of a data analyst
- Build up knowledge
Topic 2: Perform analytics in Power BI
- Introduction to analytics
- Advance data modelling
- Explore statistical summary
- Identify outliers with Power BI visuals
- Group and bin data for analysis
- Apply clustering techniques
- Conduct time series analysis
- Use the Analyze feature
- Use advanced analytics custom visuals
- Review Quick insights
- Apply AI Insights
Topic 3: Work with AI visuals in Power BI
- Introduction to working with AI visuals
- Use the Q&A visual
- Find important factors with the Key influencers visual
- Use the Decomposition Tree visual to break down a measure
- Exercise – Data analysis in Power BI Desktop
Topic 4: Data Model Design and Use DAX in Power BI Desktop
- Design a data model in Power BI
- Working with tables
- Work with dimensions
- Star schema design
- Analytic queries
- Configure report visuals
- Write DAX formulas
- DAX data types
- Work with DAX functions
- Use DAX operators
- Use DAX variables
- Use DAX time intelligence functions
- Additional time intelligence calculation
Topic 5: Data Visualization in Power BI
- Introduction to visuals in Power BI
- Create and customize simple visualizations
- Create slicers
- Map visualizations
- Matrices and tables
- Create scatter, waterfall, and funnel charts
- Modify colors in charts and visuals
- Page layout and formatting
Topic 6: Manage workspaces in Power BI
- Distribute a report or dashboard
- Monitor usage and performance
- Recommend a development life cycle strategy
- Troubleshoot data by viewing its lineage
- Configure data protection
Topic 7: Manage datasets in Power BI
- Create dynamic reports with parameters
- Create what-if parameters
- Configure a dataset scheduled refresh
- Manage and promote datasets
- Troubleshoot service connectivity
- Exercise on datasets
Topic 8: Extra Visuals and Integration with Power
- Create Extra Visuals
- Heatmap, Sankey Diagrams, Violin Chart etc.
- Integration with Power Apps
- Exercise on datasets
Date & Time
Date: 14-15 Dec 2023
Time: 09:30 – 17:00
Medium
Cantonese, supplemented with English terminology
Course Fee
HK$5,760* (May apply up to HK$3,840* RTTP subsidy)
*Maximum saving, with the final grant subjects to approval.
Prerequisite
Complete Power BI for Business Users or experiences with Power BI Desktop
Award of Certificate of Accomplishment
Participants with full accomplishment and completion of online training hours will be awarded a Certificate of Accomplishment by the Hong Kong Productivity Council.*
Trainers Profile
Patrick TSOI, he is a trainer with over 25+ years hands-on data science, Big Data and programming experiences. He is a Doctor of Education graduate from the Hong Kong Baptist University, Master in IT Education graduate from the University of Hong Kong and B.Eng in System Engineering and Engineering Management from the Chinese University of Hong Kong.