The NFL season is back in full swing. If you’re a sports and data nerd like myself, you’re ready to flex some of your analytical skills to try and beat all your friends in your fantasy leagues. Or you can take a crack at Daily Fantasy, which involves picking players and forming a team based […]
Archives: Advanced Analytics
3’s Get Degrees: March Madness Edition
At a time defined by tears, of both sadness and joy, March Madness reigns supreme as arguably the most intriguing month of the year for sports fans. Here at TCB Analytics, we are no different as not only are we huge sports fans but we take it a step further as data geeks, analyzing the […]
Update Google Sheets via R Automatically
We’ve delivered processed result data to clients in various ways. Sometimes we create a custom Shiny dashboard hosted on Amazon Web Services or shinyapps.io. In simpler cases, it is a flat text file, Excel sheet, or for more complex cases – a hosted database solution with a Tableau implementation sitting on top. Then along came […]
Automate the Updating of Tableau Dashboards using R
Many analysis projects involve data that is not stored in a database or easily accessible directly through Tableau. In some cases, clients have disparate Excel sheets that require cleansing or some amount of manipulation before importing into Tableau. The client may send updated data often, which requires re-running scripts, updating the data manually in Tableau […]
NBA Player Movement Data in R
Everyone’s excited about the newly released NBA player movement data that’s been released – at least I am. I stumbled across this post which shows how to visualize player movement data in Python, but I wanted to figure out how to do the same in R. We’ll use a combination of several R packages including […]