Chapter 10: Calculating Columns Using Complex Algorithms
The data ingestion phase allows you to gather all the information you need for your analysis from any data source. Once the various datasets have been imported, it may be that some of this information, taken as it is, isn't useful in describing a phenomenon from an analytical point of view. It is often necessary to apply non-trivial algorithms to the data you have in order to get measures or indicators that will do the trick and Power BI often doesn't have the tools to calculate them. Fortunately, thanks to R and Python, we have everything we need to calculate our measures.
In this chapter, you will learn about the following topics:
- The distance between two geographic locations
- Implementing distances using Python
- Implementing distances using R
- The basics of linear programming
- Definition of the LP problem to solve
- Handling optimization problems with Python
- Solving LP problems with R...
