1 / 27

Connecting to Business Intelligence with

Connecting to Business Intelligence with. Nick Nikijuluw Data Access Europe nick@dataaccess.nl. Data Access Europe BV. the Netherlands (’91) Marketing & Distribution Projects & Services Research & Development Tools for developing database applications. Data Access Worldwide. Denmark

colton-hatfield
Download Presentation

Connecting to Business Intelligence with

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. Connecting to Business Intelligence with Nick Nikijuluw Data Access Europe nick@dataaccess.nl

  2. Data Access Europe BV • the Netherlands (’91) • Marketing & Distribution • Projects & Services • Research & Development • Tools for developing database applications

  3. Data Access Worldwide Denmark Germany Austria Switzerland Holland Belgium Luxemburg France United Kingdom Malta Portugal Spain Norway

  4. European Channel Partners Data Project

  5. Partnerships • IBM DB2 Universal Database • Pervasive Software (“Btrieve”) • Business Objects (Crystal Decisions) • CINTAC ApS

  6. CINTAC – A New Partner • 7+ Years in Business Intelligence • Dynamic, Relational, On-line Analytical • Made in Denmark

  7. Overview Datamining Scorecards Dashboards MIS Management reports Reports “Lists & labels”

  8. Overview, and position What is “Business Intelligence”? What’s out there? Levels of abstraction Dynamic AI position, goals & purpose

  9. Business Intelligence • Exploring vast amounts of data - collect information to improve business performance • Quickly get a scope on higher level, tactical or strategic enterprise issues • BI in the past: Reporting, Querying • Introduction of OLAP, Dashboards & Score-Cards… • 2005: Users want to access data, Flexible, Intuitive, Easy, Anywhere!

  10. What’s out there? • Extract Transform Load (ETL) • Extract data from (ERP) system for aggregation • Prepare to load into data-warehouse/mart

  11. What’s out there? • Query & Reporting • Process of querying a data source • Format it to create a report • Share or archive reports

  12. Query & Reporting

  13. What’s out there? • Vendors provide: • OLAP Tools • Report & Query Tools • Sometimes: Both • OLAP offers interactive, multi-dimensional, analysis, different levels of details.

  14. What’s out there? • Dashboards • Everyone wants them! • Indicators or reports in a very “graphical” way • Example: • A gauge, showing progressive turn-over/activity • A trend line that tracks traded product • Build your OWN Dashboard

  15. BAM?

  16. BAM?

  17. BAM? … ? (courtesy: www.answers.com)

  18. What’s out there? • Business Alert Monitors • Alerts, Informers • Set parameters, boundaries • Notification function (push)

  19. What’s out there? • Score cards (BSC, Six Sigma) • Compare a given metric to a set target • Analyze performance versus target • Provide root cause analysis • Provide track accountability • Not individual (like Dashboards) but conform commonly agreed upon metrics

  20. What’s out there? • Data Mining • Discover certain patterns in data using specific algorithms • Used for • Predictive analysis • Fraud detection • Customer scoring etc. • Marketing! (today) • Very vendor niche

  21. Position – BI Scope CPM ROLAP Reporting

  22. Position – Business Scope Strategic Tactical Operational

  23. Positioning Sweet spot

  24. Other considerations… • Fat Client or Browser based • Supported Back-ends / RDBMS • Architecture • Used access methods (ODBC, OLEDB) • Standardized querying methods • Security

  25. Dynamic AI • 100% Browser based - for design & delivery • ODBC / OLEDB, native for industry standard RDBMS • MS-Sql, DB2, Oracle, MySQL, Pervasive, Interbase etc. • Enterprise Edition for Scalability and Security • Complies with German Banking Security demands • Informers notify via SMS, e-mail or Dashboard • Very short learning curve, fast & easy to use!

  26. Dynamic AI • Trend in Business Intelligence: • Web-based, Real-time Analytical • No aggregates / cubes • Fast, intuitive, low TCO (ease of use) • Power Users • Bring Business Intelligence to a rational level!

  27. A Real-time Web-based Business Intelligence tool

More Related