The Looker BI course is designed for business analysts, data analysts, and BI developers who wish to harness the power of Looker to explore, analyze, and visualize data in a user-friendly and interactive environment. Looker is a modern data platform that enables businesses to gain real-time insights through powerful reporting, data visualization, and dashboard creation.
In this course, you will learn how to connect Looker to data sources, model data using LookML, and create advanced reports and dashboards. You will also explore Looker’s data exploration features, build custom visualizations, and understand how to share and schedule reports effectively.
Introduction to Looker BI platform and its features.
Learn how to set up and configure connections to various data sources.
Understand the process of creating and managing model files in Looker.
Learn how to create and manage projects within Looker.
Learn the concept of parameters and how to use them in Looker.
This section covers the different types of parameters in Looker:
Learn how to create and manage views in Looker.
Learn how to create and manage explores in Looker.
Learn to create and configure model files in Looker.
Understand the validate process and explore use cases in Looker.
Understand Git integration and Git Actions in Looker with real-world use cases.
Learn how metadata is used in Looker and the functionality of Quick Help for better user experience.
Discover the functionality of the Field Picker in Looker for selecting fields to work with.
Learn how to create and use custom fields, including custom dimensions and custom measures.
Creating and using custom dimensions in Looker to enhance your data exploration.
Creating custom measures in Looker for specific metrics and calculations.
Learn to create table calculations in Looker to manipulate data directly within your reports.
Explore different methods to create custom fields in Looker.
Understand the role of the Data Tab in Looker’s Explore interface for data management and analysis.
Learn about Looker's visualization features and the various types of visuals available.
Understand the different types of filters available across Looker’s IDE, Explore, UI, and Dashboards.
Learn how to save reports, send them, share with users, and schedule for regular delivery.
Learn how to access LookML code in Looker for more advanced customization and development.
Merge results from multiple queries in Looker for better data aggregation.
Learn how to pivot your data in Looker to create better insights and visualizations.
Learn how to manage row and column limits in your Looker reports for better performance.
Learn how to configure totals and subtotals for a more comprehensive report in Looker.
Explore different types of folders in Looker and how to organize your projects efficiently.
Understand the key differences between LookML dashboards and user-defined dashboards in Looker.
Learn about blocks in Looker and how they can enhance your reporting and dashboards.
Understand the concept of applications in Looker and how they enhance user experience.
Learn the differences between boards and dashboards and when to use each in Looker.
Learn how to create customized dashboards for your Looker projects.
Learn how to apply and manage filters in Looker dashboards to focus on specific data sets.
Learn how cross filtering works in Looker for better data exploration.
Learn how to set up alerts for your Looker reports based on data thresholds.
Learn how to add visualizations to your dashboards for better data representation.
Explore the different types of visuals available in Looker for data visualization.
Understand the use of markdown in Looker for adding rich text formatting in dashboards.
Learn how to add buttons to dashboards for improved interactivity in Looker.
Explore the concept of "Run on Load" to auto-execute queries when dashboards load in Looker.
Learn how to set up automatic refresh for tiles within Looker dashboards.
Learn how to copy dashboards for easy duplication of settings and configurations.
Learn how to retrieve the LookML code from Looker to refine and use in custom development.
Explore how to download your dashboards in Looker and the types of formats available for export.
Learn how to delete dashboards that are no longer needed within Looker.
Understand the concept of data groups and how they help organize and manage data efficiently in Looker.
Learn about Looker's cache policies and how to control the data caching mechanism for better performance.
Learn what derived tables are and the different types available in Looker.
Understand what PDTs (Persistent Derived Tables) are and explore their types in Looker.
Learn about Liquid Language and how it is used for dynamic content in Looker.
Understand parameters and how they can be used for dynamic controls in Looker.
Learn how to create liquid parameters in Looker for better customization.
Understand the purpose of the manifest file and how it is used in Looker for customization.
Learn how the `extends` feature works in Looker and how it enables code reuse in LookML.
Learn the process of pushing code between environments in Looker for deployment purposes.