PBI ESSENTIALS FINAL EXAM
JuanooDelgadoooisooanooemployeeooinooyouroosalesoodepartmentooandooLiooParkooisooanoo
outsideooconsultant.ooIfooyouooshareooaoodashboardoowithoobothooofoothem,oowilloothereoob
eooanyoodifferenceooinootheirooPowerooBIooexperience?oo-ooans--
LiooParkoowilloohaveootheoointeractivityooofootheoodashboard,oobutoosheoowilloonotoohaveooa
nyooofootheooelementsooonootheooleft.
Youoowantootoooallowoousersooinsideooyourooorganizationootoooshareooyouroodashboard,oo
andootoooeditooyouroodashboardoobyooaddingootiles.ooHowoowillooyouoodooothis?oo-ooans--
Byoocreatingooaoodashboardooinooaoogroup.
InooorderootoooimproveooyouroodatasetootooogetootheoomostoouseoofromootheooPowerooBIoo
Q&Aoofeature,oohowooshouldooyouoonameootheootablesooinooyouroodata?oo-ooans--
Chooseoouser-friendlyoonamesooforooyourootables
IfooyouoobuildooaoodashboardoousingooQuickooInsights,ooinoowhichooformatoowillootheooinsig
htsooappearooonooyouroodashboard?oo-ooans--visualizations
WhichooofootheseooisooaooreasonootooorelateootablesooinooPowerooBI?oo-ooans--
Soooyouoocanooexamineoorelationshipsoobetweenoodifferentoodatasets
Whichoovideoootypesooareootheooonlyooonesooyouoocanooaddootoooaoodashboardooasooaoom
ediaootile?oo-ooans--Youtubeoooroovimeo
WhatoodoesootheooUnpivotoofeatureooinooaoodatasetooallowooyouootooodo?oo-ooans--
Retrieveootheoounderlyingoorowsooofoodataoofromooaoopivotootable
YouoohaveooaoofilteredoodatasetooforooCustomerooSalesoowithoosomeoonulloovalueoorows.o
oYouoowantootoooremoveootheseoorowsoocompletely.ooHowoowillooyouoodooothis?oo-ooans--
Deselectoo(null)ooinootheoopull-
downoomenuooforoocustomeroosalesooinootheoopowerooqueryooeditor
Youooareoodoingooaooresearchooprojectooonoopopulationoochanges,ooandootheooU.S.ooCen
susoowebsiteoohasootheoodataooyouoowant.ooWhichoodataootypeooshouldooyouoodownloado
osoooyouoohaveootheooeasiestooformatootoooread?oo-ooans--theootable
Youooareooconductingooaoolargeoomeetingooinoowhichooyouoowantootooomakeooaoopresenta
tionooofooaooreportooonooaooscreen.ooHowoocanooyouoodooothisoowithootheooWindowsooapp
?oo-ooans--
JuanooDelgadoooisooanooemployeeooinooyouroosalesoodepartmentooandooLiooParkooisooanoo
outsideooconsultant.ooIfooyouooshareooaoodashboardoowithoobothooofoothem,oowilloothereoob
eooanyoodifferenceooinootheirooPowerooBIooexperience?oo-ooans--
LiooParkoowilloohaveootheoointeractivityooofootheoodashboard,oobutoosheoowilloonotoohaveooa
nyooofootheooelementsooonootheooleft.
Youoowantootoooallowoousersooinsideooyourooorganizationootoooshareooyouroodashboard,oo
andootoooeditooyouroodashboardoobyooaddingootiles.ooHowoowillooyouoodooothis?oo-ooans--
Byoocreatingooaoodashboardooinooaoogroup.
InooorderootoooimproveooyouroodatasetootooogetootheoomostoouseoofromootheooPowerooBIoo
Q&Aoofeature,oohowooshouldooyouoonameootheootablesooinooyouroodata?oo-ooans--
Chooseoouser-friendlyoonamesooforooyourootables
IfooyouoobuildooaoodashboardoousingooQuickooInsights,ooinoowhichooformatoowillootheooinsig
htsooappearooonooyouroodashboard?oo-ooans--visualizations
WhichooofootheseooisooaooreasonootooorelateootablesooinooPowerooBI?oo-ooans--
Soooyouoocanooexamineoorelationshipsoobetweenoodifferentoodatasets
Whichoovideoootypesooareootheooonlyooonesooyouoocanooaddootoooaoodashboardooasooaoom
ediaootile?oo-ooans--Youtubeoooroovimeo
WhatoodoesootheooUnpivotoofeatureooinooaoodatasetooallowooyouootooodo?oo-ooans--
Retrieveootheoounderlyingoorowsooofoodataoofromooaoopivotootable
YouoohaveooaoofilteredoodatasetooforooCustomerooSalesoowithoosomeoonulloovalueoorows.o
oYouoowantootoooremoveootheseoorowsoocompletely.ooHowoowillooyouoodooothis?oo-ooans--
Deselectoo(null)ooinootheoopull-
downoomenuooforoocustomeroosalesooinootheoopowerooqueryooeditor
Youooareoodoingooaooresearchooprojectooonoopopulationoochanges,ooandootheooU.S.ooCen
susoowebsiteoohasootheoodataooyouoowant.ooWhichoodataootypeooshouldooyouoodownloado
osoooyouoohaveootheooeasiestooformatootoooread?oo-ooans--theootable
Youooareooconductingooaoolargeoomeetingooinoowhichooyouoowantootooomakeooaoopresenta
tionooofooaooreportooonooaooscreen.ooHowoocanooyouoodooothisoowithootheooWindowsooapp
?oo-ooans--
