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…
Category: SQLServerPedia
BI Industry, BI Projects, DataZen, SQL Server, SQL Server Pro Magazine, SQL Syndication, SQLServerPedia
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…
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…
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…
BI Industry, BI Projects, Excel BI, PowerPivot, Self-service BI, SQL Syndication, SQLServerPedia, SSAS Administration, Tabular Models
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 for clients. These projects were either delivered to an analyst using Excel on their desktop or some business users through SharePoint. But, authoring in Excel Power Pivot and deploying to a server-hosted Tabular model has been mainly theoretical up to this point so I thought I’d share my experience.
Articles, BI Industry, DataZen, Microsoft BI Platform, SolidQ, SQL Server, SQL Syndication, SQLServerPedia
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…
Articles, BI Industry, BI Projects, Business Analytics, DataZen, Microsoft BI Platform, Self-service BI, SolidQ, SQL Server, SQL Server Pro Magazine, SQL Syndication, SQLServerPedia
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 for SQL Server Enterprise customers who have Software Assurance agreements.
Watch for a series of articles about getting started with DataZen in SQL Server Pro Magazine online.
I presented a session at the PASS Global Summit in 2013 showcasing DataZen called “New York, London, Paris Munich; Everybody’s Talking About Mobile BI”.
SolidQ, SQL Server, SQL Syndication, SQLServerPedia, SSAS Administration, SSAS Design, SSRS Administration, SSRS Design, Tabular Models
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…
Data Visualization, Microsoft BI Platform, Power BI, Power View, PowerPivot, Self-service BI, SQL Syndication, SQLServerPedia
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…
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…
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…
BI Industry, BI Projects, Business Analytics, Power BI, PowerPivot, Self-service BI, SQL Syndication, SQLServerPedia, Tabular Models
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…
BI Industry, Business Analytics, Microsoft BI Platform, Power BI, Power View, Self-service BI, SQL Syndication, SQLServerPedia
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…
PASS, SolidQ, SQL Server, SQL Syndication, SQLServerPedia, SSAS Administration, SSAS Design, SSRS Administration, SSRS Design, Tabular Models
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 discussing migration planning from SQL Server 2005.
In the afternoon, SolidQ mentors Ron Talmage, Richard Waymire, Jim Miller and Paul Turley will talk about and demonstrate upgrading specific workloads (projects and features) from older product versions to newer product versions. We will introduce the comprehensive SQL Server 2014 Upgrade Whitepaper that we recently wrote for publication by Microsoft.
BI Industry, BI Projects, Business Analytics, DAX, Microsoft BI Platform, Power BI, PowerPivot, Self-service BI, SQL Server Pro Magazine, SQL Syndication, SQLServerPedia, Tabular Models
Adding and Displaying Comments to Power Pivot Results in an Excel Pivot Table
Requirement: Allow users to enter comments after they review results from a Power Pivot model and then show the comment text in the Pivot Table report results. Here’s a quick example of the final result. My example uses Flintstones characters in-place of employee or customer names and a simple measure value. After reviewing the results, the user moves to another worksheet and enters a comment for the date and person with an expiration date for the comment. After refreshing the report, each cell with a comment is indicated with a little “dog ear” and the comment is displayed by clicking the cell…