Sharepoint Consulting > Our Work

Our Case Studies



MDA Information Systems LLC (MDA) is a U.S. operating unit of MacDonald Dettwiler and Associates (MDA LTD) that specializes in the innovation and development of advanced information solutions in four specialty areas: Geospatial, Weather, ISR and Sensor Systems Technologies. MDA was seeking a competitive advantage by demonstrating to their clients their superior project management capabilities.

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

MDA Portal Screenshot

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
MDA Intranet Screenshot


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!

High Tech Industries


BI Solution Branding Content Management Solution Document Solution Extranet Portal Project Management Solution

Technology Stack

SharePoint 2013 SQL 2008


Subscribe to our full RSS feed and stay up to date with all the latest content (blogs, news, videos, slide presentations, jobs) we post in our site.