DAC Data Tools and Visualization 1 — Questions and Answers
Question 1: What is SQL and why is it essential for data analysts?
- Structured Query Language — the standard language for querying, manipulating, and managing relational databases (Correct answer)
- A spreadsheet application
- A data visualization tool
- A programming language for websites
Correct answer: Structured Query Language — the standard language for querying, manipulating, and managing relational databases
SQL is the universal language for interacting with relational databases, enabling analysts to retrieve specific data (SELECT), filter (WHERE), join tables, aggregate (GROUP BY), and perform complex data manipulation.
Question 2: When should you use a bar chart versus a line chart?
- Bar charts for comparing categories; line charts for showing trends over time (Correct answer)
- They are interchangeable for all data types
- Bar charts only for financial data
- Line charts only for scientific data
Correct answer: Bar charts for comparing categories; line charts for showing trends over time
Bar charts effectively compare discrete categories or groups, while line charts show continuous data trends over time. Choosing the wrong chart type can misrepresent the data and mislead the audience.
Question 3: What is a dashboard in data analytics?
- An interactive visual display of key metrics and KPIs, providing at-a-glance monitoring of business performance (Correct answer)
- A car's instrument panel
- A social media profile page
- A project management timeline
Correct answer: An interactive visual display of key metrics and KPIs, providing at-a-glance monitoring of business performance
Analytics dashboards consolidate key metrics, KPIs, and visualizations into a single interactive interface, enabling stakeholders to monitor performance, identify trends, and make data-driven decisions quickly.
Question 4: What is Python's role in data analytics?
- A versatile programming language with libraries (pandas, NumPy, matplotlib) for data manipulation, analysis, and visualization (Correct answer)
- A type of database
- A spreadsheet formula language
- A data storage format
Correct answer: A versatile programming language with libraries (pandas, NumPy, matplotlib) for data manipulation, analysis, and visualization
Python is widely used for data analytics through libraries like pandas (data manipulation), NumPy (numerical computing), matplotlib/seaborn (visualization), and scikit-learn (machine learning), offering flexibility beyond spreadsheet tools.
Question 5: What is A/B testing in data-driven decision making?
- Comparing two versions of something (webpage, email, feature) by randomly assigning users to each version and measuring outcomes (Correct answer)
- Testing version A before version B chronologically
- Grading tests on an A/B scale
- Alternating between two strategies daily
Correct answer: Comparing two versions of something (webpage, email, feature) by randomly assigning users to each version and measuring outcomes
A/B testing randomly divides users into control (A) and treatment (B) groups, each seeing a different version, to statistically determine which performs better on defined metrics, enabling evidence-based decisions.
Question 6: What is data storytelling?
- Combining data, visuals, and narrative to communicate analytical findings effectively to stakeholders (Correct answer)
- Writing fictional stories about data
- Reading data reports aloud in meetings
- Creating animated data presentations
Correct answer: Combining data, visuals, and narrative to communicate analytical findings effectively to stakeholders
Data storytelling weaves together accurate data, compelling visualizations, and a clear narrative structure to make analytical insights accessible, memorable, and actionable for non-technical audiences.
DAC Data Tools and Visualization 1
What is SQL and why is it essential for data analysts?