2010 Orchid Technical Consultancy P Ltd Problems facing

Problems facing businesses today • Non-availability of information on time – Delayed or improper decision making • Competitive market – Business performance needs to be analyzed and optimized to beat competition • Dependence on clerical staff to compile and provide information – Subject to human error – Work priorities define the availability of reports – Wastage of time in repetitive labour of generating reports • Alternative large IT systems are complex and costly – Budget issues – Failed implementations • Dependence on IT for new reports – Every new report has a lead time …it is not about the information you don’t have; It is about finding the right meaning out of what is already there… © 2010 Orchid Technical Consultancy (P) Ltd

The Solution – Business Intelligence • Business Intelligence (BI) • What is BI? – BI refers to skills, processes, technologies, applications and practices used to support decision making • The focus of Business Intelligence is Decision Making – BI is a technology which converts raw data to information to support decision making • The questions which BI answers – – – What has happened? Why has it happened? What is happening? Why is it happening? What will happen? Business intelligence is a key ingredient of success today, used by forward-thinking organizations as a driver for business innovation Gartner Business Intelligence Summit © 2010 Orchid Technical Consultancy (P) Ltd

The Need for BI BI Systems do not replace ERP systems but compliment them • ERP systems also provide reports but – – Information is static Download data to excel and prepare reports Labour intensive New report development is expensive and time consuming • BI systems provide – – Dynamic information New reports prepared on the fly User defined reports Sales No repetitive labour Purchase ERP Accounting Business Intelligence Inventory © 2010 Orchid Technical Consultancy (P) Ltd

Orqubit Business Intelligence Suite • Flexible, Scalable and Affordable • Fully integrated with common ERP systems – – – • • Tally. ERP 9 SAP B 1 Microsoft NAV Microsoft Axapta Can be linked to other data sources Pivots, Grids and Dashboards Easy to use drag and drop interface User customizable with storage of user defined reports Export and Email Reports – Excel – PDF – Others © 2010 Orchid Technical Consultancy (P) Ltd

Functions • Pre-defined analytical tools – – – – – Comparatives for user defined time periods Variation – Growth / degrowth for user defined time periods Contribution Top N / Bottom N Grouping Average, Min, Max, Count and others Custom fields and formulae Filters Many others © 2010 Orchid Technical Consultancy (P) Ltd

Example Reporting Capabilities Sales • Analyze sales performance – Across locations, SKU, salesperson, category, group, region, etc. – Comparative across user defined time periods – Growth by customer, item, stock group etc. • Focus on the right items and customers – Top N / Bottom N customers, items, groups, salespersons, etc. – Contribution percentage of item, customer etc. • Control exceptions – Sales vs. Sales Return – Sales exceeding credit limits – Sales vs. Receipts © 2010 Orchid Technical Consultancy (P) Ltd

Example Reporting Capabilities Accounts Receivable • Drive collections with – Top N outstandings – FIFO or Normal Ageing • Analyse customer performance – Payment performance – average payment days – DSO analysis • Control delinquencies and working capital – Credit limit variance • Increase revenue through following up with inactive customers © 2010 Orchid Technical Consultancy (P) Ltd

Example Reporting Capabilities Purchasing and Accounts Payable • Improve purchasing efficiency by getting ready analysis – when did I last buy this item, who were the suppliers, what was the rate, etc. . • Understand item rate movements for items with fluctuating prices such as steel, sugar, oil, copper, aluminium, etc. . Cost Centre, General Ledger & Inventory • Control cost through comprehensive cost centre reports – what are my traveling expenses across departments etc. . • Control inventory by slow and non-moving inventory analysis, inventory holding comparison across time periods and more. . • Cash flow reports to understand incomings and outgoings © 2010 Orchid Technical Consultancy (P) Ltd

Example Report Drag and drop © 2010 Orchid Technical Consultancy (P) Ltd

Other Reports Exception Report Grid Report Chart Integration © 2010 Orchid Technical Consultancy (P)

Dashboards • 360° view of business with real-time data • Standard & customizable dash-lets – – – – Interactive charts with run-time analysis Top N analysis Drill down & drill back features 2 D & 3 D chart types Zooming & scrolling Circular & linear gauges Data tables with grouping, sorting & filtering to give detailed tabular information • Export & E-mail Orqubit dashboards provide C-Suite Executives and Business Managers access to actionable information without time consuming and repeated labour or manual intervention © 2010 Orchid Technical Consultancy (P) Ltd

Example Dashboard © 2010 Orchid Technical Consultancy (P) Ltd

Architecture • • N-tier architecture and open architecture: Allows Orqubit to connect any other application, be it an ERP solution or a custom built application Standard connectivity to all Microsoft SQL Server Databases Report designer: System administrator, integrator or implementation consultants can quickly create and deploy reports User Administrator: Users with role based security © 2010 Orchid Technical Consultancy (P) Ltd