Course Outline
Introduction
Power BI Architecture
Data Sources
- On-premises versus online data sources
- Data transformation techniques and M language usage
- Establishing direct connections to specific sources (e.g., SQL Server, OLAP)
Modeling
Table Relationships (single and multidirectional data filtering)
- DAX – Exploring syntax and best practices
- DAX Introduction
- Key functions and calculation contexts
- Managing time dimensions (fiscal periods, period comparisons, YTD)
- Functions for structuring parent-child hierarchies
- Utilizing filter functions
- DAX templates
Visualizations
- Interactive data exploration
- Selecting the most effective visualization types
- Applying filters, grouping, and exclusions
- Mapping visualizations
- Enhancing visuals with custom visuals
Data Access Management – Row-Level Security
Collaboration and Mobility with Power BI
- Building dashboards and reports
- Leveraging the Q & A mechanism
- Accessing workspaces via mobile applications
Summary and Next Steps
Requirements
- Familiarity with fundamental data concepts
- Practical experience with Excel or comparable data tools
- A general grasp of business or operational analysis
Target Audience
- Business Analysts
- Data Professionals
- Individuals seeking to utilize data visualization tools for deeper 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
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
