{"preheading":null,"heading":null,"subheading":null,"id":11896125,"theme":{"name":"none","colors":{"background":"#ffffff","button":"#103B64","buttonText":"#ffffff","heading":"#0d161b","text":"#0d161b"},"background":{"blend":"multiply","blur":0,"contrast":75,"grayscale":100,"opacity":38,"url":null},"fonts":{"bodyFont":{"family":"Merriweather","height":"1.75","weight":"400","spacing":"0"},"buttonFont":{"family":"Merriweather","height":"1.75","weight":"400","spacing":"0"},"headingFont":{"family":"Merriweather","height":"1.25","weight":"900","spacing":"0"},"formInputFont":{"family":"Merriweather","height":"1.75","weight":"400","spacing":"0"},"navigationFont":{"family":"Merriweather","height":"1.75","weight":"400","spacing":"0"},"preheadingFont":{"family":"Merriweather","height":"1.75","weight":"400","spacing":"0"},"subheadingFont":{"family":"Merriweather","height":"1.75","weight":"400","spacing":"0"}}},"button":{"text":"View product","url":null},"button2":{"text":null,"url":null},"buttonSubtext":null,"collectionLayout":"collection-layout-columns-left","contentAlignment":"content-alignment-left","header":{"pretitle":null,"title":"Contents","subtitle":null,"text":null,"button":{"text":null,"url":null},"button2":{"text":null,"url":null},"buttonSubtext":null},"mediaStyle":"media-style-plain","preLaunch":false,"products":null,"sections":[{"id":4677,"default":true,"name":"Contents","description":null,"blocks":[]},{"id":4852,"default":false,"name":"The Basics","description":"

Laying the foundation for a solid Data Studio dashboard - your data.
This section covers the nuances formatting and importing data correctly into Data Studio, and creating basic charts using that data.

","blocks":[{"id":8506,"icon":"video","title":"The Course Project","length":"1 min","filesize":"112 MB","preview":true,"download":false,"buttonText":{"preview":"Preview","view":"View"},"urls":{"visit":"/view/courses/data-studio-the-lazy-way/4852-the-basics/8506-the-course-project"}},{"id":8494,"icon":"video","title":"Prepping a Google Sheet for Data Studio","length":"5 mins","filesize":"478 MB","preview":true,"download":false,"buttonText":{"preview":"Preview","view":"View"},"urls":{"visit":"/view/courses/data-studio-the-lazy-way/4852-the-basics/8494-prepping-a-google-sheet-for-data-studio"}},{"id":8501,"icon":"video","title":"Connecting your Data Source","length":"4 mins","filesize":"202 MB","preview":false,"download":false,"buttonText":{"preview":"Preview","view":"View"},"urls":{"visit":"/view/courses/data-studio-the-lazy-way/4852-the-basics/8501-connecting-your-data-source"}},{"id":8498,"icon":"video","title":"WTF are Dimensions and Metrics?","length":"6 mins","filesize":"316 MB","preview":true,"download":false,"buttonText":{"preview":"Preview","view":"View"},"urls":{"visit":"/view/courses/data-studio-the-lazy-way/4852-the-basics/8498-wtf-are-dimensions-and-metrics"}},{"id":8509,"icon":"video","title":"Building your First Chart","length":"5 mins","filesize":"96.7 MB","preview":false,"download":false,"buttonText":{"preview":"Preview","view":"View"},"urls":{"visit":"/view/courses/data-studio-the-lazy-way/4852-the-basics/8509-building-your-first-chart"}},{"id":8505,"icon":"video","title":"Adding Time Period Comparisons to your Chart","length":"4 mins","filesize":"114 MB","preview":false,"download":false,"buttonText":{"preview":"Preview","view":"View"},"urls":{"visit":"/view/courses/data-studio-the-lazy-way/4852-the-basics/8505-adding-time-period-comparisons-to-your-chart"}},{"id":9159,"icon":"content-text","title":"Quiz 1: Starting your Dashboard","length":null,"filesize":null,"preview":false,"download":false,"buttonText":{"preview":"Preview","view":"View"},"urls":{"visit":"/view/courses/data-studio-the-lazy-way/4852-the-basics/9159-quiz-1-starting-your-dashboard"}}]},{"id":4855,"default":false,"name":"Getting Fancy","description":"

Diving into calculated columns and filters, the secret weapons embedded in Data Studio.

We'll use them to calculate new metrics based on our raw data, and build some more interesting visualizations (like scatterplots) with our newfound data prowess.

","blocks":[{"id":8507,"icon":"video","title":"The Dark Art of Date and Filter Controls","length":"6 mins","filesize":"101 MB","preview":true,"download":false,"buttonText":{"preview":"Preview","view":"View"},"urls":{"visit":"/view/courses/data-studio-the-lazy-way/4855-getting-fancy/8507-the-dark-art-of-date-and-filter-controls"}},{"id":8497,"icon":"video","title":"Coding up a Calculated Column","length":"7 mins","filesize":"383 MB","preview":true,"download":false,"buttonText":{"preview":"Preview","view":"View"},"urls":{"visit":"/view/courses/data-studio-the-lazy-way/4855-getting-fancy/8497-coding-up-a-calculated-column"}},{"id":8504,"icon":"video","title":"Styling your Bar Charts","length":"5 mins","filesize":"120 MB","preview":false,"download":false,"buttonText":{"preview":"Preview","view":"View"},"urls":{"visit":"/view/courses/data-studio-the-lazy-way/4855-getting-fancy/8504-styling-your-bar-charts"}},{"id":8508,"icon":"video","title":"Styling a Scatterplot Chart","length":"5 mins","filesize":"81.4 MB","preview":false,"download":false,"buttonText":{"preview":"Preview","view":"View"},"urls":{"visit":"/view/courses/data-studio-the-lazy-way/4855-getting-fancy/8508-styling-a-scatterplot-chart"}},{"id":9160,"icon":"content-text","title":"Quiz 2: Filters and Calculated Columns","length":null,"filesize":null,"preview":false,"download":false,"buttonText":{"preview":"Preview","view":"View"},"urls":{"visit":"/view/courses/data-studio-the-lazy-way/4855-getting-fancy/9160-quiz-2-filters-and-calculated-columns"}}]},{"id":4857,"default":false,"name":"Reaching the Summit","description":"

Diving *really* deep into Data Studio's most powerful features: filter controls and calculated columns.

You'll learn to write CASE statements, work with dates, and create dashboard-level filters.

","blocks":[{"id":8499,"icon":"video","title":"Report vs Page-Level Elements","length":"5 mins","filesize":"251 MB","preview":true,"download":false,"buttonText":{"preview":"Preview","view":"View"},"urls":{"visit":"/view/courses/data-studio-the-lazy-way/4857-reaching-the-summit/8499-report-vs-page-level-elements"}},{"id":8503,"icon":"video","title":"Counting in Calculated Columns","length":"4 mins","filesize":"199 MB","preview":false,"download":false,"buttonText":{"preview":"Preview","view":"View"},"urls":{"visit":"/view/courses/data-studio-the-lazy-way/4857-reaching-the-summit/8503-counting-in-calculated-columns"}},{"id":8500,"icon":"video","title":"Using the CASE function in calculated columns","length":"7 mins","filesize":"203 MB","preview":false,"download":false,"buttonText":{"preview":"Preview","view":"View"},"urls":{"visit":"/view/courses/data-studio-the-lazy-way/4857-reaching-the-summit/8500-using-the-case-function-in-calculated-columns"}},{"id":8502,"icon":"video","title":"Working with Dates in Calculated Columns","length":"6 mins","filesize":"120 MB","preview":false,"download":false,"buttonText":{"preview":"Preview","view":"View"},"urls":{"visit":"/view/courses/data-studio-the-lazy-way/4857-reaching-the-summit/8502-working-with-dates-in-calculated-columns"}},{"id":8510,"icon":"video","title":"Filtering on the Fly","length":"5 mins","filesize":"78.4 MB","preview":false,"download":false,"buttonText":{"preview":"Preview","view":"View"},"urls":{"visit":"/view/courses/data-studio-the-lazy-way/4857-reaching-the-summit/8510-filtering-on-the-fly"}},{"id":9162,"icon":"content-text","title":"Quiz 3: Taking Calculated Columns to the Limit","length":null,"filesize":null,"preview":false,"download":false,"buttonText":{"preview":"Preview","view":"View"},"urls":{"visit":"/view/courses/data-studio-the-lazy-way/4857-reaching-the-summit/9162-quiz-3-taking-calculated-columns-to-the-limit"}}]},{"id":4853,"default":false,"name":"Putting Data Studio into Action","description":"

Case studies (and words of wisdom) for implementing Data Studio into your daily workflow.

","blocks":[{"id":8495,"icon":"video","title":"A Word of Caution","length":"4 mins","filesize":"559 MB","preview":false,"download":false,"buttonText":{"preview":"Preview","view":"View"},"urls":{"visit":"/view/courses/data-studio-the-lazy-way/4853-putting-data-studio-into-action/8495-a-word-of-caution"}},{"id":9101,"icon":"content-text","title":"Building an Ad Campaign Dashboard with Supermetrics","length":null,"filesize":null,"preview":true,"download":false,"buttonText":{"preview":"Preview","view":"View"},"urls":{"visit":"/view/courses/data-studio-the-lazy-way/4853-putting-data-studio-into-action/9101-building-an-ad-campaign-dashboard-with-supermetrics"}},{"id":9102,"icon":"content-text","title":"Visualizing your Mailchimp Data with Apps Script","length":null,"filesize":null,"preview":true,"download":false,"buttonText":{"preview":"Preview","view":"View"},"urls":{"visit":"/view/courses/data-studio-the-lazy-way/4853-putting-data-studio-into-action/9102-visualizing-your-mailchimp-data-with-apps-script"}}]}],"toggles":{"itemIcons":true,"itemDetails":true,"sectionDescriptions":true,"sectionToggles":false,"open":false},"buttonText":"View product"}