How to filter DAX for paginated reports
DAX is unlike SQL when filtering. In this article, Adam Aspin demonstrates how to filter DAX for paginated reports.
2022-01-10
BI
Introduction to DAX for paginated reports
SSRS reports can be built using DAX. In this article, Adam Aspin explains how to get started using DAX to build the reports.
2021-12-10
Text Mining and Sentiment Analysis: Data Visualization in Tableau
Tableau is a popular visualization tool used by organizations around the world. In this article Sanil Mhatre demonstrates sentiment analysis with Tableau and Oracle data.
2021-11-08
Text Mining and Sentiment Analysis: Oracle Text
Oracle has built-in functionality to analyze text. Sanil Mhatre demonstrates how to perform a sentiment analysis on data stored in a table using Oracle Text.
2021-09-15
Embed Power BI in Jupyter Notebooks
Power BI and Jupyter Notebooks are popular tools, but you may have never thought about using them together. Dennes Torres demonstrates how to do that and also asks why.
2021-07-07
DAX financial functions: Depreciation calculations
Business Intelligence Architect, Analysis Services Maestro, and author Bill Pearson continues his series surrounding the DAX financial functions. In this article, he exposes four functions that are popular in the calculation of depreciation and amortization. Those accustomed to these functions within Excel will find the syntax, uses and operation of the functions familiar within the Power BI environment.
2021-01-19
Introduction to DAX Financial Functions – Part 1
Business Intelligence Architect, Analysis Services Maestro, and author Bill Pearson kicks off a series to introduce the DAX financial functions. In this article, he exposes five functions that are popular in the calculation of loans and other annuities. Those accustomed to these functions within Excel will find the syntax, uses and operation of the functions familiar within the Power BI environment.
2020-10-22
Clarifying Data Warehouse Design with Historical Dimensions
The standard data warehouse design from Kimball with facts and dimensions has been around for almost 25 years. In this article, Vince Iacoboni describes another way to design slowly changing dimensions.
2020-08-24
Creating Time-Intelligence Functions in DAX
DAX contains a host of time-intelligence functions with exotic names such as SAMEPERIODLASTYEAR and PARALLELPERIOD. In the last article in this series, Andy Brown explains how to write measures using the range of date functions in DAX, and also explains how time-intelligence functions work behind the scenes.
2020-03-06
Text Mining and Sentiment Analysis: Introduction
Microsoft provides a service to analyze text data called Text Analytics Cognitive Service. In this article, Sanil Mhatre demonstrates how to use this service from Power BI.
2020-02-21
Blogs
Who are you? Building an identity map.
By Brian Kelley
I admit that until I read the article, Who are you as a Leader?,...
Call a Fabric REST API from Azure Data Factory
Suppose you want to call a certain Microsoft Fabric REST API endpoint from Azure...
Distributed Availability Group Dashboard
The Distributed Availability Group Dashboard can be downloaded from our GitHub repo. https://github.com/SQLUndercover/UndercoverToolbox/blob/master/DAG%20Dashboard.pbix. This...
Forums
Create Raw Zone Tables using Generative AI: Data Engineering with Fabric
Comments posted to this topic are about the item Create Raw Zone Tables using...
Database DevOps Metrics
Comments posted to this topic are about the item Database DevOps Metrics
Replacing a NULL II
Comments posted to this topic are about the item Replacing a NULL II
Question of the Day
Replacing a NULL II
What is returned from this code in SQL Server 2022?
DECLARE @value INT = NULL , @value2 VARCHAR(20) = NULL; SELECT COALESCE (@value, @value2, 100.5) AS Result; GOSee possible answers