We use proven technical approaches in developing reporting and analytics solutions.

Most of our data warehousing solutions use relational database systems to provide storage and access to large volumes of data. Relational databases are mature, stable and scalable. For customers need in processing large volumes of unstructured data, NoSQL databases and full-text indexes and data stores are also leveraged to complement relational database stores. Big data and distributed processing using cloud computing, though often expensive, are useful and necessary in certain situations where huge volumes of volatile data needs to be processed in a timely fashion.

We believe fast and accurate number crunching is the key to any business intelligence system. For analytics and reporting, we design the right model, custom build or embed data mining, OLAP and reporting tools, and pre-calculate as much as possible to boost performance.

To deliver the results to the end users, we design and build engaging user interfaces with emphasis on usability and cutting edge information visualization. We believe in interactive, responsive, and intuitive user interfaces for data driven delivery.

Finally, we believe in providing an integrated solution. We are the experts in developing on a variety of systems and platforms and integrating these system architecture components together. As a result, we build end-to-end turn-key solutions.

Our Core Technologies

Relational database systems: Oracle, SQL Server, MySQL, PostgreSQL

ETL, OLAP, analytics/mining, and reporting: Oracle, MicroStrategy, Microsoft BI suite (SSIS, SSAS, SSRS), Pentaho, R, Incanter, Weka, Lucene/Elastic Search.

Information visualization: Google visualization API, D3, Flare, Processing

System platforms and integration: Java and .NET; Windows and Linux; cloud computing (AWS, Heroku, Google App Engine); SOAP and RESTful services