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
- Interacting with the Power BI Desktop interface
- Establishing connections to standard data sources
Data Preparation and Transformation
- Leveraging Power Query for data cleaning
- Shaping and transforming datasets
- Managing and consolidating queries
Data Modeling Fundamentals
- Establishing relationships between tables
- Managing data types and hierarchical structures
- Constructing star schema models
Creating Visualizations
- Selecting appropriate visuals for specific data types
- Customizing charts and graphical elements
- Effective use of slicers and filters
DAX Fundamentals
- Grasping calculated columns and measures
- Utilizing standard DAX functions
- Implementing time intelligence concepts
Advanced Analytics and Reporting
- Developing drill-through and tooltip functionalities
- Enhancing dashboards with advanced visual elements
- Applying conditional formatting rules
Publishing and Sharing Insights
- Deploying reports to Power BI Service
- Administering workspaces and access permissions
- Distributing dashboards across team members
Performance Optimization and Governance
- Enhancing data model performance
- Adhering to governance and compliance standards
- Implementing strategies for dataset refresh
Summary and Future Directions
Requirements
- Foundational knowledge of data concepts
- Practical experience with spreadsheets or tabular data
- Familiarity with basic reporting workflows
Intended Audience
- Business analysts
- Corporate professionals engaged in data management
- Users requiring the creation of 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.