Vytvoření automatizovaných dashboardů pro podporu přímého marketingu

The goal of the thesis is to create fully automated dashboards, based on which employees from the company's marketing department will be able to make better decisions. These dashboards contain data in monthly granularity, while in the current month, data for the current day is always available with a two-day delay. There are three dashboards in total, namely the Sales, Marketing Consents and Products dashboards. As for the division of this thesis, it is divided into 6 parts. In the first part, the goal and overall purpose of the thesis are defined in more detail. The following chapter is devoted to the theoretical part, which familiarizes the reader with the basic concepts that are crucial for understanding the implementation part. After the theoretical part, the business specification of the project is defined, in which the individual dashboards are described. In the following technical solution, attention is paid to the description of the environment and the architecture of the solution itself. The penultimate part concerns the implementation, in which the procedure for creating and optimizing all scripts is found. This section also covers the process of automating and creating dashboards. The final part is devoted to a summary of all outputs and possible improvements for the future.