The mission aimed to enhance the SAS programming skills of selected ACM employees
and support them in building datamarts and reports for both the Life and Non-Life departments.
Coaching started at SAS LEVEL ZERO, and by the end of the mission, the users had become INDEPENDENT.
Each month, topics were selected from the BeOptimized coaching library, covering the equivalent of SAS Prog 1, Prog 2, SQL, and Macro. Theory was explained and reinforced through tailored exercises.
Two datamarts were created to load, transform, and monitor Data Warehouse tables. Automated reports were then developed.
For the Life department, reports focused on mathematical reserves and various listings, while for the Non-Life department, Excel dashboards were built to track key monthly indicators (e.g., new contracts, claims by category).