Home    Careers    Contact    Sitemap
 
     
Products
XLDashBoard (XLDB)


XLDashBoard  (XLDB) – a Performance Monitoring Tool for Small and Medium Enterprises

Typical Client

A small and medium enterprise with 20 – 25 managerial positions, who have implemented small ERP or online transaction processing system.

Application

Business Intelligence for performance management:

  • Top level performance management with subject areas.
  • Business Processes with internal subject areas. 
  • Daily performance reporting using Key Performance Indicators aligned to Key Result Areas of managers.
  • Analytical capability (using Online Analytical Processing – OLAP View technology) to slice and dice information and drill-down to: 
    • Identify high and low performing areas 
    • Identifying causes of performance.
  • Development of custom reports – XLDB has built-in tool for enabling users to develop their own reports and OLAP views.

Features

  • Graphical Dash Board
  • Dash Board Tables and Graphs
  • OLAP Views 
  • Analytics – Trend and Pareto analysis
  • Reports
  • Alerts
  • Access control
  • Extract, Transform and Load software for automated refreshing of Data  Warehouse and OLAP Cubes

Technology

  • Excel front-end with VBA 
  • MS - Analysis Services 
  • MS – SQL Server 2000 / 2005


Business Verticals

  • Manufacturing
  • Trading
  • Logistics – Warehousing, Distribution, Transport, Clearing and Forwarding Agents
  • Hospitality – Restaurants and Hotels
  • Hospitals 
  • BPO and Call Centers
  • Co-operative Banks
  • Retail chains

Implementation

  • Quick implementation methodology along with ready to use Logical Data Models (LDM), Physical Data Models (PDM) and ETL Maps enable implementation of the solution in 6 to 8 weeks time.
  • Customized service for implementation and system support is provided with options for Delivery Models.

For details click here

Top
 
XLMiner


XLMiner - A Data Mining Tool Set

Typical Client

Interested in analyzing data and making predictions.

Application

  • Target marketing
  • Sales forecasting
  • Predicting customer churn
  • Formulating sales promotion
  • Defect analysis and predicting defect levels 
  • Warranty claim prediction

Functions

  • Data set creation for Data Mining project 
  • Sampling from large data bases 
  • Data transformation utility 
  • Data exploration – clustering, dimension reduction 
  • Building predictive models
    • Classification for predicting class variables
    • Prediction for predicting continuous variables
  • Scoring data bases with predictive models.

Technology

  • Excel and VBA
  • Computational engines 
  • Scoring on data base: MS Access, MS SQL server and Oracle

For details click here

Market segmentation
Top
 
Printable Format
C-BIA is a Division of
TechKnit IT Enables
Services Pvt. Ltd