WorksheetsFundamentals of Data Analytics Exercise 1
Total questions: 50
Worksheet time: 25mins
In computing, data is best defined as:
Raw facts without any structure
Information translated into a form suitable for processing
Knowledge derived from analysis
Graphical representation of information
Which term describes data in its most basic digital format?
Processed data
Information
Raw data
Metadata
Data analytics is primarily concerned with:
Designing databases for information management
Analyzing raw data to derive meaningful conclusions
Collecting and storing data for analysis
Storing large datasets
Which of the following best describes the importance of data analytics?
Reduces hardware costs
Improves programming speed
Supports informed decision-making
Eliminates human judgment
Which industry commonly uses data analytics to optimize supply chains?
Education
Healthcare
Retail
Media
Data mining primarily involves:
Presenting data visually
Cleaning, sorting, and analyzing large datasets
Gathering data from multiple sources
Interpreting statistical models
Which tool was historically used and is still widely used for database management?
Python
R
SQL
Tableau
Statistical analysis in data analytics focuses on:
Storing data
Identifying trends and patterns
Collecting user feedback
Designing dashboards
Which programming language is commonly used for statistical analysis and modeling?
HTML
Java
Python
SQL
Data presentation aims to:
Encrypt data
Remove redundancy
Make insights understandable to stakeholders
Increase data size and pleasing to non-technical users
Data analysis differs from data analytics because data analytics:
Uses fewer tools
Is narrower in scope
Includes prediction and broader insights
Avoids automation
Which sector uses data analytics to detect fraudulent transactions?
Logistics
Manufacturing
Banking
Education
Understanding the problem in the analytics process involves:
Cleaning data
Defining business goals and objectives
Visualizing data and results interpretation
Deploying models
Data collection primarily involves gathering:
Only current data
Random information
Historical and transactional data
Visual data
Data cleaning is necessary because collected data is often:
Perfect
Structured
Messy and incomplete
Visual
Exploratory data analysis commonly uses:
Encryption tools
Visualization and predictive techniques
Hardware devices
Questionnaire or survey for data gathering
The final step in the data analytics process is to:
Data gathering
Analyze trends and patterns
Interpret and validate results
Store and explore datasets
Which type of analytics focuses on understanding what happened in the past?
Predictive
Prescriptive
Diagnostic
Descriptive
Diagnostic analytics aims to answer the question:
What will happen?
What should be done?
Why did it happen?
What is happening now?
Predictive analytics is mainly used to:
Summarize data
Explain causes
Forecast future trends
Recommend actions
Prescriptive analytics seeks to determine:
What happened
Why it happened
What will happen
What should be done next
Regression analysis is used to:
Group users
Simulate uncertainty
Estimate relationships between variables
Clean datasets
Factor analysis is best described as a technique to:
Predict future sales
Simplify complex data structures
Visualize dashboards
Store large datasets
Cohort analysis groups data based on:
Random selection
Time intervals only
Shared characteristics
Data size
Monte Carlo simulation is used to model:
Linear relationships
Historical summaries
Risk and uncertainty
Customer behavior only
Time series analysis focuses on data collected:
Randomly
Once only
At consistent time intervals
Without order
Which tool is an open-source programming language for data analysis and visualization?
Tableau
Power BI
R or Python
QlikView
Tableau is primarily used for:
Statistical computation
Machine learning
Data visualization and dashboards
Database creation
Power BI is classified as a:
Programming language
Database engine
Business intelligence tool
Simulation software
QlikView uses which technology for fast analytics?
Cloud storage
In-memory storage
Disk-based storage
Blockchain
Apache Spark is designed for:
Simple data entry
Real-time data processing
Document editing
Spreadsheet analysis
SAS is mainly known as:
Visualization software
Database system
Statistical analysis software
Operating system
One major benefit of data analytics is:
Increased paperwork
Reduced data availability
Operational efficiency
Manual reporting
Data analytics helps organizations primarily to:
Eliminate data
Increase storage costs
Make strategically guided decisions
Avoid automation
Structured data is typically stored in:
Text files
Images
Relational databases
Audio formats
Unstructured data includes:
Tables
Spreadsheets
Videos and social media posts
SQL records
Which analytics type uses machine learning techniques?
Descriptive
Diagnostic
Predictive
Prescriptive
Data visualization mainly supports:
Data storage
Data understanding and communication
Data encryption
Data mining
Which step consumes the most time in data analytics?
Interpretation
Presentation
Data mining and collection
Reporting
Data analytics can help healthcare by:
Reducing patients
Improving diagnosis and treatment
Eliminating records
Increasing paperwork
Predictive analytics relies heavily on:
Guesswork
Historical data patterns
Opinions
Visualization only
Which analytics answers “What is going to happen?”
Descriptive
Diagnostic
Predictive
Prescriptive
Prescriptive analytics often recommends actions using:
Manual rules only
Advanced algorithms and models
Simple averages
Historical summaries
Time series analysis is NOT merely about:
Recording data over time
Random data collection
Identifying trends
Forecasting
Which role uses analytics to optimize delivery routes?
Banking
Retail
Logistics
Education
Data analytics transforms raw data into:
Storage units
Databases only
Actionable insights
Hardware components
Which analytics technique divides users by lifecycle behavior?
Regression
Factor analysis
Cohort analysis
Time series
Data-driven decision making depends heavily on:
Intuition
Experience alone
Validated analytical results
Hypothesis and intensive research study
Which analytics type forms the foundation for trend tracking?
Diagnostic
Predictive
Prescriptive
Descriptive
Data analytics primarily enables organizations to:
Reduce data size
Advance technology
Optimize performance and strategy
Eliminate uncertainty
