Rules, announcements, and important information
Virtual Looker Office Hours 1: Dimension groups, common database and Looker errors, Numbers, floats, and ints, and missing Dimensions and Measures
Here’s the first Virtual Looker Office Hours This is our first recording of the Virtual Office Hours, thanks for those that joined and asked questions. The resolution of this recording isn’t great and the audio has an echo 😢 , we’ll be sure to fix this in the next recording! Here’s the minutes of this office hours: 00:00 Housekeeping 01:30 Intro to Lead Analyst of Looker Support, Nicole Beyer 03:30 Dimension groups 09:00 Common database and Looker errors 18:00 Numbers, floats, integers 27:00 Missing dimensions and measures 38:00 Looker 3.50 sneak peek Huge thanks to my guest @nbeyer!!! Also let us know if you have any feedback or need further clarification on things we’ve covered this office hour. Sign up here for our next office hours!
There has been growing attendance and demand after we’ve rolled out office hours in San Francisco and New York City, and we’ve received feedback that they have been super useful. We want to bring this experience to more Lookers across the world! On Wednesday June 29th 9AM PST, we’ll be holding our first Virtual Office Hour. We’ll be walking through how to solve a few of the most common questions that we receive from customers through our support team. We’ll then open it up to chat for any audience questions. Audience questions that require an unavailable dataset, data structure, or a lot of prep work to reproduce the challenge will be addressed in future episodes. Don’t fret if you can’t make a Virtual Office Hour, these will be recorded and we’ll be doing these on a regular cadence! Here’s the link to our first Virtual Office Hours, hope to see ya’ll there 😃 Crowdcast Looker Virtual Office Hours - Crowdcast Register now for Mike Xu's event on Crow
Release Rollout Begins: May 8, 2016 Release Final & Download Available: May 19, 2016 All Release Notes Legacy Features End-of-life Schedule Preparing for Release Please take notice of items marked with a as they indicate changes to existing functionality and may require your attention. Notable Features New Dashboard Look & Feel More modern aesthetic through font tweaks, better use of whitespace, and removal of visual clutter. Notice the new styling for tiles, titles, editing, hovering and spacing. You can read more about the design process for the new dashboards on our blog. Single Value Visualization Progress bar and callout number options have been added to single value visualizations. Webhooks for Scheduled Looks & Dashboards (Labs) Looker enables you to use webhooks, an great way to deliver data from a look or dashboard to other servers or services. This feature can be used to schedule passing data from Looker to Google Sheets, Amazon S3 bucket, Dropbox, and man
RealSelf, the TripAdvisor for cosmetic procedures, is looking to expand the analytics team with 2 positions. Business Analyst will actively use Looker to help internal teams make data driven decisions. Business Intelligence Analyst will write LookML and help determine how and what to track for new features on the site. Apply directly with the links above, email me (peter@), or take a look at our careers page: https://www.realself.com/about/jobs
Hi all, I’m Justin, and I work at DICE. We are music aficionados who happen to have a 100% mobile ticketing platform that just won the UK Music Week Awards for Best Ticketing Company. We are looking for a Data Analyst that can help us bed in our Looker model and grow the role from there. It’s a chance to get in early as we continue to do everything we can to weave data and analysis into how we build and grow. We are based in London, and I know the community is a little smaller here, but Looker experience is only a plus and not an absolute necessity. Please reach out if you are interested or know some good candidates in this part of the world. Here’s the job description. Cheers! Justin
This week we’re announcing Looker Office Hours. A new customer opportunity to learn from our team of Customer Success Analysts at our offices in San Francisco and New York. These open sessions are dedicated to you, our customers. Best part is? They’re free. Come with any data questions you can think of! Some places where we can help… LookML modeling Query / DB performance Analytical patterns ETL Best Practices Dashboard design LookML errors Anything related to Looker or data, really. Just register below for a location, and date: Register Looker Office Hours First sessions are being held next Thursday April 28 from 3:30pm - 5pm local time. We can’t wait to help!
Hi, my name is Aron and I run the Data & Analytics teams for ShopStyle, the fashion search destination for PopSugar. I’m hiring an intern to help us evolve our Looker implementation (on RedShift) and further democratize the data. We have hundreds of end users, so this work will have high impact across the company. Plus, tons of learning opportunities from our top notch team of data engineers, analysts, and data scientists. See the job description and apply here.
Hey everyone! After talking to a ton of customers and previous LookML developers/analysts, I figured this would be an awesome place to help connect folks looking for developers or looking to continue using Looker as their tool! If you’re interested in posting information about a position please follow these guidelines: Click on the “Who’s Hiring” category above to find the starting place to post your job Make the title the place looking to hire, the location, and the job title After the posting, please put something to allow readers to contact you back, such as an email or URL to a form to fill. These posts will not have comments and we would really like to have those happen outside of Discourse for now. NO RECRUITERS, please only post if you’re seriously and actively involved in filling a position
Come join the Analytics team at Lyft! We’re making transportation more efficient and more friendly. Our team is influencing and automating decisions across all levels of Lyft’s Product, Operations, and Marketing Orgs. See here for more information about our team and challenges, and apply here, or email me.
You are invited to participate in the 2016 Wisdom of Crowds survey! We’ve been asked by Howard Dresner the “Father of BI” to be included in his annual Wisdom of Crowds research report. We need at least 25 participants to be a part of it, so we’d love your help! It should take you around 20 minutes (depending on how in depth you want to get in your answers), and the deadline is 3/31. Here’s some more info if you are curious: 2016 Wisdom of Crowds Survey by Dresner Advisory Services The 2016 survey will build on previous years’ research into overall BI deployment trends and related technologies and initiatives including Cloud BI, Advanced & Predictive Analytics, and the role of the BI Competency Center, as well as a new section on Collective Insights, the convergence of collaborative BI and governance. The survey will also ask about Enterprise Planning usage and intentions including strategic, operational, and planning initiatives. Click here to be a part of this survey. While you’r
Release Rollout Begins: March 13, 2016 Release Final & Download Available: March 31, 2016 All Release Notes Legacy Features End-of-life Schedule Notable Features Lookerbot With the release of 3.42, we unveiled the Lookerbot, a Slack integration with Looker that allows you to bring Looker data into your chats. Learn more. Drill Preview Drill Preview keeps users in the same context – on the same Explore page or Dashboard. Users can can then choose “Explore From Here” to jump over into the full Explore experience. Learn more. Totals Labels for Stacked Charts Totals labels and silhouettes allow you to enhance stacked charts. Learn more. Embedded Dashboard API Embedded dashboards can now communicate out to its parent page. Learn more. Additional Features by Section Graduating from Labs! LookML Extensions is no longer a Labs features, and will be automatically available for all instances. Learn More Drill Menus for Visualizations: More details below. Drilling Updates Drill Men
I found a CSV of the proposed United States budget. I uploaded it directly into BigQuery and built a small model (See it on Github). Clicking on counts will show you what is in the budget Clicking on the (…) will link you to government websites and wikipedia United States Budget 2017 (In Millions) [Explore From Here](http://looker.com/publicdata/looks/53?show=fields,vis,data) The source for this data can be found on the Whitehouse.gov website, particularly this file: https://www.whitehouse.gov/sites/default/files/omb/budget/fy2017/assets/outlays.csv
Release Begins: January 12, 2016 Release Final & Download Available: February 8, 2016 See all Release Notes Dashboards & Visualizations Reorderable Filters. The order in which filters are displayed can now be configured in the Add/Edit Filters modal found in the gear menu on Dashboards. Tiny Charts. Dashboard elements are simplified as they are reduced to allow for smaller-than-ever dashboard tiles that still contain useful information. Learn More. Column Limit Warnings in Dashboard Tiles. Since visualizations constrained by reaching the column limit can produce inaccurate charts, Looker now surfaces a warning inside the visualization panel and on dashboard tiles for improved data interpretation. Charts with pivots or multiple measures with the same value_format now apply that format to the axis tick marks. Powered By Looker Custom Styling for Embedded Dashboards. Includes background colors, chart colors, font colors, and more. Applies to both LookML and Drag and Drop
I love Pandora. Type in an artist’s name and it starts playing similar stuff. Pandora’s recommendation engine feels like magic. BigQuery provides a sample data set of some playlist data (Google’s @felipehoffa says the original data set was created by @apassant, awesome data!). The data is very simple: a single row for each track in the playlist. Track data contains playlist_id, artist (id and name), album (id and title) and track (id and title). Using this simple data, we built a recommendation engine in LookML that takes an artist, finds the most related artists and then recommends a playlist, all in about 300 lines of LookML. View the code on Github First, Go Ahead, Play With It Change the filter to your favorite artist and based on this data, we’ll recommend some songs. Click on the artist or song title to play music. Step 1: Build Out a Simple LookML Model The table that we’re working with is structured like this: Table: Playlists To build our LookML views and model, we need t
Hi Good Lookers, Next Wednesday January 27th Looker is holding our first West Coast Customer Meet-Up at our new San Francisco Office! Expect Patxi’s pizza, a fully stocked bar, and data lightning talk presentations by Looker analysts, Looker customers, and our own @lloydtabb! Register for the event right here: San Francisco Customer Meet-Up If you’re in the Bay Area, we’d love to see you!
Name Game Even very simple data sets can be complex to analyze. Starting with a really simple data set of names, we’re going to see if we can learn a few things. The data includes names given in the United States since 1910, listed by state and gender. We’ll go through the LookML model building and then build some data discovery widgets to learn about the popularity of names. The Data The data set is very simple, but with these 5 columns we can figure out a lot about names. name | gender | state | year | number Each row in the table is a roll up of the number of people with a given first name and gender born in a US state in a given year. name - the first name, capitalized gender - either ‘M’ or ‘F’ state - two letter abbreviation of a US state year - number, 1910 to 2013 number - the number of people born that year with that particular name. The Looker View In the Looker view, Looker generates a dimension for each column in the database table. Looker uses the column definiti
Release Begins: December 8, 2015 Release Final & Download Available: January 7, 2016 See all Release Notes Labs Features: As of 3.36, Looker has an expanded definition of Labs features. In addition to those experimental features that exist on the Labs page, select features throughout the application will be presented as part of the Labs program to let users know that they are still being considered for additional functionality. New & Improved SQL Runner with an updated interface and the ability to share, download, and explore from SQL queries. This feature will automatically be on for all instances. Learn more Explore Table Calculations for Pivot Rows. Additional functions enabling aggregates across pivot rows, cleaner complex offset computations, and row-level aggregates. Learn more about pivot rows, offset lists, or lists Updated Dashboard Modal. Shows the type of visualization added to increase clarity while building dashboards. Share Public Look as Images. Easily
With Looker 3.34, we introduce interactive map visualizations that zoom, pan and are reactive to filter changes. Wil Gieseler, our lead engineer for maps, will provide an overview of the new functionality and take your questions. Join us! 10am PST Tuesday, November 24, 2015 RSVP Here
Release Begins: November 10, 2015 Release Final & Download Available: December 3, 2015 See all Release Notes Visualizations New Visualization: Interactive Maps. New maps zoom and pan, and are reactive to filter changes. Learn More. Color Improvements for Charts Learn More New series of color palettes that can be used in visualizations. New color picker to assist in selecting new chart colors. Global default color scheme can be applied across the entire instance. Learn More. Ability to Sort by Series in Visualizations. Sort the row total in the table to see the information in the chart displayed in order of ascending or descending row totals. Updated Tooltips for readability. ##Dashboards Asynchronous Dashboard Loading. Tiles now load as their data returns from the database, instead of 2 at a time, to aid in faster loading of cached dashboards. More Informative Error Messaging on Dashboards. Dashboard tiles will now display the error that has prevented them from
Hacking Hacker News Hacker News data has recently been released on Google’s BigQuery data engine. BigQuery is a giant clustered SQL engine that can query enormous amounts of data very quickly. Quick Links If You Just Want to Play This article talks about building out a data model in LookML to be able to explore this data. If you are in a rush, you can: Play With the Hacker News Data Dashboard See the code on Github Explore the data directly Start with the Raw Data Navigating to the Hacker News data in BigQuery, we see there are two tables, stories and comments. Both tables are relatively simple in structure. Table Stories Each story contains a story id, the author that made the post, when it was written, the score the story achieved. I believe this is ‘points’ on news.ycombinator.com Each story also has a title and the URL containing the content. Getting Started Let’s first start with Stories. First we run Looker’s generator to create a LookML model for stories. Each field in t
Release Date: September 15, 2015 End of Cycle Date: October 2, 2015 See All Release Notes Explore Page Table Calculations Date Operations, including ability to subtract dates, extract parts of dates, and return the current date. Learn More Comments, using the # key, can be inserted into table calculation definitions. Learn More. Added Excel Spreadsheet download option. Filter suggestions now pull 5000 rows of suggestions instead of 500 to improve filter performance. Allow for filtering on a timestamp field. Improved Error Messaging. Errors related to fields in an Explore now only appear if relevant to that query. Errors now state whether they are due to a database or LookML model issue. Tables now load on scroll. While the entire result set is still returned from every query, only the visible portion of the table will be rendered in the browser at any given time. This should result in performance improvements when dealing with large result sets. Dashboards & Visu
Release Date: October 13, 2015 End of Cycle Date: November 2, 2015 See All Release Notes Visualizations & Dashboards Introducing Newspaper style layout for Dashboards, which allows for some tiles to take up more than one row while others remain on a single row. Also improves ease of dragging and dropping tiles. Learn More. X-Axis density automatically reduces based on available space for a visualization. Updated the Add/Edit Filters modal for easier application of filters to Dashboard tiles. Learn more. Introduced ability to edit filters on a particular tile directly from gear menu. Learn More. Improved responsiveness of filter input boxes on large dashboards. #LookML & Development Environment Introduced a date_raw field type and raw timeframe, which excludes timezone conversions. Learn more Suggestions now work with one_to_one joins. Improved the speed of the LookML Validator. Made the behavior of type: yyyymmdd the same as type date, which means that timezone con
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.