Alexander Street - a ProQuest Company is the world’s leading provider of academic streaming media (primarily video & audio) to libraries with over 1.2 million titles. Alexander Street has thousands of customers who manage their subscriptions through an online portal.
Alexander Street wants to help their librarian customers better understand how the students and researchers engage with the content. That way, customers would better engage their constituents with the Alexander Street online portal and make informed decisions on buying the most appropriate content set for them.
They decided to provide usage analytics through their online portal to each of their customers in a useful and enjoyable way.
Data volumes: the usage analytics portal needs to process millions of page views per month on thousands of video titles and over 5 years of historical data
Security: users log in via single sign-on with the online portal
Data restrictions: each customer must only see their own data or the data of their children accounts
User experience: custom UX was required to match the visual design created by Alexander Street
Metrics: custom, sophisticated metrics like Engagement must be computed on the fly
Interactive: users must be able to filter, drill down, pivot and search
The project had a tight timeframe to be rolled-out, including testing and validation. It was therefore critical for all of the tasks and technologies to connect seamlessly in an agile process.
All Alexander Street usage data needed to build the dashboards is already loaded and available from a Redshift database, so they just had to plug Bouquet to start producing analysis.
see what database are supported out of the box
The biggest challenge is to tie raw data in the database to the front-end charts. This is solved by Bouquet Bookmarks. Each chart had a corresponding Bookmark, which provided the API endpoints to retrieve the data from the big data Redshift repository. The Bookmark API then provide flexibility to filter, pivot and drill-down to support interactive queries from the application.
See Bouquet Demo
try Bouquet Bookmark API
The project required several usage metrics: playbacks displayed, playback types, items embedded, cited, shared, by browsers, devices, operating systems used and other details about how users have accessed the content online.
These metrics were implemented in Bouquet by creating common dictionary and bookmarks, using Open Bouquet collaborative UI. The overall creation of Bookmarks took one day of the business analyst.
The front-end developer then mapped the Bookmarks to each chart created using HighCharts. User of the analytics app can change parameters from the UI like date ranges and types of data. The charts are interactive when users change the filters.
“It was easy for me to take the API endpoints and adapt the JSON to Highcharts, and then invite the team to collaborate.”
The analytics app is now live and used by hundreds of accounts. Each one has multiple end users and can access only the data they are entitled to see. By combining the usability of HighCharts with the power of Bouquet, Alexander Street was able to build a sophisticated customer-facing portal to drive engagement and deliver value to each end customer in no time!
This example demonstrates how simple is to query data in a secure and simple way from remote database and display results using HighCharts library. Find more examples on the demo page.