CaseWhen Consulting GmbH

BACKGROUND

Please describe your company and position.

I am the Team Lead Data Management & Business Intelligence of Schindler Deutschland AG & Co. KG

Describe what your company does in a single sentence.

Schindler Deutschland AG & Co. KG is a leading provider of planning, installation, modernization, and maintenance services for elevators, escalators, and moving walks, delivering innovative mobility solutions for safe and reliable vertical and horizontal transportation in buildings.

OPPORTUNITY / CHALLENGE

What specific goals or objectives did you hire CaseWhen Consulting GmbH to accomplish?

• Efficient, automated multi-department reporting in Power BI
• Production-grade data pipelines and CI/CD in Azure Data Factory
• Empowered teams to become self-sufficient in Power BI and Azure Data Factory
• Ensure data consistency and reliability across departments through centralized data models and automated validation
• Reduce dependency on legacy systems by migrating critical reporting workflows to Azure
• Implement standardized data models, naming conventions, and transformation logic

SOLUTION

How did you find CaseWhen Consulting GmbH?

Referral

Why did you select CaseWhen Consulting GmbH over others?

• Close to my geographic location
• Pricing fit our budget
• Great culture fit
• Good value for cost
• Referred to me

How many teammates from CaseWhen Consulting GmbH were assigned to this project?

2-5 Employees

Describe the scope of work in detail. Please include a summary of key deliverables.

Power BI Development:

Creation and enhancement of numerous Power BI reports
Migration of existing report logic into scalable Azure pipelines

Azure Data Platform Setup:

Setup of a production Azure environment (Data Lake, Data Factory)
Implementation of standardized and parameterized data flows and pipelines
Introduction of automated data validation and transformations

CI/CD & DevOps:

Setup of a complete CI/CD process for Azure Data Factory
Automated deployments
Git-based versioning and controlled release processes

Migration & Standardization:

Migration of critical reporting workflows from legacy systems to Azure
Establishment of consistent data models, naming conventions, and transformation logics

Enablement & Collaboration:

Close co-development with the BI team
Knowledge building in Power BI and Azure Data Factory & deployment standards

RESULTS & FEEDBACK

What were the measurable outcomes from the project that demonstrate progress or success?

Improved data refresh frequency from weekly manual uploads to daily automated updates, increasing decision-making speed by 7×

Enhanced data accuracy by 95% through centralized validation and automated ETL error checks

Saved 500+ hours of manual report work in Excel

• Multiple Power BI reports successfully deployed into production, improving transparency, standardization, and decision‑making across departments
• A fully operational Azure data platform, including Data Factory pipelines, and CI/CD processes
• Automated data ingestion and transformation pipelines, reducing manual effort and the risk of errors
• Faster delivery cycles for new reports and data products thanks to standardized models and automated deployments
• Higher data consistency and stability, resulting from centralized models and automated validation logic

Describe their project management. Did they deliver items on time? How did they respond to your needs?

• Understood our requirements quickly and adapted fast to evolving needs
• Delivered agreed items on time and followed the planned schedule reliably
• Transparent communication: if delays or blockers appeared, they informed us proactively
• Responsive and solution‑oriented, providing quick feedback and adjustments when needed
• Collaborative working style, integrating smoothly with our internal team

What was your primary form of communication with CaseWhen Consulting GmbH?

• In-Person Meeting
• Virtual Meeting
• Email or Messaging App

What did you find most impressive or unique about this company?

They consistently impressed us with their ability to quickly understand challenges and reliably find effective solutions.

Are there any areas for improvement or something CaseWhen Consulting GmbH could have done differently?

-