Share Description
In this course, you will :
- Analyze data, design stunning visualizations, and create sophisticated reports and dashboards.
- Learn how to use Looker as a business intelligence and visualization tool.
- Learn about Looker's platform, interface, and terminology.
- Use Explores to go deeper into your data and uncover meaningful insights.
- Save your findings in custom reports or Looks that also illustrate your findings.
- Create filters and custom fields by hand using Looker expressions.
- Learn about Looker's data sharing and organization architecture and philosophy.
- Make elaborate dashboards with dynamic tiles that connect to one another.
Syllabus:
1. Environment
- Sample data walkthrough
- Reference material
- Sandbox environment setup
- Loading sample data into your Looker instance
- Looker terminology
2. Beginner - Explores
- Menu navigation
- Create an Explores
- Dimensions and fields
- Removing fields
- Sorting and adding totals
- Quick start analysis
- Pivot a field
3. Beginner - Visualizations
- Introduction to visualization
- Table visualization
- Freezing a table
- Bar and column visualization
- Scatter visualization
- Sizing dots in scatter visualization
- Pie chart visualizations
4. Beginner - Looks
- Create a Look
- Creating another Look and organize it
- Organize Looks
- Edit Looks and Look settings
- Looks drill downs and explorations
5. Intermediate - Filters
- Introduction to filters
- Add values in filter box
- Filters in dimensions and measures
- Operator statements
- Advanced matches and filter expressions
- Custom filters
6. Intermediate - Custom Fields
- Table calculations
- Percent of total
- Using quick calculations in visualizations
- Create a custom measure from a dimension
- Create custom fields using group, bin, and list
- Create a custom measure
- Create a custom dimension
7. Intermediate - Sharing and Organization
- Share and send data
- Public sharing of looks and iframes
- Schedule data
- Conditional schedule and alerts
- Folders
- Manage permissions
- Boards
- Create a Board
- Details about Boards
- Favourites and recently viewed
8. Expert - Advanced Visualizations
- Map visualization
- Single value visualization
- Single value questions
- Word cloud visualization
- Box plots visualization
9. Expert - Dashboards
- Introduction to dashboards
- Look-linked tiles
- Text tiles and markdown
- Edit, move, and modify tiles
- Note icon question
- Dashboard settings
- Filters in dashboards
- Filters conditionally applied
- Filter controls
- Advanced filters
- Linking and cascading filters
- Cross filtering
- End-to-end dashboard
10. Expert - Advanced Data Manipulation
- Offset expressions
- Rolling and moving averages
- Rolling and moving averages with List
- Aggregation expressions
