Tech Stack
- Azure cloud
- Microsoft SQL Server
- Power Apps
- Power Automate
- Power BI
- REST API
- SharePoint
About Client
The client is ranked amongst India’s leading media, publishing, and entertainment groups. They are given the title of being the leaders in the print business. Besides that, they also offer services in different media forms, including radio, TV, magazines, etc. They also own an entertainment channel, an English magazine, a Women’s magazine, and one of India’s largest radio networks.
About Product
Brainvire as a Microsoft partner, provided a tailored solution to address the client's challenges by leveraging a SharePoint-based web application coupled with Microsoft technology and Business Intelligence Reporting. This application was meticulously crafted with the client's unique requirements at the forefront, effectively resolving a multitude of business and operational issues.
Data and table restrictions:
It was time-consuming to access different data and tables because they risk selecting the incorrect data and table.
The team at Brainvire altered permissions and role processes with the aid of SharePoint system configuration. It took less time and required a more organized approach thanks to this setting and Business Logic's restrictions on access to column and table level data.
Solution
The Challenges
Result
- Role-Based Permission as a ResultEveryone having easy access can confuse the client team and lead to security failures. As a result, our team added the functionality of role-based permission, which restricts access to certain data to members of a given team.
- Track PerformanceThe team was able to track which queries are being run, the performance of those queries, and the overall health of the server.
- Achieve Desired Data ParametersThe client was able to see the inputs from structured data. And also, this structured data was in a complete standardized format for providing information about a page and classifying the page content to the client.
- Forecast InsightIt helped organization gather reliable information. It helped the user to predict future trends for making informed decisions.