SharePoint Application With BI Reports For A Leading News, Media and Entertainment Company
About
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.
Project Highlights
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.
The Challenges
- Data and table restrictions:It was time-consuming to access different data and tables because they risk selecting the incorrect data and table.
- Troubleshoot Problems With QueriesOne of the major challenges our team faced was monitoring the production environment to see which stored procedures are affecting performance by executing too slowly.
- Unstructured Data:There was a need to set a proper structure to understand customer behavior
- Effective Data MiningThe client found it difficult to handle large amounts of data and forecast insights
Tech Stack
Microsoft SQL Server
SharePoint
Azure cloud
Power BI
REST API
Power Automate
Power Apps
Result
Role-Based Permission as a Result
Everyone 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 Performance
The 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 Parameters
The 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 Insight
It helped organization gather reliable information. It helped the user to predict future trends for making informed decisions.
