Designed and Developed Data Mart by ETL process. Investigate the Sales for the customer and the product and discovered relationship between the product and customer which helps business managers to make decision on the sales amount. Our Scope does not restrict to only analyze Sales but also includes functionality to summarize customer and product data by using Aggregated Fact Table and other functions like Slowly Changing Dimension.

The Report includes code to implement the data mart. Technologies included to implement data mart: MYSQL workbench, SAS, pentaho, Dimensional modelling.