Rules, announcements, and important information
I have been doing part-time contract work with RedRoute (Conversational AI for customer service ), helping them use Looker to improve their product. They are in a period of growth and are hiring a Lead Data Analyst. Salary range is $120k-$180k and the position is entirely remote.I will be leaving in late January for a full-time position and our goal is for me to help onboard this new person and get them up to speed on what I’ve been doing in Looker.You can see the job posting and apply here. Happy to answer questions.
Hey Everyone! Wanted to let you know that Snapcommerce is hiring for a Data Director, a Senior Data Analyst, and a Data Analyst Intern.We've been growing out our BI tool functionality, strengthening our modeling foundation, and delivering insights that have significantly grown the travel branch of our company even through the travel crisis of 2020.We are on the all-star data stack of Fivetran, Snowflake, dbt, and Looker.We're looking to fill out our analytics team as we tackle the upcoming challenge of growing the e-commerce side of our brand. With any of the roles, there's tons of opportunity to make your mark on our burgeoning data best practices and mountains of data left to dig into.
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
As most of you know then Looker 7 was announced a couple of days ago: Looker Looker 7: Find True Power In Your Data Looker is an enterprise-class platform that empowers users, data analysts, and application developers to get that value from their data. Lot’s of great new things coming: New Slack integration Dynamic dashboards Marketplace Multi-cloud hosting Rich development framework Wanted to know what others mostly expect from it and maybe there is something that you expected, but it’s not planned for version 7?
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
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
Last update: 06:30, Jan 12, 2022 (UTC)GitHub SSH connections in LookML projects and new Marketplace installations are working as expected. What occurred? Due to a 24-hour GitHub brownout on Jan 11, 2022, GitHub connections using SSH in LookML projects and Looker Marketplace installation experienced issues. On March 15, 2022, the new GitHub protocol will become permanent (more information here). How will Looker handle the change? Looker is actively working on this change. We will provide a mechanism to regenerate key-pairs well in advance of the GitHub protocol becoming permanent on March 15, 2022. Further information will be announced in our regular product communication channels (release docs, in-app notifications) shortly. How do I know if I’m using SSH or HTTPS?You can check to see how your project is connected to git by running a Git connection test from the git action panel to see your remote repository URL. If this URL starts with “https://github” it is configured using H
Are you a brand new to Looker? Are you an admin, developer, or BI lead? If yes, then we have the perfect webinar for you! Our customer success team has been hard at work identifying the foundational insights new admins, devs, and BI leads should know in order to ramp up fast. Now, they’ve turned that understanding into an incredibly informative webinar for all to join for free! Live in the (virtual) flesh on March 25th and April 8th, dedicated CSMs will be leading this invaluable onboarding discussion and answering any questions that come up along the way. If this isn’t you but you know others who would benefit, please share the event link! Check out the North America and EMEA event pages for more info and to register.
Greetings Good Lookers! Fresh off the heels of JOIN San Francisco, the Looker team is hitting the road for JOIN the Tour! Be a Data Driver JOIN the Tour is a new kind of event series, venturing out to meet and gather the brightest data minds from all industries. Seeking out what’s new - or making a comeback - in the world of data. If you love data and all that it can deliver, then JOIN the Tour! Our first stop - London We’ll feature a full day of networking, informative tech-sessions, and get the tour rolling with an official JOIN the Tour Launch Party! All tour stops will feature case study content and represent an unrivalled opportunity for you to meet with the Looker team and other Looker users. JOIN us. We’d love to see you there to collaborate, learn and discover.
If you are a Looker user/analyst/admin, you are probably also always on the lookout for opportunities to improve your own skill set. What are some conferences you have found very valuable and would recommend attending? Please let me know if the conference was focused on a) DBAs b) bigdata/data scientists c) analysts d) product managers e) other or where in that spectrum the conference fit in. Thanks, Lucas
For those following along asynchronously, this is a scavenger hunt-style challenge intended to be completed (or attempted 🙈 ) within 10 minutes, on an unfamiliar dataset, during the Data Explorers Guild. The event has passed, but data is forever— Everyone is welcome to play with this public dataset and share any cool insights in the thread. Join us next month to explore live! This month’s dataset is based on Reddit post data from 2019, available at: https://play.looker.com/embed/explore/reddit/posts Copy and paste the below into a reply to this post, adding explore links for as many as you get to in 10 minutes. No need to go in order, feel free to jump around. PS: It’s usually nicer to filter to the top 10 or top 50 subreddits, since there’s a LOT of noise. Bonus points for an explore link that elegantly shows data about the entire ecosystem. A replica of this visualization, showing the 100 most popular words across the top 10 subreddits. You can sort by one subreddit to pi
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
I would like to create a list of metrics as a dimension so I can create the following. I would then need to figure out how to create the second columns that does the correct aggregations. all the documentation I have found only shows the dimension as filter field only when used in a parameter, but I need it in the data pane. Metric as a dimension Value Sales 1K Email 20 Units 10
Hello Community,I am creating a looker dashboard, based on the -let’s say- last 5 days with a barchart of certain metrics per day, and would like to add a filter on the top of the dashboard to show me they last 5 weeks (or last 5 month etc.)Is that possible to switch easily between days, month etc.?Basically I would like to switch between daily charts to aggregated weekly and monthly views with only a click for the Enduser. Thanks in advance for any reply!
Slalom New York City is hiring Looker experts for immediate start. Looking for 5+ years of experience in data analytics and visualization, and recent project work in Looker. The ideal candidate understands how to prepare, connect, and model data in LookML, design and develop visualizations/Explores, and can advise on Looker Action Hub. If you can also set up necessary integrations to export data from Looker, can connect it to APIs and third party systems, or embed vizzes in web portals, you’re automatically a preferred candidate! But this portion is not essential to qualifying for the role. Apply directly here: https://slalom.secure.force.com/careers/ts2__JobDetails?jobId=a0h1R00000BXiShQAL&tSource=
Hi All, I would appreciate any help in my Looker BA Certification journey. I have been trying to interview and a lot of the places that I would LOVE to work at use Looker. I have been trying to get enough experience to get certified but I have not been able to pass the certification with just the free training materials Are there any other resources out there that might help me prepare? Any advice or tips are welcome. Thanks in advance!!
Has anyone else noticed Looker’s slowness recently? I feel I used to encounter Looker being slow maybe once a week, usually in the evening. But as of recently, there are now periods of slowness throughout every single business day of the week. My internet’s fine (everything other website loads lightning fast), it’s definitely just Looker. It’ll just sit there spinning for quite a long time during all scenarios:when I’m loading on a simple lookml file or just reloading a dashboard page (it’s not the dashboard itself, but the actual page itself just sits there blank)
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!
Hey all! We’re running a fun Looker Learning Challenge to provide hands-on practice in core Looker skills! This Learning Challenge packages up some of our hands-on learning offerings for Looker - so you or others in your org can spin up a practice instance on demand, and go step-by-step through the learning modules for free. This challenge is focused on Looker foundations, with upcoming challenges going deeper and deeper across various aspects of Looker. Join the game now! Happy learning 🙂
I am trying to forecast my monthly case volume by using month to date actuals, by day, as the predictor. My daily volume fluctuates dramatically - so if I have 5 Fridays in a month vs 4 Fridays my volume can be very different. I have created a custom dimension to convert Work Date (DD-MM-YY) information into Mon, Tue, Wed, Thu, Fri, Sat, Sun.Now I am trying to forecast the remaining days of the month volume based on the actuals that have come in by day so far in the month. How do I create a forecasted day for each day of the week, and then tie it into how many of those days are remaining in the month?
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.