Posted in Examining data structures Identifying data anomalies Microsoft Power BI Data Analyst Certification Guide Power Query parameters Transforming text columns Using sensitivity labels

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…

Continue Reading... XMLA endpoints – Connecting to Data Sources
Posted in Examining data structures Identifying data anomalies Microsoft Power BI Data Analyst Certification Guide

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…

Continue Reading... Using sensitivity labels – Using Data Model Advanced Features
Posted in Examining data structures Identifying data anomalies Microsoft Power BI Data Analyst Certification Guide

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…

Continue Reading... The Advanced section – Designing a Data Model
Posted in Examining data structures Identifying data anomalies Microsoft Power BI Data Analyst Certification Guide Power Query parameters

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…

Continue Reading... Configure table and column properties – Designing a Data Model
Posted in Examining data structures Identifying data anomalies Microsoft Power BI Data Analyst Certification Guide Transforming text columns

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…

Continue Reading... Relationship test tips – Designing a Data Model
Posted in Examining data structures Identifying data anomalies Microsoft Power BI Data Analyst Certification Guide Using sensitivity labels

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…

Continue Reading... Cardinality – Designing a Data Model
Posted in Examining data structures Identifying data anomalies Microsoft Power BI Data Analyst Certification Guide Transforming text columns

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…

Continue Reading... Using the Query Dependencies tool – Cleansing, Transforming, and Shaping Data
Posted in Identifying data anomalies Microsoft Power BI Data Analyst Certification Guide Power Query parameters Transforming text columns

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…

Continue Reading... Sentiment analysis – Cleansing, Transforming, and Shaping Data