Analysis and esign of a reporting solution for Vodafone

The thesis focuses on creating an integrated reporting solution for the campaign specialists team at Vodafone. Currently, campaign specialists face significant challenges when analyzing the customer base, which is crucial for planning and evaluating campaigns. The campaign specialists have access to a large number of reports, which are not aligned with each other for fast and effective decisionmaking. Major issues include unclear definitions across reports and the inability to combine dimensions for creating quick ad-hoc analyses. This situation leads to time-consuming efforts when retrieving the necessary information, which could be eliminated by creating an integrated report. One report that combines data from all key reports in one place with clear business definitions of metrics. The aim of the thesis is to create a reporting solution that unifies metric definitions and integrates existing reports. In the first phase of the work, requirements are gathered from campaign specialists and subsequently evaluated. The thesis then focuses on unifying metric definitions and business terms, which currently cause differing interpretations across various reports. This is followed by a technical design of the solution, an analysis of the available tools at Vodafone, examples of technical implementation in the form of data transformations for preparing the underlying tables, and the creation of a dashboard. The main outcome of the thesis is a dashboard that will serve as a unified overview of the prepaid customer base.