Excel BI Tip #18: Using CUBE Functions to Break Out of Pivot Tables
As I mentioned in my original post, Exploring Excel 2013 as Microsoft’s BI Client, I will be posting tips regularly...
2015-02-04 (first published: 2015-01-27)
8,077 reads
As I mentioned in my original post, Exploring Excel 2013 as Microsoft’s BI Client, I will be posting tips regularly...
2015-02-04 (first published: 2015-01-27)
8,077 reads
As I mentioned in my original post, Exploring Excel 2013 as Microsoft’s BI Client, I will be posting tips regularly...
2015-01-28 (first published: 2015-01-20)
6,911 reads
While this is not a regular Excel tip, but it is about Excel. In my Excel BI Tips series, I...
2015-01-22
1,102 reads
Steve:
This is James’ second post on creating SQL tools with PowerShell and Windows forms. James is a DBA responsible for...
2015-01-19 (first published: 2015-01-14)
6,787 reads
This is a follow up blog post based on the Intro to Data Factory session I gave on the Training...
2015-01-13
983 reads
A tribute is an expression of gratitude or praise. A couple of years ago, I started a series about individuals...
2015-01-12
755 reads
As is our want, we must look back over the past year to see what happened. While I normally focus...
2015-01-11
630 reads
Steve:
Check out a new blogger who is sharing secrets of the DBA world. In his first post, James shows us...
2014-12-09 (first published: 2014-12-03)
7,244 reads
This blog post digs into the details of shaping the data with Power Query and Power Pivot in order to...
2014-11-19 (first published: 2014-11-12)
8,120 reads
This is the second deep dive into Power Testing ETL with Power BI. At this point, we have created the...
2014-11-13
1,173 reads
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
By Steve Jones
We aren’t the only company that does this, but Redgate Software does try to...
By James Serra
Microsoft Fabric makes it wonderfully easy to put many analytics workloads on one platform....
Comments posted to this topic are about the item The New World Of AI...
Thanks in advance, I'm trying to avoid using IIF for performance reasons, but the...
Security has long been a problem for me. Every time I think I understand...
What does this return on SQL Server 2025?
select bit_count(null)See possible answers