How to enable business users to clean and analyze data in spreadsheets?
Short answer
A Use Dataprep to clean the data, and write the results to BigQuery. Analyze the data by using Connected Sheets.
Question
Key Takeaways
The question tests knowledge of user-friendly data preparation tools versus code-based pipelines and the distinction between spreadsheet interfaces and BI dashboards.
For business users requiring a GUI for data cleaning and spreadsheet analysis, using Dataprep with BigQuery and Connected Sheets is the recommended solution. The community agrees this combination best fits the requirement for low-code data preparation and familiar interfaces.
Common mistake: Choosing Dataflow (Option C or D) is a common mistake because it requires coding skills unsuitable for non-technical users, whereas Dataprep offers the necessary GUI.
Expert Analysis
Why the Answer Is Correct
Option A is correct because Dataprep is specifically designed as a serverless, visual data service for cleaning and preparing data without coding. It allows business users to inspect, clean, and transform data visually. Once the data is written to BigQuery, Connected Sheets enables these users to analyze the data directly within Google Sheets, a familiar spreadsheet interface, satisfying the specific constraints of the scenario.
Why the Other Options Are Wrong
Options C and D are incorrect because Dataflow is a stream and batch data processing service that requires programming (Java or Python), which contradicts the requirement for users who are less technically savvy and prefer GUIs. Option B is incorrect because while Dataprep is the right tool for cleaning, Looker Studio is a visualization and dashboarding tool, not a spreadsheet interface; the users specifically requested analysis in a spreadsheet.
Community Comment Notes
The community overwhelmingly supports Option A, noting the simplicity of the question compared to others. Comments highlight the alignment of Dataprep with the GUI requirement and Connected Sheets with the spreadsheet preference. One user explicitly pointed out that Connected Sheets allows analysis in a "familiar spreadsheet interface," which is a key keyword in the question.
Official Reference
These links open the official vendor documentation in a new tab.
Exam Strategy
Focus on the user persona described in the question. Keywords like "less technically savvy" or "prefer GUI" immediately rule out code-heavy tools like Dataflow in favor of Dataprep.
Community Votes
100% of anonymous learners picked answer A. Votes are pick records left by other test-takers — they are not the verified answer.
Discussion 6 contributions
Compiled from public community threads and reader submissions, lightly edited for clarity. Handles and vote tallies are shown as recorded, and comments reflect the views of individual contributors.
From public community threads 6
-
Sofiia98 👍 11 Answered AIf only all the questions were like this...
-
raaad 👍 5 Answered A- Allow business users to perform their analysis in a familiar spreadsheet interface via Connected Sheets.
-
josech 👍 4 Answered Ahttps://cloud.google.com/bigquery/docs/connected-sheets https://cloud.google.com/dataprep
-
scaenruy 👍 3 Answered AA. Use Dataprep to clean the data, and write the results to BigQuery. Analyze the data by using Connected Sheets.
-
Matt_108 👍 1 Answered AClearly option A
Show 1 more comment
-
hanoverquay 👍 1 Answered Avote A
Reader comments & corrections
No reader corrections yet — spotted an error or have a note? Share it below.