Month: June 2023
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…