Role of ETL in Private School Data Strategy
What is ETL and Why It’s Important for Private Schools In today’s digital age, private schools are collecting more data than ever before. From student engagement and outcomes to the impact of extracurricular activities, the amount of information can be overwhelming. To make sense of this data and use it effectively, private schools need a […]
Data Lake vs. Data Warehouse: Which is Right for Your School?
Data Lake vs. Data Warehouse Private schools looking to leverage data for better decision-making and operational efficiency will benefit from understanding the differences between data lake and data warehouse strategies. Why it matters: For private schools, choosing the right data storage solution—between a data lake’s flexibility and a data warehouse’s structured environment—is a major key […]
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 […]
SchoolBI Selected To Participate In Global AWS Education Accelerator
SchoolBI expands its use of Amazon Web Services (AWS) solutions to bring the next evolution in reporting to schools San Francisco, CA (January 9, 2024) – SchoolBI today announced it has been selected to participate in the global AWS Education Accelerator, a 10-week immersive experience for global EdTech startups that want to accelerate their go-to-market […]
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. […]
by SchoolBI