SQL with Dustin Ryan

Power BI Incremental Refresh with Web API Data Source

• by Dustin-Ryan

• SQL with Dustin Ryan

It’s been a while since I typed up a blog post but life, even in the midst of a pandemic, has been busy and crazy. As you can imagine,...

2020-06-02 (first published: 2020-05-20)

653 reads

Welcome to Azure Synapse at SQL Saturday Tampa 2020

• by Dustin-Ryan

• SQL with Dustin Ryan

SQL Saturday Tampa is coming up again in a couple of weeks on February 29th and I’m excited to announce that I’ll be there and presenting my session Welcome...

2020-02-12

11 reads

Dynamic Column Level Security with Power BI and SSAS

• by Dustin-Ryan

• SQL with Dustin Ryan

Last week I was asked to tackle a requirement by a customer adopting Analysis Services to enable data exploration and ad hoc analysis by their users. One of their...

2019-10-15 (first published: 2019-10-09)

765 reads

See You at SQL Saturday South Florida on Saturday June 8th!

• by Dustin-Ryan

• SQL with Dustin Ryan

SQL Saturday South Florida is on Saturday June 8th and its just around the corner! The event is hosted at the Nova Southeastern University campus in Davie, Florida near...

2019-05-31

10 reads

Visualizing NFL Draft History with Power BI

• by Dustin-Ryan

• SQL with Dustin Ryan

With the 2019 NFL Draft upon us, of course I wanted to visualize some NFL draft data in Power BI. So I put together this interesting set of visualizations...

2019-05-07 (first published: 2019-04-26)

1,555 reads

Power BI Governance 101 at SQL Saturday 820 in Jacksonville, Florida on May 4

• by Dustin-Ryan

• SQL with Dustin Ryan

Coming up in just a couple of weeks, I’ll be presenting my session, Power BI Governance 101, at SQL Saturday #820 in Jacksonville, Florida on May 4th. The event...

2019-04-22

15 reads

Data Warehouse Design and Power BI at SQL Saturday Tampa 2019

• by Dustin-Ryan

• SQL with Dustin Ryan

Hello, fellow data nerds! I wanted to make you aware of a fantastic event coming up this month in Tampa,...

2019-03-11

549 reads

Power BI Architecture Diagram v4 is now available!

• by Dustin-Ryan

• SQL with Dustin Ryan

I’ve finally updated my Power BI Architecture Diagram to include some of the new features that are now available and...

2019-02-16

558 reads

Calculating Quartiles with DAX and Power BI

• by Dustin-Ryan

• SQL with Dustin Ryan

Like many of my blog posts, this post is inspired by some work I was doing with a customer who...

2018-09-18 (first published: 2018-08-31)

2,514 reads

NFL Football Player Stats & Analysis 2018 is now available!

• by Dustin-Ryan

• SQL with Dustin Ryan

I’ve had a lot of people ask me for this over the past few months and its finally (mostly) ready!...

2018-09-03 (first published: 2018-08-21)

2,422 reads