Course Outline
Introduction
Power BI Architecture
Data Sources
- On-premises and cloud-based data origins
- Data transformation techniques and the M language
- Direct connections to specific sources (SQL Server, OLAP)
Data Modelling
Inter-table relationships (single and multi-directional data filtering)
- DAX - Mastering syntax and best practices
- DAX Fundamentals
- Commonly used functions and calculation contexts
- Handling time dimensions (including fiscal periods, period comparisons, and YTD)
- Functions for naturalising parent-child hierarchies
- Utilisation of filter functions
- DAX templates
Visualisation
- Interactive data analysis
- Selecting the most suitable visualisation types
- Application of filters, grouping, and exclusions
- Geospatial visualisations and maps
- Visualisation enhancements (including custom visuals)
Data Access Management - Row-Level Security
Collaboration and Mobile Integration with Power BI
- Dashboards and reports
- Q & A mechanisms
- Workspaces and mobile applications
Conclusion and Future Directions
Requirements
- A foundational grasp of basic data principles
- Proficiency in Excel or comparable data management tools
- General familiarity with business or operational analytics
Target Audience
- Business analysts
- Data professionals
- Individuais seeking to utilise data visualisation tools for strategic insights
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
Constructive exchanges
Cecile - Transdev Compagnie Axonaise
Course - Power BI
Machine Translated
Depth and knowledge was good and the trainer was able to answer all questions and explain clearly why those answers were given.
