1 / 25

An Introduction

An Introduction. Open SoftwareTechnology (India) Limited. A Background. Started in 1994 in New Jersey, USA as a software consulting firm Had presence in 4 continents and 6 countries Started Indian operation in 1998

plato
Download Presentation

An Introduction

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. An Introduction Open SoftwareTechnology (India) Limited www.open-soft.net

  2. A Background • Started in 1994 in New Jersey, USA as a software consulting firm • Had presence in 4 continents and 6 countries • Started Indian operation in 1998 • Working in the areas of OLAP,ETL, Enterprise Reporting, Business Intelligence for the last 16 years • Have done consulting on most of the major BI tools • Launched “Kautilya” Business Intelligence Tool in 2008 • First Indian company to develop a hybrid ER&BI Tool • Despite global meltdown have clients in BFSI, automotive, telecom and manufacturing verticals www.open-soft.net

  3. Customers www.open-soft.net

  4. Enterprise Reporting – Challenges faced • Getting data from different systems and consolidating the same is a challenging and costly affair • Users have to wait for IT to generate the reports and hence decisions are taken based on old data. • Providing information for remote users is a problem in non web based systems • Providing secure and limited access to reports is both difficult and very resource hungry making dispersion of information challenging • Reports out of ERP are not dynamic, user interactivity is poor and widely used spreadsheets add to the confusion. • Compliance is an issue. Once the data in ERP changes it is not possible to view the report with the same set of data. • Demand for more dynamic, user friendly and live reporting with Analytics to get competitive edge is growing rapidly. www.open-soft.net

  5. Enterprise Reporting - benefits • Instead of waiting for a monthly or a weekly report managers can  have access to information on demand. • Anywhere, anytime access to information, reports with rich graphs and charts • One version of truth across the organization unlike spreadsheets •  Each version of a report can be stored so that a user can log in and view any version from the past at any time.  • Dashboards enable managers monitor KPIs • Add value to the existing applications (ERP, CRM) as it will extract value from the data they hold within their repositories. • Better visibility of the organization for both frontline managers and top level management.  • Flexibility to users in building reports without help of IT. • And many more…… www.open-soft.net

  6. Kautilya Components - explained Enterprise Reporting: Ability to handle large complex, live and dynamic reports from multiple systems Business Intelligence or Ad Hoc Reporting: Empowering the end user to get information as desired through simple interface BI on ER: Allows end users to combine different reports or versions of reports by themselves In Memory Analytics: Fulfills the end user’s need to analyze data from different dimensions Business Messenger: Empowers users to chat and track discussions and decisions from within the report What If Analysis: Do scenario building in extremely user friendly way while keeping the data secure Dashboard: Get all this information along with tickers, traffic signals and speedometers in a single user friendly view Extreme Visualizer: This gives very different, unusual however intuitive visualization capabilities for the end user Facebook Data Integrator: Now get your Facebook data and see it along with your company Data. www.open-soft.net

  7. Kautilya Components What If Analytics Dashboard Facebook BI On ER Ex Visual ER BI User Interface BM Kautilya Administration Admin Interface Kautilya Engine www.open-soft.net

  8. Information Lifecycle Management • Kautilya unique in complete lifecycle management • User views large report • Uses it as data model to make changes • Identifies outliners and filters on data • Takes out data on a dynamic In Memory Analytics Sheet • Understands the historical trends from various dimensions • Confirms past trends, takes data with formulae to What If Analysis tool • Plans for future • Discusses the same with other users on Business Messenger with auto save function • Report saved with all details and data as time frozen version • End Result – better information flow and compliance www.open-soft.net

  9. Kautilya Salient Features Ability to pull data from multiple sources through JDBC – ODBC bridge including databases, excel, text files, etc. Easy install within a couple of hours Caters to all kinds of reporting requirements from simple few minutes reports to highly complex backend and formatting requirement reports Complete lifecycle management of reporting requirements; from dashboard to reports to analysis to what if analysis of same data and finally discussion on the same which is all stored for posterity Completely unified single repository solution Download report to popular formats like Excel and PDF Ability to retain older versions of reports without re running the reports even after the data in system has changed www.open-soft.net

  10. Case Studies Client Pain points A large automotive manufacturer The Group is a conglomerate of 17 companies and JVs. They have multiple systems ranging from home grown systems to SAP. Management doesn't have a consolidated view on performance and financial health as group. Scattered data. each company within the group maintaining different ERPs, databases, excel. Consolidating production, sales and financial data from different levels like plant, companies, and then at corporate level. Presenting reports with rich graphs and charts and ability to drill down to leaf level data. Extract data from three sources mainly, ERPs, Excel uploads, and web-forms which were created specifically to capture data from various collection points e.g. plants, companies, etc. Management now gets automated reports and outputs in less than 10% time and more accurate than before. Established one version of truth across the organization by unified reporting Management now get all information fast and with flexibility to look at data differently 45 days implementation Scope Solution Result Milestone www.open-soft.net

  11. Case Studies Client Pain points A giant white goods manufacturer Consolidation of Actual and targets from Oracle Apps and Excel for Sales and After Sales Service Departments. Provide actionable information to MD for his monthly review meetings Implement a reporting system which can connect to both Oracle Apps and Excel while doing incremental reporting so that users can see up to-date reports instantly. Give web based access to timely information to sales teams with flexibility in viewing Scheduling and E-mailing of reports made life easier for line managers to receive weekly and monthly reports as now they would automatically get generated. Figure out leakage of revenue by drilling down to leaf level data hence pin pointing exact cause of loss of revenue and can do their analysis using latest in-memory technology. Use reports from within Oracle Apps using APIs and SSO Saved time and efforts for both users and technical team for reporting Achieved all results despite presence of leading global BI tools Scope Solution Result Milestone www.open-soft.net

  12. Why Open Software Technology ? • More than 16 years of experience in implementing business intelligence solution. • Understand that BI is all about providing a business solution and not merely a technical one. • OSTIL designed “Kautilya” based on their own research and experiences of the bottlenecks faced during implementations. • Have clients in multiple verticals. • Is purely focused on Enterprise reporting and BI. www.open-soft.net

  13. OST Accolades Kautilya was showcased at NASSCOM’s Emerge Out in Chennai in 2010 Kautilya was a finalist in the Best IT Implementation Award for the year 2009 in the Enterprise segment An article on Kautilya appeared in the June 2010 issue of PC Quest www.open-soft.net

  14. Global IT research firms say… • BI is CIO's no 1. priority globally for two consecutive years now, even in the days of meltdown. • Over 60% CEO thinks that they need to do a better job of capturing and understanding information to make more efficient and timely  business decisions. • Many organizations did comparatively much better business during slowdown and they were well equipped with Reporting, score carding,  Dash boarding, forecasting, what-if modeling, interactive visualization and other analytical tools. www.open-soft.net

  15. Report Snapshots OST has designed various types of reports for various customers These reports use different templates which makes building them a very easy and smooth process It adds many pre built flexibility to the end user Some of the sample reports and analytics built are showcased www.open-soft.net

  16. Dashboard www.open-soft.net

  17. Report with Table of Content (TOC) www.open-soft.net

  18. Map view Report www.open-soft.net

  19. Analytical Report www.open-soft.net

  20. In Memory Analytics www.open-soft.net www.open-soft.net

  21. Multi System Report www.open-soft.net

  22. Daily Business Snapshop Report www.open-soft.net

  23. Extreme Data Visualization www.open-soft.net

  24. Facebook Retrieval Interface www.open-soft.net

  25. 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@open-soft.net www.open-soft.net www.open-soft.net

More Related