HomeBig DataCalifornia State College Chancellor’s Workplace reduces value and improves effectivity utilizing Amazon...

California State College Chancellor’s Workplace reduces value and improves effectivity utilizing Amazon QuickSight for streamlined HR reporting in increased schooling

The California State College Chancellor’s Workplace (CSUCO) sits on the heart of America’s most important and various 4-year universities. The California State College (CSU) serves roughly 477,000 college students and employs greater than 55,000 workers and college members throughout 23 universities and seven off-campus facilities. The CSU gives college students with alternatives to develop intellectually and personally, and to contribute again to the communities all through California. For this massive group, managing a large system of campuses whereas sustaining the decentralized autonomy of every is essential. In 2019, they wanted a extremely safe device to streamline the method of pulling HR knowledge. The CSU had been utilizing a legacy central knowledge warehouse based mostly on knowledge from their monetary system, however it lacked the robustness to maintain up with fashionable know-how. This wasn’t going to work for his or her HR reporting wants.

On the lookout for a device to match the cloud-based infrastructure of their different operations, the Enterprise Intelligence and Information Operations (BI/DO) workforce inside the Chancellor’s Workplace selected Amazon QuickSight, a quick, easy-to-use, cloud-powered enterprise analytics service that makes it straightforward for all workers inside a company to construct visualizations, carry out advert hoc evaluation, and rapidly get enterprise insights from their knowledge, any time, on any machine. The workforce makes use of QuickSight to arrange HR info throughout the CSU, implementing a centralized safety system.

“It’s straightforward to make use of, very easy, and comparatively intuitive. While you couple the expertise of utilizing QuickSight, with an enormous value distinction to [the BI platform we had been using], to me, it’s a easy selection,”

– Andy Sydnor, Director Enterprise Intelligence and Information Operations on the CSUCO.

With QuickSight, the workforce has the potential to harness safety measures and ship knowledge insights effectively throughout their campuses.

On this put up, we share how the CSUCO makes use of QuickSight to scale back value and enhance effectivity of their HR reporting.

Delivering BI insights throughout the CSU’s 23 universities

The CSUCO serves the college system’s school, college students, and workers by overseeing operations in a number of areas, together with finance, HR, scholar info, and area and amenities. Since migrating to QuickSight in 2019, the workforce has constructed dashboards to assist these operations. Dashboards embrace COVID-related leaves of absence, historic monetary reviews, and worker coaching knowledge, together with a big number of dashboards to trace worker knowledge at a person campus stage or from a system-wide perspective.

The workforce created a course of for studying safety roles from the ERP system after which translating them utilizing QuickSight teams for inner HR reporting. QuickSight allowed them to match safety measures with the advantages of low upkeep and familiarity to their end-users.

With QuickSight, the CSUCO is ready to run a decentralized safety course of the place campus safety groups can provision entry immediately and customers can get to their knowledge sooner. Earlier than transitioning to QuickSight, the BI/DO workforce spent hours attempting to get to particular individual-level knowledge, however with QuickSight, the retrieval time was shortened to only minutes. For the primary time, Sydnor and his workforce had been capable of pinpoint a selected worker’s work historical past with out having to take extra actions to search out the precise knowledge they wanted.

Value financial savings in comparison with different BI instruments

Sydnor shares that, for a public group, one of the engaging qualities of QuickSight is the immense value financial savings. The BI/DO workforce on the Chancellor’s Workplace estimates that they’re saving roughly 40% on prices since switching from their earlier BI platform, which is a big profit for a public group of this scale. Their earlier BI device was costing them intensive quantities of cash on licensing for options they didn’t require; the CSUCO felt they weren’t getting the very best use of their funding.

The performance of QuickSight to satisfy their reporting wants at an inexpensive worth level is what makes QuickSight the CSUCO’s most well-liked BI reporting device. Sydnor likes that with QuickSight, “we don’t need to exit and purchase a subscription or a license for anyone, we will simply provision entry. It’s a lot simpler to distribute the product.” QuickSight permits the CSUCO to focus their price range in different areas somewhat than having to pay for prices by rare customers.

Easy and intuitive interface

Getting began in QuickSight was a no brainer for Sydnor and his workforce. As a public group, the procurement course of could be cumbersome, thereby slowing down useful time for placing their knowledge to motion. As an present AWS buyer, the CSUCO might seamlessly combine QuickSight into their package deal of AWS companies. A difficulty they had been working into with different BI instruments was encountering roadblocks to organising the system, which wasn’t a problem with QuickSight, as a result of it’s a completely managed service that doesn’t require deploying any servers.

The next screenshot reveals an instance of the CSUCO safety audit dashboard.

example of the CSUCO security audit dashboard.

Sydnor tells us, “Our earlier BI device had an enormous library of visualization, however we don’t want 95% of these. Our displays look nice with the breadth of visuals QuickSight gives. Most individuals simply need the info and finally, want a sturdy car to get knowledge out of a database and onto a desk or visualization.”

Changing from their unique BI device to QuickSight was painless for his workforce. Sydnor tells us that he has “but to see one thing we will’t do with QuickSight.” One in all Sydnor’s workers who was a consumer of the earlier device discovered QuickSight in simply half-hour. Now, they conduct QuickSight demos on a regular basis.

Trying to the long run: Increasing BI integration and adopting Amazon QuickSight Q

With QuickSight, the Chancellor’s Workplace goals to roll out extra HR dashboards throughout its campuses and lengthen the device for school use within the classroom. Within the upcoming 12 months, two campuses are becoming a member of CSUCO in constructing their very own HR reporting dashboards by means of QuickSight. The group can be planning to make use of QuickSight to report on scholar knowledge and implement external-facing dashboards. A number of the knowledge factors they’re excited to discover are insights into at-risk college students and classroom scheduling on campus.

Pondering forward, CSUCO is contemplating Amazon QuickSight Q, a machine learning-powered pure language functionality that provides anybody in a company the flexibility to ask enterprise questions in pure language and obtain correct solutions with related visualizations. Sydnor says, “How cool would that be if professors might go in and ask easy, easy questions like, ‘What number of of my division’s college students are taking full course masses this semester?’ It has a whole lot of potential.”


The CSUCO is worked up to be a champion of QuickSight within the CSU, and are searching for methods to extend its implementation throughout their group sooner or later.

To be taught extra, go to the web site for the California State College Chancellor’s Workplace. For extra on QuickSight, go to the Amazon QuickSight product web page, or browse different Huge Information Weblog posts that includes QuickSight.

Concerning the authors

Madi Hsieh, AWS 2022 Summer season Intern, UCLA.

Tina Kelleher, Program Supervisor at AWS.


Most Popular

Recent Comments