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
Introduction to Power BI
- Exploring the Power BI ecosystem
- Interface navigation in Power BI Desktop
- Establishing connections to standard data sources
Data Preparation and Transformation
- Leveraging Power Query for data cleansing
- Data shaping and transformation processes
- Query management and combination
Data Modeling Basics
- Establishing relationships across tables
- Handling data types and hierarchies
- Constructing star schemas
Developing Visualizations
- Choosing appropriate visuals for specific data
- Customizing charts and visual elements
- Effective use of slicers and filters
DAX Fundamentals
- Comprehending calculated columns and measures
- Utilizing standard DAX functions
- Implementing time intelligence principles
Advanced Analytics and Reporting
- Developing drill-through and tooltip pages
- Enhancing dashboards with sophisticated visuals
- Application of conditional formatting
Publishing and Sharing Insights
- Deploying reports to Power BI Service
- Workspace management and access control
- Distributing dashboards across teams
Performance Optimization and Governance
- Boosting data model performance
- Adhering to governance and compliance standards
- Establishing dataset refresh strategies
Overview and Future Steps
Requirements
- Foundational knowledge of data concepts
- Practical experience with spreadsheets or tabular data
- Aquaintance with basic reporting procedures
Target Audience
- Business analysts
- Corporate professionals engaged in data work
- Users 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
Method of training.