Forum Discussion
Question about PowerBI:s feasibility
At my work, there is a system that is basically a mathematical program written in Java and C#. It is insurance math specifically and its at a level where there are several mathematicians working on it. From this system and its database, static pdf reports are created. We were wondering if PowerBI reporting could be integrated somehow into the process to replace the static pdf reports. What things should we consider? Is PowerBI suitable for complex mathematics?
Depends on the complex mathematics. I have done a number of complex mathematical/statistical calculations using Power BI. For example:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Krippendorff-s-Alpha/td-p/641996
I can tell you that if your calculations involve matrix algebra, DAX is most likely not the right language. If your calculations involve looping in any form, DAX is not the best language. If your calculations involve recursion, definitely not DAX.
But, you also have M code (Power Query) where you have recursion available to you at least and is generally better suited for complex mathematical calculations. You also can do R and Python calculations in Power BI.
Going to depend on specifics which are not provided.
3 Replies
Anonymous , power bi can integrate with R and python. And most of the common data source. If the calculation is too complex and can not be done in power bi you can use R and Python
https://www.datacamp.com/community/tutorials/data-visualisation-powerbi
https://www.tutorialspoint.com/power_bi/power_bi_supported_data_sources.htm
Hi, Anonymous
I'd like to suggest you use python or R scripts, which is support by Powe BI and personal gateways. For further information, you may refer the following links. Do pay attention to the considerations and limitations.
Create Power BI visuals by using Python
Create visuals by using R packages in the Power BI service
Best Regards
Allan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Depends on the complex mathematics. I have done a number of complex mathematical/statistical calculations using Power BI. For example:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Krippendorff-s-Alpha/td-p/641996
I can tell you that if your calculations involve matrix algebra, DAX is most likely not the right language. If your calculations involve looping in any form, DAX is not the best language. If your calculations involve recursion, definitely not DAX.
But, you also have M code (Power Query) where you have recursion available to you at least and is generally better suited for complex mathematical calculations. You also can do R and Python calculations in Power BI.
Going to depend on specifics which are not provided.
