Calendar Reporting with Excel and Power Pivot

Imagine that you wanted to see a daily sales report for each day that also included month to date and year to date numbers. You could look at a large pivot table like this: Or you could look at something that we are all a little more familiar with. A simple calendar: In a calendar… Read more

Bucketing Values in DAX

Let’s say I wanted to analyze query performance on my SQL database. I have a log that has all the queries, the time it took them to run and the total records that were returned. I want to look at how the size of the results impacts the performance of the queries. I pull my… Read more

SQL Server Data Tools – Business Intelligence for Visual Studio 2013 (SSDT BI)

Yesterday we released SQL Server Data Tools – Business Intelligence for Visual Studio 2013 (SSDT BI) for SQL Server 2014.  With this release you can use SSDT BI in Visual Studio 2013 and it includes the Visual Studio Project Templates for Analysis Services, Integration Services, and Reporting Services.  The project templates in this release generally… Read more

Released: Management Pack for SQL Server Analysis Services 2008 and 2012

This week, we released Management Packs for SQL Server 2008 and 2012 Analysis Services. The corresponding downloads are available at:   System  Center Management Pack for SQL Server 2012 Analysis Services   System  Center Management Pack for SQL Server 2008 Analysis Services These Management Packs deliver proactive and reactive monitoring capabilities for SQL Server Analysis… Read more