Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

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, 150 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, 192 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, 180 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, 299 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, 204 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, 152 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, 167 reads

Posted in SQL Server BI Blog on 26 May 2015

Microsoft DataZen Mobile Platform Available to SQL Server Enterprise Customers for Free

Last month Microsoft announced that they had acquired the DataZen mobile BI platform and were adding it to their enterprise BI product suite. This is very exciting news that rounds out the Microsoft BI capabilities of their entire product portfolio. What’s more, is that they plan to make if free…

Read more

6 comments, 220 reads

Posted in SQL Server BI Blog on 5 May 2015

DataZen Dashboards Update

I’ve spend a good three days on and off working with the new “Microsoft” DataZen dashboard tool and I think this is going to be significant addition to the enterprise BI offering. It’s not quick and easy to setup the server, configure data sources, data view queries and design dashboards…

Read more

14 comments, 345 reads

Posted in SQL Server BI Blog on 29 April 2015

Microsoft DataZen Mobile Platform Available to Enterprise Customers for Free

Last week Microsoft announced that they had acquired the DataZen mobile BI platform and were adding it to their enterprise BI product suite. This is very exciting news that rounds out the Microsoft BI capabilities of their entire product portfolio. What’s more, is that they plan to make if free…

Read more

5 comments, 179 reads

Posted in SQL Server BI Blog on 26 April 2015

SQL Server 2014 Upgrade Sessions on the Microsoft Virtual Academy

It was a great honor to be asked to join my associates from SolidQ at the Microsoft Virtual Academy Studios in Redmond and talk about how to upgrade to SQL Server 2012 and 2014.  These recordings, which are also on my YouTube Channel, include the material I covered in these…

Read more

1 comments, 166 reads

Posted in SQL Server BI Blog on 12 April 2015

Some Thoughts About Microsoft’s Cloud Platform Roadmap

There have been a lot of changes in and around Microsoft in the past few months.  Under the leadership of Satya Nadella, the push toward “cloud first” and “mobile first” services, things are stirred-up a bit right now.  I have to admit that having worked with consulting clients who can’t,…

Read more

1 comments, 224 reads

Posted in SQL Server BI Blog on 4 February 2015

Power BI Workshop Videos

I’ve created a series of five tutorial videos for a set of workshops I’ll be doing at several events this year.  The workshop is available from an hour-long quick demo to a full-day, hands-on workshop with a hosted lab environment in the cloud.  The series teaches how to create a…

Read more

4 comments, 268 reads

Posted in SQL Server BI Blog on 29 January 2015

New Power BI Preview and Pricing

Some exciting announcements were made today about the new Power BI cloud-based business analytics service.  Today Power BI is an add-on service for Office 365 that requires an enterprise-level license – about $50 per user per month.  Data transformation queries, data models and dashboard visualizations are all created using add-in…

Read more

1 comments, 221 reads

Posted in SQL Server BI Blog on 28 January 2015

How to resolve connection errors when loading data in SSAS Tabular project

This post actually applies to both multidimensional (cube) projects and Tabular projects which manage data source connectivity in a similar fashion.  The multidimensional design experience is different but the mechanics of the SSAS engine are essentially the same. When loading data from a SQL Server data source into a Tabular…

Read more

1 comments, 192 reads

Posted in SQL Server BI Blog on 9 January 2015

Power BI Semantic Model Supports Many-to-Many Relationships

Is is possible to duplicate the same many-to-many relationship behavior in VertiPaq that we have in SSAS multidimensional? Since Tabular model projects were introduced in SQL Server 2012, one of the major blocking points for adaption has been the lack of out-of-the-box support for many-to-many relationships.  I’ve been using, demonstrating…

Read more

0 comments, 192 reads

Posted in SQL Server BI Blog on 5 January 2015

Power BI Semantic Model Supports Many-to-Many Relationships

Is is possible to duplicate the same many-to-many relationship behavior in VertiPaq that we have in SSAS multidimensional? Since Tabular model projects were introduced in SQL Server 2012, one of the major blocking points for adaption has been the lack of out-of-the-box support for many-to-many relationships.  I’ve been using, demonstrating…

Read more

0 comments, 232 reads

Posted in SQL Server BI Blog on 5 January 2015

New Power BI stand-alone Designer, Dashboards, APIs & iOS App

This week Microsoft announced the availability of Power BI Dashboards and the browser-based dashboard designer.  What is it and why is it important?  The most significant thing about it is that report and dashboard users do not need to have Excel 2013 ProPlus edition or an Office 365 subscription to…

Read more

0 comments, 339 reads

Posted in SQL Server BI Blog on 20 December 2014

Drill-through to Details from Reporting Services to Excel

Can an SSRS report be designed to drill-through to an Excel workbook in-context (showing only the same filtered detail data)? I have to admit that I have been chasing this solution for a few years now before I was motivated enough to work it through to a viable result. More…

Read more

2 comments, 628 reads

Posted in SQL Server BI Blog on 1 December 2014

SQL Server Upgrade Preconference at PASS Summit 2014

Please join my associates and I for an all-day SQL Server Upgrade workshop on November 3rd If you are planning an upgrade to a newer version of SQL Server, you won’t want to miss this all-day, preconference workshop. Join John Martin, Sr. Technology Evangelist from Microsoft, will spend the morning…

Read more

0 comments, 283 reads

Posted in SQL Server BI Blog on 21 October 2014

Older posts