🔏
Faria Developer's Portal
  • Landing Page
  • Sweating the Details
    • Sweating the Details of the APIs
      • Set up Postman
      • Example Uses
    • Data Management
  • Getting Started with Google Data Studio
    • Setup raw data
      • Prepare Google Spreadsheet
      • Download from ManageBac
      • Use mb_excelexport_2csv tool
      • Placeholder
    • Re-shape raw data into DS-friendly format
    • Connect to GDS
Powered by GitBook
On this page

Was this helpful?

  1. Getting Started with Google Data Studio

Re-shape raw data into DS-friendly format

PreviousPlaceholderNextConnect to GDS

Last updated 3 years ago

Was this helpful?

Now that the raw data is in the spreadsheet, you need to shape the data so that the data is normalized, with consistent headers.

The spreadsheet provides a Term Grades menu with a handy conversion tool, written by Daniel Costich. Click on it here:

That will create a new sheet with the data as required: