Keywords

Analytical Keywords

1. Change
You can ask queries and analyze growth or decline in a Measure over time through Change

Examples:

1. Change in Profit for south region by quarter
2. Percentage change in sum of Sales by month
3. Absolute change in sum of Sales by week

You can also ask the same type of questions using: vary, variance, difference, evolve, growth, decline, going up, coming up, improve, appreciate, increase, increment, ascend, add, rise, Going down, coming down, depreciate, decrease, descend, decrement, reduce, fall, subtract, drop.

2. Compare
Here you can compare between measures and dimensions

Examples:

1. Compare sum of Profit with sum of Sales
2. Compare sum of Sales with sum of Discount for Second Class (Ship Mode)
3. Compare Canada vs Indonesia (Country) for sum of Sales

You can also ask the same type of questions using: contrast, vs, versus.

3. Why
Find out the reasoning behind the occurrence of any event. You must have a hierarchy already present in RazorIQ (present at the top right side of the screen) as a prerequisite to generate reasoning-based insights

Examples:

1. Why did Sales decline for south region?
2. Why did sum of Sales change for Furniture (Category) by month?

You can also ask the same type of questions using: reason, cause, because, drive, impact, influence, affect, factor.

Trend
Asking trend-based type of questions helps you detect changes in periodic patterns, early warning signs and outliers, so you can make proactive decisions to mitigate early risks

Examples:

1. Quarterly Trend for sum of Sales
2. Longest weekly growth for sum of Sales
3. Longest monthly decline in sum of Sales for United States (Country)

You can also ask the same type of questions using: trendline, movement, progression, fluctuation.

Budget vs Analysis
Budget provides spend visibility and analysis to reduce costs and improve results

Examples:

1. Change in budget utilized for south region
2. Budget utilized by west region

You can also ask the same type of questions using: utilize, used, expense, expenditure.

Target vs Achievement
Target-based queries let you measure variance between the target value and actual value for different dimensions. This is especially useful in Sales reports where consistent target objectives v/s achievement statistics are presented

Examples:

1. Target achieved by west region
2. Worst performing brand by target achievement
3. Top 3 regions w.r.t target achieved

You can also ask the same type of questions using: goal, aim.

Generic Keywords

Contribution
Lets you know the share percentage of entities in relation to a Measure

Examples:

1. Contribution of Canada (Country) to sum of Sales
2. Highest contributing country to sum of Sales
3. Compare the contribution of Furniture vs Office Supplies (Category) for sum of Discount

You can also ask the same type of questions using: distribution, share, market share.

Rank
It lets you track the position of an entity in relation to other entities for the same parameter

Examples:

1. Rank of Canada (Country) for sum of Sales
2. Compare the rank of Furniture with Office Supplies (Category) for sum of Quantity
3. Compare the rank of EMEA (Market) in relation to sum of Sales and sum of Discount
4. Compare change in rank for EMEA (Market) in relation to sum of Sales vs sum of Discount by month

You can also ask the same type of questions using: standing, position.

Top n Bottom n
You can ask queries based on the Top and Bottom performance parameters

Examples:

1. Top 2 Markets for sum of Sales
2. Bottom 2 decliningMarkets for Monthly sum of Sales
3. Why did the monthly sum of Sales increase for the top 5 growing categories?

You can also ask the same type of questions using: best, highest, maximum, most, biggest, worst, lowest, least, minimum, smallest.

Count
Count helps you ask queries based on overall count or unique count of dimensions and measures

Examples:

1. Count of Region(s) for Domestic (Client Type)
2. Change in count of unique Countries

You can also ask the same type of questions using: number, tally, frequency, how many, row count.

Breakdown
This allows you to deconstruct the given measure by requested dimension

Examples:

1. Breakdown of trend of sales for all Countries
2. Breakdown of trend of sales for Canada

Summary
Helps you obtain an overview of an event

Examples:

1. Summary of Target Achieved (Sales) for Regions.
2. Summary of Budget Utilized for Canada.

You can also ask the same type of questions using: snapshot, overview.

Percentage
Obtain percentage-based insights and values

Examples:

1. Percentage growth in Sales
2. Percentage of Sales contributed by India
3. Percentage decline in sales for Canada

You can also ask the same type of questions using: cent, rate, %