Google Sheets topics
12 short topics in Data Engineering and Analytics. Each one is a single focused exercise with a clear piece of evidence at the end.
12 topics, one exercise each.
Work through them in order, or jump to the one you need.
These are draft topic outlines (draft; instructor review pending). Full lessons follow after review; ask Ajay if you need a topic sooner.
- 01
Source connection and import
Inspect evidence for source connection and import in Google Sheets; explain the diagnosis and verify a proposed correction in a lab. Keep the exercise bounded and record the behavior supported by the chosen version.
Open micro-course → - 02
Table and relationship modeling
Inspect evidence for table and relationship modeling in Google Sheets; explain the diagnosis and verify a proposed correction in a lab. Keep the exercise bounded and record the behavior supported by the chosen version.
Open micro-course → - 03
Data cleaning and transformations
Inspect evidence for data cleaning and transformations in Google Sheets; explain the diagnosis and verify a proposed correction in a lab. Keep the exercise bounded and record the behavior supported by the chosen version.
Open micro-course → - 04
Calculated fields and measures
Inspect evidence for calculated fields and measures in Google Sheets; explain the diagnosis and verify a proposed correction in a lab. Keep the exercise bounded and record the behavior supported by the chosen version.
Open micro-course → - 05
Aggregation and filter context
Inspect evidence for aggregation and filter context in Google Sheets; explain the diagnosis and verify a proposed correction in a lab. Keep the exercise bounded and record the behavior supported by the chosen version.
Open micro-course → - 06
Dashboard and chart design
Inspect evidence for dashboard and chart design in Google Sheets; explain the diagnosis and verify a proposed correction in a lab. Keep the exercise bounded and record the behavior supported by the chosen version.
Open micro-course → - 07
Refresh and data freshness
Inspect evidence for refresh and data freshness in Google Sheets; explain the diagnosis and verify a proposed correction in a lab. Keep the exercise bounded and record the behavior supported by the chosen version.
Open micro-course → - 08
User and data access
Inspect evidence for user and data access in Google Sheets; explain the diagnosis and verify a proposed correction in a lab. Keep the exercise bounded and record the behavior supported by the chosen version.
Open micro-course → - 09
Business metric definitions
Inspect evidence for business metric definitions in Google Sheets; explain the diagnosis and verify a proposed correction in a lab. Keep the exercise bounded and record the behavior supported by the chosen version.
Open micro-course → - 10
Query and report performance
Inspect evidence for query and report performance in Google Sheets; explain the diagnosis and verify a proposed correction in a lab. Keep the exercise bounded and record the behavior supported by the chosen version.
Open micro-course → - 12
Report correctness verification
Inspect evidence for report correctness verification in Google Sheets; explain the diagnosis and verify a proposed correction in a lab. Keep the exercise bounded and record the behavior supported by the chosen version.
Open micro-course →
Learn the same ideas beyond Google Sheets.
These courses share topics with this one, so you can compare how each language or tool handles the same concept.
More in Business intelligence and enterprise applications.
You have the curiosity.
Let’s turn it into capability.
Start with a practical workshop or bring a specific question to Ajay.