An analyst is looking at a particular dataset that includes the scores across all 8th grade students, across three schools. The analyst is trying to determine which type of statistics average to use to best represent the results. On looking through the dataset, the analyst has identified a few extreme outliers. As a result, the analyst was led to use the following type of average:
The median is the type of statistics average that the analyst should use to best represent the results, because it is a measure of central tendency that divides the data set into two equal halves. The median is the middle value of the data set when it is arranged in ascending or descending order. The median is not affected by extreme outliers, unlike the mean, which is the arithmetic average of the data set. The median can give a more accurate representation of the typical score of the 8th grade students across the three schools. Options B, C, and D are not types of statistics average, but types of statistics measures that describe other aspects of the data set. The range is a measure of dispersion that shows the difference between the highest and the lowest values of the data set. The mean is a measure of central tendency that shows the sum of the values of the data set divided by the number of values. The mode is a measure of central tendency that shows the most frequent value of the data set. Reference:
* Business Analysis Certification in Data Analytics, CBDA | IIBA, CBDA Competencies, Domain 3: Analyze Data
* Understanding the Guide to Business Data Analytics, page 17
* Business Data Analytics (IIBA-CBDA Exam preparation) | Udemy, Section 3: Analyze Data, Lecture 13: Descriptive Statistics
A database analyst is modelling a database for a large toy manufacturer. Which statement describes a logical database model?
A logical database model is a data model of a specific problem domain expressed independently of a particular database management product or storage technology. It describes data using notation that corresponds to a data organization used by a database management system, such as relational tables and columns. It also includes rules of normalization, which are the process of converting complex data structures into simple, stable data structures12 Reference: 1: Logical schema - Wikipedia 2: What Is a Data Model? | Coursera
The team has completed their analysis on a vast amount of collected data and agree on their recommendations for action.
However, they are having difficulty in developing the appropriate messages to support their recommendations. The business analysis professional suggests which technique to assist the team?
Storyboarding is a technique that helps the team to develop the appropriate messages to support their recommendations by creating a visual sequence of the main points, evidence, and actions. Storyboarding helps the team to organize their thoughts, identify gaps, and communicate their findings in a clear and compelling way12 Reference: 1: Developing Key Messages for Effective Communication - MSKTC 2: 11 Ways Highly Successful Leaders Support Their Team - Redbooth
While creating a dataset for analysis, the analyst reviews the data collected and finds a large percentage of records are missing values. Which activity would the analyst perform in order to use this dataset?
Weighting is a technique that assigns different values or weights to different records or variables in a dataset, based on their importance or relevance. Weighting can be used to handle missing values by giving them a lower weight or imputing them with a weighted average of other values. Weighting can also help to adjust for sampling bias or non-response bias in the data collection process. Reference:
* Understanding the Guide to Business Data Analytics, page 16
* Business Analysis Certification in Data Analytics, CBDA | IIBA, CBDA Competencies, Domain 3: Analyze Data
* CERTIFICATION IN BUSINESS DATA ANALYTICS HANDBOOK - IIBA, page 8, CBDA Exam Sample Questions and Self-Assessment, Question 4
The definition of data elements is different across various data sources. The organization is looking to improve the usability of data across the organization. Which practice would help address this problem?
Data governance is the practice of establishing and enforcing policies, standards, roles, and responsibilities for the management and use of data across the organization. Data governance helps to address the problem of inconsistent data definitions across various data sources by ensuring that data is properly defined, documented, classified, and aligned with the business objectives and requirements12. Reference: 1: Guide to Business Data Analytics, IIBA, 2020, p. 292: Data Governance: How to Design, Deploy and Sustain an Effective Data Governance Program, John Ladley, 2012, p. 3.
Kimberly Wilson
3 days agoSarah Evans
24 days agoRichard Anderson
1 month agoWilliam Nguyen
2 months agoJennifer Williams
2 months agoSteven Baker
3 months agoSteven Carter
3 months agoBarbara Clark
3 months agoLisa Sanchez
3 months agoDonald Adams
3 months agoPaul Ramirez
3 months agoTiffany Parker
3 months agoQueen
4 months agoAllene
4 months agoGerman
4 months agoIvette
5 months agoCarolynn
5 months agoBarbra
5 months agoHelene
5 months agoRima
6 months agoHarley
6 months agoIluminada
6 months agoJules
7 months agoLenna
7 months agoErnie
7 months agoMaricela
7 months agoJestine
8 months agoSalley
8 months agoJulian
8 months agoGracie
8 months agoJerry
9 months agoStevie
9 months agoJoye
9 months agoHelene
9 months agoSalley
10 months agoMiesha
10 months agoLang
10 months agoMargarett
10 months agoShawnta
11 months agoLeoma
11 months agoKindra
1 year agoLemuel
1 year agoMarisha
1 year agoChristiane
1 year agoMarti
1 year agoTula
2 years agoIsaiah
2 years agoFrancene
2 years agoCharolette
2 years agoCarli
2 years agoIsaiah
2 years agoEarleen
2 years agoKati
2 years agoShayne
2 years agoEdmond
2 years agoKenda
2 years agoLeota
2 years agoFlorinda
2 years agoFarrah
2 years agoMaurine
2 years agoAlmeta
2 years agoLuisa
2 years agoYvonne
2 years agoAleisha
2 years agoAngelo
2 years agoPercy
2 years agoNickole
2 years ago