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

Gartner Magic Quadrant for BI/BA and the Lone Three Leaders

History clearly confirms that good things come in threes.  As far as I know this is the first time that only the three most widely recognized Business Intelligence platforms have been placed in the top-right leaders/visionaries space of the Magic Quadrant for Business Intelligence and Analytics Platforms, as of February…

Read more

1 comments, 178 reads

Posted in SQL Server BI Blog on 5 February 2016

Webcast: Upgrading and Migrating SQL Server 2005 BI Features to SQL Server 2014 and 2016

Please join me on February 3rd at 10 Pacific Time for this presentation brought to you by Microsoft and SolidQ If you’re still on SQL Server 2005, there are some important things to be aware of.  First and foremost is that you are missing out on innumerable capabilities in more…

Read more

0 comments, 190 reads

Posted in SQL Server BI Blog on 26 January 2016

Tabular Models, Multiple Data Sources and Unknown Members

Self-service data modeling tools like Power BI Desktop, Power Pivot and SSAS Tabular promote the advantage of using data from multiple data sources.  I’m including SSAS Tabular on the “self-service” list because it is derived from Power Pivot and often used for “quicker” IT-managed BI projects.  The alleged advantage of…

Read more

5 comments, 176 reads

Posted in SQL Server BI Blog on 29 December 2015

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

4 comments, 146 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,536 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, 176 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, 158 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, 39 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, 34 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, 462 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, 235 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, 37 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, 36 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, 400 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, 305 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, 44 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, 62 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, 591 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, 38 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, 265 reads

Posted in SQL Server BI Blog on 7 June 2015

Older posts