Font size
S
M
L
XL
Worksheets[BA] Course Review
Total questions: 96
Worksheet time: 48mins
Name
Class
Date
1.
What does the acronym MECE stand for in the context of problem-solving?
a)
Measurable, Efficient, Concise, Effective
b)
Mutually Exclusive, Collectively Exhaustive
c)
Manageable, Executable, Comprehensive, Efficient
d)
Measurable, Executable, Comprehensive, Effective
2.
An issue tree is best described as:
a)
A hierarchical representation of revenue and costs
b)
A visual representation of a company's organizational structure
c)
A "map" of the problem that captures both the big picture and details
d)
A flowchart outlining a specific data analysis process
3.
Which data analytics methodology focuses on understanding the reasons behind past events?
a)
Descriptive
b)
Diagnostic
c)
Predictive
d)
Prescriptive
4.
What is the primary goal of prescriptive analytics?
a)
Describe what happened in the past.
b)
Determine the best course of action to achieve desired outcomes.
c)
Identify patterns and trends in data.
d)
Predict future events based on historical data.
5.
Why is problem-solving using data important in business?
a)
It relies solely on personal expertise.
b)
It is based on intuition and gut feelings.
c)
It helps to remove cognitive and personal biases from decision making.
d)
It is less effective than traditional decision-making methods.
6.
Business data analytics can help organizations achieve:
a)
Decreased efficiency.
b)
Increased costs.
c)
Slower decision-making.
d)
A competitive advantage.
7.
Which of the following is NOT a problem that can be solved using data?
a)
Describing and predicting customer behavior
b)
Detecting abnormalities in health data
c)
Categorizing customers for targeted promotions
d)
Improving employee morale without data analysis
8.
A fitness tracker company using data to alert users about unusual heart rate patterns is an example of:
a)
Describing and predicting
b)
Detecting abnormalities
c)
Categorizing
d)
Identifying trends & themes
9.
A social media company using data to identify and promote trending content is an example of:
a)
Describing and predicting
b)
Detecting abnormalities
c)
Categorizing
d)
Identifying trends & themes
10.
A beauty company using data to recommend products based on past customer purchases is an example of:
a)
Discovering connections
b)
Finding patterns
c)
Detecting abnormalities
d)
Identifying trends & themes
11.
What is the first step in the process of solving problems using data?
a)
Data wrangling
b)
Data analysis
c)
Problem statement
d)
Data visualization
12.
The acronym "SMART" in relation to problem statements stands for:
a)
Simple, Measurable, Achievable, Realistic, Time-bound
b)
Specific, Measurable, Achievable, Realistic, Time-bound
c)
Strategic, Measurable, Achievable, Relevant, Time-bound
d)
Specific, Manageable, Actionable, Relevant, Time-bound
13.
Which of the following is NOT a component of understanding the business situation when creating a problem statement?
a)
What happened?
b)
Why did it happen?
c)
What are the competitors doing?
d)
What is the impact?
14.
A MECE issue tree is helpful for all of the following EXCEPT:
a)
Capturing the big picture and details of a problem
b)
Generating random ideas for brainstorming
c)
Prioritizing aspects of a problem
d)
"Dividing and conquering" a complex problem
15.
Translating business goals into data goals involves:
a)
Setting arbitrary targets for data collection.
b)
Ignoring the specific business objectives.
c)
Identifying specific data-driven metrics and analyses to achieve business objectives.
d)
Focusing solely on data collection without considering business needs.
16.
Which of the following is a data goal that could correspond to the business goal of increasing customer retention?
a)
Inventory tracking
b)
Sourcing forecast
c)
Churn & cohort analysis
d)
Sales tracking
17.
What is data wrangling?
a)
The process of analyzing data to extract insights.
b)
The process of presenting data visually.
c)
The process of cleaning, transforming, and preparing data for analysis.
d)
The process of collecting data from various sources.
18.
Data structuring involves:
a)
Removing irrelevant data from a dataset.
b)
Organizing data into a standard tabular format (variables - observations - values).
c)
Analyzing data to identify trends.
d)
Visualizing data using charts and graphs.
19.
Which of the following is NOT a step in data wrangling?
a)
Data discovery
b)
Data cleaning
c)
Data interpretation
d)
Data structuring
20.
How can you sanitize data to ensure its quality?
a)
Remove duplicate entries.
b)
Introduce intentional errors.
c)
Ignore data validation rules.
d)
Leave missing values unaddressed.
21.
Creating unique IDs for observations is part of which data wrangling step?
a)
Data cleaning
b)
Data enriching
c)
Data structuring
d)
Data publishing
22.
Dealing with missing values in data can be done by:
a)
Dropping the observation with missing values.
b)
Randomly assigning values.
c)
Leaving the values blank without any action.
d)
Ignoring the entire dataset.
23.
Imputing missing values in a dataset can be done by using:
a)
The mode for continuous variables
b)
The standard deviation for categorical variables
c)
The mean or median for continuous variables
d)
Randomly generated numbers
24.
What should you do when encountering invalid values in a dataset?
a)
Always drop the entire observation.
b)
Correct the value using the most reasonable method if possible.
c)
Ignore the invalid values and proceed with analysis.
d)
Replace invalid values with arbitrary numbers.
25.
Data validation during data wrangling ensures:
a)
Data conforms to predefined standards and rules.
b)
Data is presented in a visually appealing format.
c)
Data is stored in a specific database system.
d)
Data is accessible to all users.
26.
What does data publishing involve?
a)
Creating charts and graphs to present data.
b)
Storing and managing data in a way that allows for delivery and distribution to end users.
c)
Analyzing data to extract insights.
d)
Cleaning and transforming data.
27.
What is the defining characteristic of time series data?
a)
Data points are categorized by region.
b)
Data points are grouped by specific events.
c)
Data points are indexed in chronological order.
d)
Data points are randomly distributed.
28.
Which of the following is an example of time series data?
a)
Customer demographics
b)
Product categories
c)
Stock market prices over time
d)
Sales by region
29.
"Trend" in time series data analysis refers to:
a)
Short-term fluctuations within a data pattern
b)
A long-term general direction of the data
c)
Repetitive patterns that occur at regular intervals
d)
Unpredictable fluctuations in the data
30.
"Seasonal variations" in time series data are:
a)
Random fluctuations in data
b)
Long-term upward or downward trends
c)
Recurring patterns that occur within a fixed period, such as a year.
d)
Irregular fluctuations with no discernible pattern.
31.
"Cyclic variations" in time series data are:
a)
Predictable patterns that repeat over a fixed period
b)
Fluctuations that occur over longer, irregular periods and are often harder to predict.
c)
A consistent upward or downward movement in data
d)
Random and unpredictable changes in data
32.
What does "horizontally zooming out" in time series data analysis mean?
a)
Focusing on a smaller time window
b)
Expanding the time range being viewed to gain a broader perspective.
c)
Analyzing data in greater depth for a specific period
d)
Comparing data from different time periods
33.
What does "vertically zooming out" in time series data analysis mean?
a)
Adjusting the scale of the y-axis to view a wider range of data values.
b)
Narrowing the focus to specific data points
c)
Expanding the time range being analyzed
d)
Comparing multiple datasets simultaneously
34.
Which of the following is NOT a main data type used in Excel for data wrangling and analysis?
a)
Text
b)
Number
c)
Boolean
d)
Image
35.
In Excel, "10" displayed in a cell might be:
a)
Text formatted to look like a number.
b)
Always a numerical value.
c)
A Boolean value representing "TRUE."
d)
An error value.
36.
Which of these represents a "Boolean" data type?
a)
"Apple"
b)
"1.5"
c)
True
d)
#N/A
37.
What is the distinction between data type and data format in Excel?
a)
They are essentially the same thing.
b)
Data type refers to what the data is, while data format refers to how it is displayed.
c)
Data type determines the visual appearance of data, while data format defines its underlying nature.
d)
Data type is relevant for calculations, while data format is only for presentation purposes.
38.
Which of the following is NOT a category of data visualization?
a)
Static
b)
Interactive
c)
Animated
d)
Complex
39.
Which type of data visualization allows users to interact with the data, such as hovering, zooming, or expanding elements?
a)
Static
b)
Interactive
c)
Animated
d)
All types
40.
Which type of data visualization plays independently, often conveying changes or trends over time?
a)
Static
b)
Interactive
c)
Animated
d)
All types
41.
What is a key characteristic of a good data visualization?
a)
It should always use bright and colorful visuals.
b)
It should be able to convey a complete message even without additional context.
c)
It should prioritize aesthetics over clarity.
d)
It should be as complex as possible to demonstrate analytical skills.
42.
What is the purpose of a waterfall chart?
a)
To compare different categories of data.
b)
To show the cumulative effect of positive and negative values, leading to a final result.
c)
To depict the distribution of a single variable.
d)
To visualize relationships between different variables.
43.
A waterfall chart is particularly useful for:
a)
Understanding how individual components contribute to a total.
b)
Showing trends over time.
c)
Displaying geographical data.
d)
Representing complex networks.
44.
What is the primary function of a Sankey diagram?
a)
To show hierarchical relationships.
b)
To visualize the flow of a quantity from one set of values to another.
c)
To represent data geographically.
d)
To compare categories side-by-side.
45.
What type of chart is effective for displaying geospatial data?
a)
Choropleth map
b)
Scatter plot
c)
Pie chart
d)
Line graph
46.
A choropleth map uses:
a)
Lines to connect data points.
b)
Color or shading to represent data values associated with geographical regions.
c)
Bars to compare different categories.
d)
Symbols to represent data points on a map.
47.
What is the data type in SQL used for storing whole numbers?
a)
FLOAT
b)
TEXT
c)
INT64
d)
DATE
48.
Which SQL data type is suitable for storing fractional numbers?
a)
INT64
b)
TEXT
c)
FLOAT
d)
CHAR
49.
What is the purpose of the "WHERE" clause in an SQL query?
a)
To select specific columns from a table.
b)
To specify the table to retrieve data from.
c)
To filter rows based on a specific condition.
d)
To group rows based on shared values.
50.
Which SQL clause is used for grouping rows that share common values?
a)
WHERE
b)
ORDER BY
c)
GROUP BY
d)
HAVING
51.
What is the function of the "ORDER BY" clause in an SQL query?
a)
To sort the results in ascending or descending order based on a specific column.
b)
To limit the number of rows returned.
c)
To filter data based on specific criteria.
d)
To perform calculations on retrieved data.
52.
Which SQL clause is used to limit the number of rows returned by a query?
a)
LIMIT
b)
OFFSET
c)
WHERE
d)
ORDER BY
53.
What is the purpose of the "OFFSET" clause in an SQL query?
a)
To sort the results based on a column.
b)
To specify the starting point for retrieving rows, effectively skipping a certain number of rows.
c)
To filter rows based on a condition.
d)
To group rows with common values.
54.
What are Analytics & Business Intelligence (ABI) platforms primarily designed for?
a)
Enabling less technical users to analyze and explore data.
b)
Performing complex statistical modeling for expert analysts.
c)
Automating data entry and cleaning tasks.
d)
Providing a platform for software developers to build data-driven applications.
55.
Which language is used for Data Analysis Expressions (DAX) in Power BI?
a)
SQL
b)
Python
c)
DAX (a specific language for Power BI)
d)
M formula language
56.
What is the primary focus of the M formula language in Power BI?
a)
Data analysis and calculation
b)
Data ingestion, transformation, and loading
c)
Creating interactive dashboards
d)
Sharing and collaborating on reports
57.
Data analysts using Power BI primarily work with:
a)
Low-level data modeling.
b)
Data ingestion and transformation.
c)
Functions, operators, and constants for calculations and aggregations.
d)
Building complex data pipelines.
58.
Which of the following is NOT a function of prescriptive analytics?
a)
Suggesting specific actions.
b)
Optimizing resource allocation.
c)
Describing past trends.
d)
Simulating potential outcomes.
59.
What type of data visualization would be most suitable for displaying the proportion of different customer segments within a market?
a)
Line chart
b)
Pie chart
c)
Scatter plot
d)
Bar chart
60.
Which data wrangling step involves addressing missing or invalid values?
a)
Data structuring
b)
Data publishing
c)
Data cleaning
d)
Data discovery
61.
What is the purpose of a data dictionary in data management?
a)
To provide a glossary of technical terms
b)
To document the structure, content, and meaning of data elements within a dataset.
c)
To define data visualization standards
d)
To outline data security protocols
62.
Which of the following is an advantage of using data-driven decision-making?
a)
It guarantees business success.
b)
It reduces the influence of personal biases.
c)
It eliminates the need for human intuition.
d)
It is always faster than traditional methods.
63.
What is the difference between "data-driven" and "data-informed" decision making?
a)
"Data-driven" relies solely on data, while "data-informed" uses data as one input among others.
b)
"Data-driven" is more qualitative, while "data-informed" is more quantitative.
c)
"Data-driven" is used for strategic decisions, while "data-informed" is used for operational decisions.
d)
They are essentially the same concept.
64.
What is an example of "data-inspired" decision making?
a)
Using sales data to set precise sales targets
b)
Using customer feedback to improve a product
c)
Using data to identify potential areas for experimentation or innovation.
d)
Using financial data to create a budget
65.
Which SQL data type would you use to store a customer's name?
a)
INT64
b)
FLOAT
c)
TEXT
d)
DATE
66.
In data visualization, what is a "legend" used for?
a)
To provide a title for the chart.
b)
To explain the meaning of different colors, symbols, or patterns used in the chart.
c)
To display the units of measurement for the data.
d)
To show the source of the data.
67.
What is the best way to handle missing data when calculating the average age of customers?
a)
Replace missing ages with zero.
b)
Exclude customers with missing ages from the calculation.
c)
Replace missing ages with a randomly generated number.
d)
Use the maximum age in the dataset as a substitute.
68.
Which of these Excel functions can be used for cleaning data by removing leading or trailing spaces from text strings?
a)
SUM
b)
COUNTIF
c)
TRIM
d)
VLOOKUP
69.
What is the primary purpose of data storytelling?
a)
To present data in a purely technical and objective manner.
b)
To communicate insights from data in a clear, engaging, and persuasive way.
c)
To focus solely on data visualization without considering narrative.
d)
To create complex and elaborate data presentations.
70.
What is a common pitfall in data visualization?
a)
Using clear and concise labels.
b)
Choosing appropriate chart types for the data.
c)
Including too much information, leading to a cluttered and confusing visual.
d)
Providing context and insights along with the visual.
71.
What is the role of "data governance" in an organization?
a)
To establish policies and procedures for managing data quality, security, and access.
b)
To develop data analysis skills among employees.
c)
To purchase and maintain data storage infrastructure.
d)
To conduct market research to collect data.
72.
What is a "dashboard" in the context of data visualization?
a)
A static report with detailed data tables.
b)
An interactive display that shows key metrics and insights at a glance.
c)
A presentation with slides outlining data trends.
d)
A complex statistical model used for prediction.
73.
What is an example of a "key performance indicator" (KPI) that could be tracked on a business dashboard?
a)
Employee satisfaction scores
b)
Website traffic sources
c)
Customer churn rate
d)
All of the above
74.
In data analysis, what does "correlation" refer to?
a)
Causation between two variables.
b)
A statistical measure that indicates the strength and direction of the relationship between two variables.
c)
A visual representation of data trends.
d)
A technique for cleaning and transforming data.
75.
What does the term "data literacy" mean?
a)
The ability to code and program using data.
b)
The ability to understand and interpret data, and to communicate insights effectively.
c)
The ability to collect large amounts of data.
d)
The ability to design and build databases.
76.
Which of these is a common tool for data visualization?
a)
Microsoft Excel
b)
Tableau
c)
Power BI
d)
All of the above
77.
What does the abbreviation "ETL" stand for in data warehousing?
a)
Extract, Transform, Load
b)
Evaluate, Transfer, Link
c)
Engage, Track, Learn
d)
Explore, Test, Launch
78.
What is the primary goal of "data mining"?
a)
To store and manage data securely.
b)
To clean and structure messy data.
c)
To discover patterns, trends, and insights hidden within large datasets.
d)
To create visual representations of data.
79.
Which of the following is a benefit of using cloud-based data storage?
a)
Increased data security risks
b)
Limited accessibility
c)
Higher upfront costs
d)
Scalability and flexibility
80.
Which data visualization technique is suitable for showing the distribution of a single continuous variable?
a)
Pie chart
b)
Scatter plot
c)
Histogram
d)
Heatmap
81.
What is "data aggregation" in data analysis?
a)
The process of cleaning and transforming raw data
b)
The process of combining data from multiple sources or summarizing data into meaningful groups or categories.
c)
The process of storing and managing data in a database
d)
The process of visualizing data using charts and graphs
82.
Which SQL clause allows you to filter the results of a GROUP BY aggregation?
a)
WHERE
b)
HAVING
c)
ORDER BY
d)
LIMIT
83.
What does the term "Big Data" refer to?
a)
Extremely large and complex datasets that challenge traditional data processing methods.
b)
Datasets that can be easily managed in a spreadsheet.
c)
Data that is solely related to financial transactions.
d)
Data that is always structured and clean.
84.
Which of the following is NOT a characteristic commonly associated with "Big Data"?
a)
Volume (massive amounts of data)
b)
Velocity (high speed of data generation)
c)
Simplicity (easily manageable datasets)
d)
Variety (diverse data types and sources)
85.
In the context of Big Data, what does "Veracity" refer to?
a)
The speed of data processing
b)
The different sources of data
c)
The accuracy and trustworthiness of data
d)
The total size of a dataset
86.
A/B testing, commonly used in marketing and product development, is an example of:
a)
Descriptive analytics
b)
Diagnostic analytics
c)
Prescriptive analytics
d)
Predictive analytics
87.
Which type of chart is best for visualizing the relationship between two continuous variables?
a)
Pie chart
b)
Bar chart
c)
Scatter plot
d)
Histogram
88.
Which of the following is NOT a component of effective communication in data analysis?
a)
Using clear and concise language
b)
Using technical jargon to impress the audience
c)
Providing context and background information
d)
Tailoring the communication to the specific audience
89.
What is the purpose of "data cleaning" in the data analysis process?
a)
To analyze data for patterns
b)
To identify and correct errors, inconsistencies, and missing values in data.
c)
To create visual representations of data
d)
To store data in a secure and organized manner
90.
What is a potential downside of relying solely on data-driven decision-making?
a)
Increased objectivity
b)
Reduced bias
c)
Overlooking qualitative factors and human intuition
d)
Improved data quality
91.
What is the advantage of using a "heatmap" for data visualization?
a)
To show proportions of a whole.
b)
To display patterns and variations in data using color intensity.
c)
To visualize the flow of a process.
d)
To represent data geographically.
92.
What does the SQL keyword "SELECT" do in a query?
a)
Filters data based on conditions
b)
Specifies which columns to retrieve from a table
c)
Groups rows based on shared values
d)
Sorts results in ascending or descending order
93.
What does "RFM analysis" in marketing stand for, and what is its purpose?
a)
Recency, Frequency, Monetary - used to segment customers based on their purchase behavior.
b)
Reach, Focus, Messaging - used to optimize marketing campaigns.
c)
Risk, Feasibility, Market - used to evaluate new product ideas.
d)
Relevance, Functionality, Metrics - used to assess website performance.
94.
Which type of data visualization is suitable for displaying hierarchical data, such as an organizational structure?
a)
Pie chart
b)
Scatter plot
c)
Line chart
d)
Treemap
95.
What is the main purpose of a "boxplot" in data visualization?
a)
To show the distribution of categorical data
b)
To visualize trends over time
c)
To display the distribution of a dataset, showing quartiles, median, and potential outliers.
d)
To compare proportions of different categories
96.
In data analysis, what is a "hypothesis"?
a)
A proven fact based on data.
b)
A testable statement or assumption that is investigated using data analysis.
c)
A random guess about data patterns.
d)
A type of data visualization.
Reset
