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
- Overview of the Power BI ecosystem.
- Navigating the Power BI Desktop interface.
- Establishing connections to common data sources.
Data Preparation and Transformation
- Utilizing Power Query for data cleaning.
- Shaping and transforming data structures.
- Managing and combining multiple queries.
Data Modeling Fundamentals
- Defining relationships between tables.
- Handling data types and hierarchies.
- Constructing star schemas.
Creating Visualizations
- Selecting appropriate visuals for specific data sets.
- Customizing charts and visual elements.
- Effective use of slicers and filters.
DAX Essentials
- Comprehending calculated columns and measures.
- Applying common DAX functions.
- Implementing time intelligence concepts.
Advanced Analytics and Reporting
- Developing drill-through and tooltip pages.
- Enhancing dashboards with advanced visuals.
- Applying conditional formatting rules.
Publishing and Sharing Insights
- Publishing reports to Power BI Service.
- Managing workspaces and user access.
- Distributing dashboards across teams.
Optimizing Performance and Governance
- Optimizing data model performance.
- Adhering to governance and compliance standards.
- Implementing strategies for dataset refreshes.
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 who work with data.
- Users responsible for creating 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.
