so this is an introduction video for my upcoming video series I'm going to show you how we can create this dashboard and the name of the application is crypto analysis and in this dashboard we are going to have data related to crypto currencies okay so when you see here in this chart this is the price evolution for Bitcoin and we have data for the past five years you can actually actually see for one year each day six months three months and one month and then so on we can as well have for example the trend for the coin see the confidence man and also the forecast and in here we have the current price for the coin and in this one job we have the price for the last three months what is unique here is we have two different line chart in the same widget and this one is for April this is for me and this is for June so you can immediately see how your coin is performing this one comparing to other months now what do you have your sort of conclusion in between coins we have a scorecard and coins listed from the ice price to the lowest price so this is only for Bitcoin and we can go here and then change for example I can put - and click on apply I'm gonna have the price solution for - to pry the current price for for - and then also the price for the last three months for that coin specifically okay so let's go down see where we can get the data okay so I'm using coin ranking API so we can get the API documentation if you go to dark start coin ranking comm we are going to use mainly Bitcoin and point this one in order to get the coin detail and this one coin history which is actually going to give us data for the past five years I mean the price so we can actually have for one year if you want OB days seven days and 24 hours okay so let's go here now and what we are going to do is basically from the moment we are having your mind that this is the application that you want to build okay this is the result that you want to have so what we have as a result four different widgets and each one of them is a different visualization for the price so that's what we have here so how we can get this result okay that's what we are going to try to break it down right here so I'm gonna show you three different slide and the first one is going to be for example we're gonna talk about performance analytics and data modeling and finally we talked about before this is something that I'm using so we will have this one we will talk about this one about this one in the end okay this is going to be much more in details how we are exactly going to implement our create our application okay so the first one here we have I put a column here this is the result column and you have all the widgets so price evolution current price price cool code and then price for the last three months okay so what we know is that all these videos they are using only one indicator that the price indicator so that's what I have in here okay price indicator and then if you have one indicator needle indicator source and if you have any cable source you need a table which is going to feed your indicator source right so in our case you are going to create a crypto table that's going to be our custom table where we are going to have data related to price time also lot of information that we need in our to the price indicator and the indicator source and then you you notice that we have a breakdown right we can select the coin that we want and then see the price of Ellucian for that coin so if you want that option in your dashboard you need to have a breakdown okay if you have a breakdown you need to have a breakdown source if you have a breakdown source you need to fill your breakdown source with the table and we are going to feel the breakdown source with the existing table or you are going to create a new table so in our case you are going to play the new table okay that's going to be a cool coin table so by analyzing performance analytics by defining from the beginning what are the different things that we need like such as indicator indicator source at breakdown we are able to actually conclude at this point like many two tables okay for our application so we're gonna have put a table and then go point table ok so that's see this whole thing here that's a point of actually creating this this kind of boxes here creating relationship in between them okay so let's go and see what we have here data integration data flow so we have our table you know these are the tables that we need call coin table and then crypto table so how we are going to put the data into a table that's the second question okay so in our case we are going to use for designer and how to send the request and obviously we are going to use an endpoint Rousseau's part we're gonna have some inputs I'm gonna use the retry policy and then we're gonna get an output which is going to be our response body then we are going to parse our response body in order to get some action outputs there's the that we're doing flow designer okay now the second part will play the data source it's going to be type load by script we're going to use the core snippet that we have from let me get from Flores I know so now to call out for the flow designer and also I have some other cool in nineteen so data into staging table so the result by creating a data source and loading data it is our actually going to create a staging table and also an import a good data ok so then is the question how we are going to take the data from the staging table and put it in our target table okay we have two target tables going table and then crypto table so that's why we preload transform app and we inform we need it so stable we need I mean we making me need a target table and then business rule when it's order gonna map the fields in between so stable in target table and transform app scripts we cannot write it if you need if needed so in the end what we are going to have is the data into our target table we're gonna run our transfer map to load the data from so from the source table targetable and finally let's do a schedule import okay which means we're gonna automate the entire process like pro designer datasource and transformer so it is optional and not for all things that we are going to be running for a few things okay this step so now this is kind of general general model it's not something like I'm going to use every time most probably yes but in order to create the dashboard but we may have some situation we are not following this one but this is something that I'm going to find on the on the world so when along the road when I'm going to build much political - goes okay so now let's go and see into much more details more exactly that we are going to create in our application okay that's what I have here this is kind of real pro then I'm using and I'm gonna quickly show everything that let me have here okay so the first thing you're gonna have one floor designer action I mean the first floor designer action we're gonna have to rest requests in there I mean some party or we don't have the part parsing the response and that's one so the next step is like having a dealer source where we're going to have coin history and then calling details okay we're gonna load the data into our staging table you're gonna have all this data is trillion details and we're gonna have a transform map calling detail starts with map which is actually going to put one he'll be calling details not a story called information just to coin details so and after that we're gonna dis activate that transformer okay let's say that's the first thing that you do then we use the same data source we know again again the same videos using the same data tools our data into our staging table okay we have another input set and this time we're gonna have a business rule another transfer map is total coin details transform app and we will load the data into a crypto tea okay okay then we dis activate this transform app as well because once we have our historical data we don't need to use this this part of this entire process we no need we don't need to use this transform app okay so at this point we have our coin detail we have our waste Oracle data and then what we need is a process to get the idea do we want to update our table with the price of today for example okay so what we are going to do for that we are going to create another few actually foodies interaction we will have two requests there so we're gonna have the coin details and also a request which is actually going to get today's data okay so we are going to use the same endpoint so if I go back here and then click on Bitcoin history so we have this endpoint and we're gonna use for example for this part here the endpoint where we are going to have five year as the timeframe okay but for this one it is not necessary to mode such a big amount of data therefore fires we just need for one day right for today so we have one year thirty days seven days 24 hours but I'm going use seven days and then I will be working on the scripting level and not to have just the data for today okay so it is all so we have that one done here so the pro designer action the two works request we load the data too but just the data for today for the day you are actually doing so daily data and we have our staging table with the input set use the same business rule we have another transfer map and we put the data into the same global crypto tube and this time we have to automate the entire process because we want to have this one every day we won't have the data every day so we're gonna schedule import and it's going to repeat every day at a specific hour during the day okay so this is how we are going to exactly implement create our application this is the entire flow let's say ok so that's it thank you for watching hope you enjoyed and have a good day bye