QUIZZ answers Flashcards

1
Q

Comment faire de l´actualisation planifiée ?

A

A travers les passerelles, gateaway

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

4 ROLES in POWER BI ? In WORKPLACE

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

What is incremental update ?

A

we can put a date, and like 10 rolling years (= 10 années glissantes)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

Which data base suppport or no DirectQuery?

A

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 well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

How to retrieve negative value ?

A

Number filter, and see how many negative

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

How to write Feb 2020 in DAX?

A

(‘Date’ [Date], “MMM YYYY”)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

I have two tables Sales and Region and a common key region_id

A

the issue is that one is integer the other is varchar so i have to conver to the same data type

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

fonction COUNT ?

A

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>

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

I want to filter on the sales of the Manager

A

use the function USERNAME = UserName()

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

Sommes de plusieurs sommes du dernier trimestre

A

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>

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

Over time?

A

casi siempre va a ser LINE CHART

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

Comment trier avec M ? LANGUAGE sur ville de Berline

A

WHERE Clause
SELECT * FROM
WHERE City =’Berlin’

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

Puis-je saisir sur POWERAPP de nouvelles entree?

A

Oui pas de soucis

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

Outlier = aberrandes

A

On va favoriser SCATTER PLOT (Nuage de Point) -> pour voir les valeurs qui se detache du lot

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

Merge Table by using PowerQuery

A

A favoriser par rapport aux expressiosn DAX Complexes

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

SAMEPERIODLASTYEAR()

A

Renvoie a Y-1

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

Q & A?

A

toujours subscriber and synonyme

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

How to decrease lag ?

A

Split the visuals onto multiple pages

19
Q

Manager voit juste sa region

A

Il faut bouger dans Azure Active Directory -> configurer une RLS par region

20
Q

Comment assurer le app lifecycle management

A

Create separate workspaces for development and production. Grant the end users access to the production workspace

21
Q

Comment assurer le app lifecycle management

A

Create separate workspaces for development and production. Grant the end users access to the production workspace

22
Q

“Last refreshed”

A

The dashboard tile cache refreshed. Le cache de la vignette peut-etre raffraichi

23
Q

J´ai 4 pages memes filtres, je veux qu´ils s´appliquent a toutes les pages

A

Sync the Slicers accross the pages, Replace the slicers with report-level filters (et non page-level, pas visual-level)

24
Q

If using keyboard

A

Choose TAB ORDER

25
Q

An user wants to receive notification

A

Subscription et non data alert

26
Q

PII Personally Identifiable Information

A

Microsoft Information Protection sensitivity labels provide a simple way for your users to classify critical content in Power BI without compromising productivity or the ability to collaborate.
Sensitivity labels can be applied to datasets, reports, dashboards, and dataflows.

27
Q

3 pages and on page with KPIs, we dont wantfilter

A

Add the same slicer to each page and configure Sync Slicer

Edit the interactions of the slicer that is on the same page as the KPI Visu

(no page-level filter)

28
Q

How to do feedbacks in BI Services

A

On va utiliser comments, car feedback n´existe pas

29
Q

Si je veux connecter une liste ShrePoint

A

je passe uniquement par dossier

30
Q

POWER QUERY EDITOR i want unique values

A

COLUMN DISTRIBUTION and COLUMN PROFILE

31
Q

COLUMN QUALITY

A

valid green
error red
empty dark grey
unknown dashaed grey
unexpected error dashed red

32
Q

COLUMN DISTRIBUTION

A

give the count of each field (distinct and unique)

33
Q

COLUMN PROFILE

A

more in depth- look filter by value, copy data

34
Q

X countries -> I want 3 regions -> I WANT TO SEE employeen per regions

A

Use GROUP new group on state column set the group type to list

35
Q

large dataset a column called date poor performance

A

i´ll split date and other for heure minute date, better performance

36
Q

I need to strem videos from Microsoft Stream directly from BI, which type ?

A

web content

37
Q

APPEND

A

ajouter fichier A,B et C

38
Q

2 roles I put the roles what happens?

A

le RLS de POWER BI est calibre sur OU et non et

39
Q

You create a constant line and set the value to 0.5. Does this meet the goal?

A

creating the 50th percentile ,

40
Q

Different Business quetion, how to navigate to the right page

A

Create a button for each business question and set the action type to Bookmark.

41
Q

R visual with 500k customers

A

too many records -> 150k rows

42
Q

switch from white to black

A

dashboard theme

43
Q

You need to ensure that the visual shows only the 10 cities that have the highest sales profit.

A

TOPN filter