Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Complete DAX Function Reference

The DAX function documentation in MSDN can be found on separate pages,  organized by function categories and then details for every function.  This is useful but you can’t view all of the functions in one searchable page.  If you don’t know exactly what you’re looking for, it can be a…

Read more

5 comments, 411 reads

Posted in SQL Server BI Blog on 26 November 2015

SQL Server 2005 End of Support and Business Intelligence

How does the official end of support for SQL Server 2005 affect companies using Reporting Services, Analysis Services and other BI features? I was recently interviewed for a CIO Magazine article by freelance writer Andy Patrizio about what the end of support means for CIOs.  Thanks to the SQL Server…

Read more

0 comments, 1,736 reads

Posted in SQL Server BI Blog on 24 November 2015

The Resurrection of Reporting Services & The Maturing of Power BI

Spending the past two weeks at the annual PASS Global Summit and the Microsoft MVP Summit, I’ve consumed a literal firehouse of information about the Microsoft BI platform.  I’ve participated in the PASS Summit for twelve years and the MVP Summit for seven years thus far and in that time,…

Read more

13 comments, 326 reads

Posted in SQL Server BI Blog on 12 November 2015

Oregon SQL Saturday 2015 Keynote

This year we are honored to have a particularly special guest kicking off our SQL Saturday event on October 24th.  Microsoft is once again moving to a front-line position as a leader in Business Intelligence and Analytics and the Corporate Vice President who leads that team will be speaking live…

Read more

1 comments, 318 reads

Posted in SQL Server BI Blog on 2 October 2015

Oregon SQL Saturday 2015 Keynote

This year we are honored to have a particularly special guest kicking off our SQL Saturday event on October 24th.  Microsoft is once again moving to a front-line position as a leader in Business Intelligence and Analytics and the Corporate Vice President who leads that team will be speaking live…

Read more

1 comments, 128 reads

Posted in SQL Server BI Blog on 2 October 2015

Power BI Custom Visuals Contest Round-up

It's really exciting to see the first round of entries into the Power BI Best Visuals Contest, which has been running for about two weeks and wraps up on October 1. The first people's choice award winner is Daniele Perilli from Rome who submitted a nice horizontal bullet chart. The…

Read more

3 comments, 201 reads

Posted in SQL Server BI Blog on 22 September 2015

Power BI Custom Visuals Contest Round-up

It's really exciting to see the first round of entries into the Power BI Best Visuals Contest, which has been running for about two weeks and wraps up on October 1. The first people's choice award winner is Daniele Perilli from Rome who submitted a nice horizontal bullet chart. The…

Read more

3 comments, 637 reads

Posted in SQL Server BI Blog on 22 September 2015

Are you Ready to Use Power BI?

What! NO? Get with it, my friend.  Power BI is for everyone.  All the kids are doing it… not to mention the business owners, marketers, sales campaign planners and scientists, IT Pros and common folk.  Power BI is all the rage and can be used to analyze everything under the…

Read more

1 comments, 354 reads

Posted in SQL Server BI Blog on 18 August 2015

Are you Ready to Use Power BI?

What! NO? Get with it, my friend.  Power BI is for everyone.  All the kids are doing it… not to mention the business owners, marketers, sales campaign planners and scientists, IT Pros and common folk.  Power BI is all the rage and can be used to analyze everything under the…

Read more

1 comments, 152 reads

Posted in SQL Server BI Blog on 18 August 2015

Power BI General Availability Announced: July 24, 2015

On Friday, James Phillips, Microsoft VP of Business Intelligence, announced the general availability of the new Power BI Business Analytics Service will be July 24th.  Also referred to as “Power BI 2.0”, the new service will eventually replace the 1.0 Power BI extension to Office 365.  In a nutshell, this…

Read more

2 comments, 143 reads

Posted in SQL Server BI Blog on 12 July 2015

Power BI General Availability Announced: July 24, 2015

On Friday, James Phillips, Microsoft VP of Business Intelligence, announced the general availability of the new Power BI Business Analytics Service will be July 24th.  Also referred to as “Power BI 2.0”, the new service will eventually replace the 1.0 Power BI extension to Office 365.  In a nutshell, this…

Read more

2 comments, 630 reads

Posted in SQL Server BI Blog on 12 July 2015

Online Training event: Designing a Mobile Dashboard Solution with Microsoft DataZen

I’d like to make you aware of a three-hour training event that I will be presenting, hosted by SQL Server Pro Magazine on Thursday, July 30th beginning at 11 AM Eastern Time.  Each one-hour session has a one hour break between and registered attendees can watch the sessions again after…

Read more

2 comments, 512 reads

Posted in SQL Server BI Blog on 11 July 2015

Online Training event: Designing a Mobile Dashboard Solution with Microsoft DataZen

I’d like to make you aware of a three-hour training event that I will be presenting, hosted by SQL Server Pro Magazine on Thursday, July 30th beginning at 11 AM Eastern Time.  Each one-hour session has a one hour break between and registered attendees can watch the sessions again after…

Read more

2 comments, 145 reads

Posted in SQL Server BI Blog on 11 July 2015

Power BI Hands-On Workshop at PASS Global Summit

Please join me at the PASS Global Summit in Seattle for a half-day, 3-hour hands-on Power BI mini workshop. Bring your laptop and let’s build a real business intelligence (BI) solution using Power BI! In this deep-dive session, we build a complete solution.  You will need the Power BI Designer…

Read more

4 comments, 140 reads

Posted in SQL Server BI Blog on 2 July 2015

Power BI Hands-On Workshop at PASS Global Summit

Please join me at the PASS Global Summit in Seattle for a half-day, 3-hour hands-on Power BI mini workshop. Bring your laptop and let’s build a real business intelligence (BI) solution using Power BI! In this deep-dive session, we build a complete solution.  You will need the Power BI Designer…

Read more

4 comments, 1,616 reads

Posted in SQL Server BI Blog on 2 July 2015

Animated Graphics Depict The Fallen of World War II

In an amazing application of visualization techniques, this production is a depiction of the casualties and affects of war.  Starting with World War II, Neil Halloran uses animated charts to measure the number of soldier and civilian deaths and then pivots and refactors these numbers in an impressive and impactful…

Read more

3 comments, 110 reads

Posted in SQL Server BI Blog on 7 June 2015

Animated Graphics Depict The Fallen of World War II

In an amazing application of visualization techniques, this production is a depiction of the casualties and affects of war.  Starting with World War II, Neil Halloran uses animated charts to measure the number of soldier and civilian deaths and then pivots and refactors these numbers in an impressive and impactful…

Read more

3 comments, 336 reads

Posted in SQL Server BI Blog on 7 June 2015

Maintaining Parallel Power Pivot and SSAS Tabular Models–Tales from the Trenches

This post is really a collection of field notes and some lessons learned from recent project experience. I’ve done plenty of SSAS Tabular projects over the past few years – usually starting with a Visual Studio project rather than Power Pivot. I’ve also done a bit of Power Pivot work…

Read more

7 comments, 305 reads

Posted in SQL Server BI Blog on 27 May 2015

Maintaining Parallel Power Pivot and SSAS Tabular Models–Tales from the Trenches

This post is really a collection of field notes and some lessons learned from recent project experience. I’ve done plenty of SSAS Tabular projects over the past few years – usually starting with a Visual Studio project rather than Power Pivot. I’ve also done a bit of Power Pivot work…

Read more

7 comments, 138 reads

Posted in SQL Server BI Blog on 27 May 2015

New Articles About Datazen, Microsoft’s Mobile Dashboard Platform

I’m pleased to share the first two articles in a series for SQL Server Pro Magazine.  Here’s a short excerpt from each with a link to the full article: Getting Started with Datazen, Microsoft’s New Mobile Dashboard Platform (Part 1) Microsoft Datazen is a new tool from Microsoft built on…

Read more

1 comments, 115 reads

Posted in SQL Server BI Blog on 26 May 2015

Newer posts

Older posts