Analyzing and Visualizing Data in Looker

Module 1) Introduction to Looker

• Define Looker and the capabilities it provides for working with data.
• Navigate the Looker user interface to access data and functionality.

Module 2) Core Analytics and Concepts

• Explain the four core analytical concepts in Looker (dimensions, measures, filters, pivots)
• Discuss dimensions to access data attributes.
• Identify measures to aggregate data attributes.
• Combine dimensions and measures for richer data analysis and visualization.
• Filter dimensions and measures to analyze a subset of the data.
• Use pivots to restructure and group data.

Module 3) Table Calculations

• Explain how table calculations and offset functions are used to work with data in Looker.
• List the types of table calculations and offset functions available in Looker.
• Create new metrics instantaneously with table calculations and offset functions.

Module 4) Looks and Dashboards

• Explain how to create and deliver Looks and dashboards in Looker to share results with stakeholders.
• Discuss how to create and share standalone visualization reports called Looks.
• Discuss how to create and share dashboards to combine multiple visualizations for a business topic or domain.
• Add new content to an existing dashboard.
• Add filters to a Look or dashboard for flexible analysis of a subset of the data.
• Discuss the delivery of data outside of Looker for access by other stakeholders or system.

Module 5) Content Management

• Looker content organization, folders, boards
• Discuss folders in Looker to organize content for navigability and discoverability.
• Discuss the creating and sharing of boards to centralize content that lives in different folders in a Looker instance.