Zpracování dat pro reporting v oblasti prodeje alkoholických nápojů

This master thesis deals with the design and implementation of a datamart and an automatic process for getting and processing the data. The data relates to reporting on the sales of alcoholic products in foreign markets, specifically in the Caribbean and selected Latin American countries. Author has tailored the solution to the requirements of the client, which in this case is an American company engaged in the distribution, sale, and production of alcoholic beverages. The main objective of this thesis is to create a data infrastructure for the purposes of reporting on individual foreign markets. Fulfilment of this goal includes the design of a datamart and a process for importing and processing the data. This is followed by the implementation of individual steps of the process, data pumps, database tables and stored procedures. Closely related is the deployment of this solution into the production environment. Secondary goals include process monitoring, particularly in terms of sending notifications to users about the progress of the process and alerts in the event of detected errors. Author also compares the deployed solution with the previous state and evaluates the resulting work.