Paul Turley's SQL Server BI Blog
sharing my experiences with the Microsoft data platform, Fabric, enterprise Power BI, SQL Server BI, Data Modeling, SSAS Design, SSRS, Dashboards & Visualization since 2009
Is is possible to duplicate the same many-to-many relationship behavior in VertiPaq that we have in SSAS multidimensional? Since Tabular…
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.
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…
I’ve created a simple query performance logging tool for Analysis Services, called the SSAS Performance Logger. The tool allows you…
As I continue to explore the many facets of DAX functions, I’m finding more creative ways to add business value…
This series of video sessions will demonstrate how to create a business intelligence solution with sets of business data from…
by Paul te Braak, from Packt Publishing on Amazon Good technology books usually come in one of two forms. Some…
What I’m going to show you is not rocket science. This one gets filed under the category of “well, duh. …
A client came to me with a challenge this week that, although simple in concept, posed an interesting challenge that…
After working on a couple of serious tabular model projects, I’ve been talking to other BI practitioners lately about their…
A Getting-Started and Survival Guide for planning, designing and building Tabular Semantic Models with Microsoft SQL Server 2012 Analysis Services.…
We can now use Visual Studio 2012 to create and edit SQL Server BI projects! Woo Hoo. In the past,…
This is a very significant day in the progression of the Microsoft Business Intelligence platform. Earlier this year, Power View…
Literally, minutes after I began posting my running notes from the keynote presentations and the first session I attended, I…
I had a really good experience presenting a session at the SQL Saturday BI Edition in Dallas this weekend about…