NEW
Font size
WorksheetsDSC119_Chap 2: Data Preparation Methodology and Interface Design
Total questions: 14
Worksheet time: 7mins
Which of the following is NOT TRUE about user requirements?
It contains the point of view is user towards the system
It explains the user goal and its relationship with organisation
It tells how well the system can perform the task given
It gathers the user input and output data or information on natural language
The following diagram shows an Energy Dashboard. Which of the following is a CORRECT statement that explains the Dashboard ?
Energy Dashboard helps the manager to indicate the performance of energy consumption by daily, monthly and yearly.
Energy Dashboard assists the operational staff to check the current status of energy consumptions and associated ingestions in a day.
Energy Dashboard helps analyse the cost and its usage for top level management for estimating the operational cost.
Energy Dashboard is being used as centre of information for an organisation to predict the future trends and pattern of energy usage.
"Many analysis problems are vaguely defined, making it difficult for people to know how to address them. In such cases, an analysis process with a human in the loop is the best way forward, because dashboard design makes use of the great pattern identification capabilities of the human visual system."
Identify the ideal process to solve the above issue.
Requirements gathering
Dashboard development
Reporting documentation
Data cleansing
Data structuring is one of the activities in the data transformation process. Which of the following tasks best describes the activity? ?
Identifies patterns, relationships and other attributes in the data, as well as inconsistencies, anomalies, missing values and other issues so they can be addressed.
Creating new fields or columns that aggregate values from existing ones.
Enhance and optimizes data sets as needed, through measures such as augmenting and adding data.
Data stored in comma-separated values (CSV) files or other file formats must be converted into tables to make it accessible to Business Intelligence and analytics tools
Choose the CORRECT principle with regard to gathering requirements.
i. Focus on the questions stakeholders are trying to answer rather than the specifics of how the dashboards will look.
ii. Ask “why?” when stakeholders describe what they are looking for.
iii. Don’t limit the discussion, but be sure to prioritize.
I
I & II
II & III
I, II & III
The following diagram shows a dashboard features embedded current CCTV pictures and a weather report. Choose the most suitable answer for the above type of dashboard.
Operational dashboard
Analytical dashboard
Strategic dashboard
Platform dashboard
Data cleansing is the process of fixing or removing incorrect, corrupted, incorrectly formatted, duplicate, or incomplete data within a dataset.
Which of the following statements is TRUE about the chunking method in data cleansing?
Turning a meaningful piece of data (such as an account number) into a random string of characters.
Marking up a word in a text (corpus) as corresponding to a particular part of speech, based on both its definition and its context.
Taking individual pieces of information and grouping them into larger units.
Aggregating individual observations of a variable into groups, so that a frequency distribution of these groups serves as a convenient means of summarizing or analyzing the data.
Prior to designing data visualisations, it is critical to identify target audience to communicate the way data scientists want the audience to assimilate the information. What do target audience expect to obtain from the visualisation?
I & II
I, II, & III
II, III, & IV
I, III &, IV
_________ is information boundary specified based on target audience backgrounds, needs and requirements for the need to communicate the information effectively.
Data visualisation
Data context
Data validation
Data acquisition
________ step is performed by a data scientist after acquiring the data.
Data cleansing
Data integration
Data replication
Data loading
_______ is what you do to understand the data and figure out what might be significant or interesting to highlight to others.
Explanatory analysis
Exploratory analysis
Predictive analysis
Data analysis
Below are the tips of designing a good dashboard, except:
group related matrix
use clear labels
use less colours
use big pictures
The green column in the following figure is derived from a data cleansing method performed. VLOOKUP function has been used to determine "Type of Work" based on hours-per-week attribute. Identify which data cleansing method applied.
part-of-speech tagging
classification
chunking
coding
Identify which of the following is an operation dashboard?
