Design and implementation of solutions for cash flow prediction using Microsoft Power Platform

The main goal of this thesis is to confirm the hypothesis that Microsoft Power Apps can be used for write-back in combination with the use of Microsoft SQL Server Analysis Services technology and reporting in Microsoft Power BI. The assumption is verified on the example of cash flow prediction. The first of the partial goals is to explore the possibility of connecting Power Apps, Power BI and Power Automate when creating a report and a possible write-back tool for users monitoring the outputs in Power BI. Also evaluation of individual possibilities and limitations in the use of these services. The next partial goal is to evaluate the creation of cash flow prediction using visualizations in the Power BI tool. The last of the partial goals is to evaluate the entire cash flow prediction solution using the tools of the Microsoft Power Platform. The result of this work is a functional prototype of a solution for cash flow prediction set in the context of the company's current reporting and a possible refutation / confirmation of the basic hypothesis.The work is intended mainly for users interested in new concepts of solutions within the visualization tool Power BI, the possibility of writing back to the database (write-back) within Power BI or for users dealing with the possibility of creating cash flow predictions in the context of Business Intelligence without use of mathematical prediction models. It is also suitable for users exploring new technologies Microsoft Corporation.