20 Basic Data Analytics Questions
1. What is data analytics?
Answer: The process of examining datasets to draw conclusions about the information they contain.
2. What are the main types of data analytics?
Answer: Descriptive, Diagnostic, Predictive, and Prescriptive.
3. What is the difference between data and information?
Answer: Data: Raw facts and figures. Information: Processed data with context and meaning.
4. What is a dataset?
Answer: A structured collection of data, usually in tabular form.
5. What is the difference between qualitative and quantitative data?
Answer: Qualitative: Descriptive (e.g., colors, names). Quantitative: Numeric (e.g., height, age).
6. What is data cleaning?
Answer: The process of fixing or removing incorrect, corrupted, or incomplete data.
7. What is a primary key in a database?
Answer: A unique identifier for each record in a table.
8. What is normalization in data?
Answer: Transforming data to a standard scale without distorting differences in ranges.
9. What is the mean, median, and mode?
Answer: Mean: Average. Median: Middle value. Mode: Most frequent value.
10. What is a null value?
Answer: A missing or undefined value in a dataset.
11. What are outliers?
Answer: Data points that differ significantly from other observations.
12. What is correlation?
Answer: A measure of the relationship between two variables.
13. What is a pivot table?
Answer: A tool in Excel and data tools to summarize and analyze data.
14. What is data visualization?
Answer: Using graphs or charts to represent data visually.
15. What tools are commonly used in data analytics?
Answer: Excel, SQL, Python, R, Tableau / Power BI.
16. What is SQL used for in analytics?
Answer: To retrieve, update, and manage data in relational databases.
17. What is data sampling?
Answer: Using a subset of data to analyze and draw conclusions about the whole dataset.
18. What is a histogram?
Answer: A graphical representation of the distribution of numerical data.
19. What is a KPI (Key Performance Indicator)?
Answer: A measurable value that indicates how effectively a company is achieving key objectives.
20. What is the purpose of data analysis in business?
Answer: To support decision-making, identify trends, solve problems, and improve efficiency.
