In any thoughtful analytical exercise, impromptu questions continually arise. Yet analysts and business professionals often struggle to perform very basic ad hoc calculations within common business intelligence tools. As a workaround, users will often pull data into Excel to build basic formulations such as time-period aggregates, percent-of-parent calculations, and dynamic cumulative totals.
There are downsides to this approach: users are duplicating data and further fragmenting the analytic process. Analysis is a continually evolving exercise. Users need to think about the next question constantly. And the next question after that. Answering each successive one cannot come at a tremendous cost or effort. That’s why it’s crucial that users be able to write common business calculations easily within their analytics tool.
Join Ian Macdonald (Principal Technologist, Pyramid Analytics) to learn how Pyramid Analytics’ powerful and flexible calculation engine can be used throughout the application to answer the types of ad hoc questions that constantly arise during everyday analyses.
Ian Macdonald, Principal Technologist at Pyramid Analytics