Introducing CXAIR. E development and performance

Transcription

1 Search Powered Business Analytics Introducing CXAIR CXAIR has been built specifically as a next generation BI tool. The product utilises the raw power of search technology in order to assemble data for querying/reporting purposes. The product has been designed around 3 core principles: speed, flexibility and usability. CXAIR enables Business Analytics use by everyone, not just analysts, and knocks down many of the barriers prevalent in traditional Business Intelligence technologies to finally make reporting, ad-hoc analysis and dash-boarding as easy and as straightforward as searching the Internet. Traditional technologies are inherently maintenance; requiring the formulation of a competency centre (BICC), data warehouse design and T C A SEA H RC implementation and ongoing EXT R technical and therefore expensive in the S EN LY S CXAIR removes this. PRE tuning of SQL statements... E development and performance A N T A

2 Extract: Providing a Consolidated View of your Data A common and increasing problem in both small and large organisations is the proliferation of data contained in multiple and often unconnected data stores and systems. Whether you have implemented a data warehouse or continue to try to join up the data manually, CXAIR provides an extremely simple and easy to use method of bringing data together into a single coherent search engine that can be used to provide consolidated reporting and analysis from a single point of access. STRUCTURED 3RD PARTY APPLICATIONS Business Intelligence Content Management Systems Helpdesk Systems Sales & Marketing REPORTS DATABASES OLAP Data Warehouse Flat Files DASHBOARDS e INBOX CROSSTAB + + SERVER DIRECTORIES + CXAIR <HTML> <XML> VENN DIAGRAMS WEB SEARCH UNSTRUCTURED

3 Search: Simple Querying Most people are familiar with search engines and use them to explore vast amounts of information available on the Internet. Using CXAIR, users are able to use the same natural language queries and experience the impressive speed and simplicity of search engine technology across data contained in their operational and back-office data stores. CXAIR provides users with the ability to rapidly filter results by simply clicking on values on the screen or generating range filters, allowing the user to choose the data they want without having to rely on running pre-canned reports or SQL queries. Secure Information Access CXAIR includes many powerful security features to ensure that information presented is relevant and secure across the organisation including single sign-on, realm based security and integration with Windows security for Windows based implementations. Data contained within CXAIR can be automatically filtered to restrict access at document, row and column level for groups or individual users with only minimal configuration.

4 Analyse Drill-down into the Detail Unlike many traditional BI tools, CXAIR does not store any of its indexed data in a preaggregated form. This means that data is either rolled-up dynamically or presented back to the user at transaction level when queries or reports are generated. Storing data at transaction level means that is always possible to drill down from a total field, chart or VENN segment into the underlying records that make up the total with sub-second response times. An obvious advantage to storing data at transactional level is that users can see the provenance of a total by being able to crosscheck against the original data. Ensuring business users are confident in the data they see returned by a query or report is critical to them making Analytics a key part of their daily processes.

5 Analyse Venn Diagrams Venn diagrams has always been an extremely useful way of demonstrating relationships in data, however very few products have been developed that support the generation of Venn diagrams in a dynamic environment. Traditional database technology is not fast enough due to the complexity of the calculations required to total up the various elements of the Venn over what can be huge volumes of data. Due to the speed of querying in CXAIR, users are able to generate and manipulate Venn sets over huge data sets in an extremely simple and easy to use interface, providing unparalleled insight into data relationships through the ability to dynamically segment data down to any level of detail. Venn sets are able to display simple record counts, calculations or distinct counts based on specific business criteria enabling you to analyse information in many different ways and identify clusters of data that can then be drilled into at transaction level for further analysis.

6 Analyse Crosstabs One of the most powerful features of CXAIR is the ability for business users to produce multi-dimensional crosstabs on top of your filtered data. Users can nest multiple fields as rows or columns, select multiple measures and calculations, apply traffic lighting and field formatting on any data contained within the search engine and produce tables of results in real-time. As in all areas of CXAIR, users can drill down from a total to the underlying data and drill back up to the original crosstab without any pre-configuration of the data. Users can add charts alongside the crosstab simply by selecting a set of pre-defined chart types that are automatically selected based on the shape and size of your current crosstab. Unlike pivot table services in EXCEL or reporting over OLAP data sources, crosstabs run in real-time across the actual event level data and produce results in seconds without the need to pre-aggregate or perform any pre-configuration.

7 Present Dashboards Every BI tool has dashboards however few tools provide facilities as flexible, simple and comprehensive as CXAIR for business users. Users can easily design and build dynamic and visual dashboards that provide high-level overviews of tabular and cross-tabular data. Using the in-built search and filtering, generic dashboards can be created that provide simple overviews of data that change depending upon user-defined filters and search terms that narrow down, or extend the range of data reported on at any one time. By defining a layout that applies to all of the data as opposed to a pre-defined subset, the number of dashboard views an organisation needs to produce are dramatically reduced, simplifying the administration process of publishing reports and saving many hours and days of unnecessary man-time in cloning and customising reports. In addition to crosstabs, charts, lists and Venn diagrams, CXAIR allows organisations to generate pictorial maps using in-built flash-based templates as well as integration with Google maps without the need to purchase a full-blown GIS system. Dashboards can be extended to include embedded HTML, text, and images as well as reference external web pages or local intranet web pages. Dashboards can also be customised to use your own corporate logos, fonts and colour schemes. Once built, dashboards can be saved and published to user groups to be viewed across the organisation either directly through CXAIR or through a simple report viewer interface. The Report Viewer provides a simplified user interface that is ideal for users who simply want to view and print pre-defined reports and dashboards.

8 Present Flow Reports Unlike Crosstabs, VENN diagrams and Dashboards, flow reports are designed to be multipage reports where information is broken down into a series of repeating groups or sections. The concept dates back to the very earliest 132 character main-frame reports where reports were often lists of repeating data broken into sections where each new section would appear at the top of a new page. Unlike legacy mainframe reporting, CXAIR Flow Reports allow you to combine formatted text, list style data, crosstab, VENN and formatted HTML into each report section enabling you to generate some amazing reports that span multiple pages, can be filtered in real time and can be saved away as PDF for distribution to other users.

9 Present CXMobile With the continued advancement of smartphones and the need to access information whilst on the move, CXMobile allows you to access reports and the information you need to make business decisions no matter where you are. Available through the Google Play store or Apple App store, CXMobile is a native application designed for integration with CXAIR. In addition, CXMobile has an offline capability to view reports whilst without an active connection to the CXAIR server.

10 About Connexica Established in 2006, Connexica provides a fundamentally different approach to information retrieval and management reporting. As a software house we defy definition because we don t fit into the conventional Business Intelligence, Enterprise Search or Data Access spaces. Our powerful querying and analysis tools help bridge the gap between all three solutions, by offering our customers the ability to index, retrieve and analyse their organisation s data at search engine speed, easily and securely from any location. United Kingdom Connexica Limited United Business Centre Parker Court Dyson Way Staffordshire Technology Park Stafford ST18 0WP United Kingdom Tel: +44 (0) Fax: +44 (0)

Search Powered Business Analytics, the smartest way to discover your data A Shift in the World of Business Intelligence Comparison of CXAIR to Traditional BI Technologies A CXAIR White Paper www.connexica.com

Sisense Product Highlights Introduction Sisense is a business intelligence solution that simplifies analytics for complex data by offering an end-to-end platform that lets users easily prepare and analyze

CRGroup Whitepaper: Digging through the Data Reporting Options in Microsoft Dynamics GP The objective of this paper is to provide greater insight on each of the reporting options available to you within

Paper BB-01 Lost in Space? Methodology for a Guided Drill-Through Analysis Out of the Wormhole ABSTRACT Stephen Overton, Overton Technologies, LLC, Raleigh, NC Business information can be consumed many

Search Powered Business Analytics, the smartest way to discover your data Data Migration How CXAIR can be used to improve the efficiency and accuracy of data migration A CXAIR White Paper www.connexica.com

Business Benefits From Microsoft SQL Server Business Intelligence Solutions How Can Business Intelligence Help You? www.ptr.co.uk Business Benefits From Microsoft SQL Server Business Intelligence (September

The difference between BI and CPM A white paper prepared by Prophix Software Overview The term Business Intelligence (BI) is often ambiguous. In popular contexts such as mainstream media, it can simply

GADD Dashboards available on any device via web browser. GADD Dashboard Express Get out-of-the-box dashboards or create your own. Publish them on your Intranet and make them available on any devices; PC

Sage 200 Datasheet provides you with full business wide analytics to enable you to make fast, informed desicions, complete with management dashboards. It helps you to embrace strategic planning for business

Data Management Solutions Horizon Software Solution s Data Management Solutions provide organisations with confidence in control of their data as they change systems and implement new solutions. Data is

Microsoft Dynamics NAV Maximising value through business insight Business Intelligence White Paper May 2013 Reports were tedious. Earlier it would take days for manual collation. Now all this is available

Sage 200 Business Intelligence Datasheet Business Intelligence comes as standard as part of the Sage 200 Suite giving you a unified and integrated view of all your data, with complete management dashboards,

The Jet Reports Suite of Products The Jet Reports Suite of Products is an integrated reporting and business intelligence solution that ranges from individual ad-hoc reporting to enterprise level reporting

Analytics with Excel and ARQUERY for Oracle OLAP Data analytics gives you a powerful advantage in the business industry. Companies use expensive and complex Business Intelligence tools to analyze their

MicroStrategy Products Bringing MicroStrategy Reporting, Analysis, and Monitoring to Microsoft Excel, PowerPoint, and Word With MicroStrategy Office, business users can create and run MicroStrategy reports

idashboards FOR SOLUTION PROVIDERS The idashboards team was very flexible, investing considerable time working with our technical staff to come up with the perfect solution for us. Scott W. Ream, President,

Using Microsoft Business Intelligence Dashboards and Reports in the Federal Government A White Paper on Leveraging Existing Investments in Microsoft Technology for Analytics and Reporting June 2013 Dev

Exceeding Standards LOGO Mind Offers Quick Integration and Dynamic Reporting and Analysis! Provided by an avant-garde technology in its field, Logo Mind will carry your business one step ahead and offer

Introduction to Oracle Business Intelligence Standard Edition One Mike Donohue Senior Manager, Product Management Oracle Business Intelligence The following is intended to outline our general product direction.

60 Business Intelligence. A Presentation of the Current Lead Solutions and a Comparative Analysis of the Main Providers Business Intelligence. A Presentation of the Current Lead Solutions and a Comparative

A white paper prepared by Prophix Software 2012 Overview The term Business Intelligence (BI) is often ambiguous. In popular contexts such as mainstream media, it can simply mean knowing something about

Microsoft Dynamics NAV Maximising value through business insight Business Intelligence White Paper October 2015 CONTENTS Reports were tedious. Earlier it would take days for manual collation. Now all this

The Jet Suite of Products The Jet Suite of Products is an integrated reporting and business intelligence solution that ranges from individual ad-hoc reporting to enterprise level reporting and business

Sage 200 Business Intelligence Datasheet Business Intelligence comes as standard as part of the Sage 200 Suite giving you a unified and integrated view of important data, with complete management dashboards,

The BI Requirements Checklist is designed to provide a framework for gathering user requirements for BI technology. The framework covers, not only the obvious BI functions, but also the follow-up actions

Everything you Need to Know about Intelligence FAQ What is Sage ERP Accpac Intelligence? Sage ERP Accpac Intelligence is an exciting new product that empowers you to quickly and easily obtain the information

September 9 11, 2013 Anaheim, California The Right BI Tool for the Job in a non- SAP Applica9on Environment Speaker Name(s): Ty Miller Full Spectrum Business Intelligence Self Service Dashboards and Apps

Chapter 4: Business Analytics CHAPTER 4: BUSINESS ANALYTICS Objectives Introduction The objectives are: Describe Business Analytics Explain the terminology associated with Business Analytics Describe the

Sage ERP Accpac Everything you Need to Know about Intelligence FAQ i WHAT IS SAGE ERP ACCPAC INTELLIGENCE? Sage ERP Accpac Intelligence is an exciting new product that empowers you to quickly and easily

DATA VISUALISATION An Intrafocus Guide September 2011 Table of Contents What is Data Visualisation?... 2 Where is Data Visualisation Used?... 3 The Market View... 4 What Should You Look For?... 5 The Key

IBM Software IBM Cognos TM1 Enterprise planning, budgeting and analysis Highlights Reduces planning cycles by as much as 75% and reporting from days to minutes Owned and managed by Finance and lines of

Microsoft Dynamics NAV 2015 Microsoft Dynamics NAV Maximising value through business insight Business Intelligence White Paper December 2014 CONTENTS Reports were tedious. Earlier it would take days for

Business Intelligence and intuitive reporting in one comprehensive solution Business Intelligence Jet Enterprise is Business Intelligence and intuitive reporting in one solution that enables analysis and

Components of SAP BusinessObjects 4.0 An Overview Adam Getz Practice Manager, Business Intelligence Overview of DCS Consulting is a Business Intelligence and Data Warehousing (BI/DW) professional services

Business Intelligence EMPOWERING BUSINESSES FOR BETTER DECISION MAKING Having the market leading financial and operational management system, automating the processes associated with managing income and

An Oracle White Paper April 2013 Reporting Tools in Oracle Fusion Financials Executive Overview We are living in an Information Age, where the success of an organization depends largely on how effectively

NAI Global s Technology Solutions One of the key aspects of any successful technology implementation is the ability to quickly bring to the user desktop, that critical information that is integrated across

Microsoft Dynamics NAV Maximizing value through business insight Business Intelligence White Paper November 2011 The information contained in this document represents the current view of Microsoft Corporation