Home > Casos prácticos

Caso Práctico

Data management and support in migrating to a new MS Teams Enterprise Voice telephone system

Data Engineer creating a Power Query database

Client

 

deutsche_bank

 

Industry
  • Banking & Finance
  • Headquarters in Frankfurt (re-established in 1957)
  • Major global bank, operating in retail and corporate banking, as well as investment banking
  • Balance sheet total: 1,312 billion euros
  • Deposits: 622 billion euros
  • Customer loans: 479 billion euros
  • Approx. 130,000 employees (global, internal and external working for the bank)
  • Approx. 1,400 branch offices

Challenges

Creation of a central data foundation and data structure in the form of a data warehouse using Excel Power Query to handle mass migrations every weekend:

  • Acquiring and learning the Power Query structure.
  • Adapting technical knowledge with the operational process of employee migration.

Solutions

  • Create a Power Query database and keep it updated daily.
  • Perform data analysis for special configurations of various banking areas.

Methodology

Business analysis and data analysis.

Tecnologies

  • Excel Power Query (M-Language)
  • Microsoft Teams EV functions
  • ChatGPT
  • Various additional support software

Timeline

April 2024 - September 2025

Results and customer experience

  • Transition to modern communication technology.
  • Cost reduction through the elimination of Avaya licences.
  • Support with mass migration of Deutsche Bank employees.
  • New perspectives and solution approaches from outside.
  • Advanced automation through Excel Power Query.
  • Advanced automation mindset in the area.