Hands On With Google Data Studio von Lee Hurst

<p><b>Learn how to easily transform your data into engaging, interactive visual reports!</b></p><p>Data 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.<i>Hands On With Google Data Studio</i>teaches you how to visualize your data<i>today</i> and produce professional quality results quickly and easily.</p><p>No previous experience is required to get started right awayall 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:</p><ul><li>Use Google Data Studio to access various types of data, from your own personal data to public sources</li><li>Build your first data set, navigate the Data Studio interface, customize reports, and share your work</li><li>Learn the fundamentals of data visualization, personal data accessibility, and open data API's</li><li>Harness the power of publicly accessible data services including Googles recently released Data Set Search</li><li>Add banners, logos, custom graphics, and color palettes</li></ul><p><i>Hands On With Google Data Studio: A Data Citizens Survival Guide</i>is 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.</p><p></p>

LEE HURST 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.

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

Funktionsweise E-Books.