MotifWorks team has experience delivering Business Intelligence (BI)/Analytics solutions to a range of industries, such as retail, manufacturing, logistics/supply chain, health-care, financial services, telecom, and more.

Our solutions include horizontal applications such as CRM analytics, sourcing optimization, vendor analytics, promotion analytics, inventory optimization, assortment planning, and material planning.

The MotifWorks team has experience with all the facets of a BI/Analytics solution such as:

• Design and modeling of Enterprise Data Warehouse (EDW)
• Design and development of ETL (Extract Transform and Load)
• Design and development of reports using a range of BI/dashboarding tools

Some of the BI/DW tools that we have experience with are:

• BI Tools – Cognos, BO, Actuate BIRT, SSRS, JasperSoft, Pentaho, SQL Server Reporting Services (SSRS),  and SQR Production Reporting
• Databases – Oracle, DB2, Teradata, and SQL Server
• Analytics Servers – Netezza, Cognos, Business Objects (BO), SAS, and SSAS
• ETL tools – Informatica, BODI, PLSQL, Ascential, SwissSQL, SSIS, and Pentaho/Kettle