14
Calculating Columns Using Complex Algorithms: Optimization Problems
As a Power BI analyst, you may be faced with interesting mathematical optimization problems. There may be times when you need to solve basic, yet critical, optimization questions without having expertise in advanced mathematical concepts. Linear programming (LP) has made its way into data analysis with its simple requirements and immediate applicability. To show you how effective and easy it is to apply LP techniques to real-world cases, you will see how to solve a simple demand optimization problem for a manufacturing company using both Python and R in Power BI.
This chapter will cover the following topics:
- The basics of linear programming
- Handling optimization problems ...
Get Extending Power BI with Python and R - Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
