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 transformation using M language
Modeling
Table Relationships (single and multi-directional data filtering)
- DAX - Exploring syntax and best practices
- DAX Fundamentals
- Commonly used functions and calculation contexts
- Handling time dimensions (including fiscal periods, period comparisons, and year-to-date metrics)
- Application of filter functions
Visualizations
- Conducting interactive data analysis
- Choosing the most effective visualization types
- Utilizing filters, grouping, and exclusions
- Creating map-based visualizations
Collaboration in Power BI
- Building Dashboards and Reports
- Q & A Session
Requirements
Who will gain the most from this program:
- Business Analysts: Professionals seeking to interpret and visualize data to drive strategic decision-making.
- Data Analysts: Specialists handling data who aim to build dynamic reports and dashboards.
- Managers / Team Leads: Leaders tasked with overseeing key performance indicators (KPIs) and monitoring business metrics.
- Individuals passionate about data visualization and analytics.
Learning outcomes for participants:
- A clear grasp of Power BI architecture, data sources, and transformation workflows.
- Competence in establishing table relationships and applying DAX functions.
- The capability to construct effective visualizations and intuitive dashboards.
- Confidence in utilizing collaboration and report-sharing features.
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.
