Apps Development
Data Warehousing/BI
Digitization & Data Entry
E-business Solutions
Enterprise Architecture Integration
Enterprise Systems Mgmt.
Integration & Migration
Staff Augmentation

Data Warehousing/BI
JB Software’s approach towards data warehousing projects has two main features. One is Incremental Development and other is Flexibility.

Incremental Development provides rapid return on investment due to the size and complexity of the data warehousing projects and to the evolving nature of an enterprise’s decision support needs. A flexible methodology allows to tailor the development approach to fit individual client needs.

With an incremental development approach, the complete data-warehousing project can be broken into small, manageable chunks, referred to as projects. In this approach the overall architecture is designed without evaluating all the deliverables up-front. This way only first project or iteration can be concentrated in the planning phase. After each project, the overall architecture, development processes, and business requirements can be reviewed.


JB Software begins the data warehousing projects with the planning and growth activity. During this activity the readiness of the organization for a data warehouse is assessed. Risks associated with feasibility, sponsorship, motivation, and culture is identified. This activity sees the development of a preliminary definition of the scope of the system and preliminary success criteria. A business case is then developed and an estimate made of the expected return on investment of the project.

If it is decided to proceed with the project after findings from the previous activity, the business requirements definition activity begins and high-level requirements for the data warehouse are developed. These requirements are sourced from interviews of executives, managers, analysts, and IT staff. Along with the system requirements, the data sources are identified. The resulting high-level specification of requirements becomes the starting point for three parallel activities: technical architecture design, dimensional modeling, and end-user application specification.


In the technical architecture design activity, the data staging, data warehouse and application environments are designed. Criteria are developed for the selection of products to implement this architecture. Products (hardware, database, data loading, and data access tools) are selected and installed. In dimensional modeling activity, the required star-join schemas are designed. In the next stage, physical design, the required indexes and aggregate tables are designed. The data load process (including the data staging area of the bus architecture) is designed. Attention is given to strategies for ensuring conformity of dimension tables where they are shared by different star schemas and to handling slowly changing data in the dimension tables. In the activities end user application development and end-user application construction, the applications that will be used to access the warehouse are designed and constructed. The basis of this activity is a design of report templates that will provide users with reports with a standard view of the data via a number of selectable parameters. The same report template will be able to provide the users with a large number of views of the data as a result. The applications and report templates might be delivered within a web-based environment, a tool environment, or a custom application.

We provide Business Intelligence solutions which go hand in hand with our Datawarehousing solutions to major clientle in US with the help of our experienced and innovative team using software and tools from vendors like Microstrategy, Actuate and Business Objects.