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 components of 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 cleansing
- Reshaping and modifying data structures
- Administering and merging queries
Data Modeling Foundations
- Establishing relationships between data tables
- Handling data types and hierarchical structures
- Constructing star schema designs
Creating Visualizations
- Choosing appropriate visuals for specific data sets
- Tailoring charts and graphical elements
- Utilizing slicers and filters for effective analysis
DAX Fundamentals
- Comprehending 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
Publishing and Sharing Insights
- Deploying reports to the Power BI Service
- Administering workspaces and user access
- Distributing dashboards among team members
Performance Optimization and Governance
- Boosting the performance of data models
- Adhering to governance and compliance standards
- Establishing strategies for dataset refreshes
Conclusion and Future Steps
Requirements
- Foundational knowledge of data concepts
- Practical experience with spreadsheets or tabular data structures
- Acquaintance with basic reporting procedures
Target Audience
- Business analysts
- Corporate professionals engaged in data work
- Individuals responsible for developing 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.