Category: Examining data structures
Posted in Examining data structures Microsoft Power BI Data Analyst Certification Guide Power Query parameters
Star schema – Designing a Data Model
Author: Noah Walker Published Date: July 10, 2023 Leave a Comment on 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…
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
Author: Noah Walker Published Date: June 10, 2023 Leave a Comment on 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,…
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
Author: Noah Walker Published Date: June 10, 2023 Leave a Comment on 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…
Posted in Examining data structures Microsoft Power BI Data Analyst Certification Guide Power Query parameters
Enriching data with AI – Cleansing, Transforming, and Shaping Data
Author: Noah Walker Published Date: February 10, 2023 Leave a Comment on 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…