Power BI, Twitter and the Old Settlers Music Festival

Learning by Combining Multiple Interests:

Power BI, Social Media, Music and my Daughter

A few weeks ago I discovered the Power BI Solution Template for Twitter Campaign/Brand Management. I’ve played with the template a bunch since then, made some discoveries, dug a little deeper and put it to use on a few occasions. I’ve used it to review tweet patterns about #sqlpass, #mvpbuzz and most recently #osmf2017.  What is #osmf2017? I’m so glad you asked! (proud Mama Bear’s gotta share).

Last weekend my daughter Riley Curnutt (please go like her Facebook page) was one of the top 10 finalists in the Youth Competition at the Old Settler’s Music Festival in Driftwood, TX. The Festival is held adjacent to the world famous Salt Lick BBQ (which Bobby Flay says is “the best BBQ beef ribs he ever ate“). This year the lineup was fantastic and included some of my personal favorites: The Old 97s, Los Lobos, Sarah Jarosz, Gaelic Storm and many others. Riley competed as a singer/songwriter against 9 other young musicians (all under 18) and ended up taking 3rd place. Did I mention she’s only 13? I was really beside myself. Here is a video of her performance:

Anyway, when I was trying to come up with something fun to use as a hashtag to visualize using Power BI the thought crossed my mind to use the hashtag from the Festival, which was #osmf2017. So…that’s what I did. My daughter rolled her eyes when I told her I did this analysis – “Mom, your such a Nerd”.  Hopefully those of you who are fellow-nerds will find this stuff of interest! Let me go through the process step-by-step with you, (it’s not difficult), because I found there are several places that you can get mucked up and where things are a bit vague.

In order to make this work you will need Power BI Desktop, an Azure SQL Database and a Twitter account.

Read more Power BI, Twitter and the Old Settlers Music Festival