Foothold DataStudio is a cloud-based data warehouse tool, powered by Snowflake, and designed to enable and support business intelligence (BI) activities, especially analytics. DataStudio utilizes Snowflake's best-in-class technology coupled with special data management techniques guided by Foothold's in-house data experts. The result is a tool that transforms relational datasets in AWARDS into highly efficient analytics datasets that execute quickly, with capabilities that scale to meet your needs. Simply put, DataStudio helps organizations get the most value out of the data they are diligently collecting.
DataStudio Options
There are two DataStudio options available:
-
DataStudio Query - provides access to curated data models hosted by Foothold's Snowflake data warehouse. Using a connector, you can send data to a tool of your choice, or write queries directly in Snowflake. This offering is ideal for organizations that have familiarity with business intelligence (BI) and analytics, and want to send data to a warehouse or tool of their choice.
-
DataStudio Share - also provides access to curated data models, but you must have your own Snowflake data warehouse. This offering gives you the flexibility to transform and transport tables to meet your data needs.
Understanding the Capabilities of Your Data
Discussions around data management tools and analytics capabilities can be daunting. We've created some resources to help you understand the basic concepts of how taking your data collection a step further can not only help your agency better understand the trends in the populations you serve, but can help you identify gaps in care, evaluate your programs, and advocate for funding.
Getting Started
While DataStudio is a self-service tool, we are happy to help your organization get started. Should you find any issues with the data in DataStudio as you learn and use the tool, please let us know by contacting the Foothold Help Desk. We stand behind our product and are here to support you. Below are links to common start-up questions:
Other Helpful Resources
We understand that DataStudio requires some advanced skills, including SQL, in order to get the most out of it. Below are a few resources that you may find helpful if you're interested in learning more about SQL, Snowflake, or other data management techniques. If you're looking for a full-stack visualization solution for your AWARDS data, we suggest looking at AWARDS InSights, which is powered by the same Snowflake data warehouse as DataStudio.
Frequently Asked Questions
- I forgot my password and I cannot reset it through Snowflake.
Please contact the Foothold Help Desk.
- I am receiving an error message when attempting to run a valid query.
Please contact the Foothold Help Desk. Be sure to provide the query and the error message.
Service Agreement
DataStudio is an optional add-on service available for subscription. If you are interested in learning more about the DataStudio service and/or you would like to proceed with signing up for it, please download and complete the Service Agreement below. When you're ready, submit it to your Foothold Customer Experience representative.