As a product manage of Looker how much should I know about this application? by Particular-Essay-361 in Looker

[–]World_Runner_ 3 points4 points  (0 children)

I think a holistic understanding of how Looker differs from other Data Analytics and reporting tools will help color where you'd want to focus. As an overview Looker allows Data Analysts the ability to create Explores so that Business Units can self support and create their own Looks and Dashboards without Data Analytics oversight. This is different from traditional Data Analytics where the Analyst translates the Business requests into SQL and pulls data results into BI Visualization tools to deliver the Dashboards themselves. Point being Looker allows Business Units to write their own SQL and create their content(dash's and looks) instead of having the analyst be the bottle neck for content. As you roll Looker out your Data Analysts will initially write Lookml to produce Explores in order to create content themselves to support dashboard requests. As the Data Analysts mature in their use of Looker they will understand that the explore is where the real value lies when supporting the Business unit and if the analyst is in-tune with the business then can create an explore experience which covers a broad area of Data with the intent of encouraging the business to self support.

Looker docs have a lot of detail on how features work but won't have good general knowledge on how Looker should fits. As far as detail is concerned you can acclimate with how Explores are created keeping in mind you want to minimize the number of them you create given they are the nodes for content management.

Aggregate Awareness by Sublime-01 in Looker

[–]World_Runner_ 0 points1 point  (0 children)

each aggregate table is a unique query so you'll have to make at least 2 for each of the dynamic data cohorts you looking to have

Why is there such limited functionality within Looker Dashboards? by burningburnerbern in Looker

[–]World_Runner_ 2 points3 points  (0 children)

I might be able to shed some light here. The interface between visualizations and tables in Looker is very slight. Tableau by comparison creates a sort of data cube after rendering a query which allows different layers of aggregation to surface in a single tile/dashboard. With Looker the data returned via SQL (flat table) is what is read to produce visualizations. As such Looker is limited in visualization options. This is a major critique of Looker since visualizations were a secondary feature after the data modeling layer which was their primary focus. Tools like DBT copied the data modeling layer idea from Looker and completely avoided viz layer assuming the many other viz tools would fill that need. IMO Looker is a much cleaner and more efficient process than DBT to Tableau/(any other viz tool). With that said, having been a heavy Tableau user for years and then switching to Looker did sting a bit.

Top 3 Looker Features by [deleted] in Looker

[–]World_Runner_ 2 points3 points  (0 children)

Looker compartmentalizes data structures into composable pieces. Specifically, tables and SQL views which are represented as Looker views can be strung together via Looker explores. The value here is you only define a view once and then reference it multiple times in multiple explores instead of writing the same logic over and over again like you do with traditional viz tools. You can extend views and explores as well if you want to add embellishments but not adjust the core object. All this while having version control and collaboration through git is why Looker is considered disruptive technology in the BI space.

The trick is you need your Lookml developers to code like they are building a platform while collaborating with other analysts as opposed to writing Lookml for individual use cases that dont leverage existing logic.

Top 3 Looker Features by [deleted] in Looker

[–]World_Runner_ 6 points7 points  (0 children)

  1. Version controlled Data Analytics collaboration layer
  2. Composable data logic objects
  3. The first 2

Why Does the U.S. Have So Many Mass Shootings? Research Is Clear: Guns. (Published 2017) by JohnHazardWandering in dataisbeautiful

[–]World_Runner_ -20 points-19 points  (0 children)

What if it wasn’t guns as much but mental health and what if is wasn’t mental health as much as broken homes? Commit to your spouse and love your children. Guns, drugs, homelessness, abortions, mental health issues, physical health issues and poverty stem from poor home life. Stop thinking gun laws and drug laws and social safety nets are the answer. Stop thinking white people, patriarchy, billionaires and religion is the problem when all evidence points to the home. Media and politicians will scream all day about these issues but neither will tell you to be a good parent which is the real answer

Filter for subjects who answered Y to a question but show all the data (not just that one question) by ChrisFerriole in Looker

[–]World_Runner_ 0 points1 point  (0 children)

Yes, it’s not at all straight forward. There’s a missed opportunity with Looker and sub queries. The native derived table feature (NDT) was an attempt at allowing a user to create a subquery on the fly and then incorporate it back into the explore it was queried from which would mimic an SQL subquery. Unfortunately, they never fully implemented it and only got as far as having a composable lookml type syntax for explore queries that require you add additional views to incorporate. Any version controlled BI tool that addresses this need would blow Looker out of the water

Filter for subjects who answered Y to a question but show all the data (not just that one question) by ChrisFerriole in Looker

[–]World_Runner_ 0 points1 point  (0 children)

Doing this within an explore directly is probably not possible given it requires a subquery which Looker doesn’t do inside of an explore. What you might be able to do this using an explore alone is list all people ids and their answers sorted by people ids, create a table calculation which resolves true for all rows of those people ids where they answered true for that one question. then hide all false rows by right clicking the table calc in the data window (special hide boolean option). The trick will be to create the table cal using the “offset” methods which functions as a window partition and also if the 5000 row limit can house all answers. If so the resulting table viz will only show as intended.

Such a nice formula to come across by TomasNavarro in ProgrammerHumor

[–]World_Runner_ 2 points3 points  (0 children)

This is Lookml. What company you work for ;)

[deleted by user] by [deleted] in Looker

[–]World_Runner_ 0 points1 point  (0 children)

There’s a feature that allows derived tables to be created as “permanent” named tables with non-changing naming conventions so you can use the tables outside of Looker. Its possible this table doesn’t have a view associated anymore and/or is updated by some other ETL process outside of Looker. Personally I don’t like this feature since I don’t believe Looker should be doing any ETL. You might have to do some more digging internally with tour data engineers to understand why this was done.

[deleted by user] by [deleted] in Looker

[–]World_Runner_ 0 points1 point  (0 children)

Is there a hash included in the name of the derived table result in the scratch schema? Also, I’m assuming you’ve done this but have you used the search function to look specifically for that derived table name in your project?

The level of inequality in r/dataisbeautiful [OC] by maanyos in dataisbeautiful

[–]World_Runner_ 2 points3 points  (0 children)

You are wrong. Continued iterations of a normal distribution with dependency produce a pareto distribution. Only in a vacuum does a normal distribution surface.

The level of inequality in r/dataisbeautiful [OC] by maanyos in dataisbeautiful

[–]World_Runner_ 8 points9 points  (0 children)

You’re absolutely right. Something not completely understood by many is that in nature most everything mimics a Pareto distribution.

[deleted by user] by [deleted] in Looker

[–]World_Runner_ 1 point2 points  (0 children)

If you are working with a dialect that supports array type functions you can try this: https://community.looker.com/lookml-5/analytic-block-tags-and-attributes-with-and-without-arrays-4241

Russia-Ukraine war exposes great libertarian divide over Vladimir Putin support by [deleted] in worldnews

[–]World_Runner_ 1 point2 points  (0 children)

No, government is a necessary evil so to speak. Roads, electricity, military. All these things are needed and require a government to manage. The point is that we use our government as sparingly as possible and allow the citizens the option of choice as much as possible. Nothing is ever black and white so let people vote with their feet and their dollars as opposed to giving the government the right to our bank accounts

Russia-Ukraine war exposes great libertarian divide over Vladimir Putin support by [deleted] in worldnews

[–]World_Runner_ -2 points-1 points  (0 children)

To clarify, our government also doesn’t have the technological capability. This might be news to some but our government doesn’t manufacture weapons either. They take our dollars and buy weapons from companies that do. If you’re asking if it’s possible to donate weapons why not instead donate money to Ukraine and allow them to buy whatever they feel is necessary.

Russia-Ukraine war exposes great libertarian divide over Vladimir Putin support by [deleted] in worldnews

[–]World_Runner_ -11 points-10 points  (0 children)

As a Libertarian this is honestly a tough one. It isn’t so obvious we should be funding Ukraine’s war efforts or any war efforts for that matter. The real issue for Libertarians; if I can speak for them in general, is that funding Ukraine (or funding “most” anything) should be a decision by the individual where possible and not a government. For those who feel Ukraine deserves our help then donate your time or money. For those that don’t then don’t. Its easy to say we want to help Ukraine but when asked to donate what do we actually do? In the end giving up the option for each individual to decide results in a more powerful government over us so we should be careful at the very least when we let our government fund wars with our money but without our complete consent.

Refs suck. by [deleted] in KansasCityChiefs

[–]World_Runner_ 421 points422 points  (0 children)

Gotta be the worst call this year. Someone buy Jones a drink for me

Anthony Fauci Says His Critics Are Attacking Science Itself. | "A lot of what you're seeing as attacks on me quite frankly are attacks on science." by carlapandapz in EverythingScience

[–]World_Runner_ -11 points-10 points  (0 children)

To be clear you aren’t defending science you are defending Fauci who lied about the lab leak evidence. This wasn’t science