PROGnostications
Welcome to the CTA Blog, featuring how-to’s, tool insights, partner spotlights, and more (including from PROG, our mascot).
Scroll through our latests posts below or search for a topic here:
CTA + Impact Action: Building the District Dashboard
Teaming up to build a powerful data infrastructure to help Impact and their grantees make informed decisions in real-time
March Bracket Madness
We believe everyone should have easy access to their insights for decision-making, program iteration, and strategic planning.
Notes from BenDesk: Copying Tables in BigQuery
What happens when I click “Copy” when viewing a table in BigQuery, and why does that button disappear sometimes?
Hop into the Pond
Making world-class data infrastructure and tooling available, affordable, and easy-to-use for anyone in the progressive space
Organize! Arizona: Case Study
Centralizing real-time data to allow for data-informed decision making.
Notes from BenDesk: Visualizations in PAD
What kind of visualization does PAD offer? What is “Looker Studio” and where did Data Studio go?
Partner Spotlight: Supermajority Membership Report
Creating a holistic view of Supermajority’s members.
Notes from BenDesk: Accessing Stored Data without SQL
Is there an easy way to access stored data for someone who doesn’t know SQL?
Our Open-Source Custom Airbyte Syncs and Custom dbt
Living up to our value of transparency.
Loading Data to BigQuery using Google Workflow
How CTA uses Google Workflows to transfer data into BigQuery from S3 and Google Drive.
Partner Spotlight: Accountable.US American Democracy Scorecard
An interactive guide that holds the country’s biggest corporations accountable for their support for democracy
One Year of Kind Tech
Reflecting on one year of building a different approach to data utility in the progressive ecosystem.