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.
- Navigating 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.
- Consolidating and managing multiple queries.
Foundations of Data Modeling
- Defining relationships between different tables.
- Managing data types and hierarchical structures.
- Constructing star schema models.
Creating Visualizations
- Choosing appropriate visuals for specific data sets.
- Customizing charts and visual elements.
- Effective use of slicers and filters.
DAX Essentials
- Distinguishing between calculated columns and measures.
- Utilizing frequently used DAX functions.
- Incorporating time intelligence concepts.
Advanced Analytics and Reporting
- Developing drill-through and tooltip pages.
- Enhancing dashboards with complex visuals.
- Applying conditional formatting rules.
Publishing and Sharing Insights
- Deploying reports to the Power BI Service.
- Administering workspaces and access controls.
- Distributing dashboards among team members.
Performance Optimization and Governance
- Boosting the efficiency of the data model.
- Adhering to governance and compliance standards.
- Setting up strategies for dataset refreshing.
Conclusion and Future Directions
Requirements
- A foundational grasp of core data concepts.
- Practical experience working with spreadsheets or tabular data structures.
- Basic familiarity with standard reporting workflows.
Target Audience
- Business analysts.
- Corporate professionals involved in data management.
- Individuals responsible for generating dashboards and analytical 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.
