What’s New in Power BI Webinar Recording is Available

Thank you to everyone that attended my webinar with the PASS Excel BI Virtual Chapter today! I’d also like to thank Thomas LeBlanc for having me to present. I had a great time presenting on the newest features of Power BI and what features you will see in the near future. Continue reading What’s New in Power BI Webinar Recording is Available

View Getting Started with Power BI and Time Calculations with Dustin Ryan is Now Available!

Earlier today I had the pleasure of speaking with the PASS Business Intelligence Virtual Chapter on getting started with Power BI and time calculations! There were a bit of audio issues on my end but thankfully we were able to still have a great event with lots of great questions!

If you missed the webinar, have no fear! You can still watch the recording right here. Just jump ahead to minute 11 as I had some unfortunate connection issues!

If you have any additional questions or feedback, please leave a comment down below.

Additional Resources

Download my PowerPoint slide deck here.

The PASS BI VC is a great group with tons of free, quality training events! I highly recommend you connect with this group so you can stay up to date on all their great events!

The PASS BI VC also has all their previous webinar recordings hosted on YouTube so definitely check that out!

If you’re new to Power BI, I suggest you start here.

Read more about Getting Started with R Visuals in Power BI

Read more about 10 DAX Calculations for your Tabular or Power Pivot Model (Part 1)

Read more about 10 DAX Calculations for your Tabular or Power Pivot Model (Part 2)


I hope you enjoyed the webinar and that you maybe even learned a little something. If you have any questions, comments, or feedback, please leave it down below! Thanks for reading and watching!

Power BI Publish to Web for Anonymous Access is Here

Earlier this week on Wednesday the Microsoft Power BI made an incredibly exciting announcement and released Power BI “publish to web” as a preview feature. This is HUUUUGE news! This was probably the top requested feature and its finally here thanks to the hard work and dedication of the Microsoft Power BI team! Continue reading Power BI Publish to Web for Anonymous Access is Here

Microsoft & R Programming Session Materials & Resources Available

Last Thursday night I had the pleasure of speaking with Gregory Kramer and his friends at the Madison, WI Power BI User Group. We took an introductory look at how Microsoft’s acquisition of Revolution Analytics is making serious waves across the Microsoft data platform. We also walked through leveraging R in Power BI and SQL Server 2016.

New to R & Power BI? Start here.

R visuals in Power BI

Continue reading Microsoft & R Programming Session Materials & Resources Available

Sentiment Analysis & Key Phrase Detection w/ Power Query & Power BI

Recently I worked on a neat little POC with Patrick Leblanc for a customer in Education who wished to perform sentiment analysis and key phrase extraction on surveys completed by students regarding classes and instructors, which brings me to this blog post.

Using Azure ML and a free subscription to the Text Analytics API, I’m going to show you how to perform sentiment analysis and key phrase extraction on Continue reading Sentiment Analysis & Key Phrase Detection w/ Power Query & Power BI

Why I Joined Microsoft

new-microsoft-logo-square-largeIf you follow me in social media, you may have seen my announcement that I’ve joined Microsoft. Late in October I resigned my position at Pragmatic Works as a Senior Business Intelligence Consultant and accepted an offer from Microsoft to join their Education Specialty Teams Unit as a Data Platform Solutions Architect. This is such an awesome opportunity and one that I’m so very excited about but I wanted to take a few moments to share my reasons for resigning from Pragmatic Works and joining Microsoft.

This was an incredibly difficult decision that I did not make lightly. I spent over a month thinking, praying, and talking with my wife, Dad, and a few trusted friends about the decision. For the past seven years I’ve loved working, growing, and learning with the wonderful people at Pragmatic Works so I knew any opportunity I would consider would have to be the exact right opportunity. But after all the consideration both my wife and I felt like that this was an opportunity we were led to and that was right for our family at this point and time.

I knew that transitioning from a consultant to a solutions architect position would challenge me and force me to stretch and grow. I felt like that the opportunity at Microsoft would provide me the chance to continue my learning on a different level and this is one of the things that led me to Microsoft.

Also, the information technology field is changing so mind-numbingly fast that its impossible to stay abreast of all the changes, update, and products. Working with Microsoft will provide me the opportunity to learn and work with these new technologies before they’re even released. With Microsoft, I can stay on the bleeding edge of Microsoft’s data platform.

My position at Microsoft also affords me the ability to work from home unless I’m on the road. Time with my family and children is incredibly important to me. Working from home affords me the luxury of eating breakfast, lunch, and dinner with my wife and babies. My kids are growing up and changing so fast and I want to be there for as much of it as possible.

So how will things be changing here at SQLDusty.com? Well, I’m in a brand new role facing an incredible challenge to learn the ins and outs of a bunch of quickly changing technology so you notice that I’m not posting as frequently.

Also, the topics I do post on may increase in variety of topic. Previously I was neck deep in business intelligence (which isn’t a bad thing! BI is awesome!) but now I’ll be working with customers and technologies across the data platform.

I know this is going to be a wonderful journey and learning opportunity and I can’t wait to share what I’m learning with you, my friends and fellow nerds!



Tons of Updates to Power BI in October!

There were so many updates to Power BI this month I thought I’d put all the links to the information on the updates in one place so we can get caught up quickly on everything that changed with the tool this month. Down below you’ll find my commentary on which updates I’m most excited about and links to the Power BI blog to get all the information on all the changes!

New to Power BI? Start here.

The big one here, in my opinion, is the ability to use custom visuals! Not only can you create your own visualizations to meet your organization’s needs, you can download other custom visualizations that have been shared in the Power BI Visuals Gallery. Some of these custom visuals are just awesome. The capabilities of this tool are off the charts (see what I did there?)!

Continue reading Tons of Updates to Power BI in October!

Dustin Ryan is a Data Platform Solutions Architect with Microsoft interested in Power BI, SQL Server, SSAS, & Azure


Get every new post delivered to your Inbox.

Join 216 other followers

%d bloggers like this: