{"product_id":"hands-on-with-google-data-studio-isbn-9781119616085","title":"Hands On With Google Data Studio","description":"\u003cp\u003e\u003cb\u003eLearn how to easily transform your data into engaging, interactive visual reports!\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eData is no longer the sole domain of tech professionals and scientists. Whether in our personal, business, or community lives, data is rapidly increasing in both importance and sheer volume. The ability to visualize all kinds of data is now within reach for anyone with a computer and an internet connection. Google Data Studio, quickly becoming the most popular free tool in data visualization, offers users a flexible, powerful way to transform private and public data into interactive knowledge that can be easily shared and understood. \u003ci\u003eHands On With Google Data Studio \u003c\/i\u003eteaches you how to visualize your data \u003ci\u003etoday\u003c\/i\u003e and produce professional quality results quickly and easily. \u003c\/p\u003e \u003cp\u003eNo previous experience is required to get started right away—all you need is this guide, a Gmail account, and a little curiosity to access and visualize data just like large businesses and organizations. Clear, step-by-step instructions help you identify business trends, turn budget data into a report, assess how your websites or business listings are performing, analyze public data, and much more. Practical examples and expert tips are found throughout the text to help you fully understand and apply your new knowledge to a wide array of real-world scenarios. This engaging, reader-friendly guide will enable you to:\u003c\/p\u003e \u003cul\u003e \u003cli\u003eUse Google Data Studio to access various types of data, from your own personal data to public sources\u003c\/li\u003e \u003cli\u003eBuild your first data set, navigate the Data Studio interface, customize reports, and share your work\u003c\/li\u003e \u003cli\u003eLearn the fundamentals of data visualization, personal data accessibility, and open data API's\u003c\/li\u003e \u003cli\u003eHarness the power of publicly accessible data services including Google’s recently released Data Set Search\u003c\/li\u003e \u003cli\u003eAdd banners, logos, custom graphics, and color palettes\u003c\/li\u003e \u003c\/ul\u003e \u003cp\u003e\u003ci\u003eHands On With Google Data Studio: A Data Citizens Survival Guide \u003c\/i\u003eis a must-have resource for anyone starting their data visualization journey, from individuals, consultants, and small business owners to large business and organization managers and leaders.\u003c\/p\u003e \u003cp\u003e \u003c\/p\u003e \u003cp\u003eIntroduction xv\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart I Data Studio Basics 1\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 1 Data Studio and the Data Citizen 3\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eData, Data Everywhere 4\u003c\/p\u003e \u003cp\u003eAccessibility of Data 4\u003c\/p\u003e \u003cp\u003eDeriving Value from Data 5\u003c\/p\u003e \u003cp\u003eThe Role of Data Studio 7\u003c\/p\u003e \u003cp\u003eA Brief History of Data Studio 9\u003c\/p\u003e \u003cp\u003eFundamentals First 12\u003c\/p\u003e \u003cp\u003eWhere to Go for Help 12\u003c\/p\u003e \u003cp\u003eTime to Get Started! 13\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 2 Cooking with Google Data Studio 15\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eOur First Example 15\u003c\/p\u003e \u003cp\u003eStep 1. Select a Dish to Prepare: Visualizing a Bank Account 16\u003c\/p\u003e \u003cp\u003eBefore We Start: Things You’ll Need 19\u003c\/p\u003e \u003cp\u003eStep 2. Let’s Go Shopping! Getting the Data 19\u003c\/p\u003e \u003cp\u003eStep 3. Unpack the Groceries: Setting Up Google Drive 21\u003c\/p\u003e \u003cp\u003eStep 4. Preparing the Ingredients: Working with Google Sheets 22\u003c\/p\u003e \u003cp\u003eStep 5. Familiarizing Yourself with the Kitchen: Data Studio Home Screen and Starting a New Report 25\u003c\/p\u003e \u003cp\u003eStep 6. Assemble the Ingredients: Connecting the Data to the Report 28\u003c\/p\u003e \u003cp\u003eStep 7. Set the Table: Adding Your First Chart 35\u003c\/p\u003e \u003cp\u003eStep 8. Keep Score with Scorecards 40\u003c\/p\u003e \u003cp\u003eStep 9. It’s About Time: Building the Time-Series Chart 45\u003c\/p\u003e \u003cp\u003eStep 10. Serving Suggestions: Finishing Touches and Sharing Your Report 50\u003c\/p\u003e \u003cp\u003eSummary 55\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 3 Enhancing Basic Graphs 57\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eStatic Report Design 57\u003c\/p\u003e \u003cp\u003eBefore Getting Started: Things You’ll Need 59\u003c\/p\u003e \u003cp\u003eStep 1. Copy the Report 60\u003c\/p\u003e \u003cp\u003eStep 2. Modify the Header and Set the Date Range 61\u003c\/p\u003e \u003cp\u003eStep 3. Modify Scorecards 63\u003c\/p\u003e \u003cp\u003eStep 4. Modify Time-Series Chart 65\u003c\/p\u003e \u003cp\u003eStep 5. Modify the Transactions Table 66\u003c\/p\u003e \u003cp\u003eStep 6. Save the Report as PDF for Sharing 69\u003c\/p\u003e \u003cp\u003eSummary 70\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 4 Data Exploration with Interactive Elements 73\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eBuilding Our Workbench Example 73\u003c\/p\u003e \u003cp\u003eStep 1. Selecting a Dish to Prepare: Exploration Workbench for a Bank Account 74\u003c\/p\u003e \u003cp\u003eStep 2. Let’s Go Shopping! Getting the Data Set 77\u003c\/p\u003e \u003cp\u003eStep 3. Assembling the Ingredients: Connecting Data to the Report 78\u003c\/p\u003e \u003cp\u003eAdding Chart Components and Graphic Elements 82\u003c\/p\u003e \u003cp\u003eStep 4. Reuse, Recycle, and Repurpose: Copying Elements from Other Reports 82\u003c\/p\u003e \u003cp\u003eStep 5. Easy as Pie! Adding a Pie Chart 84\u003c\/p\u003e \u003cp\u003eStep 6. Step Up to the Bar: Adding the Bar Chart 85\u003c\/p\u003e \u003cp\u003eStep 7. Lining Things Up: Adding the Line Chart 90\u003c\/p\u003e \u003cp\u003eStep 8. Tables, Again!? Setting Up the Table 91\u003c\/p\u003e \u003cp\u003eAdding and Configuring Filter Controls 92\u003c\/p\u003e \u003cp\u003eStep 9. Fun with Filters: Setting Up the Standard Filter Controls 92\u003c\/p\u003e \u003cp\u003eTips for Using Interactive Filters 94\u003c\/p\u003e \u003cp\u003eFind the Answers: Filter Challenge 95\u003c\/p\u003e \u003cp\u003eSummary 97\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart II Business and Marketing Applications 99\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 5 Web Data Visualization with Google Analytics 101\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eGoogle Services for Websites and Business 102\u003c\/p\u003e \u003cp\u003eA Brief Primer for Google Analytics 104\u003c\/p\u003e \u003cp\u003eUsing a Template to Create a New Report 106\u003c\/p\u003e \u003cp\u003eBuilding the Google Analytics Report 110\u003c\/p\u003e \u003cp\u003eModifying the Charts 112\u003c\/p\u003e \u003cp\u003eWorking with the New Report 117\u003c\/p\u003e \u003cp\u003eA Real-World Example: The Effects of a Beach Party in Spain on Web Traffic 117\u003c\/p\u003e \u003cp\u003eThe Limits of Demographic Data from Google Analytics 124\u003c\/p\u003e \u003cp\u003eNow for a Side Dish: Adding a Page and Using Filters 126\u003c\/p\u003e \u003cp\u003eSummary 132\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 6 Using Google Search Console for Audience Insights 135\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eSearch Console and Search Results Pages 136\u003c\/p\u003e \u003cp\u003eCreating a Search Console Report with Data Studio 141\u003c\/p\u003e \u003cp\u003eStep 1. Selecting the Dish to Prepare 142\u003c\/p\u003e \u003cp\u003eStep 2. Let’s Go Shopping! 144\u003c\/p\u003e \u003cp\u003eStep 3. Assemble the Ingredients 147\u003c\/p\u003e \u003cp\u003eStep 4. Setting the Table 153\u003c\/p\u003e \u003cp\u003eBon Appetite! Using the Search Console Report 157\u003c\/p\u003e \u003cp\u003eAn Example for Your Soul! 161\u003c\/p\u003e \u003cp\u003eSummary 170\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 7 Viewing Local Organization Data from Google My Business 173\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eGoogle Search and the Local Organization 173\u003c\/p\u003e \u003cp\u003eGMB: The New Home Page in the Search Results 175\u003c\/p\u003e \u003cp\u003eWhat the User Sees in a GMB Listing 176\u003c\/p\u003e \u003cp\u003eWhat the Owner Sees in a GMB Listing 180\u003c\/p\u003e \u003cp\u003eWhy Use Data Studio for GMB? 185\u003c\/p\u003e \u003cp\u003eStep 1. Selecting the Dish to Prepare 187\u003c\/p\u003e \u003cp\u003eThe Actions Page 189\u003c\/p\u003e \u003cp\u003eThe Reviews Page 190\u003c\/p\u003e \u003cp\u003eThe Search Page 192\u003c\/p\u003e \u003cp\u003eBefore You Begin: What You Need to Get Started 194\u003c\/p\u003e \u003cp\u003eStep 2. Let’s Go Shopping and Assemble the Ingredients 195\u003c\/p\u003e \u003cp\u003eStep 3. Setting the Table 202\u003c\/p\u003e \u003cp\u003eReport, Page, and Header Setup 203\u003c\/p\u003e \u003cp\u003ePage Navigation Button Setup 206\u003c\/p\u003e \u003cp\u003eBuilding the Actions Page 209\u003c\/p\u003e \u003cp\u003eBuilding the Search Page 213\u003c\/p\u003e \u003cp\u003eBuilding the Reviews Page 215\u003c\/p\u003e \u003cp\u003eSummary 218\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart III Beyond the Office 221\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 8 Getting Personal 223\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eCreating Your Own Data 223\u003c\/p\u003e \u003cp\u003eUsing Google Forms to Collect Your Own Data 225\u003c\/p\u003e \u003cp\u003eCurating Data from Other Sources 248\u003c\/p\u003e \u003cp\u003eSetting Up IFTTT to Capture Tweets 250\u003c\/p\u003e \u003cp\u003ePreparing the Google Sheet for Data Studio 256\u003c\/p\u003e \u003cp\u003eCreate a Data Source for the Google Sheet 256\u003c\/p\u003e \u003cp\u003eCreate the New Twitter Report 258\u003c\/p\u003e \u003cp\u003eWorking with Data Generated for You 262\u003c\/p\u003e \u003cp\u003eMusic Service Tracking Example 262\u003c\/p\u003e \u003cp\u003eGoogle Fit Community Connector Example 269\u003c\/p\u003e \u003cp\u003eCommunity Connector Setup for Google Fit 270\u003c\/p\u003e \u003cp\u003eBringing It All Together 280\u003c\/p\u003e \u003cp\u003eCreated Data 280\u003c\/p\u003e \u003cp\u003eCurated Data 283\u003c\/p\u003e \u003cp\u003eGenerated Data 284\u003c\/p\u003e \u003cp\u003eSummary 288\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 9 Going Public 291\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eShared Data Sets 291\u003c\/p\u003e \u003cp\u003eSearching for Data Sets 292\u003c\/p\u003e \u003cp\u003eGetting Data from Kaggle 294\u003c\/p\u003e \u003cp\u003eUsing a Kaggle Account 294\u003c\/p\u003e \u003cp\u003eBuilding the UFO Sightings Workbench 302\u003c\/p\u003e \u003cp\u003eDealing with Performance Issues in Reports 307\u003c\/p\u003e \u003cp\u003eUsing the Extract Data Connector to Speed Up Reports 307\u003c\/p\u003e \u003cp\u003edata.world and Makeover Monday 314\u003c\/p\u003e \u003cp\u003eBringing It Home: Real Estate in Your Neighborhood 330\u003c\/p\u003e \u003cp\u003eSelecting the Dish to Prepare 331\u003c\/p\u003e \u003cp\u003eGoing Shopping: Hunting for Housing Data 332\u003c\/p\u003e \u003cp\u003eUnpacking the Groceries: Moving the File to Google Drive 337\u003c\/p\u003e \u003cp\u003ePreparing the Ingredients: Fixing Data Formatting Issues 338\u003c\/p\u003e \u003cp\u003eAssembling the Ingredients: Connecting the Data to the Report 340\u003c\/p\u003e \u003cp\u003ePreparing the Meal: The Plan Meets Reality 340\u003c\/p\u003e \u003cp\u003eSharing Your Dish: Embedding Reports 346\u003c\/p\u003e \u003cp\u003eEmbedding a Report in a Google Site 351\u003c\/p\u003e \u003cp\u003eEmbedding a Report in a WordPress Site 353\u003c\/p\u003e \u003cp\u003eDealing with Pivoted Data 356\u003c\/p\u003e \u003cp\u003eSummary 361\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 10 Where Do You Go from Here? 363\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eHelping Your Audience See the Light 363\u003c\/p\u003e \u003cp\u003eAnnotation Ideas for Static Reports 364\u003c\/p\u003e \u003cp\u003eAnnotation Ideas for Interactive Reports 367\u003c\/p\u003e \u003cp\u003eProviding Detailed Instructions for Users 371\u003c\/p\u003e \u003cp\u003eCommunity Visualizations 375\u003c\/p\u003e \u003cp\u003eData Studio as an Application Development Platform 377\u003c\/p\u003e \u003cp\u003eExotic Ingredients and Your Pantry 383\u003c\/p\u003e \u003cp\u003eData Blending 383\u003c\/p\u003e \u003cp\u003eFile Upload 388\u003c\/p\u003e \u003cp\u003eBigQuery for Big Data 390\u003c\/p\u003e \u003cp\u003eCommunity Connectors 395\u003c\/p\u003e \u003cp\u003eThe Latest Dishes: New Developments and Releases 396\u003c\/p\u003e \u003cp\u003eSummary 396\u003c\/p\u003e \u003cp\u003eIndex 399\u003c\/p\u003e  \u003cp\u003e\u003cb\u003eLEE HURST\u003c\/b\u003e 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.   \u003c\/p\u003e\u003cp\u003e\u003cb\u003eEasily transform your data into engaging, interactive visual reports!\u003c\/b\u003e \u003c\/p\u003e\u003cp\u003eYou 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. \u003ci\u003eHands On With Google Data Studio\u003c\/i\u003e teaches you how to visualize your data today and produce professional results in no time—no previous experience required! \u003c\/p\u003e\u003cp\u003eWritten 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—\u003ci\u003eHands On With Google Data Studio\u003c\/i\u003e will help you: \u003c\/p\u003e\u003cul\u003e \u003cli\u003e\u003cb\u003e Learn the fundamentals of data visualization and personal data accessibility\u003c\/b\u003e\u003c\/li\u003e \u003cli\u003e\u003cb\u003e Access various types of data with Google Data Studio\u003c\/b\u003e\u003c\/li\u003e \u003cli\u003e\u003cb\u003e Use open data API's from numerous public sources\u003c\/b\u003e\u003c\/li\u003e \u003cli\u003e\u003cb\u003e Navigate the Data Studio interface and build your first data set\u003c\/b\u003e\u003c\/li\u003e \u003cli\u003e\u003cb\u003e Add visual interest with banners, logos, custom graphics, and color palettes\u003c\/b\u003e\u003c\/li\u003e \u003c\/ul\u003e","brand":"Wiley","offers":[{"title":"Default Title","offer_id":47989345648869,"sku":"NP9781119616085","price":40.0,"currency_code":"USD","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/1842\/7735\/files\/9781119616085.jpg?v=1761783753","url":"https:\/\/k12savings.com\/products\/hands-on-with-google-data-studio-isbn-9781119616085","provider":"K12savings","version":"1.0","type":"link"}