Introduction to Teradata

Jigar Vora
A free video tutorial from Jigar Vora
Planning Manager at Panasonic
3.9 instructor rating • 8 courses • 30,398 students

Learn more from the full course

TERADATA: Data Warehousing technology

Teradata tutorial with complete real life examples for people who would like to get certification as DBA.

06:07:02 of on-demand video • Updated June 2015

  • Understanding Datawarehousing concepts
  • Get Certified as : Teradata Certified Technical Specialist
  • Get Certified as : Teradata Database Administrator
English [Auto] Help people welcome to this introductory session on data hoes which will be the first step towards learning Teradata. So as in when we begin learning to meditate we need to know where does tell it to fit into the entire data set up and for that we need to know what is a data house. Right. So to begin with let's take a deep dive into what is a data warehouse where this Derek Jeter lie in this and then from there we dig forward in terms of learning different intricacies on charity. All right. So to begin with generally the environment which we have in the present world or we can say the present setup is primarily divided into two types of projects. All right. Sue We have one set of projects who are solely concentrating on building applications. So the technologies which is in building applications are like darknet Jowell didn't we have something called scripting in Python and there are many other. So these set of projects so we have a set of products named Project type and then we have a project type B right. So this project type we are mostly concerned with building applications I NSA building applications it might be like a internet reservation system where we log on to a particular you Warrell and we book article today or in internet banking system where we do transactions online rather than hanging on to you in a bank. Right. So these set of projects are concerned or they are focused on building applications which can either use to make his life easier. Right. Then there are a set of other projects which we call us data warehousing projects who are mostly concerned with answering business questions. So once a business is set up once a business is set up and we go out and do different transactions so the business guys who have set up this business who are keen to know about how they're performing how their business is performing they will have all this have set of questions on the one for which they need an answer. So better housing projects are concerned with getting the yes business questions they are not building applications but there are you know silly business questions so as to give valuable insights to the business stakeholders on how the business is performing. So that by no those inside sight they can go ahead and take corrective actions or Hokke and increase their sales or how can they make their business perform better. All these things can be taken care by a data warehousing project. So a lot of it was in project generally has technologies like data data where we'll be focusing on. And then we have Informatica we have business or just has a reporting to and then we have a Sears as an analytical tool. So these are a few tools which we use in the state of. There are many more that I've just named a few of them which helps us in making informed business decisions. So these are the center of your we generally do right or we do a logical grouping on the projects based on these two types like a set of projects who will be building applications to assist the user to perform tasks in an easier way by just a click of the mouse. And then there are a set of other projects who help us to make informed decisions who will help us to answer a number of business questions. So we'll be focusing on data warehousing only and this is a goal of the entire data warehousing product. So any project we do will have a set of goals defined rate like you'll have a set of goals and then we'll be working towards achieving that goal. Right. So in our data warehouse the business holders are the stakeholders who are important in that business will have lead these type of questions like business stakeholders might be interested to know which are the lowest or highest margin customers if they go or if they get to know who are the customers who give them more margin they can devise strategies to engage with those customers quite often. Like suppose I know that this particular customer is making an average monthly spend of more than thousand dollars. So what we can do is that we can give them give them quarterly gifts or we can give them coupons or any stock cruise to get so we can keep them engaged we can keep them happy so that they can engage more with us and thereby increasing our margin to the next level. Right. And then there'll be a set of other customers who are lowest margin customers. So by knowing what the set of customers who are purchasing less with us who are giving us so much in debt dealing like going into the details of that those customers what we can come up is that one of the reasons why these customers are transacting less with us. So if we pinpoint in a particular reason what we can do that we can take corrective actions or we can do some promotion of them so that they are more engaged. Similarly this is one more important question which plague most of the organizations and it is like which other customers who are most likely to go to my competition. So suppose I engage with Wal-Mart as of now and as a store manager I get to know that OK these are a set of customers who are more inclined to purchase with Best Buy rather than purchasing with a Wal-Mart than what I can do is that I can take corrective actions to make them engage more with us or make them or I can take some retention measures so that these customers are with me. They don't go to the competition. So if we know these answers before hand that will add more value to my business. So thats what is the aim of the entire hosting project is they are aimed at answering dozens questions so that by getting our driving insights from this business questions of these business answers we can make more informed decisions. We can build more strategic solutions or we can take corrective actions which will add greater value to my business. Similarly we can have a question like What are my most effective distribution channels. Suppose there was product launch Les's had a Samsung Galaxy S6 it was launched Baddeley our in-house store Wal-Mart and we launched it online as well. So by looking at the transaction the deal is that how many units of Samsung Galaxy S6 or online or how many units or does seem more Bayles. So in a particular store I can devise a strategy that OK this medium is more profitable for me because I am getting more revenue out of the online distribution channels so why not keep more inventory there. Why not pay more attention on this particular distribution channel. Or if you take it other way around like what are the reasons why my in store sales are less what are the reasons why I am not able to sell more Windows install media. So Biden knowing answers to these questions I can enhance my seat mate. Similarly there are other questions like what promotions. So a particular organization will top many proportionally. So which other promotions which are impacting more customers and who are generating more revenue. So these other set of customers we are sorted these are a set of questions which every business stakeholder will always need an answer to. And we as a data warehouse professionals are responsible to answer this question. OK.