Data warehousing/Business Intelligence

1
August 2007
KAUTILYA Overview
Presented by Open Software Technology (India)
Ltd.
www.open-soft.net
2
INTRODUCTION

• A powerful tool for Generating, Managing and
  Distributing interactive, content-rich enterprise
  reports for employees, customers, and business
  partners in browser-based, Web formats

www.open-soft.net
3
LINE OF PRODUCTS OF KAUTILYA

• Web Based Enterprise Reporting Tool
• Business Intelligence
• Business Intelligence On Enterprise Reporting
• Dashboard

www.open-soft.net
4
FEATURES OF KAUTILYA

• Online / web based Report Designer
• Hetrogenous data source connectivity
• In built Report Templates
• Sorting and Grouping
• Dynamic Sorting / Sorting at Runtime
• Report Parameter
• Dynamic Report Parameter Values
• Page Level Security and Report Scheduler
• Support for Multi-List or Multiple Report
  Queries
• Report Output Versioning
• Export Option
• Report Viewer and Progressive Viewing for fast
  response times.
• Executive Dashboard
• E-mail notification capabilities supporting
  attachments in Excel and PDF.

Presented by Open Software Technology (India)
Ltd.
www.open-soft.net
5
Actuate OST
DashBoard
www.open-soft.net
6
Reports
ENTERPRISE REPORTING
CREAT NEW REPORTS
EDIT REPORTS
DELETE REPORTS
Classification of Organizational Users
Enterprise Reporting 80 Ad Hoc Reporting
15 OLAP 5
www.open-soft.net
7
Business Users can Now Create Query
BUSINESS INTELLIGENCE
Business Intelligence is a practice used to
provide the access to the enterprise information
or data, analyze the information by providing
common user interface capable of retrieving data
from heterogeneous sources of information. BI
leverages end user to analyze real time
information to make more informed business
decisions Business Users can perform managed
query reporting
Query EditorAccess-like GUI for defining
connections to data sources for power users
www.open-soft.net
8
DESIGN REPORTS
REPORT STYLE
HEADER STYLE
MODIFY REPORT
www.open-soft.net
9
COLUMN MODIFICATION
ADD COLUMNS
MODIFY DISPLAY FORMAT
MODIFY COLUMNS NAME
ASCENDING / DESCENDING
www.open-soft.net
10
Kautilya Connectivity to almost any Database
Kautilya Enterprise Information Integration
integrates information from many disparate
information sources.
DATA BASE
KAUTILYA ENGINE
REPORTS
www.open-soft.net
11
Kautilya Query Option
Kautilya Query is an Ad-Hoc query facility for
business users that requires no up front training.

• Four steps from questions to answers.
• Data is grouped, sorted and presented in Excel,
  HTML and PDF format.

Excel DHTML PDF
Kautilya Query

• Kautilya Query
• New easy to use end-user query tool
• Enables users to access the data they need
• 100 web based
• Zero training required

Q1 Product Sales Information Object
Q2 Pipeline Information Object
Pending Shipments Information Object
Warehouse Stock Information Object
www.open-soft.net
12
PAGE LEVEL SECURITY
For those who need to restrict data to the
users, Kautilya PLS option delivers powerful
security capabilities without requiring any
transformation or warehousing of Application data.

• Create new user.
• Assign Role to the new user.
• Delete the Users.

www.open-soft.net
13
GRAPHS
Kautilya delivers fully functional, formatted,
live content over the Web in Excel, PDF, Word
format

• Leverage existing Excel skills when accessing
  enterprise information.
• Real Excel documents with charts, formulas and
  multiple worksheets with zero coding and minimal
  training.
• Support for What-If Analysis, Trend Analysis and
  Projections.
• Users can view reports using Excel.
• Distributed spreadsheets via Web and e-mail
  attachments.

www.open-soft.net
14
AUTO ARCHIVING
Auto-Archiving of old business data. Seamless
interoperability of Near-Line, Archived and
Active data. Supports custom rules for archiving
and Near-line view of data.
The ENTERPRISE REPORTING APPLICATIONS
www.open-soft.net
15
BUISNESS INTELLIGENCE ON ENTERPRISE REPORTING
A unique Feature incorporated into Kautilya where
Enterprise Reporting is merged with Business
Intelligence. We can merge two reports and
generate a third report . This is a proprietary
product.
The ENTERPRISE REPORTING APPLICATIONS
www.open-soft.net
16
Online Analytical Process (OLAP)
CROSS-TAB
Kautilya Cross-tab Analytics extends the Kautilya
Enterprise Reporting Application Platform by
providing Web based Analytical capabilities to
power users empowering them to interactively
explore information, build insightful,
multi-dimensional reports, thereby facilitating
good decisions

• Cross Tab Report upon which power users
  can click and create hierarchical views,
  details, custom calculations, highlighting and
  graphs.
• Scalable to thousands by leveraging the
  enterprise reporting capabilities of Kautilya.

ANALYZE DATA

• Real Time Data Analysis for Business Analysts.
• Supports OLAP to handle larger volume of data at
  faster rate

www.open-soft.net
17
Executive Dashboard
Customizable and Configurable Management
Dashboard. Graphical and Tabular KPIs for
Management and real time data. SSO with any
existing web application or business portal.
www.open-soft.net
18
OST Customers
OST shall have several corporate houses future
tie-ups who are fortune 500 companies and are
spanning across the Globe.
www.open-soft.net
19
SUMMARY

• Kautilya is not a technology, but a Business
  Strategy
• Kautilya is an Intelligent first step in
  incorporating Enterprise Reporting Tool
• Analyze customer, product and services
  profitability in real-time
• Consolidate financial data from disparate sources
  across the entire enterprise
• Standardise on data communication, data
  comprehension data control
• Optimize IT resources and infrastructure
• Single version of the truth

The ENTERPRISE REPORTING APPLICATIONS
www.open-soft.net
20
Thank You !
Please send us your precious feedback! Open
Software Technology (India) Ltd. 512, Phase V,
Udyog Vihar, Gurgaon. INDIA. Telefax
0124-2345223, Phone - 4012305/06/07 E-mail
business_queries_at_open-soft.net
The ENTERPRISE REPORTING APPLICATIONS
www.open-soft.net