Team Analysis Report using
custom visual and Power Apps
Problem Statement
The report to be developed to show team hierarchy and individual employee details reporting to the respective manager.
Business USA Case Implementation Steps
1. Source as SharePoint for Network View
The data for employee details maintained in SharePoint is converted into structured format to be used as a data point for Social Network view chart in Power BI.
The data for employee details maintained in SharePoint is converted into structured format to be used as a data point for Social Network view chart in Power BI.
2. Source Office 365 for Card View
Data of employees from Office 365 connected as a source for Power Apps to design Card View.
3. Automate the solution
The visual was integrated in Power BI with the help of Power Apps visual available in Visualizations.
The visual was integrated in Power BI with the help of Power Apps visual available in Visualizations.
Tools Used
SharePoint, Office 365, Power Apps, Power BI
- The solution provided has 2 custom visuals for the user to toggle and choose the view.
- Used Social Network Graph, a custom Power BI visual, by connecting SharePoint as a source to display employee image and details.
- An alternative solution was built in Power Apps using Office 365 as a source and created a Canvas App to display all details in one view.
Tools Used
SharePoint, Office 365, Power Apps, Power BI
- A healthcare provider company with 10,000+ employees needed team analysis and project performance tracking.
- Employee details such as image, designation, and reporting manager are displayed replicating Microsoft Teams Hierarchy View.
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
