Project Description


Case Study

The Distribution Portal was based on SharePoint Commerce Service and utilized SQL server as the backend.  Amexon was responsible for creating the DDBMS schema, writing advanced queries and migrating the data from SQL Server 2005 to SQL Server 2014.  Amexon also designed a data warehouse for the distribution portal which utlizied SQL servers OLAP capabilities in a Star-Schema.  Amexon was responsible for creating various business intelligence reports using SQL Reporting Services.