Category: Identifying data anomalies
XMLA endpoints – Connecting to Data Sources
XMLA endpoints XMLA is the communications protocol used by Microsoft SQL Server Analysis Services instances. XMLA is a widely used connectivity option supported by many…
Using sensitivity labels – Using Data Model Advanced Features
Using sensitivity labels As part of the holistic data protection capabilities, Power BI includes integration with Microsoft Information Protection (MIP). MIP provides sensitivity labels as…
The Advanced section – Designing a Data Model
The Advanced section In the Advanced section, you can choose to sort one column by another column in the same table. A common use for…
Configure table and column properties – Designing a Data Model
Configure table and column properties Once we have our relationships sorted, we can take a peek at our table and column properties. In Power BI…
Relationship test tips – Designing a Data Model
Relationship test tips Here are some tips for managing table relationships: Define role-playing dimensions If you are used to using star schemas, one of the…
Cardinality – Designing a Data Model
Cardinality Power BI relationship cardinality decides which table filters the other. There are three possible cardinalities. Many-to-one (*:1) and one-to-many (1:*) This is a relationship…
Using the Query Dependencies tool – Cleansing, Transforming, and Shaping Data
Using the Query Dependencies tool For complex data models, it’s very helpful to understand the relationship between different queries, staging queries, and transformations. While the…
Sentiment analysis – Cleansing, Transforming, and Shaping Data
Sentiment analysis A sentiment is a feeling or judgment of something and in the field of analytics, sentiment analysis is a type of language or…