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. 
• Optional: Advanced visualization techniques for impactful storytelling: Master advanced visualization techniques, including customizations with HTML, CSS, and JavaScript, and interactive visualizations using Looker's API, to create compelling data stories that resonate with your audience. 

Need different skills or topics? If your team requires different topics or tools, additional skills or custom approach, this course may be further adjusted to accommodate. We offer additional Looker, data visualization, reporting, analytics and other related topics that may be blended with this course for a track that best suits your needs.  

The course is for 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. 

Please note that this list of topics is based on our standard course offering, evolved from typical industry uses and trends. We will work with you to tune this course and level of coverage to target the skills you need most. Course agenda, topics and labs are subject to adjust during live delivery in response to student skill level, interests and participation.  

Introduction to Looker and Data Analysis 

Getting Started with Looker 

• Overview of Looker and its key features 
• Navigating the Looker interface 
• Looker terminology and basic concepts 
• Lab: Navigating the Looker Interface - Familiarize yourself with the Looker interface by exploring its various components, menus, and tools. 

Connecting to Data Sources 

• Setting up and managing data connections 
• Exploring database schemas 
• Understanding LookML: Looker's data modeling language 
• Lab: Connecting and Exploring Data Sources - Practice setting up data connections, reviewing database schemas, and writing basic LookML code. 

Creating and Customizing Explores 

• Building and customizing Explores 
• Adding dimensions, measures, and filters 
• Creating calculated fields 
• Saving and organizing Explores 
• Lab: Create an Explore from scratch, adding dimensions, measures, filters, and calculated fields to generate insights. 

Data Visualization 

• Creating visualizations using Looker's visualization library 
• Customizing chart types, colors, and labels 
• Displaying visualizations in dashboards 
• Introduction to Looker's API for custom visualizations 
• Lab: Creating Data Visualizations - Develop a variety of visualizations using Looker's built-in library, customizing chart types, colors, and labels. 

Advanced Looker Techniques and Applications  

Advanced Explores and LookML 

• LookML refresher and best practices 
• Creating derived tables and data transformations 
• Managing access controls and data permissions 
• Lab: Write advanced LookML code to create derived tables, manage data permissions, and optimize your data model. 

Organizing and Sharing Content with Folders and Boards 

• Introduction to folders and boards in Looker 
• Creating and managing folders for organizing content 
• Setting up boards for easy content discovery 
• Sharing folders and boards with different user roles and permissions 
• Lab: Set up and manage folders and boards for content organization, sharing, and discoverability. 

Dashboard Design and Sharing 

• Best practices for dashboard design 
• Adding, arranging, and resizing visualizations 
• Scheduling and exporting dashboard data 
• Lab: Build an interactive dashboard, arrange visualizations, and practice sharing it with various user roles. 

Advanced Visualization Techniques 

• Customizing visualizations with HTML, CSS, and JavaScript 
• Creating interactive visualizations using Looker's API 
• Integrating Looker visualizations with other tools 
• Lab:Advanced Visualization Techniques - Customize visualizations using HTML, CSS, and JavaScript, and explore interactive visualization options with Looker's API. 

Hands-on Workshop and Project 

• Participants work on a guided project  
• Summary & Continued Learning Resources review