Tech Stack
- Postman
- Power BI
- Power Query
- SAP CLOUD
About Client
The client is to set new standards for integrated Real Estate service solutions globally. They wanted an integrated service solution based on international standards, giving our stakeholders the peace of mind to focus on their core operations while adding sustainable value to their assets.
About Product
Brainers developed a Microsoft-based ticket analyzer solution that automated the client’s service deliverables. This application offers precise information on analyzed tickets along with issues. The app updates the client about solved tickets and customer feedback. Our Brainers have designed the app to escalate the tickets to the right team and person. The individual addresses the ticket and further works on it. Alongside this, the customized dashboard provides a comprehensive report and analysis of all tickets, teams, and tasks completed to the client.
Synchronized Data Integration:
The biggest challenge was to align tickets raised from multiple sources at any time.
Brainers examined the nature of their streams and proposed using Power Query and Power Pivot. Brainers chose these tools because Power Query offered an enriched experience of importing data while Power Pivot has excellent potential to shape this data effectively. We integrated these tools with multiple sources to track each piece of information and tickets raised for the client. Alongside this, all this data was stored in an organized format at a single location.
Solution
The Challenges
Result
- Centralized Location:Brainers introduced Power Pivot and Power Query to accumulate and store all data at a single location.
- Two-Factor Authentication:Azure Active Directory provides two-factor authentication that provides smooth but controlled data access to the client.
- Easy To Interpret Data:With POSTMAN API, it was easier to translate data into English and process it further to the right team.
- Improved Decision-Making:The interactive and accurate graphical representation on the dashboard assisted the client in making lucrative business decisions.