Beyondsoft Consulting - Using Power BI & Multiple Data Sources to Manage Resources in a Sprint
Using JIRA, an issue tracking system, and an internally crafted time-keeping system, this showcase presents a dashboard created to manage sprints and resources across projects and teams.Contact partner Watch video
This solution helps project managers track key performance indicators (KPI’s) (i.e. number of open issues, project velocity, # of hours consumed per project) so that intelligent decisions can be made regarding resource planning. The information presented in this dashboard helps project managers focus on key areas and ensure customer project needs are being met according to the agreed upon schedule. in addition to information on current sprints, the reporting also allows project managers to review performance over time. This historical information allows managers to drill down into the data and identify areas of improvement.
PowerBI allows you to easily integrate data from different sources. in this project, a web API was used to pull data from a cloud-based issue tracking system. This data was then integrated with information from an on-premises database used in an internal time-keeping system. Interactive visuals were created to provide information and insights to project managers.