Calculations in BI Office vs Power BI vs Excel
I know BI Office has some powerful custom calculation options. Can someone explain how these compare to Power BI and/or Excel.
Thank you for the question.
BI Office provides the best ability over to create simple to advanced analytics without the need of scripting knowledge, opening analytics up to the largest audience possible. And this analysis can be reused across all content for specific user groups to make sure all audiences are working in unison.
- Analytics. Simple analytics are surfaced via right-clicks, such as Mathematical, Context, Date, Aggregate functions (more details HERE). The next level of advanced analytics are surfaced up in the Analytics and Query Tab. The Advanced Set Designer allows for complex calculation creation with nested filters in a point and click fashion. The Advanced Calculation Designer allows not only for complex member creation, but an easy KPI creation capability AND What-If modeling option. Other wizard driven, no script option include the ability to create Time Intelligence, Binning, Cascading Filters (using parameters). R-integration is made simple by allowing single click forecasting but also allowing for a R text wizard. And of course nested, dynamic N-N filters that would normally require customer MDX script (GENERATE statement). And all content can be custom edited as well as all script that comprises the content is fully accessible for those with more advanced knowledge.
- Reuse of calculations across all views/content. Any and all logic created by analysts can be secured (Private, Public) by user group and shared across ALL Objects in BI Office. This capability is incredibly powerful in that IT is not required to share the wealth of knowledge across the organization.
Excel (and to a lesser extent, Power BI) can do a number of calculations. But you have to have skill to script out the formulas/calculations for all but the most basic functions.
Jason Picker and Michael Raam for more context.
Thank you - John HormaecheaReply