Using Tableau for Scouting

[RebelsScouting]

We have been developing a scouting system for collecting match data on every single robot...We are looking for other teams that are using Tableau for data analysis and visualization...Attached is one of our screen shots showing a trend line for scoring in each match and also lines of averages.

Who else is using Tableau? What other technologies does your scouting system utilize? Thanks!

[Ether]

Originally Posted by RebelsScouting

Who else is using Tableau?

While you're waiting for responses, you might want to try searching.

"Tableau" is a sufficiently unique word; it should make an excellent search key.

[CTbiker105]

Yes, we've been using Tableau for our strategy sessions/pick list meetings for the past 3 years of competition.

Our scouting system as a whole made the switch from paper to electronic in 2014, and Tableau has helped streamline the strategy session process tenfold. Makes presenting data to our strategists and drive team much easier.

[dirtbikerxz]

I just started experimenting with tableau this season. Basically I have an android app that scouters use to collect data. The app uploads all the data to a mysql database server automatically. While I have other functions running from that mysql server, strictly speaking about tableau, I just use a couple of formulas to estimate (automatically) who would be the best pick and rankings.

Just as a side note, another function I have running of the database, is I have a couple of formulas and stuff running in a php script that automatically decide which defenses to pick for each match. This is based of data the scouters collected in the pit scouting, and in the field scouting. Basically picking whichever defenses that the bots on the other alliance can't cross as well.

[AliciaTBay]

Hi All. We've used an app to collect the data and store it on the Cloud, downloaded the data from the Cloud into Excel, then pulled it into Tableau from there. Here are links to a couple of our published dashboards:

https://public.tableau.com/profile/p...ublish-confirm

https://public.tableau.com/profile/p...ublish-confirm

This our first year with this system, have learned a lot this season to apply to next year.

[Ayykorn]

We've been using Tableau for the last 3 years, though I've only picked up how to work the software myself this year.

We had a scouting app last year, but that fell through this year. We've gone back to paper scouting for data collection to our databases.

I create dashboards for our drive team before matches and then use Tableau for alliance selections later. I also create stacked bar charts of the average score for all robots, and print+post those around the venue for people to look at.

https://public.tableau.com...Ellensburg2016/ScoreBreakdownDash

[aphelps231]

Originally Posted by Ayykorn

We've been using Tableau for the last 3 years, though I've only picked up how to work the software myself this year.

We had a scouting app last year, but that fell through this year. We've gone back to paper scouting for data collection to our databases.

I create dashboards for our drive team before matches and then use Tableau for alliance selections later. I also create stacked bar charts of the average score for all robots, and print+post those around the venue for people to look at.

https://public.tableau.com...Ellensburg2016/ScoreBreakdownDash

At the Philomath district a week ago, I got the chance to see some of the inner works of your team's data process, and one of the parts I really liked was that you actually printed out data for each match on paper. This was convenient because we could write on the sheets while creating strategies, as opposed to just being able to look at it on a tablet or laptop. So come eliminations we could circle defenses/write notes for enemy teams, etc.

The cumulative bar charts you have published across the venues is also really cool, although I wonder how much teams are relying on that data rather than their own notes for alliance selection

[droswell]

Originally Posted by RebelsScouting

We have been developing a scouting system for collecting match data on every single robot...We are looking for other teams that are using Tableau for data analysis and visualization...Attached is one of our screen shots showing a trend line for scoring in each match and also lines of averages.

Who else is using Tableau? What other technologies does your scouting system utilize? Thanks!

Wish our scouts would have connected with you guys and gals up at our scouting box in UNH! We had a Google spreadsheet with copious amounts of info - we didn't have much luck using our Google Sheet as a data source into Tableau though, and we had one of our IT mentors trying to connect it up. What do you use to collect the data, if you don't mind me asking?

[dirtbikerxz]

Originally Posted by droswell

Wish our scouts would have connected with you guys and gals up at our scouting box in UNH! We had a Google spreadsheet with copious amounts of info - we didn't have much luck using our Google Sheet as a data source into Tableau though, and we had one of our IT mentors trying to connect it up. What do you use to collect the data, if you don't mind me asking?

A good app that we are using is FRC SCOUTING (google play). Basically it stores all the data to a mysql database. You have to setup the database and host it somehow, but once you jump through the initial hurdles there is so much you can do with it. Strictly speaking about tableau, it can directly interface with any mysql database, and allow you to directly interact with and manipulate the data, easily creating graphs. If you guys would like any help or pointers to go in this direction, I am more than happy to help .

[Sean4488]

Originally Posted by aphelps231

At the Philomath district a week ago, I got the chance to see some of the inner works of your team's data process, and one of the parts I really liked was that you actually printed out data for each match on paper. This was convenient because we could write on the sheets while creating strategies, as opposed to just being able to look at it on a tablet or laptop. So come eliminations we could circle defenses/write notes for enemy teams, etc.

The cumulative bar charts you have published across the venues is also really cool, although I wonder how much teams are relying on that data rather than their own notes for alliance selection

We use a similar method, where we print out a sheet with match specific data before each match, in addition to a strategy sheet. They are really helpful for pre-match strategy, especially during quals. One thing it made really easy was defense selection, I could just look at which defenses they had crossed least or failed most and easily make picks.