Category: SQL Server

Azure Data Factory, Azure Databricks, BI Industry, Business Analytics, Dimensional Modeling, Microsoft BI Platform, Power BI, Power Query, Self-service BI, SQL Server, Tabular Models

Getting Data Into Shape for Reporting with Power BI

Paul Turley

Even for small, informal BI projects, shaping the data into a dimensional model alleviates complexity, speeds up slow calculations and reduces the data model storage size. I conclude this post by reviewing seven data architectures and the data shaping methods with different degrees of scale.

Microsoft BI Platform, MVP Community, PASS, SQL Saturday, SQL Server

Interviews with Microsoft Data Community Speakers and Leaders

Paul Turley

What is the key to advancing your career in the Microsoft data platform? Here is some advice from some of the most successful people in the industry…
Every year we have some big community events that bring together community leaders from all over. These are international user group and community leaders who write books and speak at conferences. we had our local Oregon SQL Saturday “SQL Train” which is a chartered train – some coaches that one of our speaker’s chartered to bring all of our speakers and attendees up to the PASS summit after Oregon SQL Saturday, and then the big PASS summit (the big conference up in Seattle). I had a chance to sit down with a number of our speakers, community leaders and attendees and just ask questions about what brought them there, and advice that they would give people in the industry about how to get the most value out of that experience …and this is what they said:

BI Projects, Business Analytics, Microsoft BI Platform, Power BI, Power Query, SQL Server

How to Configure the Power BI Gateway to use Dataset Connection Parameters

Paul Turley

A service provider or vendor might want to publish multiple copies of a report that should connect to different database…

BI Industry, BI Projects, Business Analytics, DAX, Microsoft BI Platform, Power BI, Power Query, SQL Server, T-SQL

SQL, M or Dax? – part 2

Paul Turley

This is a post about a post about a post. Thanks to those of you who are entering comments in the original May 12 post titled SQL, M or DAX? This is a popular topic. And thanks to Adam Saxton for mentioning this post in his Guy in A Cube Weekly Roundup.

BI Industry, PASS, SQL Server

Interview with Pinal Dave at PASS Summit 2017

Paul Turley

While attending PASS Summit 2017 in Seattle, I had a chance to catch-up of several friends and industry experts, and…

24 Hours Of PASS, Data Visualization, Excel BI, Microsoft BI Platform, Power BI, SQL Server, SSAS Design, SSRS Administration, SSRS Design

Can’t We Just Get Along? Making SSRS, Power BI and Excel Play Well Together

Paul Turley

Please join me and other 2017 PASS Summit speakers for 24 Hours of PASS: Summit Preview on July 19th and 20th.  24HOP is a series of 60 minute on-line sessions presented back-to-back for 24 hours, from the same professionals who will deliver preconference and main conference sessions during the Summit the first week of November this year.  These online sessions are free of charge and normally attended by thousands of individuals to gain insight and knowledge about the topics.  24 Hours of PASS features free educational webinars delivered over 24 hours. Topics covered in this edition include Performance Tuning, SQL Server 2017, Linux, DevOps, Azure, PowerShell, SSRS, Power BI and much more. Browse all sessions. These webinars provide a sneak peek at some of the best practices, expert tips and demos you’ll find at this year’s PASS Summit in Seattle.

24 Hours Of PASS, MVP Community, PASS, SQL Server, SSRS Administration, SSRS Design

Modern Reporting with SQL Server 2016 and 2017 Reporting Services full day pre-conference session

Paul Turley

Please join me and other 2017 PASS Summit speakers for 24 Hours of PASS: Summit Preview on July 19th and 20th.  24HOP is a series of 60 minute on-line sessions presented back-to-back for 24 hours, from the same professionals who will deliver preconference and main conference sessions during the Summit the first week of November this year.  These online sessions are free of charge and normally attended by thousands of individuals to gain insight and knowledge about the topics.  24 Hours of PASS features free educational webinars delivered over 24 hours. Topics covered in this edition include Performance Tuning, SQL Server 2017, Linux, DevOps, Azure, PowerShell, SSRS, Power BI and much more. Browse all sessions. These webinars provide a sneak peek at some of the best practices, expert tips and demos you’ll find at this year’s PASS Summit in Seattle.

%d