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 Microsoft Power BI Data Analyst Certification Guide Power Query parameters

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…

Continue Reading... Star schema – Designing a Data Model
Posted in Examining data structures Microsoft Power BI Data Analyst Certification Guide Power Query parameters Transforming text columns

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,…

Continue Reading... Define the tables – 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 Microsoft Power BI Data Analyst Certification Guide Power Query parameters Transforming text columns Using sensitivity labels

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…

Continue Reading... Using merge queries – 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
Posted in Examining data structures Microsoft Power BI Data Analyst Certification Guide Power Query parameters

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…

Continue Reading... Enriching data with AI – Cleansing, Transforming, and Shaping Data
Posted in Microsoft Power BI Data Analyst Certification Guide

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…

Continue Reading... Image tagging – Cleansing, Transforming, and Shaping Data