nabling an Agile Business E Business Self Service with Data Lab & OLAP Agenda First, what about you? Teradata Data Lab Overview 15.10 Release Teradata OLAP Connector Overview OLAP Server Initial Setup 2 2 Teradata Confidential Teradata Data Lab Overview 3 It starts with an idea … I believe this new data may add value but I need a fast and efficient way to prove the theory … 4 Teradata Confidential Production Process versus Exploration Flexibility “Follow the process” ……. “I can’t wait” Excel files mart SAS data IDW 5 ODS Teradata Confidential mart Is this really the best option? DBA Concerns: – Loss of data containment (i.e. firewall) – Loss of access control – TD resource cost for data exports “I lost my laptop at the airport!” Excel files Analytic Concerns: – Data quality/currency suspect mart SAS data – Schema changes may go unnoticed – Effort to manage external repositories “Is my testing still valid for production?” Community Concerns: – Islands of innovation – Often become permanent “Where did this report come from?” 6 Teradata Confidential IDW ODS mart The better solution – Teradata Data Lab Self Service Viewpoint Data Lab Studio Express Production Data Warehouse 7 Teradata Confidential Data Lab - Value Add DBA: “protect production” • Maintain security; Lab privacy • Easy TASM / TIWM integration • Size and expiration controls • Safe delegation of ownership • Complimented by e-mail notifications User Community: “self service” • Automation; Self-provisioning – Easy data loading option • Use the same tools used today • Manage ourselves • Complimented by e-mail notifications 8 Teradata Confidential Data Lab Hierarchy Teradata Database Marketing Lab Group 9 Sales Lab Group Data Scientist Lab Group Campaign Lab Americas Lab Risk Analytics Lab Promotion Lab APCJ Lab Customer Segmentation Lab EMEA Lab Jills Personal Lab Teradata Confidential Teradata Data Lab Roles Dan the DBA 10 Sam the Power User Ann the Business Analyst DBA Lab Group Owner Data Lab Owner Member Architects the Lab Group structure Manages the Lab Group Authority granted by DBA / Lab Group owner Assigns Lab Group owners Approval authority for requests Owns and manages the Data Lab Configures workload management Receives Lab Group email notifications Receives Data Lab email notifications Teradata Confidential Performs data analysis Use what you use - Analytic Tools and Partners Advanced Analytics Reporting and OLAP OLAP Connector Advanced Visualization Text/Semi-structured Analytics Data Model Driven Design 11 Teradata Confidential Data Lab & Teradata QueryGrid™ QueryGrid: Teradata-Hadoop TERADATA DATABASE To prove out a customer sentiment theory <= HADOOP 12 Teradata Confidential Workload Management Integration Through a set “lab prefix” and simple wildcard matching (“Lab Prefix” + User’s Data Lab Name) Classification, State Matrix, and VP’s Workload State Matrix i.e. “dlab_lost-cart” Pre-execution Controls Filters Throttles Partitions 13 Teradata Confidential Execution Phase Prioritization Exceptions Teradata Data Lab 15.10 14 Data Lab 15.10 – New Look & Feel New “Data Labs” full size all inclusive portlet – Combines Viewpoint 15.00 Lab Group Setup and Data Labs portlets – Performance, navigation, requests, and display improvements – Lab Group Setup wizard 15 Teradata Confidential Data Lab 15.10 – Additional New Features – Custom date ranges for expiration and deletion settings – Maximum size / extensions setting – New lab group and data lab User / Role / Owner displays – Security - Create table permissions toggle – New “Reinstate” request; Remove “no expiration” option from requests – Improved “My Notifications” 16 Teradata Confidential Teradata OLAP Connector Overview 17 Desktop Business Intelligence Solutions “Spread-marts” Philosophy 18 Teradata Confidential OLAP Connector - Value Add • Approach – Provides seamless connectivity from Excel, Tableau, or arcplan for selfservice analytics without moving the data out of Teradata DB – Enables Excel users to create and use PivotTables with direct access to Teradata leveraging a ROLAP (relational OLAP) approach • Benefits – Access your business data securely – Increase data quality and consistency – More efficiency by eliminating time packing and moving the data – And … Teradata OLAP Connector Data Lab 19 Teradata Confidential OLAP Connector – Example Excel gesture Connect to TaaDemoSchema using Excel/TOC. Drag Cost to Values Excel Gesture MDX Teradata OLAP Connector (ODBO) MDX MDX: SELECT FROM [TBIO1401Demo] WHERE ([MEASURES].[COST]) CELL PROPERTIES VALUE, FORMAT_STRING Teradata MDX Provider Teradata Optimized SQL SQL SELECT SUM(mdx_fact."COST") AS "MEASURE_COL_0_1" FROM "TAADEMO"."TDAT_FACT_TRANS" mdx_fact AJIs Security Roles 20 Cube Schema Star/Snowflake View Fact Tables Teradata Confidential OLAP Connector and OLAP Server Overview • Teradata OLAP Connector provides seamless access from MDX client solutions directly into Teradata Database: • Teradata OLAP Server provides access from XMLA client solutions for OLAP directly into Teradata Database 21 Teradata Confidential OLAP Connector and OLAP Server Architectures SAP BusinessObjects Analysis, edition for OLAP Excel / Tableau* / arcplan XMLA MDX Teradata OLAP Connector Teradata OLAP Server SQL SQL 3-tier Solution 2-tier Solution AJIs Security Roles 22 Cube Schema Star/Snowflake View Teradata Confidential Fact Tables Initial Setup Your DBA may need to prepare Teradata for ROLAP: 1. Prepare the Environment – Support ROLAP (semantic layer) – Setup security roles Teradata Schema Workbench 2. Implement Optimizations: – Use Teradata Aggregate Designer to create performance AJIs AJIs Cube Schema Setup the new solution – Capture the schema definition using Teradata Schema Workbench – Setup security for the schema 23 Security Roles Star/Snowflake Fact Tables Teradata Designer automates Teradata Aggregate Schema Workbench for setup of designing, building, managing for ROLAP the virtual cube andand TD roles accessAJIs permissions solutions Teradata Confidential 24 24
© Copyright 2024