EndorsedendorsedOngoing

Azure SQL Migration and Power BI Integration for Hilti

Services Covered:

Big Data Analytics and Business IntelligenceCloud Consulting and Services
Project hero — replace with case study imagery
Industry
Industry

Engineering & Manufacturing

Duration
Duration

9 months

Budget
Budget

Confidential

Start Date
Start Date

1 December 2023

Team Size
Team Size

1-5

Engagement Model
Engagement Model

Onshore

Project Capability Score (PCS)

gauge meter
81/100
Strong

Project Capability Score (PCS) estimates how capable SnapStack is of successfully delivering a project like this, based on its past experience, track record, and ability to handle similar work. Learn more about PCS


Client

Hilti

mapPrague, Czech Republic

Project Summary

Hilti (construction industry) engaged SnapStack Solutions to migrate multiple SQL Server instances to Azure and reconnect the company's reporting tools (Power BI) to the new environment. The vendor completed the scope, delivered timely results and testing, and the client signed off on user acceptance testing and the acceptance protocol; communication and flexibility were highlighted as strengths.

Key Challenges

  • Migration of multiple Database servers from one to another location and then to Azure cloud
  • Reporting in Power BI (reconnection and integration to new servers)

Project Deliverables

  • SQL Server migration to new location and to Azure
  • Reconnection of existing reporting products to the new server (Power BI)
  • Testing and debugging of reporting and data connections
  • Review and optimization of the existing setup

Project Solution

SnapStack migrated the client's SQL Server instances to a new environment and to Azure, reconnected existing reporting products (Power BI) to the new servers, and performed testing, debugging and optimization. The engagement included review and improvement of the existing setup to ensure stable reporting after the migration.

Project Outcome

  • Successful completion of the development
  • Signed-off User Acceptance Testing and Signed Acceptance Protocol
  • Results delivered on time with fast, flexible communication and responsiveness

Platforms

  • CloudCloud

Tech Stack

  • AzureAzure
  • Microsoft SQL ServerMicrosoft SQL Server
  • Power BIPower BI

Client Endorsement

Overall Review Rating

4.75star5 out of 5 stars

Timeliness

Cost Rating

Willing to Refer

Quality of Deliverables

SnapStack Solutions has completed the project, and the client has signed off on the user acceptance testing and acceptance protocol. The team has been delivering timely results, communicating efficiently and quickly, and being flexible. Moreover, they are responsive and address the client's needs.

Tetyana Mazur

Head of Controlling & Reporting

Note: This endorsement is based on publicly available client feedback from external review sources.

More Projects by SnapStack