{"heading":"Contents","id":11896125,"theme":{"name":"none","colors":{"background":"#ffffff","button":"#103B64","buttonText":"#ffffff","heading":"#36434d","text":"#5e6971"},"background":{"blend":"multiply","blur":0,"contrast":75,"grayscale":100,"opacity":38,"url":null}},"button":{"text":null,"url":null},"enrollmentsClosed":false,"fileCounts":{"file":null,"text":"5 text files","video":"16 videos"},"includedHeading":"What's included?","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":"play-circle-o","title":"The Course Project","length":"1 min","filesize":"112 MB","preview":true,"download":false,"buttonText":{"closed":"Enrollment is closed","preview":"Preview","purchase":"Get access","view":"View"},"urls":{"purchase":"/data-studio-the-lazy-way/buy?term=full","visit":"/courses/data-studio-the-lazy-way/4852-the-basics/8506-the-course-project"}},{"id":8494,"icon":"play-circle-o","title":"Prepping a Google Sheet for Data Studio","length":"5 mins","filesize":"478 MB","preview":true,"download":false,"buttonText":{"closed":"Enrollment is closed","preview":"Preview","purchase":"Get access","view":"View"},"urls":{"purchase":"/data-studio-the-lazy-way/buy?term=full","visit":"/courses/data-studio-the-lazy-way/4852-the-basics/8494-prepping-a-google-sheet-for-data-studio"}},{"id":8501,"icon":"play-circle-o","title":"Connecting your Data Source","length":"4 mins","filesize":"202 MB","preview":false,"download":false,"buttonText":{"closed":"Enrollment is closed","preview":"Preview","purchase":"Get access","view":"View"},"urls":{"purchase":"/data-studio-the-lazy-way/buy?term=full","visit":"/courses/data-studio-the-lazy-way/4852-the-basics/8501-connecting-your-data-source"}},{"id":8498,"icon":"play-circle-o","title":"WTF are Dimensions and Metrics?","length":"6 mins","filesize":"316 MB","preview":true,"download":false,"buttonText":{"closed":"Enrollment is closed","preview":"Preview","purchase":"Get access","view":"View"},"urls":{"purchase":"/data-studio-the-lazy-way/buy?term=full","visit":"/courses/data-studio-the-lazy-way/4852-the-basics/8498-wtf-are-dimensions-and-metrics"}},{"id":8509,"icon":"play-circle-o","title":"Building your First Chart","length":"5 mins","filesize":"96.7 MB","preview":false,"download":false,"buttonText":{"closed":"Enrollment is closed","preview":"Preview","purchase":"Get access","view":"View"},"urls":{"purchase":"/data-studio-the-lazy-way/buy?term=full","visit":"/courses/data-studio-the-lazy-way/4852-the-basics/8509-building-your-first-chart"}},{"id":8505,"icon":"play-circle-o","title":"Adding Time Period Comparisons to your Chart","length":"4 mins","filesize":"114 MB","preview":false,"download":false,"buttonText":{"closed":"Enrollment is closed","preview":"Preview","purchase":"Get access","view":"View"},"urls":{"purchase":"/data-studio-the-lazy-way/buy?term=full","visit":"/courses/data-studio-the-lazy-way/4852-the-basics/8505-adding-time-period-comparisons-to-your-chart"}},{"id":9159,"icon":"file-text-o","title":"Quiz 1: Starting your Dashboard","length":null,"filesize":null,"preview":false,"download":false,"buttonText":{"closed":"Enrollment is closed","preview":"Preview","purchase":"Get access","view":"View"},"urls":{"purchase":"/data-studio-the-lazy-way/buy?term=full","visit":"/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":"play-circle-o","title":"The Dark Art of Date and Filter Controls","length":"6 mins","filesize":"101 MB","preview":true,"download":false,"buttonText":{"closed":"Enrollment is closed","preview":"Preview","purchase":"Get access","view":"View"},"urls":{"purchase":"/data-studio-the-lazy-way/buy?term=full","visit":"/courses/data-studio-the-lazy-way/4855-getting-fancy/8507-the-dark-art-of-date-and-filter-controls"}},{"id":8497,"icon":"play-circle-o","title":"Coding up a Calculated Column","length":"7 mins","filesize":"383 MB","preview":true,"download":false,"buttonText":{"closed":"Enrollment is closed","preview":"Preview","purchase":"Get access","view":"View"},"urls":{"purchase":"/data-studio-the-lazy-way/buy?term=full","visit":"/courses/data-studio-the-lazy-way/4855-getting-fancy/8497-coding-up-a-calculated-column"}},{"id":8504,"icon":"play-circle-o","title":"Styling your Bar Charts","length":"5 mins","filesize":"120 MB","preview":false,"download":false,"buttonText":{"closed":"Enrollment is closed","preview":"Preview","purchase":"Get access","view":"View"},"urls":{"purchase":"/data-studio-the-lazy-way/buy?term=full","visit":"/courses/data-studio-the-lazy-way/4855-getting-fancy/8504-styling-your-bar-charts"}},{"id":8508,"icon":"play-circle-o","title":"Styling a Scatterplot Chart","length":"5 mins","filesize":"81.4 MB","preview":false,"download":false,"buttonText":{"closed":"Enrollment is closed","preview":"Preview","purchase":"Get access","view":"View"},"urls":{"purchase":"/data-studio-the-lazy-way/buy?term=full","visit":"/courses/data-studio-the-lazy-way/4855-getting-fancy/8508-styling-a-scatterplot-chart"}},{"id":9160,"icon":"file-text-o","title":"Quiz 2: Filters and Calculated Columns","length":null,"filesize":null,"preview":false,"download":false,"buttonText":{"closed":"Enrollment is closed","preview":"Preview","purchase":"Get access","view":"View"},"urls":{"purchase":"/data-studio-the-lazy-way/buy?term=full","visit":"/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":"play-circle-o","title":"Report vs Page-Level Elements","length":"5 mins","filesize":"251 MB","preview":true,"download":false,"buttonText":{"closed":"Enrollment is closed","preview":"Preview","purchase":"Get access","view":"View"},"urls":{"purchase":"/data-studio-the-lazy-way/buy?term=full","visit":"/courses/data-studio-the-lazy-way/4857-reaching-the-summit/8499-report-vs-page-level-elements"}},{"id":8503,"icon":"play-circle-o","title":"Counting in Calculated Columns","length":"4 mins","filesize":"199 MB","preview":false,"download":false,"buttonText":{"closed":"Enrollment is closed","preview":"Preview","purchase":"Get access","view":"View"},"urls":{"purchase":"/data-studio-the-lazy-way/buy?term=full","visit":"/courses/data-studio-the-lazy-way/4857-reaching-the-summit/8503-counting-in-calculated-columns"}},{"id":8500,"icon":"play-circle-o","title":"Using the CASE function in calculated columns","length":"7 mins","filesize":"203 MB","preview":false,"download":false,"buttonText":{"closed":"Enrollment is closed","preview":"Preview","purchase":"Get access","view":"View"},"urls":{"purchase":"/data-studio-the-lazy-way/buy?term=full","visit":"/courses/data-studio-the-lazy-way/4857-reaching-the-summit/8500-using-the-case-function-in-calculated-columns"}},{"id":8502,"icon":"play-circle-o","title":"Working with Dates in Calculated Columns","length":"6 mins","filesize":"120 MB","preview":false,"download":false,"buttonText":{"closed":"Enrollment is closed","preview":"Preview","purchase":"Get access","view":"View"},"urls":{"purchase":"/data-studio-the-lazy-way/buy?term=full","visit":"/courses/data-studio-the-lazy-way/4857-reaching-the-summit/8502-working-with-dates-in-calculated-columns"}},{"id":8510,"icon":"play-circle-o","title":"Filtering on the Fly","length":"5 mins","filesize":"78.4 MB","preview":false,"download":false,"buttonText":{"closed":"Enrollment is closed","preview":"Preview","purchase":"Get access","view":"View"},"urls":{"purchase":"/data-studio-the-lazy-way/buy?term=full","visit":"/courses/data-studio-the-lazy-way/4857-reaching-the-summit/8510-filtering-on-the-fly"}},{"id":9162,"icon":"file-text-o","title":"Quiz 3: Taking Calculated Columns to the Limit","length":null,"filesize":null,"preview":false,"download":false,"buttonText":{"closed":"Enrollment is closed","preview":"Preview","purchase":"Get access","view":"View"},"urls":{"purchase":"/data-studio-the-lazy-way/buy?term=full","visit":"/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":"play-circle-o","title":"A Word of Caution","length":"4 mins","filesize":"559 MB","preview":false,"download":false,"buttonText":{"closed":"Enrollment is closed","preview":"Preview","purchase":"Get access","view":"View"},"urls":{"purchase":"/data-studio-the-lazy-way/buy?term=full","visit":"/courses/data-studio-the-lazy-way/4853-putting-data-studio-into-action/8495-a-word-of-caution"}},{"id":9101,"icon":"file-text-o","title":"Building an Ad Campaign Dashboard with Supermetrics","length":null,"filesize":null,"preview":true,"download":false,"buttonText":{"closed":"Enrollment is closed","preview":"Preview","purchase":"Get access","view":"View"},"urls":{"purchase":"/data-studio-the-lazy-way/buy?term=full","visit":"/courses/data-studio-the-lazy-way/4853-putting-data-studio-into-action/9101-building-an-ad-campaign-dashboard-with-supermetrics"}},{"id":9102,"icon":"file-text-o","title":"Visualizing your Mailchimp Data with Apps Script","length":null,"filesize":null,"preview":true,"download":false,"buttonText":{"closed":"Enrollment is closed","preview":"Preview","purchase":"Get access","view":"View"},"urls":{"purchase":"/data-studio-the-lazy-way/buy?term=full","visit":"/courses/data-studio-the-lazy-way/4853-putting-data-studio-into-action/9102-visualizing-your-mailchimp-data-with-apps-script"}}]}],"showFileCount":true}