Time Intelligence: How Date Lists and Ranges Accelerate Insights
The blog explains how Pyramid's time intelligence features enable users like Paul, a data analyst, to create dynamic reports by using "from" and "to" date parameters combined with a "Range List" function to flexibly select and display data within customizable date ranges, enhancing control and insight in time-based data analysis beyond what many BI tools offer.
This is the fifth blog in the series on how Pyramid brings time intelligence into analytics.
In previous blogs, the author demonstrated how Pyramid provides automatic date parameters to interrogate different data slices at will, how to add intelligent calculations in a few clicks, and how to edit and adapt them. In this last post, the focus is on how a user can vary the date range of the data being analyzed, offering full control and flexibility over how the data is displayed. This is a critical element of time intelligence data analysis that is often missing in comparable BI applications.
Business case
Paul, the data analyst at Intensive Health Care from an earlier post, would like to choose a date for his report and dynamically select the start and end dates for his date range selection.
Current report
Paul creates a “from” and “to” date parameter (parameters are simply a predefined list of items that can be injected into another function). He then uses them inside the “Range List” function in the List designer (located within the Formulate module). This function asks the user to designate a range of elements from a start element (“from”) to an end element (“to”). The list engine then creates a functional listing of items between the two points—perfect for building a range of dates.
New report format
Paul now has a fully dynamic date range report that will give users full control over the dates shown in the report. After selecting June 2018 through February 2019 from the two-parameter dropdowns, the previous report changes to just the monthly data between the two date selections.
Conclusion
In this series of blogs on time intelligence, Pyramid’s tools for date-time analysis have been briefly covered. The automatic date-time grouping function is available during data modeling (ETL) and also on-the-fly. The advanced formulation tool for calculating date-time calculations (year-to-date, month-to-date, etc.) is available in the form of ready-built functions and can also be used in building more advanced user-defined functions. In this final blog, it is shown how Pyramid offers powerful tools to create parameters and date range functions that give users pinpoint control of date ranges.
The principle of both providing immense power to the business user, combined with the speed and ease to create dynamic functions, are the hallmark of Pyramid’s approach to bringing powerful BI functions to analytics.