Herramientas de bi

Choosing the Right Business Intelligence Tools for Your Data Architecture : 
Choosing the Right Business Intelligence Tools for Your Data Architecture

Slide 2: 
Types of Business Intelligence Tools… ETL Tools OLAP Tools Reporting tools Metadata tools Data warehouse tools

Slide 3: 
5 Criteria for Identifying Business Intelligence Tools… Do we intend to buy these products or build themin-house? What are the requirements for our business intelligence tools? What technical skills does my staff possess? What is our timeline for implementation? What is our available budget for the task?

Slide 4: 
3 Criteria for Selecting Smaller, Less Known Vendors… Vendor Stability Technical Support Professional Services

Slide 5: 
Relational Database Tools & Hardware Evaluation CriteriaScalability Parallel Processing Support RDBMS/Hardware Combination

Slide 6: 
Popular Relational Database Tools and Platforms Popular Relational Databases Oracle Microsoft SQL Server IBM DB2 Teradata Sybase MySQL Popular OS Platforms Linux FreeBSD Microsoft

Slide 7: 
ETL (Extract, Transform, & Load) Tools ETL data can come from many sources: mainframe applications ERP applications CRM tools flatfiles Excel spreadsheets, or even a message queue.

Slide 8: 
ETL Tools apply rules to convert content from multiple databases For Example, a Telephone number can be recorded several ways (123) 456-7890 1234567890 123-456-7890 123 456 7890

Slide 9: 
ETL Illustration

Slide 10: 
ETL Buy vs Build Factors… Complexity of the data transformation Data cleansing needs Data volume

Slide 11: ETL Implementation Questions How many sources will users extract the information from? What are your types of data sources? What are the expected sizes of these input files? Is there a need to join information from different sources? What are the growth expectations What is the current environment What is the budget for purchasing your ETL tool?

Slide 12: 
Evaluation Criteria for ETL ToolsFunctionality capability Compatibility to your data source Metadata Support

Slide 13: 
Popular ETL Tools Popular ETL tools include:   Oracle Warehouse Builder (OWB) Business Objects Data Integrator SAS Data Integration Studio Informatica IBM Information Server

Slide 14: 
OLAP (On-Line Analytical Processing) Tools

Slide 15: 
OLAP Tools are use for… Business Performance ManagementPlanning Budgeting Forecasting Financial Reporting Analysis Simulation Models Knowledge Discovery and Data Warehouse Reporting

Slide 16: 
There are 3 Types of OLAP Tools MOLAP (Multidimensional OLAP) ROLAP (Relational OLAP) HOLAP (Hybrid OLAP)

Slide 17: 
OLAP Evaluation Criteria Ability to leverage parallelism supplied by RDBMS and hardware Performance Customization efforts Security featuresMetadata support

Slide 18: 
OLAP Implementation Questions How many developers need to access the tool? Is there any security to be implemented for access? What is the level of end users knowledge What is the budget What is the report requirement What is the functional domain for analysis?

Slide 19: 
FASMI Method for OLAP Selection Fast Analysis Shared Multidimensional Information

Slide 20: Popular OLAP Tools Business Objects Cognos Hyperion DB2 MicroStrategy

Slide 21: 
Reporting Tools Evaluation Criteria Number of reports Desired Report Distribution Mode Ad hoc Report creation

Slide 22: 
Reporting Tools Evaluation Criteria Data source connection capabilities Scheduling and distribution capabilities Security features Export capabilities Integration with the Microsoft Officeenvironment

Slide 23: 
Popular Reporting Tools Business Objects (Crystal Reports) Cognos Actuate DB2

Slide 24: 
Metadata Tools Metadata refers to the collection of information about the data stored in an application or database. Information about data can include:   Definition of the data Type of data Size of data Systems abbreviation Business unit

Slide 25: 
3 Criteria For...