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
Data Modeling
Table Relationships (Single and Multidirectional Data Filtering)
- DAX - Understanding syntax and best practices
-
Introduction to DAX
- Most commonly used functions and calculation contexts
- Working with time dimensions (including fiscal periods, period comparisons, and year-to-date calculations)
- Filter functions
Visualizations
- Interactive data analysis
- Selecting the appropriate visualization type
- Filters, grouping, and exclusions
- Map visualizations
Collaboration with Power BI
- Dashboards and Reports
- Q & A features
Requirements
Target Audience:
- Business Analysts: Professionals who need to analyze and visualize data to drive informed business decisions.
- Data Analysts: Experts working with data who wish to create interactive reports and dashboards.
- Managers and Team Leads: Individuals responsible for monitoring key performance indicators (KPIs) and tracking business metrics.
- Anyone with an interest in data visualization and analytics.
Learning Outcomes:
- A clear understanding of Power BI architecture, data sources, and transformations.
- Proficiency in establishing relationships between tables and utilizing DAX functions.
- The ability to design effective visualizations and dashboards.
- Familiarity with collaboration and report sharing features.
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 -