Quizalize logo
placeholder image to represent content

YoY QoQ MoM WoW analysis

Quiz by Support - BusinessPromoted .com

Feel free to use or edit a copy

includes Teacher and Student dashboards

Measure skills
from any curriculum

Tag the questions with any skills you have. Your dashboard will track each student's mastery of each skill.

With a free account, teachers can
  • edit the questions
  • save a copy for later
  • start a class game
  • automatically assign follow-up activities based on students’ scores
  • assign as homework
  • share a link with colleagues
  • print as a bubble sheet

Our brand new solo games combine with your quiz, on the same screen

Correct quiz answers unlock more play!

New Quizalize solo game modes
10 questions
Show answers
  • Q1
    What does YoY stand for?
    Year over Year
    Quarter over Quarter
    Week over Week
    Month over Month
    30s
  • Q2
    Which DAX function is used to calculate the Last Year value?
    VAR
    CALCULATE
    ALL
    SELECTEDVALUE
    30s
  • Q3
    How is the percentage change calculated in YoY?
    (Current Year Sales - Last Year Sales) / Last Year Sales
    (Current Year Sales + Last Year Sales) / Last Year Sales
    Last Year Sales - Current Year Sales
    (Current Year Sales / Last Year Sales) - 1
    30s
  • Q4
    What is the purpose of using the SELECTEDVALUE function in the LoQ (Last Quarter) calculation?
    To select the minimum year from the date slicer
    To filter the date table to the previous quarter
    To compare the sales of the current quarter to the sales of all previous quarters
    There is no need to use SELECTEDVALUE function in LoQ calculation
    30s
  • Q5
    How is the MoM (Month over Month) difference calculated?
    Current Month Sales - Last Month Sales
    (Current Month Sales + Last Month Sales) / 2
    Last Month Sales / Current Month Sales
    YoY - MoM
    30s
  • Q6
    What is the trick to identify the low sales month pattern throughout the year in the MoM analysis?
    Analyze the graph to see if a specific month consistently has lower sales
    Calculate the MoM difference for each month and see which month has the lowest value
    There is no trick to identify low sales month pattern in MoM analysis
    Compare the sales of each month to the average sales of the year
    30s
  • Q7
    Which of the following is the first step to calculate WoW (Week over Week) analysis?
    Create a measure to calculate the sales of the current week
    Filter the data to the specific year chosen for analysis
    YoY, QoQ, MoM analysis must be completed before WoW analysis
    Define a variable to store the maximum week number of the year
    30s
  • Q8
    How is the WoW (Week over Week) percentage change calculated?
    YoY - WoW
    Last Week Sales / Current Week Sales
    (Current Week Sales + Last Week Sales) / 2
    (Current Week Sales - Last Week Sales) / Last Week Sales
    30s
  • Q9
    How is the percentage change calculated in YoY?
    Last Year Sales - Current Year Sales
    (Current Year Sales + Last Year Sales) / Last Year Sales
    (Current Year Sales / Last Year Sales) - 1
    (Current Year Sales - Last Year Sales) / Last Year Sales
    30s
  • Q10
    Which DAX function is used to calculate the Last Year value?
    SELECTEDVALUE
    ALL
    CALCULATE
    VAR
    30s

Teachers give this quiz to your class