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 online data sources
- Data transformations + M language
Modeling
Relationship between tables (single and multidirectional data filtering)
- DAX - Understanding the syntax and best practices
-
Introduction to DAX
- Most commonly used functions and context of calculations
- Working with the time dimension (including fiscal periods, comparing periods, YTD)
- Filter functions
Visualizations
- Interactive data analysis
- Select the appropriate visualization
- Filters, grouping, exclusions
- Visualization on maps
Teamwork with Power BI
- Dashboards and Reports
- Q & A
Requirements
Audience that will most benefit from this training:
- Business Analysts: Professionals tasked with analyzing and visualizing data to support informed decision-making.
- Data Analysts: Experts working with data who seek to build interactive reports and dashboards.
- Managers/ Team Leads: Individuals responsible for monitoring key performance indicators (KPIs) and tracking business metrics.
- Anyone with an interest in data visualization and analytics.
By the end of this training, participants will be able to have:
- A solid understanding of Power BI architecture, data sources, and transformation techniques.
- Proficiency in establishing table relationships and utilizing DAX functions.
- The capability to design effective visualizations and dashboards.
- Familiarity with collaboration and report sharing capabilities.
7 Hours
Testimonials (2)
Method of training.
Ineshia Bilankulu - National Transmission Company South Africa
Course - Power BI: Basics to Advanced
- Building dashboards - Learning the counts and SUMs and SWITCH -