2010, Reporting and Slice and Dice

How to Make Interactive Dashboards in Excel

Depict Data Studio

SEPTEMBER 18, 2023

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. Click on the Report Connections button. That’s where our soon-to-be-completed dashboard will live. A slicer is just a fancy name for a filter.

Interactive

Interactive Dashboards Slice and Dice IT

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

Occam's Razor

APRIL 19, 2010

Metrics almost always appear in columns in a report / excel spreadsheet. I might use other metrics in my reports, say Visits or # of Videos Watched or whatever. It is rare, even with the best intentions, that you'll create targets for all the metrics you'll report on. This is a crude way to think about it but.

Metrics

Metrics Key Performance Indicator KPI Business Objectives

Data Leaders Brief

How to Make Interactive Dashboards in Excel

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

Webinars

Stay Connected