Power BI Service Administration Training
Level
AdvancedDuration
24h / 3 daysDate
Individually arrangedPrice
Individually arrangedPower BI Service Administration Training
This training is designed for IT specialists and administrators who want to deepen their knowledge of managing and optimizing the Power BI environment in an organization. The course covers advanced data refresh techniques, content security, and integration of Power BI with other Microsoft tools. Participants will learn how to effectively manage access, build BI architecture, and monitor the Power BI environment to ensure optimal performance and security. The program combines theory with hands-on exercises, enabling participants to gain the skills required for professional administration of Power BI Service.
What You Will Learn
- Effectively manage access in Power BI Service
- Build BI architecture with workspaces, dataflows, and shared datasets
- Monitor the Power BI environment to ensure performance and security
Requirements
- Basic knowledge of Power BI Desktop (creating reports, visualizations, simple data modeling)
- Basic knowledge of Power BI Service (publishing reports, sharing content, using core features)
- Basic understanding of data management (sources, connections, processing)
- General knowledge of IT administration concepts
IT specialists-
Administrators
Training Program
u003colu003ern u003cliu003ern u003ch4u003eAdvanced Techniques in Power Queryu003c/h4u003ern u003c/liu003ernu003c/olu003ernu003culu003ern u003cliu003eIntroduction to M language and the Advanced Editoru003c/liu003ern u003cliu003ePreparing data using advanced M functionsu003c/liu003ern u003cliu003eQuery parameterizationu003c/liu003ern u003cliu003eCreating custom functionsu003c/liu003ernu003c/ulu003ernrnu003col start=u00222u0022u003ern u003cliu003ern u003ch4u003eWorking with SQL Databases as a Data Sourceu003c/h4u003ern u003c/liu003ernu003c/olu003ernu003culu003ern u003cliu003eImport and DirectQuery connection modesu003c/liu003ern u003cliu003eLoading data from SQL databasesu003c/liu003ern u003cliu003eQuery folding – concept and practical usageu003c/liu003ern u003cliu003eWriting and parameterizing SQL queriesu003c/liu003ern u003cliu003eBest practices for working with SQL data sourcesu003c/liu003ernu003c/ulu003ernrnu003col start=u00223u0022u003ern u003cliu003ern u003ch4u003eDirectQuery Optimization Techniquesu003c/h4u003ern u003c/liu003ernu003c/olu003ernu003culu003ern u003cliu003ePerformance considerations for DirectQuery modelsu003c/liu003ern u003cliu003eOptimizing queries and data modelsu003c/liu003ernu003c/ulu003ernrnu003col start=u00224u0022u003ern u003cliu003ern u003ch4u003ePython in Power BIu003c/h4u003ern u003c/liu003ernu003c/olu003ernu003culu003ern u003cliu003eSetting up Python for Power BI Desktopu003c/liu003ern u003cliu003eLimitations of Python in Power BIu003c/liu003ern u003cliu003eUsing Python scripts to retrieve data (Python connector)u003c/liu003ern u003cliu003eBuilding Python-based visualizationsu003c/liu003ernu003c/ulu003ernrnu003col start=u00225u0022u003ern u003cliu003ern u003ch4u003eAdvanced Power BI Featuresu003c/h4u003ern u003c/liu003ernu003c/olu003ernu003culu003ern u003cliu003eReport security with Row-Level Security (RLS)u003c/liu003ern u003cliu003eAI-powered visualizationsu003c/liu003ern u003cliu003eUsing DirectQuery in data modelsu003c/liu003ern u003cliu003eUsing variables in DAX measuresu003c/liu003ern u003cliu003eAdditional tools: DAX Studio and Tabular Editoru003c/liu003ernu003c/ulu003ernrnu003col start=u00226u0022u003ern u003cliu003ern u003ch4u003eAdvanced Report Publishingu003c/h4u003ern u003c/liu003ernu003c/olu003ernu003culu003ern u003cliu003eEmbedding reports on websitesu003c/liu003ern u003cliu003eUsing URL parametersu003c/liu003ernu003c/ulu003ernrnu003col start=u00227u0022u003ern u003cliu003ern u003ch4u003ePower Automate with Power BIu003c/h4u003ern u003c/liu003ernu003c/olu003ernu003culu003ern u003cliu003eAutomating workflows using Power Automate and Power BIu003c/liu003ernu003c/ulu003ern
