QUIZZ answers Flashcards
Comment faire de l´actualisation planifiée ?
A travers les passerelles, gateaway
4 ROLES in POWER BI ? In WORKPLACE
Admin : (he can update or erase the workplace, add or fire other admin, permits the other user to update the app for the workspace
Member : add people with lower permissions, publish cancel and change these permissions, update the app, share the app, permits other people to share items, administrate permits for data set) = COMME ADMIN mais ne peut pas supprimer le workplace et virer du monde
Colaborator : create edit and erase content, publish reports in the workplace and erase content, copy reports, build measures, he can update if he adds a permission
Viewer : See or interactuate with the element, see the differents datas
What is incremental update ?
we can put a date, and like 10 rolling years (= 10 années glissantes)
Which data base suppport or no DirectQuery?
Yes, DirectQuery :
Azure SQL Database, Spark, Python Script, SAP S4 HANA
No, DirectQuery : Access Database, Active Directory, Azure Blob Storage, Azure Datalake, Azure DevOps, Dynamics 365, SalesForces, SharePoint Online List, XML etc…
How to retrieve negative value ?
Number filter, and see how many negative
How to write Feb 2020 in DAX?
(‘Date’ [Date], “MMM YYYY”)
I have two tables Sales and Region and a common key region_id
the issue is that one is integer the other is varchar so i have to conver to the same data type
fonction COUNT ?
COUNT (<COLUMN>)
COUNTA (<COLUMN>) -> items no empty
COUNTX(<COLUMN>,<EXPRESION>) -> search one expresion in the column
COUNTAX(<COLUMN>,<DYNAMICEXPRESION>)
COUNTROWS (<COLUMN>) -> all the row of the column</COLUMN></DYNAMICEXPRESION></COLUMN></EXPRESION></COLUMN></COLUMN></COLUMN>
I want to filter on the sales of the Manager
use the function USERNAME = UserName()
Sommes de plusieurs sommes du dernier trimestre
CALCULATE(SUM(BalanceSheet[BalanceAmount], DATESQTD(Date[Date]))) -> va regarder la date actuelle et regarder les 3 mois avant
CALCULATE(<expression>[, <filter1> [, <filter2> [, …]]])</filter2></filter1></expression>
Over time?
casi siempre va a ser LINE CHART
Comment trier avec M ? LANGUAGE sur ville de Berline
WHERE Clause
SELECT * FROM
WHERE City =’Berlin’
Puis-je saisir sur POWERAPP de nouvelles entree?
Oui pas de soucis
Outlier = aberrandes
On va favoriser SCATTER PLOT (Nuage de Point) -> pour voir les valeurs qui se detache du lot
Merge Table by using PowerQuery
A favoriser par rapport aux expressiosn DAX Complexes
SAMEPERIODLASTYEAR()
Renvoie a Y-1
Q & A?
toujours subscriber and synonyme
How to decrease lag ?
Split the visuals onto multiple pages
Manager voit juste sa region
Il faut bouger dans Azure Active Directory -> configurer une RLS par region
Comment assurer le app lifecycle management
Create separate workspaces for development and production. Grant the end users access to the production workspace
Comment assurer le app lifecycle management
Create separate workspaces for development and production. Grant the end users access to the production workspace
“Last refreshed”
The dashboard tile cache refreshed. Le cache de la vignette peut-etre raffraichi
J´ai 4 pages memes filtres, je veux qu´ils s´appliquent a toutes les pages
Sync the Slicers accross the pages, Replace the slicers with report-level filters (et non page-level, pas visual-level)
If using keyboard
Choose TAB ORDER
