Here at Facet, we're obsessed with rapidly adding new features that help our clients dig deeper into their data. This is why we're excited to announce the release of multi dimensional pivot tables as part of the Facet application. Now you can seamlessly create large pivot tables with multiple dimensions to easily explore your time series data. For those who speak SQL, this is the result set for a query with multiple “group by” elements. You build your multi dimensional pivot table in the right-hand panel of a Facet workspace, letting you view your time series charts simultaneously.
Our power users have been beta testing pivot tables and the early feedback has been positive. One beta user described it as “a game changer over Looker” after experiencing how it took mere seconds to create a pivot table sorted by percent change in week-over-week metrics.
The power of pivot tables becomes evident when you see the metrics recalculate in real time as you update filters and timeframes. You could create a dashboard inside of Looker/Tableau that would appear the same as Facet, but it would be static. Your data analyst would set up the dashboard, and it would only contain the same dimensions, filters and timeframes. Unlike static dashboards, business needs (and oftentimes, business data) are constantly evolving. Today, you’re interested in viewing week-over-week data, tomorrow you may need to compare this Wednesday against last Monday. Or maybe you need to analyze revenue on ‘device make’ by ‘device model’ today, but spend on ‘app name’ by ‘advertiser name’ the next. With Facet, you have the freedom to easily explore and analyze your data, using just a few clicks. If you no longer need the pivot table, simply close or minimize and use the traditional Facet exploratory view.
Want a deeper dive into Facet pivot tables? Our lead application engineer walks you through a demo of the pivot tables in this video.
Interested in seeing the power of Facet on your own dataset? Contact firstname.lastname@example.org for a demo, or visit app.facetdata.com to create an account and get started with a free trial.