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
Power BI Architecture
Data Sources
- On-premises and cloud-based data sources.
- Data transformations using M language.
Modeling
Relationships Between Tables (Single and Multi-directional Data Filtering)
- DAX - Grasping syntax and best practices.
- DAX Introduction
- Commonly used functions and calculation contexts.
- Handling the time dimension (including fiscal periods, period comparisons, and Year-to-Date).
- Filter functions.
Visualizations
- Interactive data analysis.
- Selecting the appropriate visualization type.
- Managing filters, grouping, and exclusions.
- Visualization on maps.
Collaboration in Power BI
- Dashboards and Reports.
- Q & A Session.
Requirements
Who Will Benefit Most From This Training:
- Business Analysts: Professionals requiring data analysis and visualization skills to drive informed business decisions.
- Data Analysts: Experts handling data who aim to build interactive reports and dashboards.
- Managers and Team Leads: Leaders responsible for overseeing Key Performance Indicators (KPIs) and tracking business metrics.
- Professionals with an interest in data visualization and analytics.
Upon Completion, Participants Will Be Able To:
- Comprehend Power BI architecture, various data sources, and data transformation processes.
- Demonstrate proficiency in establishing table relationships and utilizing DAX functions.
- Design effective visualizations and comprehensive dashboards.
- Become familiar with team collaboration and report sharing capabilities.
7 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.
