Analyzing and Visualizing Data in Looker

Analyzing and Visualizing Data in LookerAVDLGOGoogleGO-AVDL1.2.2<ul> <li>Define Looker and the capabilities it provides for working with data.</li><li>Use dimensions, measures, and filters to analyze and visualize data.</li><li>Use dashboards for multiple visualizations and boards to curate Looker content.</li><li>Create advanced metrics by pivoting Looker data and writing table and offset calculations.</li><li>Create visualizations using Looks and dashboards, and share Looker content with others.</li></ul><ul> <li>Business users who need to draw insights from data.</li><li>Data analysts who are responsible for data analysis and visualization within their organizations.</li></ul><h4>Module 1 - The Looker Platform</h4> Topics: <ul> <li>What is Looker?</li><li>Looker user interface</li><li>Organizing content with folders</li></ul>Objectives: <ul> <li>Define the value proposition of the Looker platform.</li><li>Explain Looker’s role in the data analysis process.</li><li>Describe Looker's main user interface components.</li><li>Interpret Looker’s hierarchical folder structure for content.</li><li>Discuss different content locations within the Looker platform.</li></ul>Activities: <ul> <li>1 quiz</li></ul><h4>Module 2 - Data Analysis Building Blocks</h4> Topics: <ul> <li>Dimensions in Looker</li><li>Measures in Looker</li><li>Using dimensions and measures</li><li>Filtering dimensions</li><li>Filtering measures</li></ul>Objectives: <ul> <li>Define the purpose of a dimension and measure in Looker.</li><li>Identify where end users work with dimensions, measures, and filters.</li><li>Explain how dimensions, measures, and filters contribute to the larger data analysis process in Looker.</li><li>Identify what asset a dimension corresponds to in your database.</li><li>Identify what SQL functions a measure can correspond to.</li><li>Explain how to filter by a dimension.</li></ul>Activities: <ul> <li>3 demos, 1 lab, 1 quiz</li></ul><h4>Module 3 - Working with Looker Content</h4> Topics: <ul> <li>Filtering Looks</li><li>Introducing dashboards</li><li>Filtering dashboards</li><li>Curating Looker content in boards</li></ul>Objectives: <ul> <li>Explain how to filter within a Look and a dashboard.</li><li>Identify where users can work with dashboards and boards, and filter within Looks and dashboards.</li><li>Explain how dashboards, boards, and filtering can contribute to the data analysis process.</li><li>Define the purpose of a dashboard.</li><li>Explain what a board is in Looker.</li><li>Detail the process of creating a board.</li><li>Detail the process for pinning Looks and dashboards to a board.</li></ul>Activities: <ul> <li>1 demo, 1 quiz</li></ul><h4>Module 4 - Customizing Explores</h4> Topics: <ul> <li>Pivoting data in Looker</li><li>Introduction to table calculations</li><li>Types of table calculations</li><li>Writing table calculations</li><li>Introducing offset functions</li><li>Writing offset calculations</li></ul>Objectives: <ul> <li>Explain the process of pivoting data.</li><li>Identify where users can pivot data, write table calculations, and write offset calculations.</li><li>Identify situations to consider pivoting data and writing a new table calculation.</li><li>Explain how pivoting data, writing table calculations, and writing offset calculations can contribute to the data analysis process.</li><li>Differentiate between a table calculation and an offset calculation.</li><li>Discuss the various types of table calculations.</li><li>Detail the process to write table calculations and offset calculations.</li></ul>Activities: <ul> <li>4 demos, 1 lab, 1 quiz</li></ul><h4>Module 5 - Creating New Looker Content</h4> Topics: <ul> <li>Creating new Looks</li><li>Creating new dashboards</li></ul>Objectives: <ul> <li>Explain how to create a new Look and dashboard in Looker.</li><li>Identify where users can create new Looks and dashboards.</li></ul>Activities: <ul> <li>1 quiz</li></ul><h4>Module 6 - Sharing Looker Data with Others</h4> Topics: <ul> <li>Sharing and scheduling Looks</li><li>Sharing and scheduling dashboards</li><li>Tile-level dashboard alerts</li></ul>Objectives: <ul> <li>List the options to share Looks and dashboards once or with a regular schedule.</li><li>Identify where users can send or schedule Looks and dashboards, and configure tile-level dashboard alerts.</li><li>Explain how to configure a shared or scheduled Look or dashboard.</li><li>Discuss how to choose options that are appropriate for a given situation or business case.</li><li>Identify the options to schedule a tile-level dashboard alert.</li></ul>Activities: <ul> <li>1 quiz</li></ul>- Define Looker and the capabilities it provides for working with data. - Use dimensions, measures, and filters to analyze and visualize data. - Use dashboards for multiple visualizations and boards to curate Looker content. - Create advanced metrics by pivoting Looker data and writing table and offset calculations. - Create visualizations using Looks and dashboards, and share Looker content with others.- Business users who need to draw insights from data. - Data analysts who are responsible for data analysis and visualization within their organizations.Module 1 - The Looker Platform Topics: - What is Looker? - Looker user interface - Organizing content with folders Objectives: - Define the value proposition of the Looker platform. - Explain Looker’s role in the data analysis process. - Describe Looker's main user interface components. - Interpret Looker’s hierarchical folder structure for content. - Discuss different content locations within the Looker platform. Activities: - 1 quiz Module 2 - Data Analysis Building Blocks Topics: - Dimensions in Looker - Measures in Looker - Using dimensions and measures - Filtering dimensions - Filtering measures Objectives: - Define the purpose of a dimension and measure in Looker. - Identify where end users work with dimensions, measures, and filters. - Explain how dimensions, measures, and filters contribute to the larger data analysis process in Looker. - Identify what asset a dimension corresponds to in your database. - Identify what SQL functions a measure can correspond to. - Explain how to filter by a dimension. Activities: - 3 demos, 1 lab, 1 quiz Module 3 - Working with Looker Content Topics: - Filtering Looks - Introducing dashboards - Filtering dashboards - Curating Looker content in boards Objectives: - Explain how to filter within a Look and a dashboard. - Identify where users can work with dashboards and boards, and filter within Looks and dashboards. - Explain how dashboards, boards, and filtering can contribute to the data analysis process. - Define the purpose of a dashboard. - Explain what a board is in Looker. - Detail the process of creating a board. - Detail the process for pinning Looks and dashboards to a board. Activities: - 1 demo, 1 quiz Module 4 - Customizing Explores Topics: - Pivoting data in Looker - Introduction to table calculations - Types of table calculations - Writing table calculations - Introducing offset functions - Writing offset calculations Objectives: - Explain the process of pivoting data. - Identify where users can pivot data, write table calculations, and write offset calculations. - Identify situations to consider pivoting data and writing a new table calculation. - Explain how pivoting data, writing table calculations, and writing offset calculations can contribute to the data analysis process. - Differentiate between a table calculation and an offset calculation. - Discuss the various types of table calculations. - Detail the process to write table calculations and offset calculations. Activities: - 4 demos, 1 lab, 1 quiz Module 5 - Creating New Looker Content Topics: - Creating new Looks - Creating new dashboards Objectives: - Explain how to create a new Look and dashboard in Looker. - Identify where users can create new Looks and dashboards. Activities: - 1 quiz Module 6 - Sharing Looker Data with Others Topics: - Sharing and scheduling Looks - Sharing and scheduling dashboards - Tile-level dashboard alerts Objectives: - List the options to share Looks and dashboards once or with a regular schedule. - Identify where users can send or schedule Looks and dashboards, and configure tile-level dashboard alerts. - Explain how to configure a shared or scheduled Look or dashboard. - Discuss how to choose options that are appropriate for a given situation or business case. - Identify the options to schedule a tile-level dashboard alert. Activities: - 1 quiz1 day650.00850.00595.00695.00695.00660.002260.00695.00695.00695.00650.002500.00820.00950.00950.00950.00790.00