Category: Transforming text columns
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…
Model size – Designing a Data Model
Model size Creating your own date table and creating relationships with all the date columns in your model will reduce the model size, sometimes significantly….
Managing row-level security – Using Data Model Advanced Features
Managing row-level security In Power BI Desktop, you can manage roles and the DAX expression applied to each role by clicking Manage roles under the…
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…
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…
