I’ve been running the trial version of Smart Filter Pro through its paces for a while, and can report back that at least in my view it’s everything they say it is and more.
-
It’s incredibly fast. Even when filtering on my largest dimension table (over 2,300 records) it responds instantaneously on the autofill and search. They say anything more than 30,000 records will slow it down, so just to see what happened, I filtered directly on my fact table of 230,000 records. It was a shade slower, but barely noticeable.
-
saves time and space - rather than fiddling around with a whole bunch of different slicers, you can drop multiple fields into the Smart Filter Pro visual and basically create an integrated slicer panel in seconds. You can choose to have these fields filter each other or not.
-
looks cool and really good UX/UI - it has a great look to it, super configurable and intuitive for the users. One great feature is that with a switch you can turn on a “clear all” slicers option, in addition to the ability to clear any individual slicer separately. This is something I now have to build by hand using buttons and bookmarks.
-
logical filtering - one function I’ve never seen before is the ability to choose between “AND” and “OR”’ interaction between slicer fields in the visual.
-
cost - they just changed the licensing model and it got much cheaper. They also have a nonprofit and government discount of 50%. Taking advantage of the latter, I was able to license up to 200 users for under $150 annually. Even at full cost, it’s basically under two bucks per user per year.
I’m totally sold on this, and it will probably become the most used visual in my reports. I’ve attached a PBIX file from OKViz that demos all these features and many more.
Be very curious to hear what you think.
- Brian
smartFilterProByOKViz-tour-web.pbix (3.2 MB)