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
A SharePoint based web application that uses Microsoft Technology along with Business Intelligence Reporting was offered as the solution to the problems that the client faced. The application was developed keeping the client’s requirements in mind. The incorporation of Microsoft technology for development of the application helped to solve multiple business and operations related issues of the concerned client. We developed an application that can be used to monitor and track audience engagement with content across different channels. This includes tracking viewership, user engagement, and other metrics related to content consumption. The application also allows analyzing customer data and gaining insights on customer preferences and interests. This can help the company to develop more targeted content and marketing campaigns. The application enables developers to develop effective content strategies. This includes identifying content trends, analyzing customer feedback, and developing strategies for content optimization. The application helps organizations optimize content marketing campaigns.
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.