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

Power BI Application Embedding Releases Today

A few weeks ago, the Power BI team gave us the ability to freely embed Power BI reports, dashboards and other capabilities into a web frame for all the world to see.  The next natural step, you might think, would be a way to to securely embed selected Power BI…

Read more

1 comments, 152 reads

Posted in SQL Server BI Blog on 1 April 2016

Color Themes for Power BI

Color coordination is important in report and dashboard design.  We’ve seen theming and color pallet options in the prior iteration of Power BI but this is not yet a feature in the new version. No doubt, the product will continue to move forward and we’re likely to see some kind…

Read more

6 comments, 173 reads

Posted in SQL Server BI Blog on 22 March 2016

Annual Business Intelligence Survey

This is a reminder to compete the annual Business Intelligence product survey conducted by BARC Research.  I’ve been participating in the survey for several years (as far as I know, as long as it has been running).  As a participant, I receive a detailed copy of the results which are…

Read more

1 comments, 172 reads

Posted in SQL Server BI Blog on 15 March 2016

Article Series: Power BI Solutions for the Enterprise

I’m working on a series of articles about creating enterprise solutions with Power BI and the first article was published this past week in SQL Server Pro Magazine.  I will republish the completed series but until then, I’ll post short excerpts from each article.  In future posts, I’ll show examples…

Read more

6 comments, 188 reads

Posted in SQL Server BI Blog on 28 February 2016

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

4 comments, 223 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, 239 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, 226 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, 200 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,594 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, 213 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, 201 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, 62 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, 60 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, 506 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, 269 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, 65 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, 60 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, 471 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, 359 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, 64 reads

Posted in SQL Server BI Blog on 11 July 2015

Older posts