Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Duration 14 hours
Course Outline
Overview of Power BI
- Exploring the Power BI ecosystem
- Interacting with the Power BI Desktop interface
- Establishing connections to standard data sources
Data Cleansing and Processing
- Leveraging Power Query for data cleaning
- Refining and reshaping data structures
- Administering and merging queries
Foundations of Data Modeling
- Establishing links between tables
- Managing data types and hierarchical structures
- Constructing star schema models
Developing Visualizations
- Choosing appropriate visuals for the data
- Tailoring charts and graphical elements
- Utilizing slicers and filters efficiently
Core DAX Concepts
- Comprehending calculated columns and measures
- Employing standard DAX functions
- Incorporating time intelligence principles
Advanced Analysis and Reporting
- Designing drill-through and tooltip views
- Enhancing dashboards with complex visuals
- Applying rules-based conditional formatting
Distributing and Sharing Insights
- Deploying reports to the Power BI Service
- Administering workspaces and user permissions
- Distributing dashboards among team members
Performance Optimization and Governance
- Enhancing data model efficiency
- Adhering to governance and compliance standards
- Establishing dataset refresh protocols
Recap and Future Actions
Requirements
- A foundational grasp of data concepts
- Practical experience with spreadsheets or tabular data structures
- Basic familiarity with reporting procedures
Target Audience
- Business analysts
- Corporate professionals engaged in data work
- Individuals requiring the creation of dashboards and reports
Testimonials (2)
How to use relationships in Power BIand the differences between columns and measurements
LEUNG Chun Hei - HAESL
Course - Advanced Power BI: Data Modeling, DAX, and Enhanced Analytics
The basic structure of Power BI, its main functions, as well as some advanced functions