Details

<p>Introduction xv</p> <p><b>Part I Data Studio Basics 1</b></p> <p><b>Chapter 1 Data Studio and the Data Citizen 3</b></p> <p>Data, Data Everywhere 4</p> <p>Accessibility of Data 4</p> <p>Deriving Value from Data 5</p> <p>The Role of Data Studio 7</p> <p>A Brief History of Data Studio 9</p> <p>Fundamentals First 12</p> <p>Where to Go for Help 12</p> <p>Time to Get Started! 13</p> <p><b>Chapter 2 Cooking with Google Data Studio 15</b></p> <p>Our First Example 15</p> <p>Step 1. Select a Dish to Prepare: Visualizing a Bank Account 16</p> <p>Before We Start: Things You’ll Need 19</p> <p>Step 2. Let’s Go Shopping! Getting the Data 19</p> <p>Step 3. Unpack the Groceries: Setting Up Google Drive 21</p> <p>Step 4. Preparing the Ingredients: Working with Google Sheets 22</p> <p>Step 5. Familiarizing Yourself with the Kitchen: Data Studio Home Screen and Starting a New Report 25</p> <p>Step 6. Assemble the Ingredients: Connecting the Data to the Report 28</p> <p>Step 7. Set the Table: Adding Your First Chart 35</p> <p>Step 8. Keep Score with Scorecards 40</p> <p>Step 9. It’s About Time: Building the Time-Series Chart 45</p> <p>Step 10. Serving Suggestions: Finishing Touches and Sharing Your Report 50</p> <p>Summary 55</p> <p><b>Chapter 3 Enhancing Basic Graphs 57</b></p> <p>Static Report Design 57</p> <p>Before Getting Started: Things You’ll Need 59</p> <p>Step 1. Copy the Report 60</p> <p>Step 2. Modify the Header and Set the Date Range 61</p> <p>Step 3. Modify Scorecards 63</p> <p>Step 4. Modify Time-Series Chart 65</p> <p>Step 5. Modify the Transactions Table 66</p> <p>Step 6. Save the Report as PDF for Sharing 69</p> <p>Summary 70</p> <p><b>Chapter 4 Data Exploration with Interactive Elements 73</b></p> <p>Building Our Workbench Example 73</p> <p>Step 1. Selecting a Dish to Prepare: Exploration Workbench for a Bank Account 74</p> <p>Step 2. Let’s Go Shopping! Getting the Data Set 77</p> <p>Step 3. Assembling the Ingredients: Connecting Data to the Report 78</p> <p>Adding Chart Components and Graphic Elements 82</p> <p>Step 4. Reuse, Recycle, and Repurpose: Copying Elements from Other Reports 82</p> <p>Step 5. Easy as Pie! Adding a Pie Chart 84</p> <p>Step 6. Step Up to the Bar: Adding the Bar Chart 85</p> <p>Step 7. Lining Things Up: Adding the Line Chart 90</p> <p>Step 8. Tables, Again!? Setting Up the Table 91</p> <p>Adding and Configuring Filter Controls 92</p> <p>Step 9. Fun with Filters: Setting Up the Standard Filter Controls 92</p> <p>Tips for Using Interactive Filters 94</p> <p>Find the Answers: Filter Challenge 95</p> <p>Summary 97</p> <p><b>Part II Business and Marketing Applications 99</b></p> <p><b>Chapter 5 Web Data Visualization with Google Analytics 101</b></p> <p>Google Services for Websites and Business 102</p> <p>A Brief Primer for Google Analytics 104</p> <p>Using a Template to Create a New Report 106</p> <p>Building the Google Analytics Report 110</p> <p>Modifying the Charts 112</p> <p>Working with the New Report 117</p> <p>A Real-World Example: The Effects of a Beach Party in Spain on Web Traffic 117</p> <p>The Limits of Demographic Data from Google Analytics 124</p> <p>Now for a Side Dish: Adding a Page and Using Filters 126</p> <p>Summary 132</p> <p><b>Chapter 6 Using Google Search Console for Audience Insights 135</b></p> <p>Search Console and Search Results Pages 136</p> <p>Creating a Search Console Report with Data Studio 141</p> <p>Step 1. Selecting the Dish to Prepare 142</p> <p>Step 2. Let’s Go Shopping! 144</p> <p>Step 3. Assemble the Ingredients 147</p> <p>Step 4. Setting the Table 153</p> <p>Bon Appetite! Using the Search Console Report 157</p> <p>An Example for Your Soul! 161</p> <p>Summary 170</p> <p><b>Chapter 7 Viewing Local Organization Data from Google My Business 173</b></p> <p>Google Search and the Local Organization 173</p> <p>GMB: The New Home Page in the Search Results 175</p> <p>What the User Sees in a GMB Listing 176</p> <p>What the Owner Sees in a GMB Listing 180</p> <p>Why Use Data Studio for GMB? 185</p> <p>Step 1. Selecting the Dish to Prepare 187</p> <p>The Actions Page 189</p> <p>The Reviews Page 190</p> <p>The Search Page 192</p> <p>Before You Begin: What You Need to Get Started 194</p> <p>Step 2. Let’s Go Shopping and Assemble the Ingredients 195</p> <p>Step 3. Setting the Table 202</p> <p>Report, Page, and Header Setup 203</p> <p>Page Navigation Button Setup 206</p> <p>Building the Actions Page 209</p> <p>Building the Search Page 213</p> <p>Building the Reviews Page 215</p> <p>Summary 218</p> <p><b>Part III Beyond the Office 221</b></p> <p><b>Chapter 8 Getting Personal 223</b></p> <p>Creating Your Own Data 223</p> <p>Using Google Forms to Collect Your Own Data 225</p> <p>Curating Data from Other Sources 248</p> <p>Setting Up IFTTT to Capture Tweets 250</p> <p>Preparing the Google Sheet for Data Studio 256</p> <p>Create a Data Source for the Google Sheet 256</p> <p>Create the New Twitter Report 258</p> <p>Working with Data Generated for You 262</p> <p>Music Service Tracking Example 262</p> <p>Google Fit Community Connector Example 269</p> <p>Community Connector Setup for Google Fit 270</p> <p>Bringing It All Together 280</p> <p>Created Data 280</p> <p>Curated Data 283</p> <p>Generated Data 284</p> <p>Summary 288</p> <p><b>Chapter 9 Going Public 291</b></p> <p>Shared Data Sets 291</p> <p>Searching for Data Sets 292</p> <p>Getting Data from Kaggle 294</p> <p>Using a Kaggle Account 294</p> <p>Building the UFO Sightings Workbench 302</p> <p>Dealing with Performance Issues in Reports 307</p> <p>Using the Extract Data Connector to Speed Up Reports 307</p> <p>data.world and Makeover Monday 314</p> <p>Bringing It Home: Real Estate in Your Neighborhood 330</p> <p>Selecting the Dish to Prepare 331</p> <p>Going Shopping: Hunting for Housing Data 332</p> <p>Unpacking the Groceries: Moving the File to Google Drive 337</p> <p>Preparing the Ingredients: Fixing Data Formatting Issues 338</p> <p>Assembling the Ingredients: Connecting the Data to the Report 340</p> <p>Preparing the Meal: The Plan Meets Reality 340</p> <p>Sharing Your Dish: Embedding Reports 346</p> <p>Embedding a Report in a Google Site 351</p> <p>Embedding a Report in a WordPress Site 353</p> <p>Dealing with Pivoted Data 356</p> <p>Summary 361</p> <p><b>Chapter 10 Where Do You Go from Here? 363</b></p> <p>Helping Your Audience See the Light 363</p> <p>Annotation Ideas for Static Reports 364</p> <p>Annotation Ideas for Interactive Reports 367</p> <p>Providing Detailed Instructions for Users 371</p> <p>Community Visualizations 375</p> <p>Data Studio as an Application Development Platform 377</p> <p>Exotic Ingredients and Your Pantry 383</p> <p>Data Blending 383</p> <p>File Upload 388</p> <p>BigQuery for Big Data 390</p> <p>Community Connectors 395</p> <p>The Latest Dishes: New Developments and Releases 396</p> <p>Summary 396</p> <p>Index 399</p>

<p><b>LEE HURST</b> began doing application development in 1995 as a consultant, later joining IBM where he worked as a web application developer. Since 2006 he has worked for EnPro Industries building custom eCommerce solutions and consulting for global web development, analytics solutions, and SEO. He assists small businesses and agencies through his Helpfullee website, and maintains the Google Data Studio Resource Finder, a free service he created in 2017.

<p><b>Easily transform your data into engaging, interactive visual reports!</b> <p>You don't have to be a tech professional or large corporation to visualize all kinds of data and share eye-catching reports with colleagues and clients. Thanks to the free, widely-popular Google Data Studio visualization tool, anyone with a Gmail account and a little know-how can transform data into interactive, easily-shared knowledge. Celebrated for its power and flexibility, Google Data Studio turns immense amounts of data into beautiful, easy-to-understand visual reports. <i>Hands On With Google Data Studio</i> teaches you how to visualize your data today and produce professional results in no time—no previous experience required! <p>Written with beginners in mind, this clear, reader-friendly guide provides step-by-step instructions that will help you discover business trends, turn your budget data into interactive reports, evaluate the performance of your websites or business listings, and much more. An abundance of real-world examples, expert advice, and practical activities develop the data visualization skills you need to gather public and private data, come to your own conclusions, and share your insights with others. This invaluable guide teaches you everything you need to know to take control of your data and become a data citizen pro. A must-have resource for anyone looking to visualize their data—from individuals, consultants, and small business owners to corporate managers and organization leaders—<i>Hands On With Google Data Studio</i> will help you: <ul> <li><b> Learn the fundamentals of data visualization and personal data accessibility</b></li> <li><b> Access various types of data with Google Data Studio</b></li> <li><b> Use open data API's from numerous public sources</b></li> <li><b> Navigate the Data Studio interface and build your first data set</b></li> <li><b> Add visual interest with banners, logos, custom graphics, and color palettes</b></li> </ul>

US