BI platform

Our client, a Canadian software company, needed outstaffing support for the development of functional modules for the Business Intelligence Platform and its mobile version. So, our goal was to create a modern platform for business analysis and data-driven management.

Project details

Platform
Web & mobile
Services
Business Analysis, Web & mobile development, QA, Support & maintenance
Partnership
2008 – 2010
Hours spent
104k+

The situation

Our main task was to develop a Business intelligence platform that helps companies gather, understand, analyze and visualize their corporate and financial data. When planning the platform architecture, we consider the friendly interface for users can easily interpret the information and make better strategic decisions.

Before starting development, we highlighted such platform goals as a definition of profitability from each product, analyzing total revenue by country, city, and region, exploring sales dynamics for a week, two weeks, a month, or year. So, we added such indicators. In addition, any indicator should be visually presented in the form of a graph, chart, or table.

We should also keep in mind such platform pinpoints as a simple integration of multiple data sources, data warehouses, and CSV files. Then we should add functions to clean data and manage its quality for the correct organizing in the next step. Moreover, the platform should blend the imported, and previously uploaded data into one data set. Thus, we should create a powerful solution that allows users to get usable data from various sources for planning, reporting, financing, and boosting their businesses.

The solution

So, the developed solution contains such features:

  • Modeling, forecasting, and time series analysis
  • OLAP analysis
  • Data storage and processing
  • Data extraction, conversion, and upload
  • Dashboard Designer
  • Report Designer
  • Development of advanced UI components and visual themes

Technology stack

Xcode
iOS SDK
Graphics Device
Interface
BCGControlBar

Key results

We developed web and mobile versions of the BI platform to manage the data flow, from gathering to visualizing more efficiently. The other benefit of this BI platform is simplicity, so users don't need a highly technical background to analyze data and create reports. The developed platform can be a powerful tool for C-level executives, marketing specialists, sales managers to make the right data-driven decisions and increase company profit.