Course Outline
Introduction
Power BI Architecture
Data Sources
- On-premises and online data sources
- Data transformations and the M language
- Direct connections to specific sources (SQL Server, OLAP)
Data Modeling
Inter-table relationships (single and multi-directional data filtering)
- DAX - Comprehending syntax and best practices
- Introduction to DAX
- Commonly used functions and calculation contexts
- Handling the time dimension (including fiscal periods, period comparisons, and YTD)
- Functions for structuring parent-child hierarchies
- Filter functions
- DAX templates
Visualizations
- Interactive data analysis
- Selecting the appropriate visualization types
- Filters, grouping, and exclusions
- Map-based visualizations
- Visualization enhancements (custom visuals)
Data Access Management - Row-Level Security
Collaboration and Mobile Capabilities in Power BI
- Dashboards and reports
- Q & A mechanism
- Workspaces and Mobile applications
Summary and Next Steps
Requirements
- A solid grasp of fundamental data concepts
- Practical experience with Excel or comparable data handling tools
- Familiarity with general business or operational analytics
Target Audience
- Business analysts
- Data professionals
- Individuals seeking to harness data visualization tools for gaining insights
Custom Corporate Training
Training solutions designed exclusively for businesses.
- Customized Content: We adapt the syllabus and practical exercises to the real goals and needs of your project.
- Flexible Schedule: Dates and times adapted to your team's agenda.
- Format: Online (live), In-company (at your offices), or Hybrid.
Price per private group, online live training, starting from 2600 € + VAT*
Contact us for an exact quote and to hear our latest promotions
Testimonials (7)
Experience of the teacher, never surprised by any question.
Michal - Urzad Komisji Nadzoru Finansowego
Course - Power BI
I think the tool is usefull and the knowledge of the trainer was amazing.
Filip - Urzad Komisji Nadzoru Finansowego
Course - Power BI
Open to listen and respond to topics even if it is not in the training scope.
Julio Cesar - NabuMinds OU
Course - Power BI
It was not in form of a 'dry information' shown in the presentation, but plenty of excersises.
Marina - NabuMinds OU
Course - Power BI
Very engaging, all questions always attended to, good idea to practice after each portion of theory so you don't forget anything
Jekaterina - NabuMinds OU
Course - Power BI
Depth and knowledge was good and the trainer was able to answer all questions and explain clearly why those answers were given.
Dino - Hastings Direct
Course - Power BI
- The experience of the trainer - availability of the online server/pc with power bi installed on it - very structured the training material - the attitude of trainer - great tone and pace of the voice