Case Study

Data analysis and service quality improvement

Data analyst verifying and improving data quality

Industry
  • Media & Telecommunications
 
Challenge
Our client in Portugal is looking to improve the quality of its customers' experience, through:
  • Data analysis
    Verification and monitoring of data quality within the database and Google Cloud to ensure accuracy and reliability for decision-making.
  • Power BI report creation and updating
    Weekly updates are performed on all reports concerning voice, TV, residential and mobile internet services, in order to identify potential performance and quality improvements, and to minimise potential conflicts between databases.
  • New developments
    Managers conduct an analysis to identify areas where process updates and new reports should be implemented to minimise and automate as many reports as possible.

Solution

Continuous development in the areas of data analysis and design, namely:

  • Improvement of data quality.
  • Creation of new dashboards for metric analysis.
  • Process automation.

Methodology

Scrum.


Technologies

  • Apache Spark
  • Hadoop
  • Python
  • SQL
  • Git
  • Jira
  • Hive
  • Google Cloud

Results

Improvement of the quality of service provided to customers.

Time and resources

One consultant per product to ensure data quality. Their tasks include:

  • Daily monitoring.
  • Daily process checks.
  • Weekly report updates.