article thumbnail

How to Make Interactive Dashboards in Excel

Depict Data Studio

They’ve existed in Excel since 2010 (!!!). If I want viewers to be able to slice and dice by month, then I’d select Month – Name to feed into the slicer. That’s where our soon-to-be-completed dashboard will live. Add a Slicer(s) Finally, we’ll add a slicer(s) to the first pivot chart.

article thumbnail

Web Analytics 101: Definitions: Goals, Metrics, KPIs, Dimensions, Targets

Occam's Razor

Through this consultative process we'll create a 2010 AOV target of $95. Dimensions allow you to group your data into different buckets and they are most frequently used to slice and dice the web analytics data. I'll confab with my Assistant Senior Vice President for American Online Sales.

Metrics 138