Looker Studio (Google Data Studio)
Data sources, calculated fields, filters, parameters, blending, interactive charts, sharing
1What is Looker Studio (formerly Google Data Studio)?
What is Looker Studio (formerly Google Data Studio)?
Answer
Looker Studio is a free data visualization tool from Google that allows creating interactive reports and dashboards. It connects to numerous data sources (Google Analytics, BigQuery, Google Sheets, etc.) and enables easy report sharing with teams.
2What is the difference between a data source and a connector in Looker Studio?
What is the difference between a data source and a connector in Looker Studio?
Answer
A connector is the technical link to an external system type (BigQuery, Google Sheets, MySQL). A data source is a configured instance of that connector with specific parameters (which table, which fields). Multiple data sources can use the same connector.
3What types of native connectors does Looker Studio offer?
What types of native connectors does Looker Studio offer?
Answer
Looker Studio offers native Google connectors (Analytics, BigQuery, Sheets, Ads, Search Console) and third-party connectors via the partner connector gallery. Native Google connectors are free and optimized, while some partner connectors may be paid.
How to create a calculated field in Looker Studio?
What is the correct syntax to create a calculated field that categorizes sales as 'Small', 'Medium' or 'Large' based on amount?
+17 interview questions
Other Data Analytics interview topics
Google Sheets - Fundamentals
Google Sheets - Advanced Formulas
SQL - Fundamentals
SQL - Aggregations and Grouping
SQL - Joins
BigQuery - Fundamentals
Data Cleaning
KPIs and Business Metrics
Descriptive Statistics
Zapier and No-Code Automation
Data Visualization Principles
Python & Pandas - Fundamentals
Google Sheets - Automated Dashboards
SQL - Subqueries and CTEs
SQL - Window Functions
BigQuery - Advanced Features
Data Modeling
Funnel and Conversion Analysis
Cohort and Retention Analysis
Google Tag Manager and Tracking
APIs and Webhooks
dbt - Fundamentals
AB Testing and Applied Statistics
Power BI - Fundamentals
SQL - Advanced Analytical Queries
dbt - Advanced Features
Power BI - DAX and Advanced Dashboards
Python Analytics - Advanced Analysis and ML
Master Data Analytics for your next interview
Access all questions, flashcards, technical tests, code review exercises and interview simulators.
Start for free