FTC Data Week 4

Which tool is ideal for business analysts with limited coding experience?

• Python

• SQL

• Power BI

• Excel

What is the primary benefit of using SQL for data analysis?

• Advanced data visualisation

• Managing relational databases

• Data cleansing

• Creating machine learning models

What is a key feature of Python in data analysis?

• Handles large datasets efficiently

• Extensive data manipulation capabilities

• User-friendly interface for non-technical users

• Predefined dropdown lists for validation

Why is data cleansing important?

• To reduce processing time only

• To enhance data quality and reliability

• To make data visualisations more appealing

• To limit data storage requirements

What does the 1/10/100 rule represent?

• Cost of data processing per hour

• The escalating cost of managing data errors

• Importance of cleaning 10% of data initially

• Stages of data lifecycle

What is an example of a presence check in data validation?

• Ensuring a phone number has the correct format

• Checking that mandatory fields are not left blank

• Comparing a customer ID with the original source

• Restricting ages to a defined range

What is sampling bias?

• Data collected from only a subset of the population

• Errors introduced during data measurement

• Ignoring contradictory data to fit a narrative

• Uneven data formatting in a dataset

What is a common solution for measurement bias?

• Diversify data sources

• Standardise data collection tools and processes

• Use random sampling techniques

• Ensure unique values in the dataset

How does removing duplicates benefit data analysis?

• Reduces dataset size and prevents skewed analysis

• Adds missing data automatically

• Enhances advanced visualisation capabilities

• Improves teamwork collaboration

What is a solution for confirmation bias in data analysis?

• Focus only on expected patterns

• Highlight data supporting assumptions

• Actively seek contradictory evidence

• Ignore missing data fields