Visualization & Integration
Enabled newly onboarded customers to view Dynamic Dashboards with isolated data within minutes and complete integration of user, data, ACLs, SSO with Viz tools
Worked On
Backend integration, Viz REST APIs, SSO
Tech Stack
Ruby+Rails, Angular, Tableau, Sisense, Postgres, SQS, JWT
Date
April, 2019
Challenge
Seamless integration of the Visualization tools with platform services covering data security, integrity, access control and SSO.
Solution
With Ruby+Rails as backend, integrated the visualization tools Tableau and Sisense to the microservices plane via REST APIs, thereby enabling strict compliance between customer data and user.
As part of the Analytics team, we were responsible for reporting and gathering insights. Considering the huge volume of our data, we had to prepare datamarts in our data warehouse and push them to the in-memory data stores used by Viz tools Tableau and Sisense.
We had multi-tenancy architecture, so data security and integrity played a critical role. To achieve that, I had integrated the complete life-cycle of a user and company in our platform with the Row Level Security and ACLs in the in-memory stores. This isolated the dataset at the company level, thereby completely avoiding any data leak incidents.
This was a very critical piece to build credibility in the platform and enabled Customer Success Managers to quickly provision reporting access to users. It reduced the time taken from Access Provisioning to Viewing Dashboard in the platform from ~1-2 days to within 2 minutes.
Seamless embedding of several dashboards in the frontend was done using Angular and JWT+SSO. This generic framework was later adopted by multiple internal teams for other reporting necessities.
