The first five posts of these series were largely conceptual discussions that sprinkled in some SQL and data models here and there where helpful. This final post will serve as a summary of those posts, but it will also specifically include SQL queries, data models and transformation logic related to the overall discussion that should […] The post Tied With A Bow: Wrapping Up the Hierarchy Discussion (Part 6 of 6) appeared first on Snap Analytics.| Snap Analytics
In the first three posts of this series, we delved into some necessary details from graph theory, reviewed acyclic graphs (DAGs), and touched on some foundational concepts that help describe what hierarchies are and how they might best be modeled. In the fourth post of the series, we spent time considering an alternative model for […] The post Edge Cases: Handling Ragged and Unbalanced Hierarchies (Part 5 of 6) appeared first on Snap Analytics.| Snap Analytics
In the first post of this series, we walked through the basic concepts of a graph. In the second post, we discussed a particular kind of graph called a directed acyclic graph (DAG) and helped disambiguate and extend the roles it plays in data engineering. In the third post, we further constrained the definition of […] The post Flat Out: Introducing Level Hierarchies (4 of 6) appeared first on Snap Analytics.| Snap Analytics
Offline-KI ist eine Art von KI, die ohne Internetverbindung läuft und keine Daten an Dritte sendet. Sie bietet bessere Ergebnisse als ChatGPT und kann für Unternehmen und Behörden mehr leisten, da sie vollständige Kontrolle über ihre Daten hat und leicht verbessert werden kann.| Dr. DSGVO
Analysis of dataset properties leading to a bad performance problem with a simple fix. Continue Reading → The post A Data Model Fix for Suboptimal Semi-Join and Anti-Join Cardinality Estimates appeared first on All-round Database Topics.| All-round Database Topics
Ein Laptop kann mit Open-Source-KI-Modellen sehr schnell Bilder generieren, ohne Internetanbindung und vollständige Datenkontrolle. Die Programmierung dafür dauert nur wenige Minuten, was ein erheblicher Fortschritt im Vergleich zu früheren Software-Projekten ist.| Dr. DSGVO
This article aims to show how you can speed up distinct count calculations in Power BI using the built-in user-defined aggregations feature. The user-defined aggregation feature in Power BI is designed to work with direct query models and usually gets used for calculations such as SUM, MIN, MAX etc. However, it can also work well … Continue reading Speed up Distinct Count calculations in Power BI using Aggregations The post Speed up Distinct Count calculations in Power BI using Aggregations...| Phil Seamark on DAX
Background I recently shared on Twitter a 7-module learning path on MS Learn that teaches all you need to know about calculation groups in Power BI. This learning path is an excellent course, and I highly recommend it. However, as part of this exchange, I received a reply from someone lamenting that calculation groups are … Continue reading Using PowerShell to create Calculation Groups in Power BI Desktop The post Using PowerShell to create Calculation Groups in Power BI Desktop appeared fi...| Phil Seamark on DAX
Introduction How to choose the correct storage mode for Power BI Tables. This article aims to help explain the different storage modes available when designing an aggregation strategy for a Power BI Report. What each storage mode is and when you would use it. Picking the correct storage mode for each table in your model … Continue reading Power BI Storage Modes for Aggregations The post Power BI Storage Modes for Aggregations appeared first on Phil Seamark on DAX.| Phil Seamark on DAX
This article introduces the Power BI User-defined Aggregations feature. It includes a walkthrough example (with video) showing how to configure and test a simple model to use this feature. If you have not used Power BI User-defined Aggregations before, need a refresher or reminder, or are just keen to understand how to configure, this article … Continue reading Intro to Power BI Aggregations The post Intro to Power BI Aggregations appeared first on Phil Seamark on DAX.| Phil Seamark on DAX