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.
Course Outline
Introduction to Power BI
- Gaining an understanding of the Power BI ecosystem.
- Navigating the Power BI Desktop interface.
- Establishing connections to common data sources.
Data Preparation and Transformation
- Utilizing Power Query for data cleansing.
- Shaping and transforming data structures.
- Managing and combining various queries.
Data Modeling Fundamentals
- Establishing relationships between tables.
- Working with data types and hierarchies.
- Constructing star schemas.
Creating Visualizations
- Choosing the appropriate visuals for specific data types.
- Customizing charts and visual elements.
- Effectively utilizing slicers and filters.
Essential DAX Concepts
- Understanding calculated columns and measures.
- Applying common DAX functions.
- Implementing time intelligence concepts.
Advanced Analytics and Reporting
- Creating drill-through pages and tooltips.
- Enhancing dashboards with advanced visual components.
- Applying conditional formatting rules.
Publishing and Sharing Insights
- Publishing reports to the Power BI Service.
- Managing workspaces and access permissions.
- Sharing dashboards across teams.
Performance Optimization and Governance
- Enhancing data model performance.
- Adhering to governance and compliance best practices.
- Implementing effective dataset refresh strategies.
Summary and Next Steps
Requirements
- A foundational understanding of data concepts.
- Hands-on experience with spreadsheets or tabular data.
- Basic familiarity with reporting tasks.
Target Audience
- Business analysts.
- Corporate professionals engaged in data management.
- Users responsible for creating dashboards and reports.
14 Hours
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