Analyzing and Visualizing Data in Looker

Analyzing and Visualizing Data in LookerAVDLGOGoogleGO-AVDL1.2.2Upon completion of this course, participants will be able to: <ul> <li>Define Looker and the capabilities it provides for working with data.</li><li>Explain the four core analytical concepts in Looker (dimensions, measures, filters, pivots).</li><li>Use dimensions, measures, filters, and pivots to analyze and visualize data.</li><li>Create advanced metrics instantaneously with table calculations.</li><li>Create dashboards to combine and share visualizations.</li><li>Use folders and boards in Looker to organize content for navigability and discoverability.</li></ul>Not covered in this course: <ul> <li>LookML (Looker Modeling Language)</li><li>Looker admin features and functions</li></ul>None.Business users who need to draw insights from data; Data analysts who are responsible for data analysis and visualization within their organizations.Module 1 - Introduction to Looker Topics - Looker interface and components <ul> <li>Define Looker and the capabilities it provides for working with data</li><li>Navigate the Looker interface to access data and functionality</li><li>1 demo</li></ul>Module 2 - Core Analytics Concepts Topics - Dimensions, measures, filters, pivots <ul> <li>Explain the four core analytical concepts in Looker (dimensions, measures,filters, pivots)</li><li>Use dimensions to access data attributes</li><li>Use measures to aggregate data attributes</li><li>Combine dimensions and measures for richer data analysis and visualization</li><li>Filter dimensions and measures to analyze a subset of the data</li><li>Use pivots to restructure and group data</li><li>4 demos, 1 quiz, 1 lab</li></ul>Module 3 - Table calculations Topics - Table calculations, offset functions <ul> <li>Explain how table calculations and offset functions are used to work with data in Looker</li><li>List the types of table calculations and offset functions available in Looker</li><li>Create new metrics instantaneously with table calculations and offset functions</li><li>4 demos, 1 quiz, 1 lab</li></ul>Module 4 - Dashboards Topics - Looker dashboards, data delivery options <ul> <li>Understand how to use dashboards in Looker to share data and results with stakeholders</li><li>Create dashboards to visualize multiple aspects of a business topic or domain</li><li>Add new content to an existing dashboard</li><li>Add filters to a dashboard for flexible analysis of a subset of the data</li><li>Deliver data outside of Looker for access by other stakeholders or systems</li><li>1 demo</li></ul>Module 5 - Content Management Topics - Looker content organization, folders, boards <ul> <li>Explain how to use folders in Looker to organize content for navigability and discoverability</li><li>Create and share boards to centralize content pertaining to one topic or theme</li><li>1 demo</li></ul>Module 1 - Introduction to Looker Topics - Looker interface and components <ul> <li>Define Looker and the capabilities it provides for working with data</li><li>Navigate the Looker interface to access data and functionality</li><li>1 demo</li></ul>Module 2 - Core Analytics Concepts Topics - Dimensions, measures, filters, pivots <ul> <li>Explain the four core analytical concepts in Looker (dimensions, measures,filters, pivots)</li><li>Use dimensions to access data attributes</li><li>Use measures to aggregate data attributes</li><li>Combine dimensions and measures for richer data analysis and visualization</li><li>Filter dimensions and measures to analyze a subset of the data</li><li>Use pivots to restructure and group data</li><li>4 demos, 1 quiz, 1 lab</li></ul>Module 3 - Table calculations Topics - Table calculations, offset functions <ul> <li>Explain how table calculations and offset functions are used to work with data in Looker</li><li>List the types of table calculations and offset functions available in Looker</li><li>Create new metrics instantaneously with table calculations and offset functions</li><li>4 demos, 1 quiz, 1 lab</li></ul>Module 4 - Dashboards Topics - Looker dashboards, data delivery options <ul> <li>Understand how to use dashboards in Looker to share data and results with stakeholders</li><li>Create dashboards to visualize multiple aspects of a business topic or domain</li><li>Add new content to an existing dashboard</li><li>Add filters to a dashboard for flexible analysis of a subset of the data</li><li>Deliver data outside of Looker for access by other stakeholders or systems</li><li>1 demo</li></ul>Module 5 - Content Management Topics - Looker content organization, folders, boards <ul> <li>Explain how to use folders in Looker to organize content for navigability and discoverability</li><li>Create and share boards to centralize content pertaining to one topic or theme</li><li>1 demo</li></ul>Upon completion of this course, participants will be able to: - Define Looker and the capabilities it provides for working with data. - Explain the four core analytical concepts in Looker (dimensions, measures, filters, pivots). - Use dimensions, measures, filters, and pivots to analyze and visualize data. - Create advanced metrics instantaneously with table calculations. - Create dashboards to combine and share visualizations. - Use folders and boards in Looker to organize content for navigability and discoverability. Not covered in this course: - LookML (Looker Modeling Language) - Looker admin features and functionsNone.Business users who need to draw insights from data; Data analysts who are responsible for data analysis and visualization within their organizations.Module 1 - Introduction to Looker Topics - Looker interface and components - Define Looker and the capabilities it provides for working with data - Navigate the Looker interface to access data and functionality - 1 demo Module 2 - Core Analytics Concepts Topics - Dimensions, measures, filters, pivots - Explain the four core analytical concepts in Looker (dimensions, measures,filters, pivots) - Use dimensions to access data attributes - Use 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 - 4 demos, 1 quiz, 1 lab Module 3 - Table calculations Topics - Table calculations, offset functions - 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 - 4 demos, 1 quiz, 1 lab Module 4 - Dashboards Topics - Looker dashboards, data delivery options - Understand how to use dashboards in Looker to share data and results with stakeholders - Create dashboards to visualize multiple aspects of a business topic or domain - Add new content to an existing dashboard - Add filters to a dashboard for flexible analysis of a subset of the data - Deliver data outside of Looker for access by other stakeholders or systems - 1 demo Module 5 - Content Management Topics - Looker content organization, folders, boards - Explain how to use folders in Looker to organize content for navigability and discoverability - Create and share boards to centralize content pertaining to one topic or theme - 1 demoModule 1 - Introduction to Looker Topics - Looker interface and components - Define Looker and the capabilities it provides for working with data - Navigate the Looker interface to access data and functionality - 1 demo Module 2 - Core Analytics Concepts Topics - Dimensions, measures, filters, pivots - Explain the four core analytical concepts in Looker (dimensions, measures,filters, pivots) - Use dimensions to access data attributes - Use 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 - 4 demos, 1 quiz, 1 lab Module 3 - Table calculations Topics - Table calculations, offset functions - 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 - 4 demos, 1 quiz, 1 lab Module 4 - Dashboards Topics - Looker dashboards, data delivery options - Understand how to use dashboards in Looker to share data and results with stakeholders - Create dashboards to visualize multiple aspects of a business topic or domain - Add new content to an existing dashboard - Add filters to a dashboard for flexible analysis of a subset of the data - Deliver data outside of Looker for access by other stakeholders or systems - 1 demo Module 5 - Content Management Topics - Looker content organization, folders, boards - Explain how to use folders in Looker to organize content for navigability and discoverability - Create and share boards to centralize content pertaining to one topic or theme - 1 demo1 jour650.00850.00595.00695.00695.00660.002260.00695.00695.00695.00650.002500.00820.00950.00950.00950.00790.00