2017 Year in Review for SQLDusty.com

2017 was an awesome year for SQLDusty.com! Thank you to all of the readers and visitors that stopped by to leave a comment or share a blog post on social media. I appreciate all of you! But I also thought I’d share some interesting stats from the previous year:

  • 18 new blog posts
  • 261,586 views
  • 140,122 visitors
  • 15,132 words written
  • 841 average words per posts
  • 131 total comments
  • Tuesday 9 am is the most popular day and hour
  • Top 5 visiting countries are United States, India, United Kingdom, Canada, Australia

Here are the top 3 blog posts written in 2017 by number of views:

  1. Preparing for Microsoft Certification Exam 70-778: Analyzing and Visualizing Data with Microsoft Power BI
  2. Setting up a Drillthrough Action in your Power BI Report
  3. Power BI Architecture Diagram v3 is Now Available!

And here are the top 10 blog posts by view in 2017:

  1. 10 DAX Calculations for your Tabular or Power Pivot Model (Part 1)
  2. Preparing for Microsoft Certification Exam 70-778: Analyzing and Visualizing Data with Microsoft Power BI
  3. 10 SQL Server Data Warehouse Design Best Practices to Follow (Part 1)
  4. Ten MDX Calculations for your Cube
  5. 10 DAX Calculations for your Tabular or Power Pivot Model (Part 2)
  6. Upgrade 2005/2008 SSIS Packages to 2012 Like a Boss!
  7. Setting Up a Drillthrough Action in your Power BI Report
  8. SSRS 2008 R2 LookUp and LookUpSet Functions
  9. Power BI Architecture Diagram v3 is Now Available!
  10. My Top Four Books for the MS Business Intelligence Professional

Again, thank you to everyone that stopped by in 2017! Here’s to another great year of learning new things, making new friends, and lots of new blog posts!

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 Microsoft Data Insights Summit, which you can read about here. So I thought it’d be good to quickly walk through how you can set up the drill through action. Continue reading Setting Up a Drillthrough Action in your Power BI Report

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 can help field some of those basic questions?” Thus was gloriously born the Power BI FAQ Chat Bot 9000!

The Power BI FAQ Chat Bot 9000 uses Azure Bot Service leveraging a knowledge base created using QnA Maker. Later I’m going to do a write-up on how exactly I created the Power BI FAQ Chat Bot 9000 (it only took me about 10 minutes), but for now I just want to share the bot with you. Start with “Hello” and then try Continue reading Power BI FAQ Chat Bot 9000 lives!

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 slide deck from today’s presentation you can do that right below. Continue reading Building Your Brand and Becoming a Thought Leader Session Materials

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 at the quarterback, runningback, wide receiver, tightend, and kicker positions. Unlike previous years, this years reports are based on data from NFL.com. My goal for producing this report is, as nerdy as this is, to give me a leg up on my fantasy football drafts. If you’ve ever played fantasy football, you know the key to winning is having the deepest roster and I hope that these reports will allow me to identify middle and late round talent using the collected data in a readable and navigable format.

I think this is probably my best version of the NFL stats report that I’ve released yet, and there’s a few reasons why I think so. First, I included Continue reading Power BI NFL Football Stats Comparisons and Analysis Report is now available!

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 documentation on the process, but the screenshots of the Azure portal are out of date and I did find some errors in the instructions. I also found this very extensive project for partition management in Azure AS, but this was a little overkill for my purposes and I was just interested in the very basics.

Read my recap for MS Data Summit here

These previously mentioned resources led me to write this blog post. In this post I’m going to leverage the previously mentioned article and walk through creating an Azure Function App to automatically refresh my Azure Analysis Services model, while correcting a few errors and updating the screenshots.

If you’re new to Azure Analysis Services, take a look at this documentation. For the purposes of this post, I’m going to assume you have a basic understanding of Analysis Services.

Continue reading How to Automate Processing of Azure Analysis Services Models

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 channel that you can go back and watch anytime, which is pretty amazing!

Read my Microsoft Data Insights Summit Day 1 Recap here!

Obviously I haven’t watched all 75 different videos, but I did watch a few so I’ve included some of the things I learned, announcements on new features, links to some of the especially interesting sessions, and my notes from a couple of those sessions below. Continue reading Microsoft Data Insights Summit Day 2 Recap: Timeline Storyteller, Future of Power BI Desktop, and Freakonomics

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

%d bloggers like this: