Slice and Dice Sales to see Business Analytics from Every Angle

Home/Blog, Homepage Blog/Slice and Dice Sales to see Business Analytics from Every Angle

Slice and Dice Sales to see Business Analytics from Every Angle

Slice-and-dice’. Despite sounding more at home the dining room than the board room, the potential of slice-and-dice within business analytics tends to set analysts’ eyes aglow. But what’s really meant by this term? Potential answers include . . .

  • “It means drill-down.”
  • “It lets me view my business from any angle.”
  • “It’s a way of rearranging data, determining KPIs and better understanding how my business is doing.”

Slice-and-dice is often misused (and confused) with the related term ‘drill-down’.

Slice-and-dice refers specifically to the process of viewing data from multiple perspectives, each successive perspective focused on a smaller and smaller subset of the original data. “Slice” refers to an initial perspective – such as “sales by salesperson”. “Dice” refers to subsequent perspectives that retrieve more focused subgroups of data.

For example, a sales manager might wish to view (or “slice”) their department’s activities by salesperson, and then dice those results by each salesrep’s clients. A CFO, on the other hand, might wish to view/slice those same sales activities first by product, and then have them diced by region.

DataSelf’s Sales Slicer Dashboard

A Slicer report enables you to look at your data from every possible angle to identify KPIs, outliers, and anomalies. This includes analysis via multiple “measures” – because while one measure (such as sales revenues) might present a rosy picture of sales activities, a different measure – (such as the gross profits from those sales) might indicate a very different reality.

Effective slicing and dicing provides business analytics for:

  • Multiple perspectives (e.g., at least four levels of slicing)
  • Expedited results (sub 10 seconds)
  • Totals & sub-totals at every level

Business Analytics Provided:

  • With a tool like a Sales Slicer, you can get insight into:
  • Whether gross profits are keeping in line with gross sales
  • Market leaders – regarding top producing items, customers, & regions
  • Outliers – which products, clients, & salesreps are under-performing

Want to see it in action?! View a quick two-minute demo of Sales Slicer here.

About the Author: