MDA Information Systems LLC (MDA) is a U.S. operating unit of MacDonald Dettwiler and Associates (MDA LTD) that specializes in innovation and development of advanced information solutions.
The Challenge
Resource information was being tracked in several spreadsheets and MS Access databases, and there was no easy way to provide reporting to the client or their customer. A new RFP was being pursued MDA wanted automation upgrades.
What We Did
We created a virtual machine with a standalone SharePoint 2013 farm that MDA staff could work on with us. In an iterative design process, we worked through the logic of how to present vast amounts of data containers. SharePoint's Excel services became pivotal (no pun) in presenting the data in slicers and dicers for Interactive Power Pivot workbooks.
- SharePoint BI Tools, Excel web services
- PowerPivot Scheduled data refresh
- Performance Point Services
- SQL Server Reporting Services (SSRS)
- SharePoint Org chart tool that linked to AD
The Result
- Project Resource Information System Manager (PRISM)
- Usability of data in SharePoint lists for reporting and dashboards
- Easily created dashboards based on Excel charts, pivot tables using slicers that are connected to SharePoint data
- Great reporting features with SSRS and Excel services
- Ability to expand in the future to connect to external data as needed
- Document management system for tracking project management reports, RFP' s, and other project data
- Automatic org chart generation
As one of the oldest providers of Microsoft SharePoint consulting services we can help you get the most out of SharePoint
so
contact us today! One of the easiest ways to get to know us is with a
SharePoint health check, where we can quickly review your current configuration and recommend ways to improve SharePoint for you!