Developing Data Models with LookML
This course empowers you to develop scalable, performant LookML (Looker Modeling Language) models that provide your business users with the standardized, ready-to-use data they need to answer their questions. Upon completing this course, you will be able to start building and maintaining LookML models to curate and manage data in your organization’s Looker instance.
Download training guide
Looking to upskill your team(s) or organization?
Nico will gladly help you further with custom training solutions.
Nico de Jonge
Training Advisor
What will you learn?
You will be able to create LookML models independently and equip your stakeholders with standardized, ready-to-use data to answer their questions. The training provides both a theoretical background on the inner workings of LookML and hands-on experience with the tool.
Requirements
Define LookML basic terms and building blocks
Use caching and data groups in Looker to speed up SQL queries
Create and design Explores to make data accessible to business users
Create dimensions and measures to curate data attributes used by business users
Key takeaways
- Define LookML basic terms and building blocks
- Use derived tables to instantaneously create new tables
- Use the Looker Integrated Development Environment (IDE) and project version control to modify LookML projects.
Program
The program consists of six modules that combine theory and practice.
- Introduction to Looker and LookML: LookML basics, Looker development environment
- Creating Dimensions and Measures: Dimensions and Measures
- Project Version Control: Git within Looker, project version control
- Model Files: SQL within Looker, Explores, joins, symmetric aggregations, filters
- Derived Tables: Derived Tables best practices
- Caching and Datagroups: Caching, Datagroups
Who is it for?
To get the most out of this course, participants should have a basic understanding of SQL, Git, and the Looker business user experience. For learners with no previous experience as data explorers in Looker, it is recommended first to complete Analyzing and Visualizing Data in Looker.
Requirements
Data developers who are responsible for data curation and management within their organizations.
Data analysts interested in learning how data developers use LookML to curate and manage data in their organization’s Looker instance.
Why should I do this training?
Become an expert in the field
Working with Power BI gives you more insight in to lorem ipsum dolor sit amet….
Reach your company’s goals
Working with Power BI gives you more insight in to lorem ipsum dolor sit amelorem ipsum dolor sit amet….
Earn your data certificates
Working with Power BI gives you more insight in to lorolor sit amet….
What does it look like?
What else should I know?
Virtual or in-person training: This training can be delivered both in-person and online. When hosting the in-person training, we provide lunch, snacks, and drinks to the participants. Accordingly, there is a discount for virtual trainings.
If you want to work with your data during the final part of the program, please bring your own data set.
The training requires a laptop.
This course is brought to you by Xebia Data.
Literature and a nice lunch are included in the price.
After registering for this training, you will receive a confirmation email with practical information. A week before the training, we will ask you about any dietary requirements and share literature if there’s a need to prepare.
See you soon!
Course information
Travel and accommodation expenses are not included.
You need to bring your own laptop for this training.
Meet the trainer
Also interesting for you
View all training coursesMaster the art of goal-setting with our OKR training – practical, insightful, and applicable for all backgrounds. Achieve better outcomes with clear objectives & key results!
Discover OKRs – the popular goal-setting framework through hands-on training. Achieve better outcomes with clear objectives & key results!
Discover how to boost the value of your product by leveraging the power of Artificial Intelligence (AI). In two days, you will become comfortable with the black box that is AI and learn how to extract value from data by enhancing your collaboration with Data (Science) or Analytics teams in your organization that build AI.
The Product Backlog is an emergent, ordered list of what is needed to improve the product. It is the single source of work undertaken by the Scrum Team.
