Font size
WorksheetsPhân Tích Dữ Liệu
Total questions: 134
Worksheet time: 2hrs 35mins
What is data analysis?
What is the data analytics process?
What are the methods of the data analysis process?
Data examination
Data analysis
Analysis, scientific techniques and automated tools
Technology and templates
In the big data environment, what is the process?
What is the method of the data analysis process?
Data verification
Data analysis
Analysis, scientific techniques and automated tools
Technology and templates
In a big data environment, the data analysis process has developed methods that allow data analysis through the use of............highly scalable distributed technology capable of analyzing large volumes of data from different sources.
Automated technology and templates
Technology and templates
Scientific technology and templates
Technology and automated tools
The data analysis process is a broader term encompassing the term data analysis. The data analysis process manages the complete data lifecycle such as................
Collecting, organizing, cleaning, storing, templating
Collecting, cleaning, organizing, storing, analyzing and managing data
Testing, cleaning, organizing, storing, analyzing and managing data
Collecting, cleaning, organizing, analyzing and managing data, technology
In a big data environment, the data analysis process has developed methods that allow data analysis through the use of technology and templates..............................from different sources.
Low scalable distributed technology capable of analyzing large volumes of data
Highly scalable distributed technology capable of analyzing large volumes of data
Equally scalable distributed technology capable of analyzing large volumes of data
In the field of science, data analysis
The results of data analysis can reduce operational costs and facilitate strategic decision-making.
Data analysis can identify the causes of a phenomenon to improve the accuracy of predictions.
Based on services like public sector organizations, data analysis can help enhance focus on delivering high-quality services by reducing costs.
In service-based environments such as public sectors, how does data analysis help?
Reduce operational costs and facilitate strategic decision-making.
Identify the causes of a phenomenon to improve the accuracy of predictions.
Enhance focus on providing high-quality services by reducing costs.
In a business environment:
Reduce operational costs and facilitate strategic decision-making.
Identify the causes of a phenomenon to improve the accuracy of predictions.
Based on services like public sector organizations, data analysis can help enhance focus on providing high-quality services by reducing costs.
Which fields are the visualization processes applied in?
Science, education, art
Business, science, service-based environment
Health, sports, real estate
Information technology, tourism, banking
How many basic steps does the CRISP-DM process include?
4 steps
5 steps
6 steps
7 steps
One implementation of the data analysis process is the cross-industry standard process for data mining CRISP-DM:
Business understanding - data understanding - data collection - building - analysis model - deployment - evaluation
Business understanding - data collection - data understanding - building - analysis model - evaluation - deployment
Business understanding (field, image) - data understanding (data type)
What is the first step in the CRISP-DM process?
Data preparation
Business understanding
Modeling
Evaluation
What is the purpose of the 'Data understanding' step in the CRISP-DM process?
Understand the business objectives of the project
Understand the type of data being used
Prepare data for modeling
Build models based on existing data
Which step in the CRISP-DM process involves preparing and cleaning data for modeling?
Business understanding
Data preparation
Evaluation
Deployment
In the CRISP-DM process, what is the Modeling step?
Understand the business objectives of the project
Understand the type of data being used
Prepare data for modeling
Build models based on existing data
What is the main purpose of the 'Evaluation' step in the CRISP-DM process?
Evaluate models based on criteria such as accuracy and feasibility
Prepare data for the modeling step
Deploy the model into a real-world environment
Ensure data has been cleaned and organized properly
What is the last step in the CRISP-DM process?
Business understanding
Deployment
Data understanding
Modeling
How many basic types of analysis processes are there?
What are the types of data analysis processes from low to high?
What are the basic types of analysis processes?
1
2
3
4
What are the types of data analysis processes from low to high?
Descriptive-Diagnostic-Predictive-Prescriptive
Descriptive-Predictive-Diagnostic-Prescriptive
Diagnostic-Descriptive-Prescriptive-Predictive
Descriptive Analysis is used to:
Predict future trends
Analyze the causes of a phenomenon
Summarize, describe existing data and past events
Provide optimal solutions for data issues
The main purpose of Diagnostic Analysis is:
Forecast future results based on current data
Analyze the root causes of events or phenomena
Search for hidden patterns in data
Optimize decisions and actions for the future
Predictive Analysis helps:
Provide forecasts about possible future outcomes based on current data
Analyze the causes of phenomena that occurred in the past
Provide optimal solutions based on existing data
Summarize past events and trends
Prescriptive Analysis is used to:
Search for hidden patterns in data
Provide optimal solutions for future situations
Identify factors influencing consumer behavior
Predict future outcomes
Visualization is a way to communicate data clearly and understandably, mainly through:
Sound
Images
Storytelling
Use of colors and layout
How is data typically stored during the visualization process?
In table format
In plain text
Abstract
In relational databases
In report visualization, what is the main role of images?
(a)
In data analysis framework, what group do 'Central Limit Theorem, Hypothesis Testing, Chi-Square Test, F-Test' belong to?
Knowledge Discovery
Data Warehouse
Inferential Statistics
Reporting
What is the main role of images in report visualization?
To store data
To communicate data clearly and understandably
To create textual reports
To analyze data further
What can report visualization be seen as a blend of?
Design art and data science
Theory and practice
Techniques and technology
Analysis and forecasting
What does the basic data analysis process include?
Inferential Statistics, Knowledge Discovery, Reporting, Data Warehouse
Inferential Statistics, Knowledge Extraction, Reporting, Data Warehouse
Descriptive Statistics, Knowledge Discovery, Reporting, Data Warehouse
Inferential Statistics, Knowledge Discovery, Reporting Process, Data Warehouse
What is a Data Warehouse?
Central Limit Theorem, Hypothesis Testing, Chi-Square Test, F-Test...
Machine Learning, Data Mining, Forecasting Analysis...
Information systems for managers / Decision support systems, Report visualization...
Relational databases, No SQL databases, Data mart...
What is Knowledge Discovery?
Central Limit Theorem, Hypothesis Testing, Chi-Square Test, F-Test...
Machine Learning, Data Mining, Forecasting Analysis...
Information systems for managers / Decision support systems, Report visualization...
Relational databases, No SQL databases, Data mart...
What is Inferential Statistics?
Central Limit Theorem, Hypothesis Testing, Chi-Square Test, F-Test...
Machine Learning, Data Mining, Forecasting Analysis...
Information systems for managers / Decision support systems...
Relational databases, No SQL databases, Data mart...
What is statistical inference?
Central limit theorem, hypothesis testing, Chi-square test, F-Test
Machine learning, data mining, forecasting analysis
Information systems for managers / Decision support systems, report visualization
Relational databases, No SQL databases, Data mart
What is report generation?
Central limit theorem, hypothesis testing, Chi-square test, F-Test
Machine learning, data mining, forecasting analysis
Information systems for managers / Decision support systems, report visualization
Relational databases, No SQL databases, Data mart
What is report generation?
SPSS, STATA, R
MS Excel, Tableau, MS Power BI, Locker Studio
MS SQL Server, Hadoop, Mongo DB
Python, R, Spark
What is data mining?
SPSS, STATA, R
MS Excel, Tableau, MS Power BI, Locker Studio
MS SQL Server, Hadoop, Mongo DB
Python, R, Spark
What is statistical inference?
SPSS, STATA, R
MS Excel, Tableau, MS Power BI, Locker Studio
MS SQL Server, Hadoop, Mongo DB
Python, R, Spark
What is a data warehouse?
SPSS, STATA, R
MS Excel, Tableau, MS Power BI, Locker Studio
MS SQL Server, Hadoop, Mongo DB
Python, R, Spark
What are the three reasons for effective data visualization?
Memorable, actionable, leads to connections
Memorable data, actionable, leads to connections
Memorable, leads to connections, leads to action
What can report visualization be considered as a blend of?
Layout with color
Storytelling-images
Charts-data
Art design with data science
What is the most effective data visualization activity often combined with?
Layout usage
Color usage
Storytelling
Color usage and layout
What leads to action?
What are the 3 reasons for visualizing data effectively that are often combined with images?
Memorable, actionable, leads to connection
Memorable data, actionable, leads to connection
Memorable, ability to connect, leads to action
In report visualization, ............ serves as the main medium for conveying data, but can also be accompanied by other media, such as......
Color-image
Story-text
Image-text
Layout-image
How many main types of visualization are there?
1
2
3
4
Exploratory visualization in reports is?
Allows readers to explore data for further analysis.
Conducted for a problem that is not clearly defined.
Exploratory visuals are what we l
What is visualization in the EXPLORATORY report?
Allows readers to explore data for further analysis.
Is conducted for a problem that has not been clearly defined.
Exploratory visualization is what we do to understand data.
Interpreting what the audience needs to know.
Displaying specific relationships in the data, such as links between cause and effect.
What is visualization in the EXPLANATORY report?
Allows readers to explore data for further analysis.
Is conducted for a problem that has not been clearly defined.
Exploratory visualization is what we do to understand data.
Interpreting what the audience needs to know.
Displaying specific relationships in the data, such as links between cause and effect.
To develop and evaluate a hypothesis, a question, or find a pattern/overall picture in the data.
Looking at the statistical chart of the quantity.
What are the two main types of visualization reports in business?
Exploration and analysis
Analysis and explanation
Exploration and explanation
Analysis and exploration
Visual design includes:
Design principles
Sound
Storytelling
Length
Visual design includes:
Storytelling
Sound
Pre-attentive attributes (quantity, color, emphasis)
Width
What do pre-attentive attributes in visual design include?
Emphasis, quantity, color
Resolution, brightness, contrast
Time, length, thickness
Font, size, height
Visual design includes:
Storytelling
Sound
Width
Choosing the right chart
Visual design includes:
Storytelling
Visualization to represent data patterns
Sound
Width
Design principles include:
GESTALT principles and DATA principles
GESTALT principles and TUFTE principles
Principle T
What are the design principles?
Gestalt principles and Data principles
Gestalt principles and Tufte principles
Tufte principles and Analytis principles
Tufte principles and Data principles
The Gestalt principles describe how our mind organizes individual visual elements into what?
Complex shapes
Groups to understand the whole image
Abstract concepts
Scattered elements
How many Gestalt principles are there?
5
6
7
8
The principle ('Similarity') in Gestalt psychology states that objects that look similar will be grouped together based on which factor?
Only based on color
Only based on shape
Based on color, shape, size, and texture
Based on their position
The principle that states objects that are close together are perceived to be more related than objects that are far apart is which principle?
Proximity
Similarity
What principle states that objects close to each other are perceived to have a relationship more than objects that are far apart?
Proximity
Similarity
Closure
Surrounding
According to the principle of 'Proximity', why do you see three dots closer together than four columns of dots?
Because they have similar shapes
Because they are closer together horizontally than vertically
Because they have similar colors
Because they are of similar sizes
What principle makes objects appear as if they are placed separately in a distinct area compared to the rest of what we see?
Proximity
Similarity
Closure
Surrounding
What principle do you see when objects look similar as part of the same group?
Proximity
Similarity
Closure
Surrounding
What principle do you use when you group connected dots as part of the same group?
Proximity
Similarity
Closure
Connection
Symmetry: Symmetrical elements are often perceived in relation to each other, regardless of their distance. What does this create for all of us?
Proximity
Similarity
Symmetry
Connection
Figure and Ground: Naturally, the human eye has the ability to distinguish what is the subject (main) and what is the background (secondary) when looking at a picture. What principle does this refer to?
Proximity
Similarity
Closure
Figure and Ground
Continuity: Elements arranged on a straight line or a smooth curve are perceived to be more connected than arranged randomly. What principle does this refer to?
Proximity
Continuity
Closure
Connection
Closure: The human brain automatically fills in missing parts of a design to create a complete picture. What principle does this refer to?
Proximity
Similarity
Closure
K
Tufte believes that ..........
More (details) can be more (information) than
More (details) can be less (information) than
Less (details) can be more (information) than
Less (details) can be less (information) than
According to TUFTE, we need to
Maximize the image ratio
Maximize the data ratio
Maximize the ratio of legends, notes
Maximize the data ratio on print
The benefit of the data ratio on print method is
Clear message, saving data, saving space
Clear message, saving time, saving space
Clear message, saving time, saving cost
Clear message, saving space, saving cost
How many principles of deletion are there in the data ratio on print?
1
2
3
4
The principle of deletion in data ratio on print is
Delete details that do not provide information, delete image details
Delete details that provide duplicate information, delete redundant details
Delete details that provide duplicate information, delete details that do not provide information
TUFTE also points out that it can be used to create ineffective charts
A graphic with a high D:I ratio can still be difficult to understand if that graphic is not well designed. A graphic with a low D:I ratio can still be effective if that graphic conveys information clearly and attracts the viewer's attention.
A graphic with a high D:I ratio can still be easy to understand if that graphic is not well designed. A graphic with a low D:I ratio can be difficult to understand but still effective if that graphic conveys information clearly and attracts the viewer's attention.
The visual tool supports the processing of cognitive attributes immediately
Quantity - color - emphasis
Quantity - color - highlight
What are the visual attributes that support the cognitive processing of information?
Quantity - Color - Emphasis
Quantity - Color - Layout
Quantity - Layout - Emphasis
Quantity - Layout - Chart
What are the visual attributes that immediately convey cognitive perception through emphasis?
Form - Position - Color - Layout
Form - Position - Motion - Color
Form - Position - Motion - Sound
Form - Position - Motion - Layout
When comparing quantities, which type of visualization presentation is the most accurate?
Position
Length
Color
Area
When comparing quantities, which type of visualization presentation is the least accurate?
Position
Length
Color
Area
When comparing quantities, which type of visualization presentation is the second most accurate?
Position
Length
Color
Volume
When comparing quantities, what is the order of accuracy from least to most accurate in visualization presentation?
Color - Volume - Area - Angle - Slope - Position - Length
Color - Volume - Area - Angle - Slope - Length - Position
Color - Area - Volume - Angle - Slope - Position - Length
Color - Area - Volume - Angle - Slope - Length - Position
What color combinations should be used carefully for color-blind audiences?
Green with fluorescent green
Green with blue or red
Yellow with orange
Brown with black
Darker colors indicate what?
Larger quantities
Smaller quantities
Equal quantities
Average quantities
What does cognitive perception of color include?
Not overloading with color
Consistency and effectiveness in color usage
Serving
What does the cognitive property of color include?
Not overloading color
Consistency and effectiveness in using colors
Serving colors to the right audience
Understanding the context of colors
All of the above
What factors should be considered when choosing a chart?
The type of data you have
The number of variables you want to display
The relationship between variables and the intended audience
Considering the available space to display the chart
All of A, B, C, D
What are the common visual layouts?
Layout X - Layout Z - Layout Y
Gutenberg diagram - Layout F - Layout Z
Gutenberg diagram - Layout X - Layout Z
Gutenberg diagram - Layout F - Layout Y
What are the benefits of visualizing through storytelling?
Memorable - easy to understand - leads to connection
Memorable - easy to understand - leads to action
Memorable - leads to connection - leads to action
Easy to understand - leads to connection - leads to action
What are the 3 reasons for effective data visualization often combined with images?
Memorable, actionable, leads to connection
Memorable data, actionable, leads to connection
Memorable, leads to connection, leads to action
What does the narrative framework for data stories include?
Visual design, message, interaction
Understanding the story
Slide design
Dividing layout
What is the narrative framework for data stories used to PRESENT your story?
Understanding the story
Slide design
Dividing layout
Visual design
What is the narrative framework for data stories used to ENGAGE the audience?
Slide design
Understanding the story
Interaction
Dividing layout
What is the narrative framework for data stories used to TELL your story?
Slide design
Understanding the story
Message
Dividing layout
How does the author's method compare to the reader's self-guided method?
What am I?
Slide design
Story perception
Message
Layout division
The author's method compared to the self-guided reader's method is?
Best for explanatory images - reasoning
Best for explanatory images - exploration
Best for exploratory images - reasoning
Best for exploratory images - thinking
The visual process in business reporting has 7 common steps.
Identify the message, Understand the data, Choose the appropriate chart, Prepare the data, Design visually, Evaluate the design, Communicate the report
Identify the message, Understand the data, Prepare the data, Choose the appropriate chart, Design visually, Evaluate the design, Communicate the report
Understand the data, Identify the message, Choose the appropriate chart, Prepare the data, Design visually, Evaluate the design, Communicate the report
Identify the message, Understand the data, Choose the appropriate chart, Prepare the data, Evaluate the design, Design visually, Communicate the report
Preparing data sources involves?
Identifying data sources - Checking data for errors - Cleaning data - Standardizing data
Identifying data sources - Checking data for errors - Cleaning data - Standardizing data - Filtering data.
Identifying data sources - Cleaning data - Checking data for errors - Standardizing data - Filtering data.
What are the basic principles for choosing the appropriate chart?
Identify the type of data you are working with
Identify the question or message you want to convey
Consider your target audience
All of the above
Some famous applications with many functions in visualization are?
Tableau - Loker Studio - Power BI
Power BI - SPSS - Loker Studio
Tableau - Python - Loker Studio
Loker Studio - SPSS - Tableau
Which principle should be applied to design visuals?
GESTALT principle
TU principle
Which principle is applied to design visualization?
GESTALT principle
TUTFE principle
Which principle is applied to evaluate design?
GESTALT principle
TUTFE principle
Which statement is correct about report visualization?
It conveys the meanings of data through images for easy reading and visualization.
It conveys the meanings of data through detailed figures for easy reading and visualization.
It conveys the meanings of data through text for easy reading and visualization.
It conveys the meanings of data through text and figures for easy reading and visualization.
What is the disadvantage of the TABLEAU tool?
Quality is not cloud computing
Price
Acquired by Salesforce
All of A, B, C
What is the popular data visualization and business intelligence tool used for reporting and analyzing huge data sets?
TABLEAU
POWER BI
MICROSOFT EXCEL
LOCKER STUDIO
What is Tableau?
A 3D graphics creation tool
A data visualization and business intelligence tool
A graphic design software
A data programming tool
What is the main purpose of Tableau?
Video analysis
To help create financial reports
To visualize and analyze data for business decision making
To create code for software projects
Who uses Tableau?
Only those in the IT industry
Only those in marketing
Users at all levels, including experts and non-technical people
Only professional data analysts
What types of data visualizations can Tableau create?
Charts, graphs, maps, dashboards, and stories
Video and audio
Text documents
Programs
What types of data visualizations can Tableau create?
Charts, graphs, maps, dashboards, and stories
Video and audio
Types of text documents
Complex software programs
What makes using Tableau easy for non-technical users?
Complex programming interface
Easy-to-understand visual formats
Need to write code to create reports
Requires knowledge of databases
What are the advantages of Tableau?
User experience
Available resources
Integration with Salesforce systems
All of the above
What is the standout advantage of Tableau?
Easily program web applications
Overall user experience is very appealing and easy to use
Ability to create complex code
Supports running heavy software programs
What makes Tableau stand out compared to other tools like PowerBI and Looker?
Faster data analysis capabilities
Better user experience
Integration with graphic design software
No internet connection required
What resources does Tableau have available to support users?
Complex user manuals
Support resources at all levels and easily accessible
Only provides resources for data experts
Resources are only available when you pay
What benefits does Tableau's integration with Salesforce provide?
Helps users easily create sales reports
Helps organizations easily analyze and report data from Salesforce
Improves server system performance
Does not support integration with Salesforce
What can users easily do with Tableau?
Program complex software
Create reports and dashboards, explore data easily
Only create simple charts
Analyze data without understanding the data
What is Microsoft Power BI?
What is Microsoft Power BI?
A database management software
A set of software services and applications that help visualize and analyze data
A complex software programming tool
A graphic design tool
What kind of data can Power BI work with?
Only data from Excel spreadsheets
Data from Excel spreadsheets, cloud datasets, and local storage data
Only data from SQL database systems
Only data from social media platforms
What is the main benefit of using Microsoft Power BI?
Only helps create financial reports
Connects and visualizes data from various sources, making it easy to share information with others
Analyzes data without needing an Internet connection
Only uses local data from the computer
What is one of the standout features of Microsoft Power BI?
Ability to program web applications
Supports analysis of unrelated data types and transforms them into coherent, visual, and understandable information
Integration with 3D graphic tools
Creates complex financial reports without needing an Internet connection
What can Power BI users do with their data?
Create reports and share information with anyone or everyone they want
Create financial reports without data from other sources
Only create reports within the company
Cannot share information with others
What are the advantages of MICROSOFT POWER BI?
