-->
SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

SQL with Dustin Ryan

I've been working in the business intelligence field since 2008 and I've loved every second of it! Whether I'm modelling a data warehouse, overcoming some tricky ETL problems, designing an SSAS cube or Tabular model or coming up with just the right Power BI solution, I'm happy to be doing what I do.

Working as a Business Intelligence Consultant for Pragmatic Works has allowed me to gain a large amount of experience in a very short amount of time. Working with many different clients in industries such as transportation, energy, finance, telecommunications, healthcare and more has allowed me to grow immensely in both professional and personal capacities. I've also worked as an author, contributor, and technical editor on several SQL Server related books.

You can find me speaking at events such as Code Camps, SQL Saturdays, SQL Rally, PASS Summit or on-line webinars. I also blog at SQLDusty.com and www.BIDN.com

Setting Up a Drillthrough Action in your Power BI Report

At some point this weekend, the Microsoft Power BI folks turned on the drill-through feature in the Power BI service. Then the following week, the September release of Power BI Desktop included the new drill-through action feature. This is the same drill-through feature that demonstrated during day 1 of the… Read more

14 comments, 139 reads

Posted in SQL with Dustin Ryan on 3 September 2017

Preparing for Microsoft Certification Exam 70-778: Analyzing and Visualizing Data with Microsoft Power BI

Late last month Microsoft released the certification exam for Power BI, 70-778: Analyzing and Visualizing Data with Microsoft Power BI. The exam is currently in beta and will likely remain that way for the next eight to twelve weeks. If you were lucky enough to snag one of the… Read more

6 comments, 300 reads

Posted in SQL with Dustin Ryan on 23 August 2017

Power BI FAQ Chat Bot 9000 lives!

So I’ve been working on a fun little project over the past couple weeks. A lot of my customers have questions related to Power BI and I spend a lot of my time answering those questions. So I said to myself, “Self, why don’t you build a chat bot that… Read more

6 comments, 228 reads

Posted in SQL with Dustin Ryan on 18 August 2017

Building Your Brand and Becoming a Thought Leader Session Materials

Thank you to everyone that attending my session today at SQL Saturday #649 in Jacksonville, Florida! It was a packed room with over 70 people attending my session and the audience was lively! We had lots of great questions and tons of awesome interaction! If you want to download my… Read more

2 comments, 247 reads

Posted in SQL with Dustin Ryan on 12 August 2017

What-If Analysis in Power BI Desktop

One of the most talked about features previewed during the Microsoft Data Insights Summit in the previous June was the What-If Analysis capabilities. Today, this capability was finally released as part of the August update to Power BI Desktop.

New to Power BI? Start here!

The What If Parameter… Read more

2 comments, 472 reads

Posted in SQL with Dustin Ryan on 11 August 2017

Power BI NFL Football Stats Comparisons and Analysis Report is now available!

For the past few years I’ve combined my love of professional football and analytics by releasing a series of Power BI reports featuring player statistics. This year is no different. This year I’m finally able to release my NFL Football Stats, Comparisons, and Analysis reports featuring the stats for players… Read more

10 comments, 2,219 reads

Posted in SQL with Dustin Ryan on 28 July 2017

Power BI NFL Football Stats Comparisons and Analysis Report is now available!

For the past few years I’ve combined my love of professional football and analytics by releasing a series of Power BI reports featuring player statistics. This year is no different. This year I’m finally able to release my NFL Football Stats, Comparisons, and Analysis reports featuring the stats for players… Read more

2 comments, 32 reads

Posted in SQL with Dustin Ryan on 28 July 2017

How to Automate Processing of Azure Analysis Services Models

I’ve been working on a proof of concept for a customer that involved using Azure Analysis Services as a cache for some data in an Azure Data Warehouse instance. One of the things I’ve been working on is scheduling the automatic processing of the Azure AS database. I did find… Read more

15 comments, 33 reads

Posted in SQL with Dustin Ryan on 21 June 2017

How to Automate Processing of Azure Analysis Services Models

I’ve been working on a proof of concept for a customer that involved using Azure Analysis Services as a cache for some data in an Azure Data Warehouse instance. One of the things I’ve been working on is scheduling the automatic processing of the Azure AS database. I did find… Read more

9 comments, 487 reads

Posted in SQL with Dustin Ryan on 21 June 2017

Microsoft Data Insights Summit Day 2 Recap: Timeline Storyteller, Future of Power BI Desktop, and Freakonomics

The theme of day 2 of the Microsoft Data Insights Summit was sessions, sessions, sessions! There were a ton of different sessions for attendees and for us to watch! In total, there are 75 different videos between the keynotes and the individual sessions posted on the Microsoft Power BI YouTube… Read more

6 comments, 1,441 reads

Posted in SQL with Dustin Ryan on 15 June 2017

Microsoft Data Insights Summit Day 2 Recap: Timeline Storyteller, Future of Power BI Desktop, and Freakonomics

The theme of day 2 of the Microsoft Data Insights Summit was sessions, sessions, sessions! There were a ton of different sessions for attendees and for us to watch! In total, there are 75 different videos between the keynotes and the individual sessions posted on the Microsoft Power BI YouTube… Read more

6 comments, 27 reads

Posted in SQL with Dustin Ryan on 15 June 2017

Microsoft Data Insights Summit Day 1 Recap: Power BI Visio & PowerApps Integration, Custom Drill Through Actions, Book Marks, What If Analysis, & Data Insights

If you were at the Microsoft Data Insights Summit or were watching the live stream of the keynote, then you know that yesterday was a great day for Power BI! There were numerous announcements regarding new features, capabilities, and integrations coming to Power BI (If you missed it, you can… Read more

9 comments, 29 reads

Posted in SQL with Dustin Ryan on 13 June 2017

Microsoft Data Insights Summit Day 1 Recap: Power BI Visio & PowerApps Integration, Custom Drill Through Actions, Book Marks, What If Analysis, & Data Insights

If you were at the Microsoft Data Insights Summit or were watching the live stream of the keynote, then you know that yesterday was a great day for Power BI! There were numerous announcements regarding new features, capabilities, and integrations coming to Power BI (If you missed it, you can… Read more

7 comments, 1,933 reads

Posted in SQL with Dustin Ryan on 13 June 2017

Deploying to Power BI Premium

Obviously the big news of the day is the announcement for general availability of Power BI Premium! And if you were at or you watched the Microsoft Data Insights Summit you saw that announcement. But early last month on May 3rd, Microsoft announced Power BI Premium, which allows you… Read more

1 comments, 235 reads

Posted in SQL with Dustin Ryan on 12 June 2017

Deploying to Power BI Premium

Obviously the big news of the day is the announcement for general availability of Power BI Premium! And if you were at or you watched the Microsoft Data Insights Summit you saw that announcement. But early last month on May 3rd, Microsoft announced Power BI Premium, which allows you… Read more

1 comments, 26 reads

Posted in SQL with Dustin Ryan on 12 June 2017

Setting up Cross Database Queries in Azure SQL Database

A question that I answer what seems like all the time is how to run cross-database queries against Azure SQL Database. So rather than answering those questions repeatedly I figured I should blog my response up so from here on out I can just forward the link to this blog… Read more

10 comments, 56 reads

Posted in SQL with Dustin Ryan on 30 May 2017

Setting up Cross Database Queries in Azure SQL Database

A question that I answer what seems like all the time is how to run cross-database queries against Azure SQL Database. So rather than answering those questions repeatedly I figured I should blog my response up so from here on out I can just forward the link to this blog… Read more

9 comments, 1,222 reads

Posted in SQL with Dustin Ryan on 30 May 2017

What is Power BI Premium?

Yesterday I had the pleasure of delivering a webinar presentation in partnership with Pragmatic Works called “What is Power BI Premium?”.

New to Power BI? Watch this introduction to Power BI Desktop video.

Since Power BI Premium was announced on May 3 there’s been a lot of questions around what… Read more

5 comments, 35 reads

Posted in SQL with Dustin Ryan on 23 May 2017

What is Power BI Premium?

Yesterday I had the pleasure of delivering a webinar presentation in partnership with Pragmatic Works called “What is Power BI Premium?”.

New to Power BI? Watch this introduction to Power BI Desktop video.

Since Power BI Premium was announced on May 3 there’s been a lot of questions around what… Read more

5 comments, 567 reads

Posted in SQL with Dustin Ryan on 23 May 2017

Setting up the Power BI Report Server Preview

Last week on May 17th the Power BI team announced the release of the Power BI Report Server preview. Power BI Report Server includes the ability to host Power BI reports, along with traditional SQL Server Reporting Services content, within the boundaries of your organization’s firewall.

I put together… Read more

7 comments, 2,053 reads

Posted in SQL with Dustin Ryan on 23 May 2017

Older posts