Business Intelligence Blogs

View blogs by industry experts on topics such as SSAS, SSIS, SSRS, Power BI, Performance Tuning, Azure, Big Data and much more! You can also sign up to post your own business intelligence blog.

21 June
2017
Author: DustinRyan
DustinRyan

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 the following...
15 June
2017
Author: DustinRyan
DustinRyan

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...
13 June
2017
Author: DustinRyan
DustinRyan

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...
12 June
2017
Author: DustinRyan
DustinRyan

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 purchase...
30 May
2017
Author: DustinRyan
DustinRyan

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 on to my customers and...
23 May
2017
Author: DustinRyan
DustinRyan

What is Power BI Premium?

What is Power BI Premium? " data-medium-file="https://sqldusty.files.wordpress.com/2017/05/title-slide1.png?w=680&h=384?w=300" data-large-file="https://sqldusty.files.wordpress.com/2017/05/title-slide1.png?w=680&h=384?w=474" class="alignnone wp-image-2714"...
23 May
2017
Author: DustinRyan
DustinRyan

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...
19 May
2017
Author: DustinRyan
DustinRyan

Power BI Architecture Diagram v3 is Now Available!

Over the past couple weeks there has been a ton of news and announcements around the direction Microsoft is taking Power BI. Between Power BI Premium and Power BI Report Server, my head has been spinning trying to stay educated on all the new changes and enhancements. With all these...
10 April
2017
Author: DustinRyan
DustinRyan

Microsoft Business Intelligence Materials from Discussion at Jacksonville University

Today I had the wonderful pleasure for leading a discussion regarding the products, services, and tools Microsoft provides in the business intelligence stack. I met with Jacksonville University students and faculty and also had the pleasure of speaking with members of local businesses that are...
30 January
2017
Author: DustinRyan
DustinRyan

Another 5 Power BI Tips

If you’ve been at least paying attention to my blog a little bit, you’ve probably noticed I occasionally blog about Power BI. Part of the reason I blog so often about Power BI is because that’s the topic of a whole bunch of conversations I’m having with my customers. The other reason is that the...