Set up your SchoolBI Account – Part 1
In this video, learn how to create and set up your SchoolBi account, the first step to improving your school’s data democratization. Hi. My name is Ryan Bowse with School BI. This short video explains how to actually set up your School BI account and how to configure it for the first time. It’s about […]
2023 Dec – Data Warehouse 101 Webinar
In the “Data Warehouse 101” webinar presented by SchoolBI, Ryan Bowse, founder and CEO, introduced the concept of data warehouses, highlighting their importance in organizing and analyzing data for schools. He explained how data warehouses consolidate data from various sources, using processes like Extract, Transform, and Load (ETL) to make data accessible and actionable for […]
Looker Studio – Tips and Tricks on custom sort order
Learn how to create custom sort orders in Looker Studio using the regx_match function and how to overcome Looker Studio’s limitations by creating a calculated field that assigns custom values to sort data in a specific order. This is particularly useful for non-numerical or non-alphabetical data like grade levels. Hi, everyone. Ryan Bowse from SchoolBI […]
Looker Studio – Tricks on how to use the CASE formula
This video explains the use of case statements in Looker Studio, highlighting their ability to transform data dynamically within reports. Hey, everyone. Ryan Bowse from SchoolBI here. Today’s tips and tricks, we’re gonna be looking at looker case statements. We’ve graded this about a three out of five stars in the data artist level, meaning […]
Looker Studio – Tricks on how to use the REPLACE formula
Learn how to replace the formula in Looker Studio, which simplifies the process of abbreviating or altering long labels in graphs and charts. This video demonstrates creating a new field to replace lengthy city names with shorter versions, making reports and dashboards cleaner and more readable. Hey, everyone. Ryan Bowse from SchoolBI here. With today’s […]
Looker Studio – Tricks on how to connect a control to a single graph
This video demonstrates how to connect a data control to a specific graph in Looker Studio, allowing users to filter data for individual visualizations. By grouping the control with the desired graph, this technique ensures that only the selected graph responds to changes, simplifying dashboard interactions. Hey, everyone. Ryan Bowse from SchoolBI here. I’d like […]
AWS Accelerator – Product Demo
In this demo, Ryan Bowse from School BI demonstrates how to integrate Google Sheets with School BI and then connect it to Looker Studio to create a dashboard using enrollment data. He covers the process of data ingestion, configuration, and visualization, emphasizing the ease of connecting various data sources and transforming them into insightful reports. […]
AWS Accelerator – Team Overview
Ryan Bowse, founder of SchoolBI, introduces his small but dynamic team, focused on creating an advanced data analytics platform tailored for schools. The team is committed to educational technology through their successful past in the industry, and their current use of AWS infrastructure through the AWS Accelerator program for further growth and collaboration. Hi, AWS […]
Connecting SchoolBI to Looker Studio
In part two of the series, learn how to connect SchoolBI to Looker Studio. The process involves generating and copying a key from SchoolBI, using it in Looker Studio to add SchoolBI as a data source, and then customizing the dashboard with various data visualization options. It’s Kya again, and I am here to do […]
Connecting a Google Sheet to SchoolBI
In a two part series, this video guide explains how to connect Google Sheets to School BI and then to Looker Studio. The process involves configuring a custom file in School BI, sharing the Google Sheet via a provided email, uploading the data, and verifying the data before finalizing the connection. Hey. My name is […]
by SchoolBI