🔏
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

Setup raw data

PreviousGetting Started with Google Data StudioNextPrepare Google Spreadsheet

Last updated 3 years ago

Was this helpful?

There are a few steps here.

Steps
Description

Prepare your Google Spreadsheet

Make a copy of , which we'll use below.

Download from ManageBac

Go to Reporting —> Historical Reports and download the xls files provided there. (At the moment only PYP is currently supported.)

Either:

(A) Open the downloaded file in Excel to display the raw data … or

(B) Use tool to display the raw data without needing Excel.

Take the downloaded file and open it in such a way so that Google Spreadsheets can read it.

Either: (A) Copy and paste the displayed raw data and paste into Google Spreadsheet …  or (B) Save as CSV, and import into Google Spreadsheet

Bring the raw data into Google Spreadsheet

Prepare Google Spreadsheet
Download from ManageBac
Use mb_excelexport_2csv tool
Placeholder
this spreadsheet
mb_excelexport_2csv