Category: Microsoft Power BI Data Analyst Certification Guide
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…
Star schema – Designing a Data Model
Star schema A star schema organizes your data into fact and dimension tables. You can use dimension tables to filter the fact table. Dimension tables…
Define the tables – Designing a Data Model
Define the tables As mentioned in the introduction, once you’ve acquired your data, cleaned it, and organized it, you can start to model it. Usually,…
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…
Using merge queries – Cleansing, Transforming, and Shaping Data
Using merge queries Merge queries are used when we want to merge or combine columns from multiple queries where some columns are different. This often…
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…
Enriching data with AI – Cleansing, Transforming, and Shaping Data
Enriching data with AI Power Query also includes ways to enhance data using AI services from Microsoft. These features integrate with Microsoft Azure Cognitive Services…
Image tagging – Cleansing, Transforming, and Shaping Data
Image tagging Sometimes, data in a query contains an image (Base64 encoded) or a URL of an image. In those cases, we can use the…