MSTR TO POWER BI
MIGRATION
PILLARS – Product Migration
MILESTONE
- Replicate MSTR reports and dashboards in Power BI
- Integrate Rig Cloud reports into Power BI applications
- Automation of reports through email deliveries
- Paginated reports developed to duplicate MSTR functionalities
SUCCESS CRITERIA
- Power BI applications developed for all reports with optimized performance
- Self service data models provided for ad-hoc reporting
- Alert reports subscribed to be sent through emails based on high risk incidents created
- Implemented RLS for Rig Cloud reports
Project Highlights & Challenges
- Custom group equivalent reports developed successfully
- Rig cloud reports consisting more than 300 pages developed and subscribed to be sent as PDF export to users
- Graphs with more than 10,000 data points implemented
- Self serve data models with left outer joins on selective tables provided to the end users
- Direct queries in Power BI created to replace excel cubes used in MSTR reports
- Paginated reports created to replicate the export to HTML, PDF functionalities
Technology Stack
Potential Bussiness Impacts
- Setting Application password by getting client secret.
- As the service principal doesn’t have access to any of the Power BI content and APIs. Need to provide service principal access, create a security group in Azure AD, and add the service principal created to that security group.
- Enable the Embed content in apps switch either for the entire organization or for the specific security group you created in Azure AD in the Admin portal
- Add the service principal (Display name of Azure AD app) to the workspace.
- Embed your content using Power BI embedded sample application.
Our Role
1. Project Management
2. Architecture design, Installation and technology solution
3. Requirement gathering, data analysis and data modelling
4. BI application designing and development
5. End user training
2. Architecture design, Installation and technology solution
3. Requirement gathering, data analysis and data modelling
4. BI application designing and development
5. End user training
The “Nice” USP
Our customized end-to-end BI solutions empower our customers to explore many more opportunities for benefits by
exploiting their investment in any BI platform. We understand and foresee that our BI solutions will be an extension to
their current reporting capabilities. Our USP lies in our personalized approach to provide solutions to client’s technical,
function and non-functional needs. To learn more about our innovative functional and technical workshops, prototype
designing activities, customized onsite and online trainings, educative handholding sessions and end user specific
interactive videos and courses, please visit us at www.nicesoftwaresolutions.com
or email us at
info@nicesoftwaresolutions.com.
Recent Case Study
