Looker

Commentaires: We get to force-multiply our impact by making it easy for users in all departments to make data-driven decisions and help allow that to drive their day-to-day.

Avantages: I love the customization of Looker, and that you can put large amounts of data into the hands of anyone -- in a way that makes sense [to them]!
While their product is great, it speaks volumes to the team. It's an amazing group of people that continue to receive feedback from their customers and iterate time and time again on their product. They truly care about data and their customers, and they want to empower them the best they can.

Inconvénients: When modeling views, I wish you could define better filters for measures but it's limited. There are workarounds, meaning modeling out several additional dimensions to arrive at the measure you need to pull regularly, but it'd be much more efficient to allow for measures to be more nuanced. Large dashboards (with 25+ tiles) can take awhile to load, which is understandable. Once their "merge results" feature is fully rolled out and we're able to save them as new tiles or looks, it should help resolve the need for so many tiles. Neither of these two things are a big deal, and I wouldn't let this deter you from considering this software.

Commentaires: Looker is quickly becoming our go-to for reporting and dashboarding for anything requiring more than one data source (and some that are based on just one). Paired with a kick-ass centralized data warehouse (we use Snowflake), Looker lets us roll things out very quickly (provided our data infrastructure is in good shape). It did take a while to get going with Looker because it lays on top of the existing data infrastructure. Now that we have quite a bit of strong infrastructure in place in our centralized data warehouse, we are able to produce data products in Looker quite quickly.

Avantages: Provisioning security allows us to control the user experience (and only show users things they would actually care about). This makes a dashboard or data product rollout far smoother. Additionally, the customer support (especially through the chat interface) is absolutely fantastic. Because Looker creates a custom URL for each explore you're working on, you can share with Customer Support your exact problem and work together to find a solution.

Inconvénients: Looker Sales told us beforehand that it "writes the most performant SQL possible." I have not found this to be the case, as it often casts and does a few other things (I suspect to make it runnable no matter how you've set up your data). There are some limitations on the visualizations, etc., but Looker Customer Service has been super responsive when those come up.

Commentaires: This software has truly put our leadership team above the benchmark with data efficiencies and making informed data driven decisions.

Avantages: Looker is incredibly easy to use, and it easily scales with your technical abilities. As an Analyst, I can create very easy to use self serve reports for stakeholders. This saves time and effort for both parties. Looker also has a very intuitive way of organizing data and letting you quickly visualize data in your warehouse. It is reliable and the data visualization options are abundant. Our leadership team is miles ahead of others I've seen because of how quickly they were able to learn how to use Looker.

Inconvénients: I don't necessarily see this as a con, however I think there is a big opportunity to help guide some new users through some of the more technical setup of Looker. I relied on a mentor to help take me through LookML and Models/Explores, but I would have loved to have some in product help with this.

Commentaires: I user Looker every day​ to create dashboards that I share within the company. At the same time I use Looker to analyze​ data on ad hoc requests

Avantages: It's really easy to create dashboards and reports. Even though we need to code some things it allows to be really flexible in the way you create and display data.

Inconvénients: I had to learn more technical information, the code, and how to work with development and live versions of the models.

Commentaires: Like I said, it's a great tool for analysts that don't need a lot of flexibility or maybe just aren't used to working with a lot of data. To get the full value out of this software, you'll need a core group of experienced Data Analysts that can learn fast (to learn Lookers Table Calculation code which is similar to SQL) who can build a bunch of dashboards and views. You really don't want people who aren't savvy with data doing a lot of the creating because measures are always aggregated based on the dimensions you pull into each table...if a user forgets to add a specific dimension then measures could show the wrong value. This could be offset by having really good developers who architect the data in a way that doesn't allow this to happen.

Avantages: It's a great data exploration tool for users who normally would get anxious when given a large dataset in something like Excel. It's generally simple to use and there can be unlimited Viewers (users at the lowest permissions level) through the enterprise product. Data Visualization is essentially done for you and Exploers (users at the second level of permissions) can build new visualizations & turn them into interactive dashboards. On the Looker platform, Explorers can locate a view (called an Explore) and then are given a list of dimensions and measures they can pull into a table. Users can create new dimensions using calculated fields and then save their views so any users with Viewer permissions (and up) can see what was put together.

Inconvénients: With simplicity comes lack of flexibility. More skilled data analysts will want more flexibility than Looker can provide but at the same time you need to have highly skilled Data Analysts to be the Developers (high level of permissions) to set up the data so that less skilled analysts (the users who benefit from Looker most) who are Explorers don't build views that grossly misrepresent the data. My biggest pet peeve with this software as an Explorer is that you cannot make calculations on the base data...only the data that you pull into your table (called table calculations). That is a major feature that Tableau has that Looker does not have at the Explorer permission level. Of course developers can use LookML (Lookers data language) to create a new column...but a Developer license is more expensive and creating the fields take time and it's something you constantly will need.