Teradata does not have a tool for this (unless you're talking about a specific application like CRM), but they partner with Microstrategy, Cognos, Business Objects, and others for this type of access. I would look into those types of packages, all of which use the Teradata ODBC interface.
I work in a telco in Australia (I used to work for SPSS a few years back).
We have a Teradata system which we use to analyse mobile phone and land line usage (customer churn, cross-sell etc)
We use Clementine for our data analysis and data mining because it has the capability to automatically generate SQL and submit this to Teradata. It has an 'icon' based UI interface, whereby users configure the 'icons' (called 'nodes') and connect them together to represent the data flow and data transformations that need to occur. Clementine can then convert this into SQL where possible (it can process outside of the dataabse if needed).
The SQL is mostly standard SQL (not many Teradata extensions are supported), but it allows users to construct advanced queries quick and easily. You still need some background knowledge about the database so that you know which tables you should be using. Knowing how the tables are indexed and organised is *very important* for efficient data analysis and (i feel) nothing will remove this issue. With this in mind our Teradata system blasts through billions of rows of data in no time.
SPSS Clementine costs a bit though (prob around USD 200k i guess), so you might have to justify the cost depending on your budget.