Data Lab - Teradata

​ 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