You are leaving our main website to go to our chinese website hosted in China. For legal reasons there will not be any links pointing back to the main website.

Go to chinese website
Logo - Keyrus
Logo - Keyrus
  • Playbook
  • Services
  • Insights
  • Partners
  • Careers
  • About us
    Company purpose
    Innovation & Technologies
    Committed Keyrus
    Regulatory compliance
    Investors
    Management team
    Brands
    Locations

Success story

Modernizing data processes for a nonprofit

By Kit Germeroth

A large nonprofit in the education space worked with Keyrus on a data initiative to combine institutional education data and provide researchers with deeper insight into student populations. Prior to this engagement, the organization was providing institutions with eight static PDFs, one for each of their KPIs.

Keyrus conducted data source gap analysis, Tableau dashboard development, Tableau server configuration, row-level security modeling, and automated deployment processes. 

Discovery Phase

The project began with a discovery phase in order to gain a deeper understanding of the goals and expectations for the Tableau dashboard initiative. 

Previously, the reports were created via Oracle Business Intelligence and delivered as PDFs. The goal was to migrate the existing reports into Tableau and increase overall functionality and depth.

There would be eight KPI reports and an executive summary report. These reports would help researchers identify patterns in different student populations that might explain why students are successful or unsuccessful. Through these insights, institutions and initiatives would be better equipped to make decisions and develop policies that would help students succeed. 

The dashboards needed to be self-service and contain row-level security to restrict access to data based on the user groups identified by the organization.

Gap Analysis & Tableau Dashboard Development

Before starting dashboard development, Keyrus completed a whiteboarding session for each of the proposed dashboards, creating mockups for each. Keyrus then cross-referenced these models with the data currently available in the organization’s Oracle data mart. There were a number of changes to make to meet the requirements of the mockups.

After the gap analysis and in parallel with ETL changes, Keyrus developed eight Institution-level dashboards (meaning single institutions would be the main audience of these reports).

Row-Level Security Modeling

Since student academic data is private to the institution that submitted the data, the Tableau dashboards needed to incorporate row-level security so organizations could only see data that they submitted.

The nonprofit required three levels of access:

  • Institution level - users that can see only a single institution

  • System or Initiative level - users that have access to multiple institutions’ data

  • Superuser level - internal users who can see global view (all data)

The Keyrus solution includes a User Access table with a single record per institution, since this is the most granular level of security required. 

Since there are multiple users who will have access to an institution’s data, the usernames with access will be concatenated in a single cell. The purpose for this is to avoid any case of data duplication. The table is joined to the views that hold data for the eight KPIs. On the Tableau side, a Data Source Filter was applied on the datasource with logic like this:

CONTAINS([USERNAME],USERNAME()) OR ISMEMBEROF(‘SuperUsers’)

Thus, if the record contains the username of the user viewing the workbook, the user will be able to view that record. If the user is dubbed a superuser, they will be added to a corresponding group on Tableau Server and, by the above logic, will be able to see every row of data.

Automated Tableau Deployment

Instead of performing deployments to higher environments manually, the organization required the development of an automated deployment process. This process is broken into two pieces: deployment of Tableau datasources (extracts) and deployment of Tableau workbooks. 

To automate the deployment, Keyrus created python scripts that utilize the tableauserverclient library, which references the Tableau Server REST API. 

The scripts perform the following actions:

Data sources:

  • Download the lateset version from Tableau Server based on tag

  • Publish to higher environment

  • Update the connection to reflect the Oracle db credentials of the higher environment

  • Refresh the extract

Workbooks

  • Download the latest version from Tableau Server based on tag

  • Change server connection of the data source (this is done using the Tableau Document API)

  • Publish workbook to higher environment

Automated User Addition

The Tableau Server uses SAML for Single Sign On. Oracle Access Manager (OAM) is used as the identity provider. In order for SSO to exist, the user must exist on both OAM and Tableau Server (with local authentication).

In order to automate the addition of the corresponding username to Tableau Server, Keyrus developed a python script to be triggered once a user is added to OAM with a Tableau role. The script passes the argument of the username in OAM to the Tableau Server REST API and adds the user to a group on the server with corresponding permissions to their access level.

Results

The organization now uses self-service analytics rather than relying on static PDFs that used to require 3 full weeks of 40 hours each week to create. The new dashboard suite is immediately available and easy for users to navigate, eliminating the tedious manual work. Overall, the data process is more efficient and intuitive for users.

whatsapptwitter
linkedinfacebookworkplace
newsletter.svg

Never miss an insight

Stay updated on the latest articles, events, and more

Your email address is only used to send you the Keyrus newsletter and for commercial prospecting purposes. You can use the link in our emails to opt-out at any time. Learn more about the management of your data and your rights.

Continue reading

Press release

Keyrus named amongst Top B2B Companies on Clutch

December 12, 2022

The Keyrus team is excited to announce that we’ve been named one of the top 1000 companies on Clutch’s platform in 2022! This is the second year that Keyrus has been recognized by Clutch as a top company and B2B leader. 

Webinar

PDF Parsing with Alteryx Intelligence Suite

December 1, 2022

In 20 minutes, we’ll teach you how to use Alteryx Intelligence Suite to eliminate common problems and inefficiencies in accessing data from .pdf files. In the past, you’d need to run custom Python and complex parsing logic to get any usable data from a pdf. Now, you can parse PDFs with out-of-the-box features in Alteryx Intelligence Suite.

Webinar

Modern Cloud Analytics in Action: Keyrus and Red Ventures

November 11, 2022

The cloud offers new opportunities to save you time and money, allowing you to shift focus from maintaining growing servers and upgrading infrastructure to making your data work for you and the success of your business. Watch the webinar and Q&A to learn how AWS, Tableau, and Keyrus worked together to help Red Ventures migrate to a powerful cloud BI tool that created new pathways for success and a modern data culture.

Event

Pharma/Biotech GTN Summit 2022

October 27, 2022

Keyrus & Anaplan Sponsor Life Science Gross-to-Net (GTN) Summit

Press release

Keyrus Achieves AWS Data and Analytics Competency Status

October 6, 2022

Keyrus achieved Amazon Web Services (AWS) Data and Analytics Competency. To receive the designation, AWS Partners must possess deep AWS expertise and deliver solutions seamlessly on AWS.

Webinar

Live Webinar: Lessons on workforce capacity planning and optimization from Optum (UnitedHealthcare)

October 19, 2022

Wednesday, November 9th, 2022 @ 12:00PM Central Time (US and Canada)

Webinar

Tableau Embedded Analytics: Optimizing insights from Salesforce data

September 20, 2022

Want to optimize your visual analytics in Salesforce? You need the right tools. Tableau Embedded Analytics can be used to help you build and visualize reports in Salesforce.

Success story

How C&S Wholesale Grocers maximized ROI with an analytics center of excellence

September 7, 2022

C&S Wholesale Grocers worked with Keyrus and Alteryx to implement an analytics center of excellence to help them efficiently and effectively achieve business objectives, maximize return on investment (ROI), and standardize best practices.

Success story

Implementing a cloud security automation tool at a global consulting firm

September 2, 2022

Keyrus partnered with a consulting firm to build an in-house cloud security solution that would automate their verification processes and keep their information safe.

Success story

Leveraging Salesforce to improve operations at Pajama Program

July 25, 2022

Keyrus partnered with Pajama Program, a nonprofit organization, to review their Salesforce architecture and improve overall operations.

Logo - Keyrus
New York City

252 West 37th st., Suite 1400 New York, NY 10018

Phone:+1 646 664 4872

LinkedInInstagram
PlaybookServicesInsightsPartnersCareersAbout us
Company purposeInnovation & TechnologiesCommitted KeyrusRegulatory complianceInvestorsManagement teamBrandsLocations
Legal notice & Terms of use
Privacy policy
Data protection