Topics started by samiyabroudi
Ro uses Looker as its BI tool. Looker is based on the idea of analysts building Looker “models” written in its LookML language; these models describe a graphical point-and-click interface that a business-side individual can use to query the specified data sets without needing to write code. Operations, data models additions/modifications, product offerings, and medical condition offerings are scaling far too quickly at Ro for the standard Looker development model to be sustainable without having a small army of a data team to provide the labor required. Applying our general analytic tendencies to the situation, we found that much of the creation and maintenance labor required for LookML models was repetitive and error prone. Separately, LookML lacked certain features that we were having trouble doing without, particularly around documentation and the idea of view blocks. So, now we automatically generate most of our LookML code instead. Basic Architecture Completely independently of L
At Roman, a men’s telehealth company subject to HIPAA PHI regulations, we have a significant number of data access permutations (the usual financial + operations + pci levels plus a variety of HIPAA buckets). We also want to minimize the amount of time it takes any Looker user/analyst at Roman to disseminate useful information to the entirety of the company. Rather than maintain a large number of parallel models, dashboards, and look spaces we’ve opted for column-by-column permissions. This means that all of our Looker users can see all explores and the names of all possible dimensions and measures. However, if they try to access a dimension or measure in an explore for which they do not have access they will simply get no data. If they are trying to view a visualization/look that someone else created that has information that they are not authorized to access, they will see that the visualization exists but they will not be able to see any data. Credits This approach was developed wit
Already have an account? Login
Login to the community
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.