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

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, 211 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, 36 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, 34 reads

Posted in SQL Server BI Blog on 26 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, 228 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, 368 reads

Posted in SQL Server BI Blog on 5 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, 23 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, 65 reads

Posted in SQL Server BI Blog on 29 April 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, 558 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, 241 reads

Posted in SQL Server BI Blog on 26 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, 20 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, 17 reads

Posted in SQL Server BI Blog on 12 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, 207 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, 272 reads

Posted in SQL Server BI Blog on 4 February 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, 15 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, 51 reads

Posted in SQL Server BI Blog on 29 January 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, 414 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, 295 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, 237 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, 271 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, 285 reads

Posted in SQL Server BI Blog on 5 January 2015

Newer posts

Older posts