Data Analysis Quiz

Which tool is best for creating interactive charts and dashboards for non-technical users?

• Excel

• Power BI

• Python

• SQL

What is the primary advantage of using Python for data analysis?

• User-friendly interface

• Advanced visualisation for business presentations

• Flexibility for customised, in-depth data analysis

• Managing structured datasets

When should SQL be used?

• For small dataset tracking

• For creating advanced data visualisations

• For managing relational databases and ensuring data integrity

• For predictive modelling

Which cleansing process removes redundant entries within fields?

• Removing blanks

• Removing duplicates

• Removing repetitions

• Sense checks

What does the 1/10/100 rule demonstrate?

• The decreasing cost of data storage

• The impact of proactive vs. reactive data management

• The steps in data visualisation processes

• The phases of dataset integration

What is sampling bias?

• Errors introduced by data collection tools

• Overrepresentation of certain groups in a dataset

• Data skewed by preconceived beliefs

• Inaccurate measurements in surveys

What is a primary solution to measurement bias?

• Random sampling

• Standardising data collection tools

• Applying data cleansing measures

• Removing blank fields

Confirmation bias affects data analysis by:

• Introducing random errors

• Misinterpreting data to fit preconceived ideas

• Excluding irrelevant records

• Skewing measurements

Which validation method ensures no mandatory fields are left blank?

• Format checks

• Presence checks

• Range checks

• Double data entry

What is the key difference between validation and verification?

• Validation checks if data matches the original source; verification ensures correct formats.

• Validation ensures correct formats; verification checks against original sources.

• Validation involves random checks; verification is comprehensive.

• Both involve checking the accuracy of data against user requirements.