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