Day 1: 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.
Day 2: 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: 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 to apply the skills learned
- Trainer provides individual support and guidance
Project Presentations, Q&A, and Training Wrap-up
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.
Optional: Advanced visualization techniques for impactful storytelling: Master advanced visualization techniques,
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.
Ten (10) business days’ notice is required to reschedule a class with no additional fees. Notify TOPTALENT LEARNING as soon as possible at 469-721-6100 or by written notification to info@toptalentlearning.com to avoid rescheduling penalties.
Please contact our team at 469-721-6100; we will gladly guide you through the online purchasing process.
You will receive a receipt and an enrollment confirmation sent to the email you submitted at purchase. Your enrollment email will have instructions on how to access the class. Any additional questions our team is here to support you. Please call us at 469-721-6100.
If a student is 15 minutes late, they risk losing their seat to a standby student. If a student is 30 minutes late or more, they will need to reschedule. A no-show fee will apply. Retakes are enrolled on a stand-by basis. The student must supply previously issued courseware. Additional fees may apply.
You will receive a ‘Certificate of Completion’ once you complete the class. If you purchased an exam voucher for the class, a team member from TOPTALENT LEARNING will reach out to discuss your readiness for the voucher and make arrangements to send it.