Empowering Educators with Embedded Dashboards
Empowering Educators with Embedded Dashboards
Freckle empowers more than 550,000 teachers to reach every one of their students at the level that's best for them. As students practice math, english, social studies, science and more via exercises on the Freckle app, they create a ton of data that can then be used via “adaptive practice” to adjust what the students should study next based on the level of their inputs to the system.
That data becomes incredibly valuable for teachers looking to adjust their lessons, and for district administrators to understand how their teachers are performing and assess school readiness for state tests. Internally, Freckle’s product team learns from data to guide future lessons and product development, while its sales team uses data to educate customers on how Freckle fits best for them.
Customer Since: 2017
- Problem: With data at the center of the decision-making process for many aspects of Freckle, they needed an all-in-one analytics solution that could serve the internal needs of their sales and product teams, while also enabling external sharing of dashboards with administrators and teachers.
- Action: Freckle’s data team evaluated solutions and identified Periscope Data as an end-to-end platform that would help them advance their level of data maturity.
- Solution: Today, Periscope Data helps Freckle democratize data across the company and provides embedded dashboards to district administrators via the Embed API.
“Nobody else had that all-in-one solution we were looking for. So once we got through our evaluation, Periscope Data was really the only option we really considered, and it’s been a great fit as we got it quickly up and running across our business and with our customers.”
In the early stages of growth for Freckle (formerly Front Row Education), the process for accessing data internally was overly challenging and complex for its data team.
“We had our business operations people running these super complex SQL queries and then they had to connect to our data center through a VPN to run those directly on our production database,” said Alex Kurilin, CTO at Freckle. “As one of the people responsible for the database, that did not help me sleep well at night. We were just hoping not to nuke anything in the process. ”
Kurilin and his team began looking for a data analytics solution in 2017, hoping to identify a platform that would address their complete data workflow. To that point, they hadn’t reached a level of data engineering maturity where they could justify ETLing data to a Snowflake or Redshift instance and using a separate tool to read and consume data. And with Kurilin as the primary engineer responsible for the analytics workflow, they didn’t have the manpower to invest in a complicated set of solutions.
“Our team was certainly afraid of dedicating too much time getting an analytics platform up and running, because they thought it’d be an endless rabbit hole of engineering time, with several full-time engineers to get it done,” said Kurilin. “But with Periscope Data, it essentially took one person to integrate it here, and it worked really fast and we saw results right away, which was very compelling to the team.”
The Freckle team evaluated multiple analytics tools but said Periscope Data stood out as the best fit given its simplicity. Several members of the engineering team were already familiar with or proficient in SQL, which made using Periscope Data’s SQL-based editor easy to pick up quickly.
“Nobody else had that all-in-one solution we were looking for,” said Kurilin. “So once we got through our evaluation, Periscope Data was really the only option we really considered, and it’s been a great fit as we got it quickly up and running across our business and with our customers.”
Aiding Sales with Usage Data
Today, Periscope Data is very tightly integrated into Freckle’s daily workflow across the company. Account executives on its sales team use Periscope Data when reaching out to school and district administrators and communicate ways that Freckle could be a good fit to accomplish their educational goals.
“One of the first things they do is visualize utilization of Freckle within the schools, to point out groups of teachers who are using it very actively and show students completing thousands of activities and sessions each week,” said Kurilin. “It allows them to clearly illustrate the growth that students show when using our product, and makes it much easier to explain the value they’d get from getting premium subscriptions or working more regularly with us. Periscope Data is an essential part of that sales process and helps us drive more revenue in our deals.”
Periscope Data is also used internally by account managers to ensure existing customers are using Freckle to its full potential. Those teams will examine real-time data in Periscope to see which students are engaging with the Freckle platform, and make suggestions about which teachers or schools could be engaging more actively. That has provided a big boost to account teams looking to display the value of Freckle and fueled more curiosity for data insights.
“Since we rolled out Periscope Data dashboards, it’s been one of the most consistent areas of the product that we get feedback on from our salespeople and account teams as they try to come up with new ways to iterate and drill-down on the data,” said Corey Johns, senior software engineer at Freckle. “With many other aspects of our product we only get a slow trickle of feedback, but Periscope Data embeds have very consistently inspired our team to think about new ways they can use our data dashboards to better sell to people.”
Embedded Dashboards Empowering Administrators
As district administrators began to see the value in these insights, there was an increasing thirst among them to access data more directly — as a result, Freckle took advantage of Periscope Data’s embedded dashboards and the Embed API to provide direct data access to schools.
“It was initially a very manual process for the salespeople to show off our dashboards during their calls,” said Johns. “So we started looking at ways to expose data in the most useful way to the administrators, and we landed on Periscope Data Embed API as a perfect fit. It straightforwardly allows our administrators to see those insights without having us walk them through it.”
With embedded dashboards enabled, school administrators now have real-time analytics at their fingertips to follow the growth of their students and schools, directly within Freckle’s product. They can drill down to get a sense of which parts of the product teachers and students are using most and better understand the full value of Freckle’s product suite.
“Periscope Data embedded dashboards give administrators a very powerful way to consistently validate that our product is working for them,” said Johns. “All the big questions they need to answer — Are they getting their money’s worth with Freckle? Are teachers using it? Is it helping students improve? And are they improving in specific academic subjects we are mandated to train them on? — all of that is revealed within Periscope Data.”
As more schools adopt technology like Freckle, there’s an increasing expectation that administrators become more technical and build a data-driven culture to properly understand the value of these tools. Most of these school leaders don’t come from a hyper-technical background, but Johns says the Periscope Data interface is intuitive enough to enable answering all their questions.
“Many of these schools were already familiar with existing dashboards we had created and exposed to them, and the Periscope Data embeds make it so that experience isn’t any different for them,” said Johns. “At the end of the day, they are primarily looking to consume the data, and we’re not getting any sort of feedback that it is excessively complicated, which I think confirms that embedded dashboards with Periscope Data have been the right way to share data with them.”
In the future, the Freckle team hopes to expand the power of their data even further by exposing Periscope Data dashboards directly to teachers.
“Periscope Data embedded dashboards give administrators a very powerful way to consistently validate that our product is working for them. All the big questions they need to answer — Are they getting their money’s worth with Freckle? Are teachers using it? Is it helping students improve? And are they improving in specific academic subjects we are mandated to train them on? — all of that is revealed within Periscope Data.”
From a technical perspective, Kurilin says working with Periscope Data has really helped Freckle improve its level of sophistication with data. They recently enhanced their workflow by using Periscope Data’s Git Integration to get externalized version control on all their dashboards.
“We’ve always been looking for ways to get better versioning of our dashboards and charts, so Periscope Data adding the Git integration was something we really needed,” said Kurilin. “We’re looking to leverage that as much as possible moving forward as the integration extends.”
They are also becoming more sophisticated by using a dedicated warehouse through Periscope Data, which allows them to more freely ETL data from all their other data sources without investing in separate warehouse integrations. That’s a significant step up from their previous process of data siloes that were hard to join together.
“The fact that Periscope Data has Salesforce ETL available by default among the standard options is fantastic because that allows us to integrate our sales data silo really easily with the rest of our product data,” said Kurilin. “We didn’t have to go for an external ETL provider among the billions available out there — it’s so great to have that available straight out of the box.”
In some senses, the increased access to data has eased the load on the data team, as they don’t have to invest time re-creating reports to answer basic questions and can get to key data insights much faster. However, Kurilin says he’s still keeping plenty busy as administrators dig deeper and explore questions they never previously thought to pursue.
“Once they got their hands on Periscope Data, we consistently had requests for more dashboards with different stats,” said Kurilin. “They’ll say ‘Okay, that was great, can we have one for this school or this category?’ Or they’ll want more insight on exporting and importing data from other tools. They really understand the product and it’s definitely been very popular with our administrators.”