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

Using your own date table – Designing a Data Model

Using your own date table You can either create a date table in Power BI or use a date table already in your data source….

Continue Reading... Using your own date table – Designing a Data Model
Posted in Examining data structures Microsoft Power BI Data Analyst Certification Guide Power Query parameters

Implementing row-level security – Using Data Model Advanced Features

Implementing row-level security A common security need for customers building reporting solutions with Power BI and needing to simplify the data model is a way…

Continue Reading... Implementing row-level security – Using Data Model Advanced Features
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 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 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