Adding PerformancePoint Dashboard Content to SharePoint
Microsoft SharePoint Server 2010 provides several options for creating Dashboards using PerformancePoint content.
The first option is to implement the...
2013-02-11
3,568 reads
Salvo(z) SQL
SQL Server Analysis Services Tabular KPIs
A few weeks ago, I wrote a blog post that discusses implementing KPIs in SQL Server Analysis Services Multidimensional. For...
2013-02-04
2,608 reads
Currency Conversion in Tabular Model Using DAX
Roughly a year ago, I implemented currency conversion logic in multidimensional cubes using measure expressions (as well as using the...
2013-01-28
3,856 reads
Re-writing MDX calculated members as DAX measures
I have been working on re-creating some logic in a tabular cube that was originally implemented in multidimensional. This involved...
2013-01-21
1,352 reads
SQL Server Analysis Services KPIs
Key Performance Indicators (KPIs) are measurements used to gauge business performance against quantifiable goals. SQL Server Analysis Services provides functionality...
2013-01-15 (first published: 2013-01-14)
6,553 reads
Querying and Optimizing DAX
Over the past few weeks, I’ve been watching some videos from this year’s PASS Summit. One of the presentations I...
2013-01-02
3,974 reads
Optimizing Your BI Semantic Model for Performance and Scale
Here’s my notes from the ‘Optimizing Your BI Semantic Model for Performance and Scale (BIA-402-M)’ session at PASS Summit, presented...
2012-12-11
2,994 reads
SSIS: Character Replacement Using the Script Component
When cleansing data from source systems to store in a data mart or warehouse, we often need to remove or...
2012-12-08
1,755 reads
T-SQL Tuesday: What Does the SQL Community Mean to You?
Today is T-SQL Tuesday #36, hosted by Chris Yates (B | T). The topic this month is ‘What Does the SQL...
2012-11-13
788 reads
Book Review: SQL Server 2012 Analysis Services The BISM Tabular Model
I will start off by saying, whenever I see the names Marco Russo, Alberto Ferrari and Chris Webb on a...
2012-11-12
1,885 reads
Blogs
The Benefits of Teaching
By Brian Kelley
Even preparing for a class or seminar with set materials takes a lot of...
Power BI, Excel, OneLake – Dreams Do Come True!
By DataOnWheels
I can’t believe it’s finally here! A way to have Excel live in OneDrive...
The Book of Redgate: What Our Staff Says
By Steve Jones
This image is from 2010, and it goes along with my last post of...
Forums
Website Stability 2025/12/05
All week we've had issues with the site being up and down. There's been...
403 Forbidden
I created a post (or tried) in the 2022 Admin forum. https://www.sqlservercentral.com/?post_type=topic&p=4694880 But it's...
Question of the Day
Fabric Mirroring
In which versions can I mirror a database from an on-premises SQL Server to a Fabric data warehouse?
See possible answers