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