Add Seer Default with airSlate SignNow

Add seer default

hello everyone I would like to give an overview of this year's historical database it shortens your HD and also the data storage and retrieval processes and also give an overview of how customers can customize your HD for their own data so some films that are not see or formatted how you can create custom tables or custom fields and how you can you view your data in the seer metrics primarily we're going to be concentrating on share metrics it's all plotting tool that you can access either by itself start menu or through here Sam and through the icon currently you will see you're looking a little sear metrics and data so that is showing is our eyes big data set one of the ways the iceberg data says it's a lot of data is not common with this year HD one of the ways you can have a data to plot and compare your current estimates with the historical data as you can enter your own data sets one of the ways I mean pretty much the only ways to do it to enter the data and modify the irregular data in HD is through our here historical database administrator let me go to them you can Exodus through the start menu go to our CEO folder here for south torrance your historical database this tool is pretty much in administrator for our Syrah HD data set our Syrah HD comes in as an access and the sequel data said today I will be concentrated on the access RX schd because it's easier for demon situation but you will certainly be able to do the same custom fields in love you will processor the river if your HD sequel and the I mean I'll show you later the tools that you can do that when you start your historical database you have a quick your menu um is if you are familiar a little bit with a database of that at all you can have a list you will see the list of the the top dooming the tools that are most commonly used with this year historical database administrator insurance called here HD a while the way why would that you can do is they retrieve data you can add a new record and you go you can save and it then later the call and editing session if some data modification process wasn't finished last time you what you can also do either you can you can see we're here you can import the projects from your here enterprise data base here gb and you can also import your current CSM project as a you know if you current estimate and share some of the regular project file is finished and you can enter it to this year HDA is a historical bail that's a certain we know the things you can do what i'm going to come to demonstrate in the moment i already in this the data set that i'm currently using for this purposes i have here Isaac's installed loaded so i'm going to retrieve the data through this dialog you will be able to you will see certain different ways that you can retrieve the data based on the group on the project scale by the size of it and also the descriptions you will also be able to search by knowledge basis if you if you aware of all it's not aware of like if you have a specific application or platforms that you want to narrow down the data sets or more advanced away if you are familiar with a house your HD or if you have or if you already have or will have custom tables in HD you can also sort it out by this advanced filter for for now i will i already have our icebergs data set in there and i will just see retrieve that group our offer purposes in the inner HDA when you retrieve the data set the default we only have one column that is in view it's the name you will be able to enter other columns and we also have a set of different views that you can load into the here HDA for the viewing purposes if you go to the view tools and the columns add you will see this list of pretty much all the columns that are available for viewing purposes that are currently in HD there are some columns in CHD that are for administrative purposes let's say and there you wouldn't be able to view them or modify the data in them in HD a these tables were here is big zero data one two and three these tables are what we will call a custom tables our sphere default installation does not come with this tables this is something that we process this data set that we have manually created these tables and that I've entered data in there this is the raw data means this is a data that coming with the data set maybe like an Excel spreadsheet file the board documents and we have entered the data there as it as it is a beginner 11-year here for Martinez here modification to the data center I'm not going to play or currently with the view I mean with a column selection because I already have a view set up for this particular data set please them kind of remember this location and the set of views that you have available for the HDA most of pretty much all of this view available with HD installation so if you want to see kind of the most important information that is for certain projects most common part of the pattern of the projects that have been viewed we have a set of views that I came come with installation there in the U public documents folder and this is this location is for windows 7 vista windows 8 and you have a very similar of default folder for windows 64 now I want to give you because already have some of them to you that and we already have a view for the iceberg Stata Center to be a currently viewing you will you should see their the names that I have our creatives for the aspects that I said with or without custom tables just how much how many calls you will be able to see interview in any particular time I'll show you let's do with custom tables this is if you see the error like that this is not a problem with justice showing that you certain columns will be with my dear a the interview they open it again did this is a pretty large you so give it a couple of seconds in order to Odense while it's loading I'll show you this is our folder with the view again most of the staff has come pre-installed with a CH da but you can also create your own views and you own you're going to pick one that we provided and modify it and you can also be able to save at the video names and stuff and then you can also if you do share the data set you can email to your colleagues the view and the data set as well like for example if I will be processing to their own the icepick data set and I want to modify i can open i can copy and paste it and really rename it to something like more work revision 1 and then i can forward to this particular file to my colleague who he or she can view what I was working on apologize had taken a little bit a while while it's lower than i can now it doesn't always load that long is just it's a huge data set and it might take a while probably also because we had according the webinar slows down the computer a little bit a while it's loading a couple of points about your HD you have default installation you always have installed one or copy of CHD but if you do work with a multiple customers and multiple data and said you data set you are welcome to have multiple copies of CHD and you can also have at the same time sequel and icebergs and I mean sorry sequel and access here historical database installed on your computer we can look into my data service administrator in my systems they send that a point in two different data sets I have a multiple instances of CHD that I may be in process and that i'm currently using and since i have a sequel versions installed for that for them as well so i can switch an energy new tiles which here HD i want to work with so it's not necessarily you don't have to have a 10 HD copy on your machine so I excuse me to go few seconds but we loaded the the view for the data set we just wanted to demonstrate how you can view with it at the same time the actual columns better come with shira HD and the custom fields that we have created I mentioned you before that the three tables when the few little columns these three tables they will manually add it to the HH d they will not did not come with installation and that you also be able to view them in the process the way what make sure like if you there i know i mean i can calculate that view i know that i have all of this entries at the end so all of this training give instead of this nation speed of our lighting solution this is not something that this is not the fields that your HD comes with this is icebergs raw data fields and all of this to count business area type that we have a similar maybe for the business area type in CHD but this is isaac several data of formats and you wanted to preserve it that way i'm demonstrating that currently that's how the data set is being viewed in give details of how you can create the custom built so if i do want to create my own I mean I'm sorry let me give it one more point did either way I viewed the custom fields if I go to the data menu can select the custom tables menu option so you'll be able to see there the options you could too big that I speak several data fields that I want to say i want to pick one two and three and add them to my parentheses i want to work with this particular data this is where you do this selection so for now if i want to um sorry that's quite large oh this particular source at the beginning this is what to fear HD comes with this is the this is related to the actual tables and columns in alcohol historical database so if I want to clear this data session I want to work with something I want to create a new historical projects that are saved in my repository and I want to add to my own data all start the demonstration process for that excuse me hi apologize is taken a little bit longer i'm expecting products of the webinar ok clue so I have my own data and my own information that I want to enter so for example let's let's be girl kind of a default view but I could contain to pretty much a basic required remote information about its historical data said that i'm going to enter so when ensured the new records and now i'm gonna and let's say that test project give it a name the next thing is i would like to maybe group it any it's not necessary step to do it but we do recommend to group the projects but prime reason is it will be very easy to retrieve the data what I mean with this if i do want to retrieve something ok let's let's get if i do want to retrieve something i can say the retrieval dialogue the ball of the first things you do you see is it groups and as this field right here so we do recommend grouping the projects maybe by the department today to the organization where to come from or whatever it is that you want to create and you will be able to it's like one of the first bill where you can retrieve it of course you can also match text by name and retrieve it another way to you will be able to load it in the data they review but groups is one of the easiest way to do then so i'm going to create a since i don't have one so far i could create a test group and you will see a message asking if i want to create it and i'll give a description demo for webinar and then i will need to pick a feels like a platform application acquisition method upland hours development schedule and other fields well i'm just going to do video around them selections this knowledge base selections a platform application acquisition methods out you will they are all already have a list of here format example to be using gsm you can there is a way you can maybe enter your own platforms but we don't recommend that because the the point of entering data here is to be able to view it within the sheer environment and this is an important the platform applications and acquisition as it's important knowledge bases for river which you can narrow down your dataset and be able to view it in metrics and other tools within the sheer environment and then so I random blip pick the knowledge bases and I'm let's say I under development hours schedule Dennis like and I'll dig surg inner asian languages one another common that would like to make the development hours and development schedule months when you see in HD a a field that requires it has an actual you will not see the estimated prefix to it just to show what I mean if I wanna for example I will be entering some data from the CSM estimate that i can save the actuals like development our schedule or development month I'm up we have that available but I want to bring up something from system and save the actual estimate we have a field that has a well this is different for maintenance it will have a protects asked and before the name of the column so if it doesn't have it that's the actual the development hours and development schedule months of the actual values sir let me all sorted by alphabets we can easily navigated so yeah if I want to let's say added to this selection of the estivation estimated effort month an estimated schedule months I can enter it as well to this particular view selection it will show up and and and then I will I can enter here the data may be that comes from CSM or maybe like an original estimate but not the actual for the project so I've entered this data I want to bother with details oversized now let's say out a general estimate was oh I don't know kid months whatever I now I kind of hoping that this is like the basic information of that I have for this particular historical data I'm going to save it to the database it will ask me if I want to save it I'll say that they say yes this is a clear view if you want to clear this particular view in HD or not I'll say no but now I want to say that I have some specific fields that I want to enter for this project but they are not if I go through the columns in here what is available in here HD and that I'm not finding what I what I'm looking for there is no columns like that I would like to enter something that is custom to me for this particular project so you this is more of advanced process and where I assume only advanced users will do it but you certainly you certainly can't do that one way to do it I'm going to demonstrate it for the access your HD but you can also do it for the sequels here adg as you can create custom fields and custom our tables in a historical database one thing you should do should exit the Syria HDA and navigate to the here HD that you have been using to enter the data like I've been using this this copy over here HD this is my access copy and I have multiple have demonstrated before make sure it's it's enabled you will see the list of all the available tables here and one table you knew after you create you seriously you will be you will have to enter the name of the new table in here this user defined tables right now I have the icebox datasets in here it will this is where the hero salmon symmetric sincere compel will read what's available from the custom tables that users define for now let's let's create for example let's do two things let's create a table and we'll give it a name as a one second webinar yeah and we'll give it them let's say company name is something I like in a couple of other fields I don't know test filled one just fill Q and make sure that the company name it I'm sorry the test fields I'm sorry I missed I skipped one point that I'm why I'm getting quiet and in order to to custom tables will be able to connect to the rest of the data set in in Assyria HD I missed one point with me let me go back and demonstrate it each project that's been saved in the historical data set is assigned a number so it has a unique ID that has been assigned to it this ID right over here work element ID'd table it said it connects each particular projects to each table so you can retrieve the data for the specific school from every table that is available in HD so when you do create when you do create a custom table but the first field the very first rule that you create it should be underscore work element ID that will pick up the ID for this particular project in in connected everything else so we will have an underscore work element underscore ID and that's an outer now but that's that should be at least one film this way the first one for each custom table and then you can create your custom columns and we had company a name column in here and lets a company name should be text we can maybe have a number for one of the test fields so we have a table name webinar demos and then it contains three fields and once extra field to connect their work the work element ages between the projects will save it and we have to enter a webinar demo name to our user defined tables otherwise we won't be able to look it up through the rest of this year projects that's pretty much all i need to create a custom tables but we will have to have a Microsoft Access installed in your computer in order to to open this year a GD in order to use HD you don't need to have access but in order to modify and enter new data manually I mean the attorney tables manually will have to have Microsoft Access installed and then you can also do the same thing in there HD sequel through sequel management studio just great demonstration if this is this is Microsoft sequel server management studio and this is my Syria HD you will be able to find the table list and you will but also to do enter the custom tables and custom fields in there so this is a this is what we entered for our new test project like for example let's now we have to save and exit go back to our arm here HD administrator and what we can all we can do right now go to the data select custom tables and we will see in the latter in the list of the available custom tables with another demo table so we're going to click it because you want to enter data in there and let's say okay we already have one project that we wanted to but it we entered previously they want to enter more information there so we can retrieve this project from data set I can retrieve it by name because we had a test or the name or I can retrieve it by group this group only has one project and we can now you can take that as well well nothing we can do is we can enter our views I mean we can pick any of you but we know all this you does not do not contain their custom tables but let's maybe we can just start with the default you because we'll use it previously this is a lower information that we enter it but now we want to enter add more columns and let me from the table will just enter in the HD and enter information in there so I'll we go to the view again we go two columns and DC our webinar demo table in here and I'll just enter Egypt this Sheldon here here I mean you can now just a comment you can rearrange the order of which you view the tables you don't if you don't want to see your custom tables in then you can bring them up and rearrange it as you like since we and and the view or one comment all facing maybe you like the default of you but you enter this new fields and you want to save at this particular view what you can do you save the view because we're going to save the view and you give it a new name let's say test project you and Bill savings will have this on the list so next time you don't have to pick each column separately you will have it there then we can enter new information in here one was number the other one was slow and the company name a random company quick note when you see a blue color in HD it means it's the data is not yet saved to this year's historical database you will have to click on the database it that that is that in case you want to change your mind and some sentences because this is basically in progress data entry since maybe let's say we like the automation is connected to like it we want to save to database will click yes yes at all if you have a multiple projects in the view we currently don't want to change the view so we have all this just one project information and it's our cook we know this information is in our custom table one thing I want to say is that we want we only enter it one table to this year of historical database with the students permission but you can create multiple tables on em and some random a model fields and random information for that just so if there are certain the fields that are your company cannot match to the here data so we have this test project in our data said that when you want to do something with it or maybe let's enter lines of code for just just in case that say to database humble close it what we want to do with this projects we know it is it's safe to their data set but maybe we want to be able to view it in in metrics like if we go to metrics and just click on the view we won't be able to see that because you need to go through it an extra a process to enter that the pier serious historical custom table in there one way where you will be able to i'll show you click XP if you go to charge configuration you want to be able to see this new field in this selection for the x and y am access and currently we are not visible even though they're not they are connected to the same the same as your historical data set so how do we do that what we need to do is we need to go back to the hours your historical data set or the database and we have a table here that is where the metrics is is reading the information for them where the custom fields are created if you if you see in historical database the table that starts with a SP that's the it means scatter plot that is our old name for metrics and those tables corresponds to the the what we have been able to see in metrics and their customization information is also there so we go to the table called SD metrics table in what you see here is pretty much it is available 24 plot in for x and y-axes information you have metrics name some ID for each metric and then you have a repository a table from from Syria HD and the field name as well as the units and the type of data that is available to see them so what we want to do is to enter our custom data fields in here so maybe we want to we'll give it a new ID and we have a table name webinar demo and oh I think for the platen purposes it has to be a number field and i think it was test of sorry for forgot where we enter it was test field one that had that was a number field this is a right here you give a name where how it will show display in metrics as I is the name for the XY axis so i'll just keep the same mom just filled one let's hit numeric go to skip that so we want to enter just just so we entered our custom field into the metrics information so we'll hopefully see that now we save it we close our sphere of historical data set database we're going to open metrics again and let's go to our chart configuration no chief it's feasible forgot which field have a weapon their demo field I'm sorry let me just good I I got rid of them log information I must have entered something different and he regressing p matrix table so I'm sorry this is a I messed up by one this is a depositary table and it's very positive field filled one rep another demo this is our about the table for the name for the depositary in this year HD and let's say and then we have a numeric data in the unit let's keep the unity system test filled one I apologize for this let's try that again this is our metrics to go to the chart configuration and vc lat sto one and we can maybe display we don't really have a lot of information enter it in there but maybe total lines well it is let's displayed according to each other we only have one historical data point with this information so you're able to hit for and you have a test feel logs I'll take get rid of the log representation so you are able to display that information in their metrics if we do want to have a little bit more sense at all which I think we enter it development estimated development schedule month to the information as well so we have a on the XX this development schedule meant months and whatever that test still one might replace intend to present in the y axis so that this is how you can enter the custom information for the purpose of displaying the seals and metrics it's not very counter intuitive i would say in it i would recommend to do it for advanced users if we if you have questions by all means or you're welcome to come together at will be able to help you with that and I mean I did demonstration for access fear of historical database but you're certainly welcome to do the same thing in the sequel on data set as well I think this is all I wanted to represent for this webinar I hope it was understandable if you have any questions you're welcome to contact me with more