Power BI Advanced: Deep dive into DAX and Modelling
Power BI Advanced: Deep dive into DAX and ModellingDuration – 1 dayAudienceThis course is designed for people who already using Power BI and would like to expand their knowledge. Pre-requisitesBasic experience in Power BI and DAX.Detailed outlineReview of the basics: DAX basics, Evaluation context?Advanced RelationshipsRelationships overviewAdvanced relationships optionsCross filter directionsAmbiguity in bidirectional filtersCROSSFILTER functionMany-to-Many relationships?Advanced DAXTable functions – understanding the differencesALLVALUESDISTINCTALLNONBLANKROWALLEXCEPTFILTERRELATED, RALATEDTABLEEARLIERSUMMARIZEUnderstanding context transition. CALCULATE and CALCULATETABLELOOKUPVALUETOPNJOIN and CROSSJOINAdvanced time intelligence FunctionsQuerying with DAX Other advanced functionsVariablesWhy use variables?Understanding variablesVariables scopeParametersDynamic CalendarsAdvanced VisualisationsDigital StorytellingButtons and BookmarksSelection PaneDrill throughTooltip PageUse of Custom VisualsMultiple pages slicersAdvanced Conditional formatting?Connecting to other sourcesImport vs Direct Query and Live connections?Publishing and sharingSetting User Role in BI DesktopPublishing a reportCreating DashboardsSharing DashboardsCreating WorkspacePublish AppMore on QueriesAdvanced query techniquesIntroduction to M ................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.