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
Power BI Introduction
- Exploring the Power BI ecosystem
- Interacting with the Power BI Desktop interface
- Establishing connections to various data sources
Data Preparation and Transformation
- Utilizing Power Query for data cleansing
- Shaping and modifying data structures
- Controlling and merging queries
Foundations of Data Modeling
- Establishing connections between tables
- Managing data types and hierarchical structures
- Developing star schema models
Creating Visualizations
- Choosing appropriate visuals for specific data types
- Customizing charts and graphical elements
- Effectively utilizing slicers and filters
Core DAX Concepts
- Grasping calculated columns and measures
- Applying standard DAX functions
- Incorporating time intelligence concepts
Advanced Analytics and Reporting
- Developing drill-through and tooltip pages
- Enhancing dashboards with sophisticated visuals
- Applying conditional formatting rules
Distributing and Sharing Insights
- Deploying reports to the Power BI Service
- Oversight of workspaces and access permissions
- Distributing dashboards among teams
Performance Optimization and Governance
- Boosting the efficiency of the data model
- Adhering to governance and compliance standards
- Setting up strategies for dataset refreshing
Conclusion and Future Directions
Requirements
- A solid grasp of core data concepts
- Practical experience with spreadsheets or tabular data
- Accustomed to performing basic reporting tasks
Target Audience
- Business analysts
- Corporate professionals engaged with data
- Professionals responsible for creating 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
Method of training.