Secondary Sales Tracking Application...Developed at Zed-Axis
The objective was to track the Secondary Sales; after collating the monthly sales data from distributors across the country.
We came up with a web based Business Intelligence Tool leveraging the power of Internet to bring along the data from all distributors to a common platform and thereby massaging it to convert into a usable format.
The data warehouse was built using the SQL Server for data storage and SQL OLAP services for the OLAP Cube(s). The Business Intelligence tool was built using J2EE and interacts with SQL-OLAP service using XMLA.