Our team has used Tableau in the past, but only locally. It seems that the Tableau plan that comes in the Virtual Kit of Parts does not allow privately hosted visualizations, only public.
Has anyone else experimented with a web hosted dashboard/data visualization tool that allows the dashboard to be privately shared, or use any cool data analytics tools at events in general?
We have historically used a OneDrive-hosted Excel file, but it’s a bit clunky and I definitely wouldn’t call it a smooth process. We also share scouting with other teams and because all of our data is saved only in Excel, the sharing is a bit awkward. We would like to share the same data source but each have our own viewer/space to make dashboards, pick lists, etc. I’d like to move towards hosting the raw data in a database that can be connected directly to a web interface that does the data analysis portion.
Everyone talks about the data collection side, but I’d love to hear all about your data analysis plans!
I’m not certain exactly what your privacy requirements are, but 6672 has found success in data visualization with ggplot in R, using shinyapps to manage and display the data. ShinyApps can be web hosted, but we use a single centralized tablet and transfer data by QR code to accommodate arena restrictions. I suspect you’d find the visualization framework behind ggplot familiar if you use Tableau - Leland Wilkinson wrote a very influential book The Grammar of Graphics that deeply influenced the design of ggplot.
I’ll tag @BoRocks813, the student who was primarily in charge of our Shiny App development, in case you have any questions.
Iv been looking into getting batter data viz for my team aswell because last years scouting keeps we where just starting at color coded cells with numbers wich is awful and hard to understand most of the time, looking into tabluea but it’s hard to learn at first, messing with Google sheets charts a little bit because that’s where we store our data, but i think I will be using a combo of the 2 previously mentioned until I find something better, using tabluea public to publish the data.
Combining Tableau and Google Sheets charts sounds like a smart approach, especially if you’re still learning. As you explore, you might find more options and tools that suit your team’s needs. And if you’re interested in data-related tips and resources, check out https://www.nannostomus.com/. It could be a helpful addition to your data journey!
If you store your data on O365, have you tried PowerBI?
Our team just uses Google Sheets with AppScripts (to pull TBA data behind the scenes) to visualize data.
Hopefully the ScoutingPalooza group would be willing to share some of the submissions they receive, as I think it’s fruitful for the whole community.
1710 does visualization within their application and use a mysql backend. @CoreyBrown can explain in more details.
1710 actually switched from using SQL to mongo last year. That switch also came with a whole new setup. We ended up visualizing data using Google sheets apis to pull from bluealliance as well as our own mongo db. This year I think we are trying to include visualization into the scouting app again.