Looker Bootcamp: Analyzing and Visualizing Data with Looker

Learning Objectives

This course combines expert lecture, real-world demonstrations and group discussions with machine-based practical labs and exercises. Working in a hands-on learning environment led by our expert facilitator, you’ll explore and gain:

· Comprehensive understanding of Looker's platform: Gain a solid foundation in Looker's key features, functionality, and interface, enabling you to navigate and utilize the platform effectively for your data analysis and visualization needs.

· Mastery of LookML and data modeling: Develop proficiency in Looker's unique data modeling language, LookML, to create customized and efficient data models that cater to your organization's specific requirements.

·Expertise in creating insightful Explores: Learn to build, customize, and save Explores with dimensions, measures, filters, and calculated fields, empowering you to analyze your data and uncover valuable insights.

· Proficiency in dashboard design and sharing: Acquire the skills to design visually appealing and informative dashboards, share them with different user roles, and schedule exports to keep stakeholders informed and up-to-date.

·Enhanced content organization with folders and boards: Understand how to effectively use folders and boards to organize, manage, and discover content within Looker, making it easily accessible for you and your team.

Audience

The audience for this course includes professionals who are new to Looker who are interested in leveraging Looker for data analysis, visualization, and reporting. The course is designed for individuals seeking to gain a comprehensive understanding of Looker's functionalities and apply these skills in their organizations to drive data-driven decision-making.

Ideal attendees for this course come from a wide range of roles, including but not limited to:

• Data Analysts: Professionals responsible for analyzing data and creating reports to support decision-making processes within an organization.
• Business Analysts: Individuals who work closely with business stakeholders to understand their requirements, analyze data, and provide insights for strategic decision-making.
• Data Engineers: Technical professionals who manage and process data and want to expand their skill set to include data visualization and reporting using Looker.
• Product Managers: Professionals who need to track and analyze product performance metrics and want to utilize Looker to create visually appealing and informative dashboards for better decision-making.
• Marketing Analysts: Individuals responsible for analyzing marketing data and providing insights to drive marketing strategies and optimize campaigns.
• Data Science Team Leads: Professionals who oversee data science teams and want to leverage Looker to efficiently communicate results and insights to stakeholders within the organization.
• Project Managers: Individuals who need to monitor project progress and performance and want to use Looker for creating project-specific dashboards and visualizations.

Pre-Requisites

In order to be successful in this course you should have:

• Basic computer literacy: Participants should be comfortable using computers and navigating software applications, as well as basic file management and organization.
• Fundamental understanding of data concepts: Attendees should have a basic understanding of data concepts such as tables, columns, rows, data types, and primary/foreign keys.
• Familiarity with databases and SQL (helpful, not required): Participants should have a basic understanding of relational databases and some experience with SQL, including SELECT statements, JOINs, and WHERE clauses.
• Basic spreadsheet skills: Attendees should be comfortable working with spreadsheets (e.g., Microsoft Excel or Google Sheets) for data manipulation, filtering, and sorting.
• Foundational knowledge of data visualization: Participants should be familiar with common chart types and their use cases (e.g., bar charts, line charts, pie charts, etc.), as well as basic principles of effective data visualization.
• Basic statistical knowledge (optional): While not required, a basic understanding of descriptive statistics, such as mean, median, and standard deviation, as well as concepts like correlation and regression, can be helpful for grasping some of the more advanced analytical features in Looker.

Course Agenda

Day 1: Introduction to Looker and Data Analysis