Previous Lecture Complete and continue  

  Lesson 7: The raw data

The raw dataset for our dashboard can be accessed here:

Static Sales Dashboard Raw Data - Google Sheet

Click the link above to open and make a copy of the sheet containing the raw data.

Learning Objectives for this lesson:

  • Understand the raw data --> Tell the story of one row
  • Freeze panes for easier navigation of our dataset
  • Prepare the data for our dashboard
  • Understand the YEAR() and MONTH() formulas

Resources:

Link to the official Google documentation on the YEAR() formula

Link to the official Google documentation on the MONTH() formula