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
- Exploring the Power BI ecosystem
- Navigating the Power BI Desktop interface
- Establishing connections to common data sources
Data Preparation and Transformation
- Leveraging Power Query for data cleaning
- Shaping and transforming data structures
- Managing and combining queries
Foundations of Data Modeling
- Establishing relationships between tables
- Managing data types and hierarchies
- Constructing star schemas
Creating Visualizations
- Selecting appropriate visuals for the data
- Customizing charts and visual elements
- Utilizing slicers and filters effectively
DAX Fundamentals
- Understanding calculated columns and measures
- Applying common DAX functions
- Incorporating time intelligence concepts
Advanced Analytics and Reporting
- Developing drill-through and tooltip pages
- Enhancing dashboards with advanced visuals
- Applying conditional formatting
Publishing and Sharing Insights
- Publishing reports to Power BI Service
- Managing workspaces and user access
- Distributing dashboards across teams
Performance Optimization and Governance
- Enhancing data model performance
- Adhering to governance and compliance standards
- Implementing dataset refresh strategies
Summary and Next Steps
Requirements
- A foundational understanding of data concepts
- Experience working with spreadsheets or tabular data
- Familiarity with basic reporting tasks
Target Audience
- Business analysts
- Corporate professionals handling data tasks
- Individuals 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
Method of training.