1 / 8

Resources

Resources. What is Xpert BI. A software program that efficiently enables Moving data from a system/application or file to SQL Server Making the data understandable for usage in either other systems or processes, or for BI/Reporting/Analysis purposes Creating more effective data loads/updates

karins
Download Presentation

Resources

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. Resources

  2. What is Xpert BI • A software program that efficiently enables • Moving data from a system/application or file to SQL Server • Making the data understandable for usage in either other systems or processes, or for BI/Reporting/Analysis purposes • Creating more effective data loads/updates • Configuring data loads in a simple interface • Controlling relationships and dependencies between tables, views and other objects in an entire data warehouse solution • Consequence analysis before implementing change requests or as a part of trouble shooting • Analysing data quality at an early stage • Automation/Standardization of data warehouse development and maintenance • Lower personal dependency • Data warehouse automation tool (++) • ETL Tool

  3. Xpert BI Business Value • Business Value for Xpert BI vs Other/traditional DWH/ETL Tool • Revolutionary fast development of BI/DWH solution Lower project cost Faster implementation of business requirements • Easier to make changes and expansions to the solution Lower cost Faster implementation of change requests (new business rule, new dimension etc) • Easier to maintain the solution Lower maintenance cost • One interface/one tool for all data loads and extractions Lower degree of personal dependency • Better data quality Better decision support system One truth • Better traceability and documentation Faster troubleshooting and error handling Shorter backlog

  4. The Solution Approach • Existing • Methodologies • Architecture • Best practices • New methodologies • Idealized data sources • Natural process dependencies Software Development

  5. Platform : SQL Server 2008R2 + • Collection • Unstructured/non-database data • Flat File • XML – Web service • Extraction • All database data sources • Idealization • Transformation • All ETL data loads (ITS) • Automatic object dependency

  6. Unique features • Idealizing data sources • Faster and more structured development • Better data quality and reliability • Foundation for SSBI and further data processing • Inline Transformation Services – object dependencies • Full control of data flow and updates • Optimalized data updates (bulk load and paralellization) • Higher reliabilty and flexibility Use the full potential of your data!

  7. Data Warehouse Environment Visualization Tools (MS) Other vendors Cubes / Data Marts Standard user Standard user Data Access Layer - STAR SCHEMA Data Transformation (ITS) MS SQL Server Data Extraction  IDEALIZATION Expert analyst/user Applications Not recommended Data Flow ERP CRM HR XXX

More Related