Dimensions of BI
Mega Vendors have everything in the BI stack: 1) Databases 2) Data Integration Platform 3) Reporting / Dashboarding Platform 4) Predictive Analytics 5) Performance Management 6) Appliance option
Big Data Appliance - Cloudera, R and Oracle NoSql. Exadata / Exalogic / Exalytics.
ETL - DataStage. Reporting - Cognos Suite. Appliance - Netezza / Smart Analytic Engine. Database - DB2. Applications - Pre-built industry models. MDM - IBM Infosphere MDM. PM - Cognos Planning / TM1. Data Mining - SPSS.
ETL - SSIS. Reporting - SSRS / SSAS / PPS / PowerPivot. Appliance - PDW. Database - SQLServer. MDM - Microsoft Data Services.
Aleri. Alteryx. Altosoft. Altworx. Appfluent. Arcplan. Attivio. BalancedInsight. BIReady. Birst. Board. Coral8. Corda. Datawatch. Dimensional Insight. DSPanel. Endeca. ESRI. eThority. Fuzzylogix. Gooddata. iDashboards. iWay. Jackbe. Jaspersoft. Kalido. LogiXML. Lyzasoft. Neotix. Panorama. Pentaho. Pitney Bowes MapInfo. PivotLink. QlikTech. Quiterian. R. SiSense. SpagoBI. Splunk. Spotfire. Tableau. Talend. VanillaBI. Visual Mining. Wherescape. Yellowfin.
Sybase IQ. Vertica (HP). Infobright.
SAP HANA. Greenplum. Teradata v14.
Check out - http://nosql-database.org/. NOSQL refers to NOT ONLY SQL, where SQL here denotes Database Management Systems
Map Reduce Framework. Key Value Pairs. Document Databases. Graph Databases. Google File System (GFS). Hadoop Distributed File System (HDFS). Google BigTable. Cassandra. Amazon DynamoDB. Oracle NoSql - BerkeleyDB. Mongo DB. Couch DB. HBase. Hive.
ER / 3 NF. Dimensional Modeling. ADAPT - For OLAP modeling. Data Vault Modeling.
Traditional BI Architecture. Refers to BI Architecture that involves Staging Areas, Data Warehouses, Data Marts with batch oriented ETL loads. Federated Architecture. Federated Architectures utilize the concept of Enterprise Information Integration (EII). In-Memory Architecture. 64-Bit BI is very relevant in the context of In-memory architecture. Real Time Architecture. Real Time Architecture minimizes Data Latency, Analysis Latency and Decision Latency. Cloud Based BI Architecture. Information Processing Architectures. Event Processing Architectures. Cognos Virtual View Manager. Composite Software. BO Data Federator. Qlikview. TIBCO Spotfire. Microsoft PowerPivot. BO Explorer. Cognos TM1. Tableau. Data Mashups. Real Time BI Products. Pure Cloud BI Environments. Cloud + On-premise. Symmetric Multi-Processing (SMP). Massively Parallel Processing (MPP). Distributed Data Processing. Complex Event Processing (CEP). Presto Mashup Server. Enterprise App Stores - Very interesting concept. Oracle GoldenGate. DMExpress. Informatica RT. Birst. Oracle. SQL Server. DB2. Teradata. Greenplum. Microsoft PDW. Hadoop. Sybase. Streambase. Progress Apama. Cloudera. Karmasphere.
Real-Time. Batch.
Microsoft Data Services. SAP MDM. Informatica MDM. Oracle MDM / Hyperion DRM. Kalido MDM.
Reporting. Self-service BI. Dashboarding & Scorecarding. What-If Analysis. Alerts. Visualization. Protovis. Flare. gapminder.org. IBM - many-eyes.com. Microsoft LiveLabs. http://numberpicture.com. http://visual.ly.
Data Mining resource http://chem-eng.utoronto.ca/~datamining/dmc/data_mining_map.htm
Ad-hoc Discovery. Data Mining. Predictive Analytics Model Markup Language (PMML). Forecasting. Predictive Analytics. Optimization. BI Products. IBM SPSS. Oracle Data Miner. Oracle also acquired a company called 'Crystal Ball'. Microsoft SSAS Data Mining. SAS. R. Microstrategy Predictive Analytics. Statsoft. Minitab. Matlab.
Planning, Budgeting & Forecasting. Financial Consolidation. Profitability Analysis. Financial & Regulatory Reporting. Hyperion Planning Plus. Cognos Planning. Hyperion Financial Management Plus. Oracle Hyperion Disclosure Management.
Domain Knowledge. Business Process Understanding. Data Modeling. Architecting BI Solutions. BI Tools Expertise. Statistical Background. Project Mangement Methodologies. Conceptual. Logical. Physical. Waterfall. Iterative Prototyping. Agile BI.
Business Process Management. Electronic Content Mangement. SOA / Webservices. Enterprise Portals. Enterprise Application Integration. Business Process Simulations. BI and Devices. BizTalk Server. Sharepoint. Sharepoint platform has: Sites, Communities, Content, Search, Insights and Composites. Enterprise Message Bus. Powersim. Vensim.
BI on the Cloud. Appliances. Packaged Applications. Open Source BI. Mobility. Major Platforms for Mobile & Smart Devices: 1) Apple iPhone, iPad 2) Google Android 3) Windows Mobile 4) Blackberry. Agility in BI. Types of Data. Syndicated Data. IaaS. System administration, obtain general processing, storage, database management and other resources through the internet and pay only for what gets used. PaaS. Developers can design, build and test applications that run on the cloud provider's infrastructure and then deliver those applications to end-users from the provider's servers. SaaS. Companies host applications in the cloud that many users access through internet connections. The services being sold or offered is a complete end-user application. Teradata. Oracle Exadata / Exalogic / Exalytics. Oracle Big Data Appliance. Microsoft Parallel Data Warehouse. SAP Hana. IBM Netezza. EMC - Greenplum HD Data Computing Appliance. Oracle BI Apps. SAS Business Solutions. Teradata Industry Models. SAP Business Content / Rapid Marts. SAP HANA based Applications. Jaspersoft. Pentaho. BIRT / Actuate. Apache Hadoop. R Project. Talend. Mobile Platforms from BI vendors. Platforms for Mobile Apps. BI Mobility from Independent vendors. Actionable BI. Collaborative BI. Embedded BI. Unstructured Data. Social Media Analytics. Web Analytics. Open Data. Publicly available datasets. Check out Open Knowledge Foundation - http://okfn.org/. Big Data. AC Nielsen. Symphony IRI. Amazon AWS. EMC. VMware. Rackspace. Private Clouds. Microsoft Azure. Google App Engine. Force.com. Microstrategy Cloud. Informatica Cloud 9 Platform. SAP BO On-Demand. IBM Blue Insight. RightScale - End to End BI Platform. Birst. SalesForce. Adaptive Planning. Rosslyn Analytics. Spend Management Analytics. PivotLink. Oco. Gooddata (www.gooddata.com). Predixionsoftware. Loudcloud Analytics. Cloudera. Microstrategy Mobile. Cognos Mobile. Business Objects Mobile. Qlikview. Sybase Unwired Platform (SUP). MeLLmo - Roam BI. Extended Results - Push BI. Transpara - Visual KPI. OBIEE 11G Action Framework. Collaborative Decision Making (CDM). CDM + Collaborative BI. Pure play Collaborative BI. Eclipse IDE + BIRT. Intersystems. Content Analytics. Content Analytics refers to the broad category of analyzing unstructured data that includes text, videos, audio etc.. Extended Results. Microstrategy Wisdom. Kosmix (Walmart Labs). Alterian SM2. Google Analytics. Omniture. data.gov. publicdata.eu. data.gov.au. getthedata.org. datamarket.com. www.google.com/publicdata. www.guardian.co.uk/data. Microsoft Azure Datamarket. Hadoop. DecisionLens. Sharepoint. DecisionSurface (Purus). SAP Streamwork. Lyzasoft. IBM Cognos ver 10.1. Panorama Necto. Cogniti (Performance Management). Sentiment Analytics. Text Analytics. Hadoop Distributions / Vendors. Apache Hadoop. Others. Attensity. Calais. IBM SPSS. BO Text Analytics. Clarabridge. IBM Infosphere BigInsights. Cloudera. Oracle Big Data Appliance. Microsoft. EMC Greenplum. Hortonworks. MapR. Karmasphere. Datameer. Amazon Elastic MapReduce. Teradata Aster. Hadapt. Hadoop Common - Set of Utilities that support Hadoop subprojects. HDFS - Distributed File System. Map Reduce - Framework for computation. HBase - Opensource, Non-relational, Column oriented database that runs directly on Hadoop. (Not a Mapreduce implementation). Programming - a) Low-Level : Java, Ruby, Python, C++ etc. b) High-level Map-Reduce programming language - Apache Pig (or Pig Latin). Hive - SQL Like Language for Hadoop. Oozie - Server based workflow engine specialized in running workflow jobs that run Hadoop jobs, such as Mapreduce, Pig, Hive, Sqoop, HDFS operations etc.. Zookeeper - Coordination service for distributed applications. Mahout - Scalable machine learning and data mining library. Flume - Helps deliver data from applications to Hadoop's HDFS. It is a reliable, distributed, streaming data collection service. Sqoop - Bulk data transfer between HDFS and Relational DB. Scribe - Aggregate log data from large number of web servers. Hue - Desktop based application that can run on modern web-browsers helping to interact with Hadoop clusters. Informatica HParser. Apache Hadoop Distribution. Pig for MapReduce programming. Connectors to IBM DB2 database. IBM Bigsheets. Cloudera Enterprise ($4000 per node per year). Cloudera CDH & Manager. Oracle NoSQL Database. Oracle BigData Connectors. Oracle R. Oracle Enterprise Linux & Java VM. Partnered with Hortonworks. Unified Analytics Platform. Datameer Analytics Solution (DAS). SQL MapReduce. Industry Formats. Hadoop Distribution. Cloudera Manager. Cloudera Support. EMC Greenplum Database. EMC Greenplum HD Hadooop distribution. EMC Greenplum Chorus (Collaboration). NACHA in Banking. SWIFT for Payments. FIX for Financial Data. ACORD for Insurance.