DSC119_Chap 2: Data Preparation Methodology and Interface Design

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