WPC 300 UPDATED EXAM SCRIPT 2026/2027 QUESTIONS
AND SOLUTIONS RATED A+
✔✔5. Conduct Critical Analysis - ✔✔For simplicity, start with heuristics -short cuts or
rule of thumbs - to get an order of magnitude understanding of each problem
component and assess the priorities quickly
▪ This helps us understand where we do need more work including more complex
analytics techniques such as game theory, regression, Monte Carlo simulation, or
machine learning
✔✔6. Synthesize Findings from Analysis - ✔✔Assemble the findings from the analysis
into a logical structure to test validity and then synthesize in a way that convinces others
that you have a good solution
▪ Great team processes are critical to the success of this step.
✔✔7. Prepare a Powerful Communication - ✔✔Develop a storyline from the conclusions
that links back to the problem statement and the issues that were defined
▪ It will lead with action steps or pose a series of questions that motivate actions,
depending on audience receptivity
✔✔What step of the bulletproof problem-solving process helps avoid making common
decision-making biases such as sunk cost fallacy.
A: Step-1: Define the problem
B: Step-3: Prioritize the issue, prune the tree
C: Step-4: Build a workplan and timetable
D: Step-6: Conduct critical analysis - ✔✔C: Step-4: Build a workplan and timetable
At this step, good team norms and processes help avoid common pitfalls and biases in
decision making (confirmation bias, sunk cost fallacy and anchoring bias)
✔✔A critical analysis based on heuristics will lead to:
A: Understanding of each problem in great details
B: Avoiding of confirmation bias
C: Getting an order of magnitude understanding of each problem component
D: Developing a story line that links back to the problem statement - ✔✔C: Getting an
order of magnitude understanding of each problem component
Heuristics definition: a mental shortcut commonly used to simplify problems and avoid
cognitive overload.
✔✔Online Analytical Processing (OLAP) also known as - ✔✔Multi-dimensional analysis
(MDA)
✔✔Dimension - ✔✔A dimension is a categorically consistent view of data whose
members can be compared and aggregated (product, time period)
, ✔✔Measures - ✔✔Measure is actual measurement associated with dimensions -
quantitative data that is analyzed across dimension (ex. total sales)
✔✔Cubes - ✔✔Cubes are made of cells - Organized by dimensions and contain the
measures
Example: cube contains 1 measure (revenue) , organized along three dimensions -
Product, Time and Geography
✔✔Slice - ✔✔Two dimensional "slice" of a three dimensional cube
Keep one dimension constant (in the example- geographical area = west)
✔✔Dice - ✔✔Subset (or a smaller version) of the cube
Product = beverages and Dairy
Time = 2018 and 2020
Geography = West and East
✔✔Pivot - ✔✔rotate the current view of data
Simple Pivots are done on a slice - rotate 90 degrees
Columns become rows and rows become columns
✔✔Drill-down - ✔✔Move from aggregated to more granular data of a measure
Move higher to lower in hierarchy or level
Example - we drill-down the time hierarchy from year to month for the year 2020
✔✔Roll-up - ✔✔Move from granular to more aggregated data
Lower to higher in a hierarchy or level
Example - we move up in the geography dimension to a country level
✔✔In a multi dimensional analytical operation, analyzing a smaller version of a cube is
called
A. Slice
B. Pivot
C. Dice
D. Drill-down - ✔✔C. Dice
✔✔Let us assume that you started a job on 08/21/2019. You graduated on 05/20/2022.
How many days have you been working at the job as a student? - ✔✔1003
✔✔What is The difference between VLOOKUP and HLOOKUP?
AND SOLUTIONS RATED A+
✔✔5. Conduct Critical Analysis - ✔✔For simplicity, start with heuristics -short cuts or
rule of thumbs - to get an order of magnitude understanding of each problem
component and assess the priorities quickly
▪ This helps us understand where we do need more work including more complex
analytics techniques such as game theory, regression, Monte Carlo simulation, or
machine learning
✔✔6. Synthesize Findings from Analysis - ✔✔Assemble the findings from the analysis
into a logical structure to test validity and then synthesize in a way that convinces others
that you have a good solution
▪ Great team processes are critical to the success of this step.
✔✔7. Prepare a Powerful Communication - ✔✔Develop a storyline from the conclusions
that links back to the problem statement and the issues that were defined
▪ It will lead with action steps or pose a series of questions that motivate actions,
depending on audience receptivity
✔✔What step of the bulletproof problem-solving process helps avoid making common
decision-making biases such as sunk cost fallacy.
A: Step-1: Define the problem
B: Step-3: Prioritize the issue, prune the tree
C: Step-4: Build a workplan and timetable
D: Step-6: Conduct critical analysis - ✔✔C: Step-4: Build a workplan and timetable
At this step, good team norms and processes help avoid common pitfalls and biases in
decision making (confirmation bias, sunk cost fallacy and anchoring bias)
✔✔A critical analysis based on heuristics will lead to:
A: Understanding of each problem in great details
B: Avoiding of confirmation bias
C: Getting an order of magnitude understanding of each problem component
D: Developing a story line that links back to the problem statement - ✔✔C: Getting an
order of magnitude understanding of each problem component
Heuristics definition: a mental shortcut commonly used to simplify problems and avoid
cognitive overload.
✔✔Online Analytical Processing (OLAP) also known as - ✔✔Multi-dimensional analysis
(MDA)
✔✔Dimension - ✔✔A dimension is a categorically consistent view of data whose
members can be compared and aggregated (product, time period)
, ✔✔Measures - ✔✔Measure is actual measurement associated with dimensions -
quantitative data that is analyzed across dimension (ex. total sales)
✔✔Cubes - ✔✔Cubes are made of cells - Organized by dimensions and contain the
measures
Example: cube contains 1 measure (revenue) , organized along three dimensions -
Product, Time and Geography
✔✔Slice - ✔✔Two dimensional "slice" of a three dimensional cube
Keep one dimension constant (in the example- geographical area = west)
✔✔Dice - ✔✔Subset (or a smaller version) of the cube
Product = beverages and Dairy
Time = 2018 and 2020
Geography = West and East
✔✔Pivot - ✔✔rotate the current view of data
Simple Pivots are done on a slice - rotate 90 degrees
Columns become rows and rows become columns
✔✔Drill-down - ✔✔Move from aggregated to more granular data of a measure
Move higher to lower in hierarchy or level
Example - we drill-down the time hierarchy from year to month for the year 2020
✔✔Roll-up - ✔✔Move from granular to more aggregated data
Lower to higher in a hierarchy or level
Example - we move up in the geography dimension to a country level
✔✔In a multi dimensional analytical operation, analyzing a smaller version of a cube is
called
A. Slice
B. Pivot
C. Dice
D. Drill-down - ✔✔C. Dice
✔✔Let us assume that you started a job on 08/21/2019. You graduated on 05/20/2022.
How many days have you been working at the job as a student? - ✔✔1003
✔✔What is The difference between VLOOKUP and HLOOKUP?
