Moving important business data into a data model for analytic reporting can often be a two-edge sword. Data retrieval is fast and can support all kinds of analytic trending and comparisons. But, data in the model may be one or two layers away from the original source data, making it more challenging to compare with familiar user reports. Often the first validation effort after transforming and loading data into the model and then visualizing the initial results is having a business user say “yeah, that looks about right.” Then, sometime later after more development and extensive user testing, the feedback might be “hmm, that looks a bit off.” …not exactly scientific.
I have been doing a lot of data validation work lately – both formally and informally. Informally: Validating calculation results from a Power BI data model is just a normal part of the development process. Formally: After developing and delivering an entire business dashboard solution, a formal validation process is used to validate the ongoing results after future data refresh cycles and to certify reports so that business leaders know they can trust them.
Like this:
Like Loading...
good explanation on the video, thanks.
thanks for the topic, good work bro
Капсулы Негрустин – отзывы, инструкция по применению – FarmDirect
Hey Paul,
Thanks for sharing, it’s very useful the way that you treat BLANK() value.
Below I share my code DAX that I apply to CRM Dynamic 0365 the idea is :
1/ you look up for the position (and their business unit ) of the person who log in then you stock the result in a variable.
Position:
Sales Rep – only see their own data
Sales Manager – see the whole team data
Business Unit:
Retail
Salon
2/ Then depend on the position you show them what they can see using SWITCH():
//position of UPN
VAR Position_Rule = LOOKUPVALUE(
User[Position],
User[Sales Rep], USERNAME()
)
//business unit of UPN
VAR BU_Rule = LOOKUPVALUE(
User[Business Unit],
User[Sales Rep], USERNAME()
)
RETURN
//if the UPN’s postion is
SWITCH(Position_Rule,
//Representative : display only their data
“Sales Representative”,[Sales Rep] = USERNAME(),
//Sales Manager > display all the data relevant to their team and them self
“Sales Manager”, ([Sales Manager] = USERNAME() || [Sales Rep] = USERNAME()),
FALSE()
)
Dung Anh