Looker Business User Bootcamp

Navigate the Looker interface, customize your home page, and practice building dashboards with looks and Lookml dashboards while exploring history, schedules, and Looker help resources.

Explore the Looker interface: navigate the left menu to home, recent reviews, favorite dashboards, boards, and folders, and learn about admin, developer sections, and blocks and applications.

Join a Looker dashboard walkthrough to learn using filters, sharing with links, cloning and customizing dashboards, exporting Lookml and formats, and scheduling deliveries while managing cache.

Explore how to use Looker explorer and dashboards, apply global and tile filters, and perform actions like save, download data, view, refresh, and export visuals.

Explore the field picker to select dimensions and measures, apply filters, create custom fields and table calculations, and pivot and group data for insightful Looker dashboards.

Explore the Looker explorer by building a 2021 monthly total sales bar chart, filtering by year, and adding it to a dashboard. Customize visuals with sorting, colors, themes, labels, and axes.

Pivot sales data by category in Looker to read monthly totals clearly, switch to stacked visuals for a category breakdown, and compare 2021 sales efficiently.

Create dashboard visualizations by adding a table calculation to show the last month of 2021 sales and its change from the previous period, saved to a new dashboard.

Develop a cost-focused sales dashboard by adding total cost tiles and percent change from the previous period, save edits, and enforce consistent naming for clarity.

Build an overview dashboard by adding bar charts of the top five categories and top five brands by total sales, filtering to 2021 and saving the visuals.

Create a month-by-month overview of total cost and total sales, using bars and a line, and add total sales versus total cost during that year to the dashboard.

Master calculating count of distribution centers using custom dimensions and a custom measure, then display the result as a single value on the dashboard in Looker.

Enhance a Looker dashboard by mapping distribution centers on Google Maps, showing sales price and gross margin, and add a delta calculation to compare metrics by area or post code.

Create a custom dimension by concatenating brand and category to form brand product category. Then display the top five total sales in a bar chart and save to the dashboard.

Create and organize a Looker dashboard in edit mode by adding headers, text, and markdown, positioning top KPIs, total sales versus cost, distribution maps, and the top five list.

Explore filters and cross filtering in dashboards; enabling cross filtering updates fields but may disable actions, and learn to create cascading filters with defaults and tag list options.

Explore dashboard settings, time zone, and filter options, and consider auto refresh costs in BigQuery, then build a sales overview with brands and distribution centers using custom dimensions and visualizations.

Learn how to schedule delivery in Looker: configure daily 8 a.m. pdf email deliveries to Rahul, using filters for year 2021 across all brands and states, with saved schedules.

Create and organize a new business overview board by adding dashboards and sections like marketing overview, then set the board as the home page and share it with controlled access.

Use buttons to create workflows across dashboards, linking sales overview and marketing overview, duplicating titles, and delivering a consolidated view that helps end users assimilate information and act on it.

Limit Looker dashboards to about 15 tiles, up to 25 if needed, to avoid performance issues; wireframe, split into multiple dashboards with control flow, and keep names concise.