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…
Category: SSAS Design
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.
Business Analytics, DAX, SolidQ, SQL Server, SQL Syndication, SSAS Administration, SSAS Design, Tabular Models
SSAS Performance Logger Now Available
I’ve created a simple query performance logging tool for Analysis Services, called the SSAS Performance Logger. The tool allows you…
Creating a Dynamic, Parameterized Measure in DAX
As I continue to explore the many facets of DAX functions, I’m finding more creative ways to add business value…
SSAS Tabular Models: The Good, the Bad, the Ugly & the Beautiful
After working on a couple of serious tabular model projects, I’ve been talking to other BI practitioners lately about their…
BI Industry, Microsoft BI Platform, MVP Community, PowerPivot, SolidQ, SQL Server, SQL Syndication, SQLServerPedia, SSAS Administration, SSAS Design, Tabular Models
Taking the Tabular Journey
A Getting-Started and Survival Guide for planning, designing and building Tabular Semantic Models with Microsoft SQL Server 2012 Analysis Services.…
BI Industry, Microsoft BI Platform, Power View, PowerPivot, SolidQ, SSAS Administration, SSAS Design
Power View for Multidimensional Cubes Released
The Power View connectivity for Multidimensional Models has been released to the public as part of SQL Server 2012 Service…
BI Industry, Microsoft BI Platform, SolidQ, SQL Syndication, SQLServerPedia, SSAS Design, SSRS Design, Tabular Models
Visual Studio 2012/SSDT Addition for BI Project Version Compatibility & Themes
We can now use Visual Studio 2012 to create and edit SQL Server BI projects! Woo Hoo. In the past,…
BI Industry, Microsoft BI Platform, Power View, PowerPivot, SQLServerPedia, SSAS Administration, SSAS Design, Tabular Models
Power View Now Works with Cubes!
This is a very significant day in the progression of the Microsoft Business Intelligence platform. Earlier this year, Power View…
BI Sessions and Report Dashboard Demos at the PASS Global Summit
Literally, minutes after I began posting my running notes from the keynote presentations and the first session I attended, I…
Articles, BI Industry, Microsoft BI Platform, MVP Community, SolidQ, SQL Server, SQL Syndication, SSAS Administration, SSAS Design, SSRS Administration, SSRS Design
SQL Server BI & SharePoint eBooks, Guides and Resources
There are many free eBooks & resources available from Microsoft and members of the MVP community. This is a collection…
Microsoft BI Platform, SolidQ, SQL Server, SQL Syndication, SSAS Administration, SSAS Design, SSRS Administration, SSRS Design, Tabular Models
SQL Server 2012 Upgrade Technical Guide is available
The SQL Server 2012 upgrade white paper is now available from Microsoft. I’m proud to have made a contribution and…
Presentation: Visual Report Design
My presentation from SQL Saturday #94 in Salt Lake, TechEd 2011 in Atlanta and 24 Hours of PASS. The spotlight…
Microsoft BI Platform, MVP Community, SQL Saturday, SQL Server, SQL Syndication, SSAS Administration, SSAS Design
Come to SQL Saturday 92 in Portland
Are you In Portland, Oregon? Do you plan to be in Portland on Saturday, October 8th? Can you be in…
SQL Saturday – Salt Lake and Portland
I will be speaking at two SQL Saturday events on the topics of visual report design with SQL Server Reporting…