How to connect a data source to Google Data Studio
Google Data Studio allows you to create dashboards from any number of data sources: Adwords, BigQuery, MySQL, Google Analytics, Youtube and Google Sheets.
I usually dump data from many different sources into a Google Sheet, then connect it to Data Studio to create charts.
Once you connect a data source, you'll be prompted to check that your columns are being pulled in correctly. There are two things to watch out for:
1) Are columns being properly picked up as metrics or dimensions? Metrics are fields that can be counted (ie are numbers), and dimensions are fields that you'd use to group data by (usually text fields).
2) Are date fields being recognized properly? This is important, as you'll need a date field to make any type of time series charts.
This video is excerpted from my course, Data Analysis the Lazy Way, which teaches how to use Blockspring, Google Sheets and Data Studio to automate your reporting work. Learn more at https://goo.gl/CfCDzW