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
- Connecting to on-premises and cloud-based data sources
- Data transformations and M language basics
Data Modeling
Table Relationships (Single and Multi-directional Filtering)
- DAX - Exploring syntax and industry best practices
- Getting Started with DAX
- Essential functions and calculation contexts
- Handling time dimensions (fiscal periods, period comparisons, YTD)
- Utilizing filter functions
Visualizations
- Conducting interactive data analysis
- Choosing the right visualization types
- Applying filters, grouping, and exclusions
- Creating map-based visualizations
Collaboration with Power BI
- Managing Dashboards and Reports
- Q & A Session
Requirements
Target Audience:
- Business Analysts: Professionals seeking to leverage data analysis and visualization for strategic decision-making.
- Data Analysts: Specialists looking to develop interactive reports and dynamic dashboards.
- Managers / Team Leads: Leaders responsible for overseeing key performance indicators (KPIs) and monitoring business metrics.
- Enthusiasts: Any individual with an interest in data visualization and analytics.
Learning Outcomes:
- A solid grasp of Power BI architecture, various data sources, and transformation techniques.
- Competence in establishing table relationships and applying DAX functions.
- The capability to create compelling visualizations and effective dashboards.
- Proficiency 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.
