25-question diagnostic

Provides an indicative assessment of Excel, analytical thinking, SQL, modelling, Power BI and chart interpretation. The result recommends a pathway; it does not certify a professional level.

Question 1 of 25 · EXCEL

A cooperative receives an inventory with one section per warehouse, Total rows and notes inserted between products. The procedure will become part of a recurring refresh and must be traceable. Two analysts propose different solutions that enable the team to turn the workbook into a source that supports filters and new loads. Which correctly applies the table criterion?

A. The team would attempt to turn the workbook into a source that supports filters and new loads by applying this premise: Dates in DD/MM/AAAA format sort correctly as text and do not need a date/time type. This would replace compare the number of products in each warehouse before and after removing the presentation structure with an output without its exceptions.B. Turn the workbook into a source that supports filters and new loads, but assuming that IFERROR (SI.ERROR in Spanish Excel) must wrap the entire sheet to turn any issue into a usable zero. compare the number of products in each warehouse before and after removing the presentation structure would be omitted and the appearance of the result would be accepted.C. To turn the workbook into a source that supports filters and new loads, it would be assumed that removing duplicates across all columns is equivalent to defining a business key. compare the number of products in each warehouse before and after removing the presentation structure would not be checked; only the same rule for all segments would be checked.D. Retain the stated population and period and turn the workbook into a source that supports filters and new loads. Approval requires the following: compare the number of products in each warehouse before and after removing the presentation structure, because each row must represent an observation and each column a variable with a single logical type.

Question 2 of 25 · EXCEL

A clinic exports expenses with two header levels and repeated names such as Importe in several columns. Acceptance requires another person to reach the same result from the retained source. The team cannot complete the work until create stable fields for accounting reconciliation. Which criterion for headers should take priority?

A. The proposal would be to create stable fields for accounting reconciliation, accepting that removing duplicates across all columns is equivalent to defining a business key. It would omit assign a unique name to each variable and check that no column remains unnamed and be limited to replacing the original source.B. The defensible option is create stable fields for accounting reconciliation; this must be validated when carrying out the following: assign a unique name to each variable and check that no column remains unnamed. The criterion is that headers must be unique, stable and part of the table, with no intermediate titles.C. To create stable fields for accounting reconciliation, it would be assumed that a subtotal row within the table simplifies formulas and does not affect filtering or import. assign a unique name to each variable and check that no column remains unnamed would not be checked; only the same rule for all segments would be checked.D. Create stable fields for accounting reconciliation, but assuming that dates in DD/MM/YYYY format sort correctly as text and do not need a date/time type. assign a unique name to each variable and check that no column remains unnamed would be omitted and the appearance of the result would be accepted.

Question 3 of 25 · EXCEL

An association imports renewals and finds a corrected version and a cancelled version for the same member and period. The result will reach decision-makers using different filters and needs a single definition. An independent review will assess how retain a single valid renewal without deleting traceability was reached. Which answer resolves the issue with duplicates?

A. Retain a single valid renewal without deleting traceability, but assuming that XLOOKUP (BUSCARX in Spanish Excel) can use product names as a key even when names are duplicated or their spelling changes. define partner, period and version as the criterion and send discarded records to a review table would be omitted and replacing the original source would be accepted.B. The team would attempt to retain a single valid renewal without deleting traceability by applying this premise: In a PivotTable, monthly percentages must always be summarised by summation. This would replace define partner, period and version as the criterion and send discarded records to a review table with the first available total.C. To retain a single valid renewal without deleting traceability, apply this rule: Before removing duplicates, define the key and retain a count of removed records. The check before publishing the output is define partner, period and version as the criterion and send discarded records to a review table.D. The proposal would be to retain a single valid renewal without deleting traceability, accepting that SUMIFS (SUMAR.SI.CONJUNTO in Spanish Excel) accepts ranges of different sizes if the first criterion contains all values. It would omit define partner, period and version as the criterion and send discarded records to a review table and be limited to a check carried out after publication.

Question 4 of 25 · EXCEL

A workshop calculates quotations using retired supplier codes that may or may not have an authorised replacement. The person responsible requires the source and a before-and-after comparison to be retained. To retrieve the current price and flag references awaiting resolution without changing the population, which proposal about lookup is correct?

A. The team would attempt to retrieve the current price and flag references awaiting resolution by applying this premise: In a PivotTable, monthly percentages must always be summarised by summation. This would replace test a current match, a code with a replacement and a code with no match with an output without its exceptions.B. To retrieve the current price and flag references awaiting resolution, it would be assumed that a pie chart is the clearest option for comparing twelve months and six regions simultaneously. test a current match, a code with a replacement and a code with no match would not be checked; only the same rule for all segments would be checked.C. The proposal would be to retrieve the current price and flag references awaiting resolution, accepting that SUMIFS (SUMAR.SI.CONJUNTO in Spanish Excel) accepts ranges of different sizes if the first criterion contains all values. It would omit test a current match, a code with a replacement and a code with no match and be limited to the first available total.D. Resolve the case by retrieve the current price and flag references awaiting resolution and retain as a check test a current match, a code with a replacement and a code with no match. This preserves the retained source and the reconciled output and applies the principle that a missing lookup must produce a reviewable status rather than being hidden as a valid zero.

Question 5 of 25 · EXCEL

An insurance broker copies a commission from a product-and-quarter matrix to hundreds of policies. Acceptance requires another person to reach the same result from the retained source. The case file must allow prevent the product row or quarter column from shifting incorrectly. Which option best preserves the meaning of references?

A. Prevent the product row or quarter column from shifting incorrectly; then, copy the formula in two directions and check four matrix intersections. This sequence respects the condition that references are fixed only in the dimension that must not shift when the formula is copied.B. The team would attempt to prevent the product row or quarter column from shifting incorrectly by applying this premise: A subtotal row within the table simplifies formulas and does not affect filtering or import. This would replace copy the formula in two directions and check four matrix intersections with the same rule for all segments.C. Prevent the product row or quarter column from shifting incorrectly, but assuming that in a PivotTable, monthly percentages must always be summarised by summation. copy the formula in two directions and check four matrix intersections would be omitted and the first available total would be accepted.D. The proposal would be to prevent the product row or quarter column from shifting incorrectly, accepting that a pie chart is the clearest option for comparing twelve months and six regions simultaneously. It would omit copy the formula in two directions and check four matrix intersections and be limited to an output without its exceptions.

Question 6 of 25 · PENSAMIENTO

Senda Finanzas mixes invoiced amounts and receipts in the same card. The check must be repeatable without depending on the report creator’s computer. The pending decision is explain weekly liquidity. Which action is technically defensible regarding dimension?

A. Explain weekly liquidity; then, state the event, unit, period and population of each metric. This sequence respects the condition that A dimension describes how to segment; a measure quantifies the phenomenon.B. The proposal would be to explain weekly liquidity, accepting that OTIF can be obtained by adding the percentage of on-time deliveries to the percentage of complete deliveries. It would omit state the event, unit, period and population of each metric and be limited to a check carried out after publication.C. Explain weekly liquidity, but assuming that ROAS measures profit because it already implicitly deducts all the company's costs. state the event, unit, period and population of each metric would be omitted and replacing the original source would be accepted.D. The team would attempt to explain weekly liquidity by applying this premise: A high correlation permits a causal recommendation without controlling for alternative explanations. This would replace state the event, unit, period and population of each metric with the first available total.

Question 7 of 25 · PENSAMIENTO

Orbe Logística finds that the cause of delay is unreported in twelve per cent of cases. The procedure will become part of a recurring refresh and must be traceable. An independent review will assess how prioritise an operational action was reached. Which answer resolves the issue with quality?

A. First, prioritise an operational action; since evidence, measure missing values and analyse whether they are concentrated by carrier. This preserves the granularity of the case and its exceptions and fulfils the condition that A null is interpreted according to the process; it is not automatically replaced with zero.B. To prioritise an operational action, it would be assumed that OTIF can be obtained by adding the percentage of on-time deliveries to the percentage of complete deliveries. measure missing values and analyse whether they are concentrated by carrier would not be checked; only replacing the original source would be checked.C. The team would attempt to prioritise an operational action by applying this premise: ROAS measures profit because it already implicitly deducts every business cost. This would replace measure missing values and analyse whether they are concentrated by carrier with the appearance of the result.D. Prioritise an operational action, but assuming that a high correlation permits a causal recommendation without controlling for alternative explanations. measure missing values and analyse whether they are concentrated by carrier would be omitted and a check carried out after publication would be accepted.

Question 8 of 25 · PENSAMIENTO

Cobalto Ventas shows a percentage decrease without stating the previous period’s baseline. The result will reach decision-makers using different filters and needs a single definition. To communicate the change to the board without changing the population, which proposal about denominator is correct?

A. To communicate the change to the board, it would be assumed that an insight is any change exceeding the threshold, even if it changes no decision. show absolute values, the denominator and a comparable time window would not be checked; only the appearance of the result would be checked.B. The proposal would be to communicate the change to the board, accepting that a metric becomes a KPI as soon as it is highlighted on a dashboard. It would omit show absolute values, the denominator and a comparable time window and be limited to a check carried out after publication.C. Communicate the change to the board, but assuming that the target can be changed at the reporting close if the actual result is very far from the original target. show absolute values, the denominator and a comparable time window would be omitted and replacing the original source would be accepted.D. Retain the stated population and period and communicate the change to the board. Approval requires the following: show absolute values, the denominator and a comparable time window, because A rate is comparable only when its numerator, denominator and time window are compatible.

Question 9 of 25 · PENSAMIENTO

Prisma Salud analyses synthetic appointment data and confuses segmentation with a KPI. The audit does not permit the population to change while the calculation is corrected. The case file must support redesign capacity monitoring. Which option best preserves the meaning of KPI?

A. First, redesign capacity monitoring; since evidence, link each KPI to an objective, owner and threshold. This preserves the version of the data used at the reporting close and fulfils the condition that a KPI needs an explicit objective, formula, period, population, unit and threshold.B. To redesign capacity monitoring, it would be assumed that OTIF can be obtained by adding the percentage of on-time deliveries to the percentage of complete deliveries. link each KPI to an objective, owner and threshold would not be checked; only a check carried out after publication would be checked.C. Redesign capacity monitoring, but assuming that a high correlation permits a causal recommendation without controlling for alternative explanations. link each KPI to an objective, owner and threshold would be omitted and the first available total would be accepted.D. The team would attempt to redesign capacity monitoring by applying this premise: ROAS measures profit because it already implicitly deducts every business cost. This would replace link each KPI to an objective, owner and threshold with replacing the original source.

Question 10 of 25 · SQL

A franchise is looking for shops with more than twenty accepted returns during the quarter. The output will be reused at the next reporting close and exceptions must remain visible. To apply the limit to the count for each store without changing the population, which proposal about which HAVING is correct?

A. The team would attempt to apply the limit to the count for each store by applying this premise: A CTE materialises a permanent table that, by definition, improves any query. This would replace count statuses by store before filtering groups and retain the denominator with the appearance of the result.B. The proposal would be to apply the limit to the count for each store, accepting that ROW_NUMBER does not need a tie-breaker because the engine always retains the physical insertion order. It would omit count statuses by store before filtering groups and retain the denominator and be limited to the same rule for all segments.C. To apply the limit to the count for each store, apply this rule: HAVING filters groups after aggregation; WHERE filters rows before aggregation. The check before publishing the output is count statuses by store before filtering groups and retain the denominator.D. Apply the limit to the count for each store, but assuming that LIMIT is applied before ORDER BY to reduce the set and then identify the highest values. count statuses by store before filtering groups and retain the denominator would be omitted and an output without its exceptions would be accepted.

Question 11 of 25 · SQL

Assortment needs to display all active SKUs, including those with no purchases this month. The person responsible requires the source and a before-and-after comparison to be retained. Two analysts propose different solutions that enable the team to audit catalogue coverage without losing products with no transactions. Which one correctly applies the criterion of LEFT_JOIN?

A. The proposal would be to audit catalogue coverage without losing products with no transactions, accepting that a CTE materialises a permanent table that, by definition, improves any query. It would omit confirm the SKU total and locate NULL amounts after the join and be limited to an output without its exceptions.B. Audit catalogue coverage without losing products with no transactions, but assuming that ROW_NUMBER does not need a tie-breaker because the engine always retains the physical insertion order. confirm the SKU total and locate NULL amounts after the join would be omitted and the first available total would be accepted.C. To audit catalogue coverage without losing products with no transactions, it would be assumed that LIMIT is applied before ORDER BY to reduce the set and then identify the highest values. confirm the SKU total and locate NULL amounts after the join would not be checked; only a check carried out after publication would be checked.D. Resolve the case by audit catalogue coverage without losing products with no transactions and retain as a check confirm the SKU total and locate NULL amounts after the join. This preserves the version of the data used at the reporting close and applies the principle that LEFT JOIN preserves the left-hand population and allows unmatched records to be located.

Question 12 of 25 · SQL

Insurance combines claims with policy conditions that change by version and effective date. The team must also resolve a negative case before approving the submission. Two analysts propose different solutions that enable the team to assign a single valid version to each claim. Which one correctly applies the criterion of join_key?

A. Assign a single valid version to each claim; then, test validity intervals and identify overlaps before the final JOIN. This sequence respects the condition that a join must use compatible keys and be checked for row multiplication.B. To assign a single valid version to each claim, it would be assumed that INNER JOIN is the correct option for identifying customers who do not yet have sales. test validity intervals and identify overlaps before the final JOIN would not be checked; only the same rule for all segments would be checked.C. Assign a single valid version to each claim, but assuming that a JOIN that duplicates rows can be corrected by applying DISTINCT at the end without checking the key. test validity intervals and identify overlaps before the final JOIN would be omitted and the appearance of the result would be accepted.D. The team would attempt to assign a single valid version to each claim by applying this premise: NULL is compared using = NULL because it represents an empty value in the column. This would replace test validity intervals and identify overlaps before the final JOIN with an output without its exceptions.

Question 13 of 25 · SQL

Transport ranks providers by OTIF within service type and needs to break ties by cost. The team must also resolve a negative case before approving the submission. An independent review will assess how publish a stable and explainable ranking was reached. Which answer resolves the issue with ranking?

A. To publish a stable and explainable ranking, it would be assumed that SELECT * is more stable than listing columns because it automatically adapts to any schema. partition by service, sort by OTIF and use cost and the identifier as tie-breakers would not be checked; only the same rule for all segments would be checked.B. The defensible option is publish a stable and explainable ranking; this must be validated when carrying out the following: partition by service, sort by OTIF and use cost and the identifier as tie-breakers. The criterion is that a reproducible ranking adds a tie-breaker alongside the main value.C. Publish a stable and explainable ranking, but assuming that WHERE SUM(importe) filters groups after aggregating them and avoids writing HAVING. partition by service, sort by OTIF and use cost and the identifier as tie-breakers would be omitted and the appearance of the result would be accepted.D. The proposal would be to publish a stable and explainable ranking, accepting that NULL is compared using = NULL because it represents an empty value in the column. It would omit partition by service, sort by OTIF and use cost and the identifier as tie-breakers and be limited to replacing the original source.

Question 14 of 25 · MODELADO

Cobros stores one row per partial payment and Facturas one row per issued document. The solution must retain granularity even if the next batch changes. The pending decision is analyse debt without repeating the original invoice amount. Which action is technically defensible regarding grain?

A. First, analyse debt without repeating the original invoice amount; since evidence, state both granularities and reconcile an invoice with several receipts. This preserves the retained source and the reconciled output and fulfils the condition that granularity states what a row represents and is defined before tables are related.B. Analyse debt without repeating the original invoice amount, but assuming that bidirectional filtering must be enabled on all relationships so that any slicer works. state both granularities and reconcile an invoice with several receipts would be omitted and an output without its exceptions would be accepted.C. To analyse debt without repeating the original invoice amount, it would be assumed that many-to-many cardinality is appropriate when the one side contains unexpected duplicates. state both granularities and reconcile an invoice with several receipts would not be checked; only the first available total would be checked.D. The proposal would be to analyse debt without repeating the original invoice amount, accepting that a fact table can mix daily transactions and monthly targets if they share a date. It would omit state both granularities and reconcile an invoice with several receipts and be limited to the same rule for all segments.

Question 15 of 25 · MODELADO

The Cliente dimension retains two active versions with the same customer_id after a merger. The procedure will become part of a recurring refresh and must be traceable. Two analysts propose different solutions that enable the team to restore a valid one side without losing the necessary history. Which correctly applies the key criterion?

A. The proposal would be to restore a valid one side without losing the necessary history, accepting that many-to-many cardinality is appropriate when the one side contains unexpected duplicates. It would omit apply the validity rule and test uniqueness, nulls and the records retained and be limited to replacing the original source.B. Resolve the case by restore a valid one side without losing the necessary history and retain as a check apply the validity rule and test uniqueness, nulls and the records retained. This preserves the granularity of the case and its exceptions and applies the principle that the one side of a relationship needs a unique key without relevant missing values.C. Restore a valid one side without losing the necessary history, but assuming that removing an ambiguous relationship and replacing it with a measure corrects any propagation problem. apply the validity rule and test uniqueness, nulls and the records retained would be omitted and the appearance of the result would be accepted.D. The team would attempt to restore a valid one side without losing the necessary history by applying this premise: Bidirectional filtering must be enabled on all relationships so that any slicer works. This would replace apply the validity rule and test uniqueness, nulls and the records retained with a check carried out after publication.

Question 16 of 25 · MODELADO

Training relates learners and programmes when each person can take several learning pathways. The audit does not permit the population to change while the calculation is corrected. Two analysts propose different solutions that enable the team to represent the assignment without an accidental many-to-many relationship. Which correctly applies the cardinality criterion?

A. Resolve the case by represent the assignment without an accidental many-to-many relationship and retain as a check create and validate a bridge table with one row per student–programme pair. This preserves the granularity of the case and its exceptions and applies the principle that cardinality describes uniqueness between tables; it is not selected merely to remove a warning.B. The team would attempt to represent the assignment without an accidental many-to-many relationship by applying this premise: A fact table can mix daily transactions and monthly targets if they share a date. This would replace create and validate a bridge table with one row per student–programme pair with the same rule for all segments.C. To represent the assignment without an accidental many-to-many relationship, it would be assumed that model keys must be shown and summarised by summation to make exploration easier for the user. create and validate a bridge table with one row per student–programme pair would not be checked; only the appearance of the result would be checked.D. Represent the assignment without an accidental many-to-many relationship, but assuming that a calendar table needs only dates with sales to reduce its row count. create and validate a bridge table with one row per student–programme pair would be omitted and replacing the original source would be accepted.

Question 17 of 25 · MODELADO

Presupuesto and Real reach Región through different paths via Centro and Responsable. The audit does not permit the population to change while the calculation is corrected. The pending decision is prevent a slicer from activating two ambiguous paths. Which action is technically defensible regarding filter?

A. The proposal would be to prevent a slicer from activating two ambiguous paths, accepting that removing an ambiguous relationship and replacing it with a measure corrects any propagation problem. It would omit draw propagation, retain one deliberate path and compare segmented totals and be limited to replacing the original source.B. The defensible option is prevent a slicer from activating two ambiguous paths; this must be validated when carrying out the following: draw propagation, retain one deliberate path and compare segmented totals. The criterion is that one-way filtering from dimension to fact usually provides a more predictable path.C. The team would attempt to prevent a slicer from activating two ambiguous paths by applying this premise: Many-to-many cardinality is appropriate when the one side contains unexpected duplicates. This would replace draw propagation, retain one deliberate path and compare segmented totals with a check carried out after publication.D. Prevent a slicer from activating two ambiguous paths, but assuming that a calculated column responds to slicers at query time in the same way as a measure. draw propagation, retain one deliberate path and compare segmented totals would be omitted and the appearance of the result would be accepted.

Question 18 of 25 · POWER_BI

Selecting a province on the map changes a national card that must remain as a reference. The team must also resolve a negative case before approving the submission. The pending decision is limit the filter to comparative visuals. Which action is technically defensible regarding interaction?

A. The team would attempt to limit the filter to comparative visuals by applying this premise: The more visuals a page contains, the easier it is for each audience to find its answer. This would replace test source and destination for the map, national card and detail table with the appearance of the result.B. First, limit the filter to comparative visuals; since evidence, test source and destination for the map, national card and detail table. This preserves the documented normal case and boundary case and fulfils the condition that each interaction is configured according to the question; not every visual should filter every other visual.C. The proposal would be to limit the filter to comparative visuals, accepting that mobile design consists of proportionally shrinking the desktop page without rearranging objects. It would omit test source and destination for the map, national card and detail table and be limited to the same rule for all segments.D. Limit the filter to comparative visuals, but assuming that a visual calculation is the best place for any KPI reused across several pages. test source and destination for the map, national card and detail table would be omitted and an output without its exceptions would be accepted.

Question 19 of 25 · POWER_BI

The Reset button restores visuals but retains an old product filter. The output will be reused at the next reporting close and exceptions must remain visible. A reproducible evidence is needed before deliberately capture all the states that must be cleared. Which design handles bookmark appropriately?

A. The team would attempt to deliberately capture all the states that must be cleared by applying this premise: The more visuals a page contains, the easier it is for each audience to find its answer. This would replace change the page, filters and selection before testing the bookmark with replacing the original source.B. To deliberately capture all the states that must be cleared, it would be assumed that the theme alone guarantees AA contrast and alternative text for all objects. change the page, filters and selection before testing the bookmark would not be checked; only a check carried out after publication would be checked.C. Resolve the case by deliberately capture all the states that must be cleared and retain as a check change the page, filters and selection before testing the bookmark. This preserves the segments that the audience will receive and applies the principle that a bookmark saves a defined state and needs a clear route back to the initial state.D. Deliberately capture all the states that must be cleared, but assuming that hidden filters are preferable to slicers because they prevent the user from changing the population. change the page, filters and selection before testing the bookmark would be omitted and the first available total would be accepted.

Question 20 of 25 · POWER_BI

The Producto page receives the category but loses the specific product_id selected in a matrix. The result will reach decision-makers using different filters and needs a single definition. An independent review will assess how transfer the detail key and retain only relevant filters was reached. Which answer resolves the issue with drillthrough?

A. To transfer the detail key and retain only relevant filters, it would be assumed that the theme alone guarantees AA contrast and alternative text for all objects. open two products with the same name and check the context and Back button would not be checked; only the same rule for all segments would be checked.B. Retain the version of the data used at the reporting close and transfer the detail key and retain only relevant filters. Approval requires the following: open two products with the same name and check the context and Back button, because drillthrough opens detail while retaining relevant filters and showing the received context.C. The proposal would be to transfer the detail key and retain only relevant filters, accepting that mobile design consists of proportionally shrinking the desktop page without rearranging objects. It would omit open two products with the same name and check the context and Back button and be limited to the first available total.D. The team would attempt to transfer the detail key and retain only relevant filters by applying this premise: The more visuals a page contains, the easier it is for each audience to find its answer. This would replace open two products with the same name and check the context and Back button with an output without its exceptions.

Question 21 of 25 · POWER_BI

The mobile version places a decorative chart first and leaves KPI unnamed for screen readers. The result will reach decision-makers using different filters and needs a single definition. The pending decision is reorder essential content and provide accessible names. Which action is technically defensible regarding accessibility?

A. Reorder essential content and provide accessible names, but assuming that the theme alone guarantees AA contrast and alternative text for all objects. navigate the mobile layout using a keyboard or screen reader and check focus, contrast and text alternatives would be omitted and replacing the original source would be accepted.B. First, reorder essential content and provide accessible names; since evidence, navigate the mobile layout using a keyboard or screen reader and check focus, contrast and text alternatives. This preserves the granularity of the case and its exceptions and fulfils the condition that tab order, contrast, alternative text and avoiding reliance on colour alone are basic checks.C. To reorder essential content and provide accessible names, it would be assumed that the more visuals a page contains, the easier it is for each audience to find its answer. navigate the mobile layout using a keyboard or screen reader and check focus, contrast and text alternatives would not be checked; only the appearance of the result would be checked.D. The proposal would be to reorder essential content and provide accessible names, accepting that hidden filters are preferable to slicers because they prevent the user from changing the population. It would omit navigate the mobile layout using a keyboard or screen reader and check focus, contrast and text alternatives and be limited to a check carried out after publication.

Question 22 of 25 · STORYTELLING

An algorithm groups customers by frequency and spend. The audit does not permit the population to change while the calculation is corrected. To interpret clusters without attributing causation without changing the population, which proposal about cluster is correct?

A. To interpret clusters without attributing causation, it would be assumed that an executive recommendation can omit risks and an owner if the trend is sufficiently clear. describe variables, stability and the limitations of clustering would not be checked; only a check carried out after publication would be checked.B. Interpret clusters without attributing causation, but assuming that composition with many categories is best communicated using pie sectors in similar colours. describe variables, stability and the limitations of clustering would be omitted and the first available total would be accepted.C. The team would attempt to interpret clusters without attributing causation by applying this premise: The most useful forecast hides the uncertainty interval and shows a single figure. This would replace describe variables, stability and the limitations of clustering with replacing the original source.D. First, interpret clusters without attributing causation; since evidence, describe variables, stability and the limitations of clustering. This preserves the granularity of the case and its exceptions and fulfils the condition that A cluster describes similarity according to the selected variables; it does not demonstrate a cause.

Question 23 of 25 · STORYTELLING

The demand forecast is presented as a single figure. The check must be repeatable without depending on the report creator’s computer. Two analysts propose different solutions to communicate uncertainty. Which correctly applies the criterion for forecast?

A. Resolve the case by communicate uncertainty and retain as a check show the horizon, assumptions and interval. This preserves the retained source and the reconciled output and applies the principle that A forecast states its horizon, assumptions and uncertainty and does not guarantee the future outcome.B. The team would attempt to communicate uncertainty by applying this premise: Two series rising together allow a causal relationship to be described in the chart title. This would replace show the horizon, assumptions and interval with a check carried out after publication.C. Communicate uncertainty, but assuming that a truncated axis improves any comparison because it visually amplifies small differences. show the horizon, assumptions and interval would be omitted and an output without its exceptions would be accepted.D. To communicate uncertainty, it would be assumed that storytelling should remove contradictory evidence to maintain a consistent narrative. show the horizon, assumptions and interval would not be checked; only the first available total would be checked.

Question 24 of 25 · STORYTELLING

The recommendation proposes changing carrier without an owner or metric. The solution must retain granularity even if the next batch changes. The team cannot complete the work until make it actionable. Which criterion for recommendation should take priority?

A. The team would attempt to make it actionable by applying this premise: The most useful forecast hides the uncertainty interval and shows a single figure. This would replace link evidence, action, risk, timescale and follow-up with the same rule for all segments.B. Make it actionable, but assume that composition with many categories is best communicated using pie sectors in similar colours. link evidence, action, risk, timescale and follow-up would be omitted and replacing the original source accepted.C. To make it actionable, apply this rule: A recommendation connects evidence, action, owner, risk and a follow-up metric. The check before publishing the output is link evidence, action, risk, timescale and follow-up.D. To make it actionable, assume that an executive recommendation can omit risks and an owner if the trend is sufficiently clear. link evidence, action, risk, timescale and follow-up would not be checked; only the appearance of the result.

Question 25 of 25 · STORYTELLING

A narrative removes a region that contradicts the overall trend. The output will be reused at the next reporting close and exceptions must remain visible. Before maintain honest communication, which alternative correctly applies the criterion for storytelling?

A. Maintain honest communication, but assuming that composition with many categories is best communicated using pie sectors in similar colours. separate facts, interpretation and contradictory evidence would be omitted and a check carried out after publication would be accepted.B. The team would attempt to maintain honest communication by applying this premise: Data storytelling should remove contradictory evidence to maintain a consistent narrative. This would replace separate facts, interpretation and contradictory evidence with an output without its exceptions.C. To maintain honest communication, apply this rule: The narrative separates facts, interpretation and proposals, including relevant contradictory evidence. The check before publishing the output is separate facts, interpretation and contradictory evidence.D. The proposal would be to maintain honest communication, accepting that two series rising together allow a causal relationship to be described in the chart title. It would omit separate facts, interpretation and contradictory evidence and be limited to the first available total.