1 / 21

Cubes on Hadoop

Cubes on Hadoop. About Intellicus. Provider of Reporting and BI Products since 2003 9500+ Installations in various Industry Verticals Installations in America, Asia-Pac, and EMEA. OLAP Analysis. Canned Reports. Ad-hoc Reports. Dashboards. Mobile Analytics. Partnerships & Alliances.

magee
Download Presentation

Cubes on Hadoop

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. Cubes on Hadoop

  2. About Intellicus • Provider of Reporting and BI Products since 2003 • 9500+ Installations in various Industry Verticals • Installations in America, Asia-Pac, and EMEA OLAP Analysis Canned Reports Ad-hoc Reports Dashboards Mobile Analytics

  3. Partnerships & Alliances

  4. Fortune Customers

  5. Agenda • Benefits of Hadoop • Typical Usage of Hadoop • Traditional Approaches using BI Tools • Intellicus Solution: Cubes on Hadoop • Case Study • Benefits of Intellicus Solution • Demo

  6. Benefits of Hadoop Huge Dollar Savings Keep Everything Always Almost Endless Exploration of Data Low Total Cost of Ownership Unlimited Storage No Upfront Decisions

  7. Typical Usage of Hadoop Retail Data Accounts Data Customer Data Transaction Data Sales Data Web Logs Name Node HDFS Custom Map Reduce Jobs Open Source Scalable Solution on Commodity Hardware Data on Multiple Data Sources

  8. Traditional BI Architecture Moving Data to BI Process Catalog Data Campaign Data Customer Data Transaction Data Sales Data Accounting Data MOLAP ROLAP Relational Data ETL SQL Enterprise Data Warehouse Dashboards BI Stack Data on Multiple Data Sources Huge Licensing And Maintenance Costs

  9. Using BI Tools with Hadoop BI Tool Hive Pig Impala Stinger Retail Data Accounts Data Customer Data Transaction Data Sales Data Web Logs ETL HDFS Name Node Hadoop Based Data Warehouse Open Source Scalable Solution on Commodity Hardware Data on Multiple Data Sources

  10. Intellicus Solution: OLAP Processing on Hadoop Built Cube Intellicus BI Server Data Connectors Business Meta Layer Security Layer Presentation Layer Report Server Invoking MR Jobs Name Node Cube Definition Workflow HDFS OLAP Server RDBMS Web Services CSV | EDW Other Data Sources

  11. Intellicus Solution: Interactive Analysis Intellicus BI Server Data Connectors Business Meta Layer Security Layer Presentation Layer Report Server Compressed and Indexed Viewing Cubes Browse Cubes Workflow Cube Repository OLAP Server

  12. Case Study Requirement – Customers of an Online Advertisement Website want to explore the effectiveness of their advertisements over various parameters such as - Number of Impressions Density across geographical locations Density across time frames of the year Comparison between brands on the same parameters

  13. Solution Overview – Accessing Data on Hadoop Cluster

  14. Solution Overview – Designing Workflow

  15. Solution Overview – Drag And Drop To Design Cube

  16. Solution Overview – Browsing the Cube This view enables the organization to drill down to explore the density of impressions its advertisement has across geographies.

  17. Solution Overview – Browsing the Cube This view shows the ad impressions of the product against other brands across major geographies.

  18. Solution Overview – Browsing the Cube This view enables the organization to see the impressions movement across time frames of a year for all organizations selected.

  19. Benefits of Intellicus Solution • Connects to any data source with lightweight ETL • Uses Hadoop to process data and build and store cubes • No need to pull full data into separate BI solution • Visualize, Slice and Dice, Drill Down Interactively • No Programming Required • Full Benefits of OLAP with the power and scalability of Hadoop

  20. Fortune Customers

  21. Thank you www.intellicus.com | webinars@intellicus.com San Jose | Atlanta | Indore | NOIDA | Bangalore

More Related