Thanks Martin. So now I'm actually very nervous because coming after Mabel right, pardon my coding. Okay so it may not be the best code and cleanest one. There's no type scripting. Okay so pardon me. Okay so as Martin introduced me I'm a bit of a jack of all traits but master of none. Okay so my main objective here is just to get it to work. Okay so I feel like a student getting marked by Mabel. Okay so the topic that I'm going to touch on today right is the automatic cube creation but actually the whole idea is to have a small program that will allow the end users to interactively create a Python BI Analytics 2 platform. Okay so that they can create dashboard perform some analytics. Well skip the technical part first. Let me show you what I'm trying to say. So I have this particular notebook that I've already run through. Ignore all the coding. So here I have a button. What I'm going to do is click on it, select a data set. So here I have pre downloaded some data sets from cargo. So I'm going to choose the avocado.csv. Okay and here once I select that right I have the I have a list of columns that is from the data set. Okay so the next step now is to choose a set of keys. So what are keys here? So in Atoti keys are meant for us to identify unique data rows in your data set. Why is that important? Okay so first of all when the when your data set is not unique when there are duplicates based on these sets of keys right the last uploaded record will actually overrides the first the previously uploaded data. Okay so we will only keep the latest unique data set okay in the cube. So the other the second reason why we have the keys is that because Atoti actually dissonant rise based on these keys so that it will speed up your querying. Okay so the the query performance will be much faster in that sense. Okay so in case you know you don't know anything about the data you can always choose none. What does this mean? It means that all the columns are used to identify the unique rows. Okay so if nothing choose none. Okay so in this case I'm going to choose date and then type year and region and once I submit that you can see that my program starts creating a session and then it will actually take the data that I've uploaded right and create some tables Atoti table. Give it a little while you know then here you can see that I actually have a progress bar that is moving as my my program creates. So then once data is created into the cube voila. So now I have a BI analytic platform from one CSV. Okay so can you imagine your user is you know like not very savvy you know but they have a data set that they want to analyze right. So if you create this small little program you give it to them and say hey now you can actually analyze huh but they stare at this. What do I do next? Right I have a a GUI here so next we go and create a new dashboard here.  Okay so here right on the left hand side we have a couple of drawers so we have the content editor. I'll come back to this later on and then we have some filter editor widgets as well as style editor and on the top here we have the rebounds. So I think it's pretty intuitive because it's similar to how your excel works now right you have the rebounds so then you have some editor on the left.  So now I have a table and if you're not happy with a table okay I'm not happy with the table I want to see a trend let me switch over to a line chart easy peasy right okay so now let's say your user say this is not very interesting I can split it again by the type so now I have the trend of the conventional avocado versus the organic avocado okay and of course you can drag and drop even more of them let's say for example I want to compare the across the years okay I said I want to compare maybe the sales of 2017 against 2018 okay and then I say let's look at the total volume. So now here you can see that we have the difference across the two years. So the dashboard is yours to build I mean you can play around with the different kind of visualizations you know you can have a pivot table that allows you to drill down let's say for example I can say for each region I want to look at the sales the dates for the dates so maybe I want to see the large bags small bags and the total bags right and then let me just collapse this a little bit and we can add a bit of storytelling some some interactive component for your end users so let's say for instance now I select region I can multiple select you know like I want to add in let's say California Chicago okay if you don't want to show them as a multi-select you can always change it to single select for instance that at any point in time they will only be able to select one so the question now to you is how much time would you take to develop this as an application yourself you know it's for one data source for one cse file is it worth the effort to build a whole bi analytic platform not really right so that's the coding about python because there are so many libraries out there right so you just need to have an idea look for the correct library piece them up like Legos and then you get something like this you know so now I can easily go back to my notebook I click on upload again so another data set that I've downloaded from cargo ds salary okay so now I reset the whole program again and then I say okay based on the work year or maybe I will just choose none this time around okay I don't select any key and you see here I'm deleting the existing unnamed session to create the new one what this means is actually because I'm a bit lazy you know like I don't perfect it but rather you know I just want to explore the data right I want to allow my user to explore the data anytime they are ready so I will destroy the previous session re-instantiate and create a new one so now the users can actually go in and then look at what is the salary for this job title for instance okay and then maybe now you see the problem here now is my work year becomes a sum I have a mean and a sum I don't know if it's big enough for you to see okay so I have mean and some for every columns right so in authority when you have a data set okay there's two types of columns we have okay numerical and non-numerical normally when we want to look at a business matrix we look at the figures but along some hierarchies right what hierarchies like for example company location right so in this case year should be a hierarchy but it becomes a matrix now that's because I didn't select it as a key so theoretically I should have selected it as a key then it will be created as a column then I will be able to query it okay now so far okay am I boring you all right so as you can see we can easily build everything together so now let's take a quick look here you can see that I've created and save a dashboard I could actually save it so just I didn't perform a save so it actually becomes you know like blank here but let me just go back to the technology behind this let me just zoom a little bit out okay so in this particular notebook I use a couple of libraries but most importantly I want to highlight two libraries okay I guess you know for the interactive component can y'all guess what library I use no no I use ipyrejet okay so ipyrejet allows you to have this kind of you know float bar progress bar you know the multi-select as well as the buttons upload button so and so forth so check it out you know ipyre the jupiter widgets ipyrejets you know there are lists of interactive components that you can actually put into the jupiter notebook okay to have this kind of interactions here okay so that's the first part to having this program here to allow your users select their own csv and then create a bi analytic platform so second part easy right exactly that's why I'm here today okay so a 30 is actually a free python library so you can download it and play along with it okay around with it so now let's take a look I won't go into the details of how we integrate you know the ipyrejet so so long as you know how to retrieve the data source pass it on to the next function I mean then you can piece up this whole program right and anyway it's available later on I'll be sharing it with you now let's look at the create cube let me zoom a little bit okay so it's very straightforward step one we create a session okay a 30 session so in this session right what I've done here is I've fixed a port to 9090 you can change the port by default you can don't even pass anything to the variable okay when you don't pass anything to the session it will create a random port number for you which is bad okay if you're just playing around trying to explore some data it's fine but if you're going to share your dashboard with someone else okay say for example the dashboard that we create earlier on see now it's broken because I recreate you know the notebook so the data has changed the column has changed but suppose if I want to share the dashboard right that I have here I can just send this url to someone else provided they're on the same network this is localhost so nobody can access my machine okay so then I will want to fix the port so that you know they don't have to re-bookmark the dashboard every time right secondly firewall if you're going production with a actual project right with this then you need to fix it for the firewall okay it's more controllable when you fix the port then step two of course just now earlier on we have selected the csv upload into the notebook right so in this use case I have converted into a panda data frame okay and of course the keys here is the key that you have selected earlier on to identify your unique dataset right so now using session dot read pandas I could actually create an an r2t table and load the data into the table so but of course in a proper project setting we would first of all create a table then we load the data in okay but for this case because I want it to be dynamic so it should create based on whatever the user uploaded right so using read pandas it will automatically create a table structure based on the available column in the dataset okay so the next step is to take this table and create a cube so anyone play with a cube before or lap cube no okay so basically r2t creates an in-memory data cube that would allow you to you know view the data in in different dimensions you can actually slice and dice you know just switch your perspective around like how I drill down just now you know I can look at the year I can look at the company I can switch my view anytime I want okay so that's the beauty of having a cube but of course later on I'll tell you more about our cube it's different from the typical or lap that you have okay and then finally here I'm just calling the I'm just using web browser to open a url so using session dot link okay so this is actually you know it should be a private function but here to facilitate so I'm using the local url but with session link actually I will be able to get the the url to the web application so then it will launch it okay then you can start building it so this is very easy four main statement to create the cube and then voila you have your vi analytic platform okay let's go okay so now we are done with the basic crash course of course if it's so basic then my company wouldn't want me anymore right so I will say adios goodbye okay so now I've created an advanced version just for this this session okay so what can I advance on okay before I do this advanced advanced advanced mode right let's look at let's have a quick recap on what we can actually do here okay so basically the idea is that we create a session okay so and then using the session right in the session we can actually do data loading so we create an r30 table we load the data all the other way around we could use the connector to directly read your data source and create the table so there's two ways that we can go about it and we have a few data type I mean the data connector such as sql sparks pandas uh pake csv numpy for instance so another beauty of python you know if I don't have the connector I'm sure you can load it into pandas right or you can load it into numpy you know like sparks data frame so so long as you can load into a certain format that my connector can connect right can can load right then you can use r30 and I show you the simplest basic format which is one single table but if you imagine like a database you can have multiple tables depending on how your data source is being organized right so you can actually join this table together based on the columns you know similar columns you join them together then you have a snowflake schema okay so by snowflake schema what we meant is that we will have a base store that contains the most granular level data okay so we will use that base table to create a cube and what I've shown you just now is just a single cube within a session within a session you can have multiple cubes if you want so again that is a little bit of how you plan your data model right so you would group like data of the same structure together you know the same storyline you know if your company wants to see the pnl versus you know like intraday liquidity or whatever you know in finance will then you can have different cube and then they are all accessible within one bi platform okay so it's one one session one bi application so far okay okay then let me quickly show you again what is the difference so same thing here I scroll right to the bottom I do the upload so now I will use a financial data set the var the var data set which is the value at risk so first of all you can see that now I explore using a different ipie widget so I use checkboxes for my keys okay you can see that all the columns are being exposed here and I have a drop down list here can anyone guess what is this drop-down list for the types exactly how you listen to Mabel right okay so let's take a quick look at my data okay so my data set because it's a financial use case and in finance right we want to know the daily profit and loss so can you imagine I have a figure per day across 300 over days right and then if I were to store it as a actual data row then I have to identify the key let's say I have instrument code book id then the day the day and then I have the value so then this is multiplied by 365 so your data set is huge but by having a list to store each day that the value for each day right I compress my original data set right but if I were to load this data set into pandas right what do you think will be the data type inferred a string unless you cast it right yeah so it will be treated as a string which no I wouldn't want a list to be treated as string right so that is why over here I could choose my PNL vector as a Boolean array okay and then let me select my keys to the data set and then again I submit it okay so there's some other slight differences but let me just show you once this is created so you can see that here I have flagged out all the numeric numerical columns because later on we will see that I actually created some additional measures in this system instead of just now we saw we have default just a mean and a sum right when RTT creates it so can anyone spot the difference nobody no no this is the default landing page so the main difference is that now I have a demo folder and I have data exploration right let me go into the presentation mode just now earlier on when I restart the session it was a clean page nothing is persist even though I created some dashboard you know I did some things right so by default RTT will not persist anything so the data cube is created in memory your tables are in memory the dashboard the widgets the filters whatever you created is in memory so when you re-instantiate a session everything is gone right but we can actually persist it if we want so that is the first change in this advanced notebook that I have done so let's quickly go back to the code again okay so you can see that in my sessions in my session function other than the port number here I have also created something called I have used the parameter user content storage okay so in this content folder here that I've defined let me go back to my root folder you can see it here and I actually have this content mv.db so this is actually a h2 database okay so this will actually store the widgets that you create or you know the filters that you have saved as well as the dashboards you have saved so now if I want to share with someone else I could actually copy this I do a incognito window say for example paste this and then you should be able to view the exact same dashboard so if you put this on the cloud you know then you have a public ur ip address then you can actually share it with any of your collaborator and the good thing is because everything is created on the fly right so whatever changes that I do in the Jupyter notebook you know the other side will be able to see the changes immediately okay so far the first change okay so now that we have persisted the next thing that I want to show you is that as a user you know who doesn't really code and then you know like I want to do something right do I have to go back to IT you know like I just want to compute something new if I have to go back to IT then you go through the requirement gathering you go through the the development and then the UAT SIT UAT production then oh I got my final project one month three months later right so now there is this function called new calculated measure okay for example I'm going to do a PNL okay so square bracket for this is basically the syntax for OLAPS okay so I can do a M and then you can see that it's auto suggesting what are the available values so then now here I'm going to take my PNL dot value okay and then I'm going to multiply it by another measure say in this case I want it to be quantity dot sum okay so I can add it to view and then ah I've added it to the wrong view because this is actually my selected widget so you can see that I have my PNL here let me just do a small change I'm going to save okay let me go back a little bit sorry it's a little bit small let me undo it undo it ah okay so now I have my PNL here okay so I'm going to do a save okay I save my calculated measure so this is where it gets committed into the H2 database that I told you earlier on and then I could actually select the correct widget now and then I can go to my file and then my save measure I select this and then I apply it so let me go back to the presentation mode so now I have the quantity multiplied by my PNL value to get this PNL here okay so your users do have some control over some measurements that they want to do on the fly without going back to it okay now any questions so far okay nobody's asleep yet right okay one more question are those same sessions all shared by one login or like different users have different sets of saved sessions in the h2 and maybe you can share some well so basically you view this as an application so many users assess the application so there's only one session yeah of course you can create multiple sessions within the jubilee notebook but each one will have their own web application so the new guy comes and like the leads something either a way to roll back to like wow theoretically that is a process outside maybe we can advise on that right because then that's where your geek hub control you know or big bucket comes in you know you have your commit and etc and theoretically you shouldn't be sharing the same notebook because there's one corner as only for each notebook right so if you restart the corner then the session is gone so theoretically you should be having something like maybe jupiter hub where everybody can spin up their own instance they copy a version of this notebook adapted to their own use but as a project right if you're running as a project typically maybe it's here typically you wouldn't run jupiter notebook in production you can run in doctor right usually if you want to maintain it for a long period of time then they can choose not to run in the jupiter notebook right yeah yeah so theoretically you could extract this out and then put into a python script right but then you will lose the ipai widget's interactive component last last thing starts for q&a um does that help to provide hosting of these jupiter notebooks um no no no so it's just a python library yeah so you can use it in python project or in in the notebook okay yeah so of course you know like it's basically right fundamentally ato t is a bi analytic platforms you know it provides you the holistic solution so you should be able to create your own measurements you know your own measures kpis based on your formulas computation so here right in this program i have only incorporated a very simple measure which is called a single value so then of course this is where i bring you back to my product okay going back to the documentation right if we go to the reference okay of course you can install you know and then go through the tutorial how to use it for for your own project or you know for this particular ones okay so under the api references let's say for example i just look at the aggregation module okay so then you see i have long max max member mean medium etc a lot of functions available here and then not to mention that i have like if you want to order your data by some scope you want to perform some functions like date difference or shift the date or look at the parent value so and so forth so if you have a formula then it's a matter of how you use the various functions to put together to create your formulas right to chain them up so it's pretty much like in excel you know you have your excel function and then you formulate them bit by bit and then chain them up together right but however it's interpretable so in this use case right what i am using is the single value maybe it's not very intuitive so basically the idea is that for a member for the members of the level if you have the same value for all the members it will return you that number but if it's different then it will not return you anything say for example if you go to a shop and then for all the hitachi they sell hitachi tv that say they sell 500 dollars okay but then there's one particular model that sells 499 so it won't be able to return you the value for hitachi tv but let's say for maybe some song it returns 999 for all the tvs then single value will return you 999 okay so it's very minute but then you'll find that in some cases we need that okay so just to demonstrate that we can create some measures so you can see that here right depending on how you want to hide how dynamic you want your cube to be in this setup you could actually add it on you can actually expand it okay and to go back a little bit to the the the part on the data type so because atot will inherit the data type from the panda data frame okay so we are actually taking the value that you have selected earlier on and cast it so if you didn't select anything right for the data type we will automatically take the value that is inferred by pandas okay yeah okay so i think that is about it for the auto part so if you guys are still with me i can explain to you the technology about i mean behind my product okay so well so it can be a python project okay so you just take the library you take your own data you take multiple data create multiple table you join them together create a cube you know then you perform your computation etc or you can make use of jupyton new book jupyton lab like what i'm doing now so atot has some custom features that helps us to leverage on to this function right to perform well to to to to explore your data okay we'll see later on to make prototyping much faster and for interactive experience okay and underlying is actually java so actually i'm a java developer i learned python only three years ago okay so underlying is java and then we have the in-memory data cube okay with a bi-analytic platform so the history of the whole product is that this was sold alone and this was sold as another product and then now because we have a python wrapper right and we decided to have an open software so the entire thing is free all right okay so feel free to use it of course there's the oiler check out the oiler first okay everyone's still with me can i continue a little bit more five more minutes i think okay so now to tell you a little bit more about the data cube olap right so typically olap let me just do this okay so we have some dimensions and we have some measures so as i mentioned just now we look we create only one atot table so therefore i only have one dimension which i named table by the way so it's a silly name but sorry so this is actually the the parent table and this is the table that i created okay and i have the for each non-america columns or key column that we have selected right it will be created as a hierarchy and beneath each of this hierarchy right is a single level so by default it can be more than 3d it's called multi-dimensional thing exactly so each of this is a dimension as you can i mean it's a hierarchy rather so then each table that you create is another dimension so dimension actually groups the hierarchy and then hierarchy is the the so-called query that you will query your business metrics around right so let's say for example which building what time you know and then maybe who so these are the the dimensions right the different dimensions that you can look at and then let's say for example quantity all these are measures so all the numerical figures that you are interested in in statistics right are measures so for atot right by default it will create them as mean and sum and then we can actually have dot value okay so this dot value is the single value that i've created earlier on okay so basically this is the structure of a cube so now with this structure right let me just quickly show you so this this is a customized feature for for atot where we have the atot editor here that will allow you to you know interactively build the same thing as what we have done earlier on so i can have my underlying code and then here i could actually drag and drop into the table and then i can have a collapsible pivot table here right and then i will say okay so i can look at maybe say the quantity dot sum for each of this right and then i have the maybe i want to look at the p and l vector dot value as well so here you can see that my p and l vector i have 372 values in my list okay so let's work a little bit more with the vector okay so with the cube rather so in order to work with the cube so i can call cube dot hierarchies okay cube dot levels or cube dot measures to start working with them so these are the three attributes of a cube so then say for instance in this case right i have my p and l vector okay and i'm going to scale it up with the quantity dot sum so it's as simple as taking the measure multiplied by this so again going back to what maybe was saying so if i do a tab here you'll be able to see the auto suggestions on what are the available values that you can use okay so in this case i'm going to use the value p and l vector dot value sorry and then just to move on again let me just collapse this so that we can see it properly okay so now now that i have my skilled p and l vector i'm going to perform an aggregation okay so there's two dimensions here so on the scope level the instrument code and book id right and anything that you carry below this two level right i will take the value of my skilled p and l but for anything above it i will perform an aggregation that is a summation so what do i mean by that okay so let's do another visualization so now this is my original vector and then this is my skilled one so let's look at a simple number like for example this one it was negative and when i multiply by the negative one quantity it becomes positive right so at the instrument code level which i stated it under the scope right you can see the value is exactly the same but now what i have is i have a summation on top okay so this is where the aggregation function kicks in right so i have a value on top but we don't really want to work with vectors right i mean it's not really readable you know we can't really use it so what we are going to do now is we are going to create value at risk okay that's the main purpose here so for this value at risk i'm going to quick use the the array function quantal to take the 0.95 percent d95 percent tau of my position vector okay so now i can actually do a visualization so let me just drag this a little bit okay so then again i have my instrument code and then on my p and l i have my vector and then i have my var here so you can see immediately it appears right so if i were to go back to my my dashboard here you'll be able to find the var as well right so whatever you do on the Jupyter notebook side right it will be available on the dashboard side as well okay so your end users will be able to see it immediately okay so now i actually have my value at risk and then i could actually let's say for example i put my book id because i want to view each one by book id you can see that here when i sum up all the instruments under my book right the total value should be 101 and 927.09 uh 309 sorry but however the top value here shows 47,080.63 why is that so okay why because we are summing up the vector and then we are taking the 95 percentile of this vector okay so this is something we call non-linear aggregation so you can actually decide right what formula to apply at what level and when you query it actually change based on your query okay and everything is actually computed on the fly as you compute as you as you query them so this is something different from OLAP because OLAP actually you have to perform the pre-aggregation first and then put everything into the the LDAP right into the OLAP right sorry and then when you query it you have it but here we define the formula and then as you query it then we compute it on the fly okay and not to mention that we actually support incremental data loading which means that when you have new data coming in i could call the load function load it into the table and immediately you will be able to see it in the data cube without having to restart it so in the typical OLAP situation right you will have to restart your data cube okay so finally last portion here which may be interesting for you so you can see that here we have the formula let me just collapse this a little bit we have the formula that we are taking the quantile array the the quantile of the array by 0.95 so i'm going to create a parameter simulation on this 0.95 so in this case right i create the this simulation where i create a measure called confidence level which i defaulted to 0.95 i call the base this base scenario as 95 95 percent okay so then if i were to query it okay so now it shows that i have this measure which is value 0.95 i could actually output this to a data frame and then i could actually query it along some other levels as well let's say for example i have um let me see bulk id okay and then i can also have my let's say instrument code right so if i output this df.head so actually you can do your measure computation aggregations you know into a pivot table you query out and you can output it downstream you can do further computation you can merge it with other data you know create another cube again so the imagination is yours what you want to do with the data okay and now to go back to our initial formula okay so now earlier on i use 0.95 in this definition so now i'm going to overwrite it with my new parameter simulation okay so with confidence level that is defaulted to 0.95 and then let's do a okay let's do the visualization again so you can see that now i still have my var and then i'm going to create two more simulations called 90 percent and 98 percent so with the value 0.9 and 0.98 for instance okay so finally i will be able to visualize them side by side in this manner so i can actually have my computation with the 90 percentile 98 percentile compared against my 95 so if you look at the editor here what i simply added in is the simulation hierarchy here confidence simulation okay so basically the small program that i created is just to facilitate users to quickly do a analysis around a single csv data source but the library itself is not limited to that you can actually expand on it depending on what you want to do so you can do things like this example so now right actually the key point is that with the vast amount of libraries out there actually you don't have to code everything yourself it's just a matter of imagining what you want the angle that you want to achieve finding the right correct libraries put them together you get a new product okay so if that i end my session any questions yeah well so the limit is your machine size so yeah so the hardware space that you have the RAM that you have in your machine that limits how much data you can load into the the cube etc so by default i think we set a limit to use about 25 percent of your hardware RAM but you could actually adjust this using the java options okay so in fact if you put it on the cloud then you could actually scale it according to your needs as well yep then yeah that's about it wow so really i'm not really a power bi users but i know the sharing is a little bit more difficult because you actually i think if i'm not wrong you have to host you have to engage another product of power bi to be able to start sharing right you have to host it or something but here yeah exactly but here you know like in this i i'll show you how i share it just now right so long as you host it somewhere you know that other people can use even on your intranet if someone else can access your machine they can use the ip address to access your dashboard well so that's where the paid version comes in so basically it's without security right so if you want to implement security like lock in access and then who can actually access the various data set then you have to go for r30 plus which is the paid version then you will be able to you know connect it to your l-deb or you know if you have oidc you know you can actually have an authentication mechanism implemented in it so then your users can actually lock in and then based on the roles or user group right you can so you can choose you can actually configure whether they can access certain files files certain folders certain dashboards or even up up to the data layer you can actually say that team a can only access country a team b access country b you know that kind of possibility is there once you have the authentication mechanism but i think by itself the free version you can do a lot of things everything that i've shown you inside is available in the free version actually yes yeah so yeah so you can actually find this use case right in the github gallery so under the you can go to github.com atotie slash atotie slash notebooks then all the use cases are here and then in fact right if you expand it into the notebooks folder then you can see we actually have a lot of use case the ally industry is contributed by a user and then the rest you know like we created it on and off so the auto cube is the one that i have just demonstrated to you the main advance and the main so it's step by step guide so actually you will be able to follow through it yourself and then in fact right if you are more interested about that you know you can even go to medium dot atotie whereby usually each use case right we try to create an a corresponding article to explain how it works so then you know you should be able to learn and pick up the tool by yourself yeah so you can see the different ways to secure your atotie session for instance you said you wrote a rapper a python rapper around your libraries yes those libraries did you use with reflection and how did you like meet the bindings between islam and i won't be able to tell you i'm not from r&d i would love to tell you but then sadly they think that i'm too talkative so i'm in the evangelist job and not r&d it's not open source so it's like what um female yes exactly so but the free version at the moment at least i think in my perspective you can do all kinds of aggregations already so the catch here is of course in the oiler is that normally we say that you could only have one builder and one reader meaning that you can't really share your dashboard with a lot of people you know we set some limitation here so initially when we first started out we target the data size domain because a lot of time we find that data scientists will find this very useful in prototyping exploring their data you know build out the model etc and then to run simulation as well so every time you have a machine learning algorithm that outputs some values the question is how would business find value in the prediction so then you put your prediction into atotie where you already configure the business kpi you create it as a scenario you show the users the business users what is the original value what is the predicted value and then when you have the actual value coming in you could show what is the actual value itself right so all once we have set up the model itself you just need to fit your machine learning prediction into the system so likewise for financial industry you know you have your own risk engine you know multicolor simulations etc you could actually load it inside run through the business kpi and see how they differ from you know one another the kind of idea yeah the dashboard so theoretically in the dashboard you can make it as a report right now my question was like if for example the data has changed is there like a refresh point you are going to run through the so to just change the previous you already have set up the dashboard it's just i mean i'm looking at the perspective of report yeah so basically the idea is that uh because atotie support incremental data loading right which means that you can actually add data on the goal without having to restart and then your users will be able to access the data immediately when they query it so if i were to go back to the dashboard itself here okay let me go into presentation mode notice here there's a small icon here you can actually turn on real time mode so meaning that as data come in right your query will refresh and then you will see the latest value on the widgets so you can control them widget by widget to show the data real time but depending on your business use case because not everybody require real time because it's resource more intensive right so anytime that you you want to get the latest data right you could actually just right click and refresh the query you get the latest data so then it's a matter of how you organize your data so for example in bank you know you have your s of date day one day two day three day four and then you just have to set the slicing so that every day you just see a single day and then you can order them so that you only see the latest date for instance and then when you want to see the previous data you can always switch your you know you can play around with the quick filter for instance or the or here even you know in the filter editor you have like page filter dashboard filter this widget filter that you can actually apply so that you can look at different data or date range for instance i would suggest some of you have more questions just come forward and and ask we found it directly maybe the rest of us who doesn't have questions should finish up the pizza i think might also need some time to pack up his stuff and it's quite late already so yeah once again we thank you for your talk very nice and like i said if you have more questions just walk around ask people and help me finish the pizza


You can now follow me on all my social media platforms to find out who my latest guest will be and don't forget to click the subscribe button and the notifications button so you're notified for when my next podcast goes live. My dad tried to kill my mum with a knife and it resulted in five of his kids being put into the care system and I was put into the care system when I was eight months. I overheard two of my carers say when I was six that mixed race and black children are less likely to be adopted and more likely to spend the rest of the childhood in care and the next day when I was in the bath I tried to describe myself white you know because I wanted to give myself a better chance so I could be loved. I don't really want to get into the details of it all but he raped me basically and you know yeah it wasn't great so you know that was a difficult time.  At that time I was twelve and by that time I've had twelve years of abuse of one kind or another and it was just abuse after abuse after abuse if it wasn't being raped or being punched or kicked it was bad names. Boomer on and today's guest we've got Peter Woods. Peter how are you? Hello there I'm okay thank you very much. Good to see you. I'm glad to be here. You've done a video on TikTok a lot of people tagged us in talking about the struggles of life talking about your struggles of being a kid raped at twelve being through the system and in out prisons and now you're here today to tell your story. Yeah it's a great opportunity. I'm very very grateful. Good to have you on but before we get into everything Peter I always go back to the start of my guests. Where did you grow up? How it all began? Well as far as I know because it all happened very young and extremely young. I believe by the reports I've been reading the last year because I've started writing a book about what happened and my dad tried to kill my mum with a knife and it resulted in five of his kids being put into the care system and I was put into the care system when I was eight months and because I was the youngest I was too young to go into a children's home so they put me into a nursery until I was two. I'm not sure where the nursery was but all I know is once I was two I joined my brothers up in North London a children's home called 82 Muswell Hill and it was a detached house and it was a children's home and it was about ten kids and a fourth staff there. So I grew up there basically in North London in Muswell Hill. How was it not skilling enough and then just out care homes from a very young age? Well yes from eight months and I went and I left when I was 18 but during them years I mean you know it was in the 1960s so there was no care really. I mean it's called a children's home and a care home there was no care. There was no love, there was no kind words. The only thing we got for care was food and clothes and for someone like me it's very hard because I'm very emotional and very sensitive I'm actually born a highly sensitive person which is maybe only 15% of the population which means we feel things on a different dimension than most people. I mean it's very profound and very strong and when we feel it's we feel deeply. You know so for someone like me not to have any love as a child it's hard, it's hard. No foster parents? Well what actually happened in the 60s not many adopted black kids and I overheard two of my carers say when I was six that mixed race and black children are less likely to be adopted and more likely to spend the rest of the childhood in care and the next day when I was in the bath I tried to describe myself white because I wanted to give myself a better chance so I could be loved you know because I would do anything to be loved and because I was black you know that seemed to be a problem so you know I'm only six I'm trying to think oh if I can be white I can find parents you know so I scrapped and scrapped and scrapped and I didn't get any white I started to bleed and you know I spent to the rest of the my child in care. How many other kids were in these care homes? Well the first the best home was the first home in Muswell Hill because it was small and it was the closest I felt to a family you know the staff were friendly you know not over caring but friendly and the kids were like brothers you know so it was small and intimate but once well what happened how I left that children's home was a new member of staff come and it changed the atmosphere of the home before it was nice and friendly and when she came and her husband it turned aggressive and there were rules and regulations and bedtimes and you know I didn't feel like a home anymore and the husband was quite abusive he used to conquer on the head he liked to watch the news and when the news was on he said everybody be quiet or aggressive so he bring aggression into our home and it was never like that and we were all scared of him because he was quite abrupt and quite big as well so whenever the news was on he said I can't because I like to talk and joke so a few times when I started joking he said come here and I walked up to him and he just conquers on the head so it just changed the whole atmosphere and it didn't feel like a home how did the other kids treat you no the other kids were ok we all got on really and most of the staff got on but once the staff everything about being in a children's home is especially for someone like me it takes me a long time to trust anybody because most people have come and gone but so when you trust a member of staff they become like your mum and then a year they go and then you're deflated again and you feel very sad and very hurt then someone else comes and you feel happy and you trust them then they go so my whole life was one of I was left or I was upset because they left me so most of my life it's been people coming in and out and that's been hard was there much beatings? not in that home that home was the better home as I said it only changed when that man come Mr and Mrs Hines then when they come there wasn't any beatings but it just changed I had an argument with Mrs Hines we was at the table and I don't know what happened but she said something and I forgot how to fuck off and we had a fight and she was a big fat lady and she sat on me and put me on the floor I was 11 at the time and anyway I went to school when I come back I walked in the way I've always come through the back door upstairs in the house I got jumped by three men I was 11 I was scared I didn't know what was happening and they pulled me and dragged me I was screaming and shouting I didn't know what was happening I was upset they dragged me and pulled me I said what the fuck was going on and I was terrified because I'm being jumped by three grown men I don't know what's going on I'm 11 I've come home this is my home they dragged me in the car I couldn't say goodbye to my brothers I couldn't take my property I was terrified I was a kid napping by the state they grabbed me put me in the car and took me to another home up the road and there they placed me in a new home a new environment a scary environment I was the youngest one in there I was traumatized you know so there I was fighting now in this new home and terrified and from that moment my life was hell and from that moment it's been terrible I mean literally terrible well from that moment my sweetness the sweet person seemed to have died and then the reality of life you know you're around kids who are older more aggressive and you know you're just lost there's no there was no love anyway there was no concern you just a number in a bigger home because this was a bigger home half way up Muswell Hill Road it was called Grove Lodge at the time a big white house and it was a bigger home there's about 30 kids there and they were all older and I was the youngest one there you know so they picked on me as well and I was scared and I was nervous and I was traumatized and I was just I was like a dog in the corner away I slept that night in a cardboard box underneath a bridge scared all on my own and then I come out of the box and I saw a police car and then I flagged him down and told him you know what happened and he heard a person he's run away from the children's home and he's me and then they took me to a different place like an Ipru school they took me there to be well to find out where I could be placed next but that was even worse you know so from that moment when I left the safety of 82 Muswell Hill my life was from one institution to another, to another, to another I didn't settle and everything got worse and worse and worse you know we always wanted your mother or father to come and take you home well you know my mum and dad they used to come maybe once a year and I used to look forward to it and it was like I couldn't wait I really wanted to see them because I talked to them all the time and I missed them and the others they weren't too concerned the brothers of mine, they weren't too concerned but it was me, I was really missing mum and a few times dad said he would come on a certain day and we waited and he didn't come and for me it was devastating, for me it was really hurtful he doesn't care, he doesn't love me because he let me down about 10 times when he said he was going to come and for that to happen time and time again for a child who really wants to see his dad is not nice do you still struggle with that to this day? I forgive him that's very brave to think you do well what happened there with him after not seeing him for 40 years or so my brothers went one by one to see him and so George went first the older one and then maybe 3 years later Stephen went and then Martin went to time after him and it would be 10 years until I would go but then I said to George I'm going to write dad a letter give it to dad if he reads it and he agrees with what's in there I will come but if he doesn't I will not come and what I wrote dad looked at it and said yes I agree so when George told me he agreed I went to see dad in 2015 I hadn't seen him for 40 years and but this time he's an old man I think he had diabetes frail and that time I was bigger I was really big like that so I thought to myself I don't want him to be afraid of me I don't want to go there with aggression and be submissive so we knocked on the door on Christmas day and it was always my dream to spend Christmas with my dad it was my dream and I prayed and I wished and I hoped that one day Lord God please grant me Christmas day with my dad I don't think it's ever going to happen because I'm filled with her I'm very upset he's let me down he's really hurt me many many times and he's put me through 18 years of hell I mean literally hell no child should go for that sad or that low or that sad but you know what it's time to forgive because he's an old man now and I don't and I do not want to be standing at his grave and wish I would have made peace before he died I'm not going to put myself through that so I'm going to go humble myself so he opened the door I looked at him I smiled at him and he smiled at me I put my hand down he led me into the sitting room we sat down I hadn't seen him for 40 odd years we sat down I was looking at this my older brother was looking because he knows my temperament as well so George is looking he's fascinated to see how he's going to pan out he's either going to go good or go bad but for me I said no I'm going to be submissive I'm not going to get excited I'm not going to go there with melis even though I should or I could but I'm not going to do it he held my hand we sat down he looked at me I looked at him I said how are you I'm okay son and then he said something and I said no and when he hears something he looked at me a bit puzzled he said I love you he looked again and then he said what I wanted to hear I'm sorry and that one word let everything go everything go 18 years of hell despair, loneliness, sadness anger, confusion 18 years of rage then words, magical words from my dad I'm sorry and I looked to him and said thank you and we had Christmas so we're sitting around the table on Christmas day my dad at the head of the table with diabetes my older brother George beside me with prostate cancer my sister opposite me with a tube up her nose because she got lung disease and me sitting here with a brain tumor but it was fine we all just had a great day and that's a magical day so I made up you know was that one of the best moments in your life where you felt it was the first time you probably had a family? no I didn't feel like it was a family I mean that moment is not going to make up for a family but what it was it was peace it was a wish to come true and it was the full circle it's come full circle now I've made it up I can carry on and to be honest with you I think dad was waiting for me he saw the others but when he saw me he's eyes lit up because I was the one he told me stories about me when I was younger he didn't know and the way he said it was like I've missed you more than the other three that's what I got so I think when he saw me he would die like a release see you've suffered some horrific things in the care home one of the things was when you were 12 years old yes when I was 12 years old in another home in Potter's Bar beautiful home, stately home big massive lovely home no four place it's called and that was one of the better homes that was a lovely home and the grounds were big the staff were nice it was all good and fun and then it was my birthday I was 12 and one of the carers invited me to his room he said Peter I've got a present for you I went all excited because I love presents I don't get much kindness so someone's going to give me a present so I went into his room and then he shut the door I said where's the present he said sit down he said it a bit aggressively then he pushed me down and I'm only 12 so I was a little bit scared I was a lot scared but then he you know I don't really want to get into the details but he raped me basically it wasn't great so that was a difficult time but the worst thing is then I had to see him every day he only did it once but another member of staff and this is so weird so how I got to be in Norfolk place in the beginning was from Grove Lodge because I set fire I forgot to tell you I set fire to a room in Grove Lodge and I slept in the box so when they please come they didn't want me back to Grove Lodge so they sent me to this school to get assessed to go to Potter's Bar but when I was in so the moment I got to Potter's Bar the moment I got to Potter's Bar the abuse started because Chris, some guy called Chris White he was the owner of the children's home the moment the other social workers left he started abusing me he said Peter would you like to have a bath I said no I don't want to have a bath I said what do I need to have a bath for he said yes I want to have a bath with you and I didn't think I heard right have a bath with me I said that in my mind and anyway I did go and have a bath because I fucked myself if I didn't have a bath he might send me back to that horrible home I've just come from so I said okay I'm going to have a bath so I got in the bath myself and then he went and jumped in the bath with me and you know just started having you know he's fun and I was kind of well I was terrified and I froze and I didn't know what to do because I just got there and I thought this home was going to be nice I thought they were going to treat me nice and I thought they were going to be kind first of all Peter you're brave for telling your story which will help so many others like for coming here today and obviously opening up like it takes a lot of strength but how do you then move on from that Peter at such a young age like do you become more angry towards the world or do you become more freer and fragile like you just become so scared to it?   I'm now I believe it or not 62 you look great man I tell everybody I'm only 50 that's to get the younger boys is that do you scare yourself something Peter? in what way? just that when you can be triggered no because for most of it I'm in control I said the only time I'm a little bit scared of myself is when loss comes someone is leaving me and being horrible to me at the same time have you ever been suicide though? no that's weird that's fucking weird because if anybody should have I should have I mean I did cut myself once with a Stanley blade because that's because I just wanted to take some pain away somewhere else but then instead and it worked but then I thought fuck it out and we'd do that again have you ever had therapy or anything? no I'm trying to it's one of my biggest wishes to have therapy because I'd say I must be nuts I can't be right what a fucking nut Peter my ex-boyfriend who was bipolar I said to him listen you're fucking nutty I said you're this crazy he said you're nut here than me so we're coming from a summit that's got bipolar that's for anybody watching to reach out I can tell you're a gentle man I can tell you're a sweet guy but I also can tell it people don't see it but I'm talking to you if I didn't talk to you about this you wouldn't know you wouldn't know you're like everybody does do you think that's a tactic you have though? no it's not even a tactic just me, listen I have no tactics when I'm speaking to you now and when I'm on that podcast there when I posted that thing that's gone viral no tactics the thing with me is I always speak from the heart and when I talk I speak from the heart and that's the only way I can do it and that's why any situation I'm in any situation I'm in I will hold myself properly if I'm outnumbered 10 to 1 I'm still going to go down like a man if in prison when the officers want me to do something the consequences is not good you do I do and I accept the consequences so now my integrity comes first I'm not a bully I don't want to intimidate anybody I don't want to hurt anybody in fact I want to be friends I always made friends so I could feel loved that's because I didn't get any love anywhere else and I was very popular in school and I'm still very popular as a person everybody seems to warm by my personality because nobody knows that side of me and you because you want to hear the story if you met me you wouldn't know these stories when are you at your happiest well happy is a word I'm not sure if I know the feeling I've had happy moments some great happy moments when I go to Thailand wow happy time Ibiza I lived in Ibiza happy time Norway happy time when I'm in love happy times I've had happy moments happy times my life hasn't been happy someone sent me a message the other day and they said to me even your grief is love I'm all about love it's the truth it's known so happy is something I'm not sure if I'm going to get ever be happy but I'm happy to live I know my life hasn't been great but it's not been so bad that I don't want to live does that make sense? so happy I'm not sure if I'm going to be statically happy because you know how can I be because my childhood was taken away from me there was no childhood so how can I be happy because that's supposed to be the best time of your life why did you go to Norway? because he's Norwegian oh you went for a man? no yeah of course I go anyway for love I can go to Mars if you're a Martian and you're good looking I'm leaving in Mars with you me and you in a tent because I want to be loved I want someone to love me I've been single now for seven years and it's hard for me it's really terrible and I wish I could find somebody but it's hard do you have much family around you know? no I don't have family do I I have three brothers but they're not great well they're terrible they're not great they're terrible we don't get on but I think the reason because I worked out the other day when we were in care they had to turn their emotions to survive with me I'm highly sensitive that's not an option I can't do it I can't turn off my emotions it's not possible I can't do it because I'm emotional so they forgot to turn their emotions back on and so when I see them they're like cold fish and sometimes I cry in front of them they look at me like fix up man fix yourself up you know and that hurts me because they should know how did you feel when your dad passed? well I tried to avoid it in fact because he wanted me to come I think he wanted me to come these last few days I said no my older brother said no I said listen I've gone already made up with that Christmas if you think I'm going to traumatise myself more and watch him die when I don't need to why would I do that? we parted I don't owe anything to him I don't know if I call to him so if he's going to die now he can die knowing that he's met me and I'm at peace with him but I'm not going to watch him die then walk away and be traumatised and have a scar in my body I'm not going to do that to myself so now because I'm sensitive I have to guard myself from situations like that if I'm watching a horror film now I don't even watch a horror film because I don't want that horror in my head I'm walking the street and I hear loud noises people talking loud I don't want any noise or if someone is giving me attitude which doesn't happen but if someone is giving me attitude I would just look and never look at that person again because I want to avoid any confrontation I deserve my remaining years of happiness I don't want conversation with anybody so this is what I'm trying to avoid do you sleep all day at night? and this is really weird because I shouldn't and even my exes say how is it you sleep so well with all your fucking trauma and everything you've gone through and I wondered as well so when I went to Norway to find out about my tumour they did another sleep test they wired me up with all this shit so I'm on the bed there sleeping and then I woke up and they said to me yeah but it's very weird with you I said what do you mean? they said that deep sleep is what you need to get into with you you go straight into it and I think him up there he knew he had to put that in there because otherwise I wouldn't be sleeping that's when I wouldn't be sleeping that helps with the pain I can go to sleep just like that and I sleep good but I spoke to someone a couple of weeks ago who was a bodybuilder Matt sleeps not the greatest but he says my testosterone is dropping I don't it's just that trait if there is such a thing because when it comes to God do you believe in God? I believe in the higher power it's only recently I've stopped praying when you've been praying for 60 odd years and all you get is tears what's the point? hold on I'm praying he knows I'm a good guy he knows my heart so how is it possible that these prayers have not been answered but then this happens this week and everybody is interested in me and my story and maybe this is what it's all about now I'm just saying maybe he's put me through all that to finally have something to tell people you know there's a video I made we're trying to put it on the net but it was made about two years ago and I want to do a TED talk so it's a video of me speaking for 15 minutes and hopefully we can try to put it up there if you see that video everybody who sees that video is speechless this is what I'm trying to do because I want to do a TED talk my goal is to get these books published I'm doing two books at the moment one is my autobiography and the other one is a book of letters and they both complement each other because they're both the same story but one told in letters and the other thing I want to do is a TED talk I want to go on the stage and the reason why I want to tell my story is because I've had eight friends and there's a lot of people young people committing suicide I want to let them know that we are more than our adversity I want to let them know that we can overcome it we can become something more than our pain and our tears I want them to know that suicide is never the answer because whatever you're going through we're not lost you know if I can stand up and tell my pain and my heart hurt, my sadness hold on I had no family I had no love when I left care my nose had been broken twice my jaw broken, my ribs broken I was raped, I was beaten, I had no love and look I'm here today telling you I survived this you're going through something but look what I survived so if I can do it you can hang on I don't want another young person to die like that and also childhood trauma I don't want another child to feel like I felt I don't want no child in the world in the world should feel like I felt I felt abandoned I felt worthless I felt lonely, I felt despair my whole life was no joy in my childhood I can't remember one memory that lifts me in the sky not one you wanted to read something Peter yeah well this is something because I was in the care of Haringey council and I wrote this letter and I handed it in last week and this is what I wrote excuse me I'm going to do it slowly yeah take your time reparations to Haringey council I'm writing to you asking for reparations for the many wrongs done to me while I was in your care in the 1960s to 1978 because a large number of my care was acted wolfily and with great malice towards me I am seeking compensation to offset the multitude of injustices done to me I'm also seeking an apology I feel it's important to take this step so I can gain closure and move on with my life I acknowledge 82 was one of the better homes and for 11 years it felt like a home and I felt safe but this all changed suddenly and violently which has left me traumatised to this day resulting in post-traumatic stress disorder for violently removing me from the only home ever known of 11 years I am seeking £100,000 for being traumatised for life resulting in post-traumatic stress I am seeking a further £100,000 for putting me through 25 different institutions like human cargo and in a harms way there really isn't enough money in the world that can cover what I was subjected to over nearly two decades in your care for the violence I witnessed and the violence perpetrated against me you are charged £200,000 for hearing other children scream at night £25,000 for their appalling and shameful brutality and for humiliating, terrorising, beating and scaring me shitless you will never be forgiven for the many punches and kicks that broke my nose twice and the various other wicked blows that fractured my ribs and jaw I have to tell you it was only then that I wondered how much more a young boy so could endure but being raped on my 12th birthday was the final straw and when I lost all belief and started hating myself all the money in the world can never compensate for a child living in fear for making me cry for 365 days of the year for each of my 18 years in care for a lacerated heart and wiping the smile of my face for the deep scars I carry for life and the deliberate abuse I am lost for words to describe the hell a young boy had to face the lack of care was beyond a disgrace there really is no excuse when you add it all up the true cost of my life in care was way too much for a sweet soul to bear that's released a lot of shit you know how does it make you feel ridden of that make me feel angry make me feel sad make me feel like if they were in front of me I would just line them all up now and sit them down and just give them a piece of my mind I wouldn't do anything bad to them physically but I would sit them all down for at least an hour and just tell them how they made me feel I was innocent I was young, I was a child you are my carers and that is your duty as a human being to plant seeds in me of happiness and growth and prosperity but all you did is degradation put me down treat me terrible and spit on my soul and my heart for 365 days of each year for 18 years there was no love no care, no kindness, no consideration no thoughtfulness they made me sad and today is the ripples of them of that I have to carry and live and that's why I very rarely smile I cry all the time and they shouldn't do that they shouldn't do that and that's what I would say to them how does it feel coming here and telling your story today well, to be honest with you if it was years ago I would have been nervous I would have been a little bit apprehensive but there's that thing called post-traumatic growth not post-traumatic stress post-traumatic growth which means from heartache and struggle you grow, you learn this is nothing compared to what I've been through who am I to come here and be scared who am I to be scared of talking about what happened to me I can go anywhere in the world and not be scared because I've been scared most of my life I'm traumatised from worse than this what is this? if I go on stage and do a public speaking and I fall I'm not scared because I've been worse than this so post-traumatic growth I've grown and this is nothing it's something beautiful but it doesn't scare me for over 60 years you say you've failed and all you've felt is pain and you stop praying you stop believing you gave up hope you've stopped with your faith but this week something's changed how does that make you feel can you enjoy that do you think people are up to something no, I see what it is I see it's love yesterday I'm sitting at home yeah window open 10 o'clock I hear Peter, Peter, Peter outside my house I go and look out there's two angels two ladies Peter we have some food for you come down they got a bag of food for me they gave me a little money they said we saw your TikTok we worked out where you live I said how's that because where I live in the window the buses go up and down I've got an Eiffel tower colourful with all different colours everybody looks up and says wow it's on the video three people have come to my house where I live, it's happened three days in a row Peter, Peter, Peter, people bring food and money outside my house so when I posted it it wasn't to be famous it wasn't to get a reaction so when I woke up three days later because I didn't go on it and I see the reaction I was blown away my friend said Peter over a million and a half people have seen that really? so when I leave here and go home I've got 98 parcels that open and I don't know what's in there and as I say now you've got a lot of people backing now you've got a lot of people looking to your story for inspiration does it scare you that people are then looking for answers for you? I can give nobody answers I can just tell my story and if people want to take something from there which they are doing I can give no answers to nobody I'm not a philosopher I'm not no scientist I'm not no scholar I'm a scholar of hard knocks I'm a scholar of adversity very few people will go for that kind of adversity they're so young that traumatise how did he get through that how did you get through that I can give them advice but if they want to look up to me or get something from me fine whether it's satan and the struggle just know Peter what advice would you have for them if you're struggling now you've got to find a way to deal with that struggle if it's going for a walk if it's going for a swim if it's doing some painting if it's doing meditating if it's doing crying and the only way you're going to get over that pain I'm afraid is to feel every bit of it sad is to cry is to be lonely is to be in despair because one day you'll come through it and the sun will shine so I'm afraid you know it's part of life the pain you can't have a rainbow we've had a little bit of rain and where can people get a hold of you Peter in just in case they want to get in touch ask your questions I know you've got your tech talk well well right now this is what people are saying now I would like to do what do you call it you can do open finger I may do some open on the tech talk you can speak to people I don't know what it's called yeah you can do lives I'm trying this is why I'm trying the head right I want to do because I want to give what's your name on tech talk my tech talk is Peter Woods Peter Woods one or something yeah well you can tell people yeah I'll leave it in the description yeah I would like to support in every way possible and if there's any children from the care home or have come out of the care home who are lost please contact me and I can only give you advice or give you some encouragement you know but you've seen where I come from of course it's going to be hard but I understand your journey so you talk to someone who can emphasize and who's walked in your shoes so and knowing that anybody else who's going for anything you can talk to me because I mean if I'm an expert in anything it's trauma and it's adversity and look what I've overcome and so there are ways that I've overcome it and learned and I can help the best I can it's all I can do but I would like to support as people follow me and people just just supported me in any way they can because my biggest dream is to get my books done and I'm going to do a GoFundMe page or something like that because these books need to be done not only for my purpose but they're telling a story that is very rarely told a story of children in care in their 60s and 70s and I want to tell that because I want the world to know some of it is still going on now and it really shouldn't How did you overcome it, Peter? By going through it Forgiveness Have you forgiven? Or is that too tough? I always believe you've got to forgive to heal but I've never been through that extent so I can't really give that But who am I forgiving? Your abusers the people who's left you I don't think about them but how did you overcome it? For anybody that's watched What?  No So what I'm going to think about is how can I heal or how can I distract myself so I go to the gym and I do that and now I start writing and I do that or I go for a nice long walk so I surround myself with friends or a dog or a cat which I don't have I wish I did or a bird or whatever or I go on holiday my thing is going on holiday but when I go on holiday I don't go for a week I like to go for a year Yeah You know Would you like to finish up on anything? No I have enjoyed it I hope I didn't I come over okay I don't know That's all do well Peter so it's all just down to you how you write that we have after it and doors well open but it's just down to you what ones you want to walk through Well I mean all I say is I'm looking for an opportunity to do something with what I've been through if it's helping the children or if it's the book or the podcast or I'd like to do public speaking so if anybody wants to hire me or whatever that would be wonderful for me because it would give me a it would give me a purpose and it would give me joy to go on the stage I'm not sure if I'd be good at it but I would just like to have a proper job have a proper job Yeah I never had a proper job Go for it Peter a lesson for coming on the day It's been a pleasure telling your story I've thoroughly enjoyed that I wish y'all the best for the future Go and get your dreams and keep speaking the truth My brother Thank you sir


25 miles southeast of Baghdad is an area with historical and religious significance, but the only people who get to see it are American troops. Countries all over the world have took an overwhelming interest in Middle Eastern states. In particular, Iraq has been the place of constant power struggles. Why is that? Some people may be surprised to learn that Iraq was the center of the world for thousands of years. The city of Ur was the very first true city of the world and was central to ancient activity, much like New York City is today. Ur is recorded in written history dating back 6,500 years BC and is even in the Torah Old Testament. They made many advances including mass and astronomy to name a few, and they may have even made alien contact. We know that sounds crazy guys, but what if it were true? What if we were to tell you that the power struggles in the region surrounding modern day Iraq is the direct result of the search for ancient technology? What if we were to tell you that a Stargate portal was discovered there in the 1920s and for almost a hundred years the search has been on for technology that could change the course of human history. Just wait till you guys hear this, in 2003 in direct response to the attacks in New York City, American and British troops invaded Iraq within weeks the two armies crushed the Iraqi army, mission complete right? So why did the United States Army stay for over 10 years after liberating the country? Recently we came across information that strongly suggests that there was a secret objective to the occupation. We are of course referring to the oldest known Stargate on planet Earth that we know of. At the site of the Great Zigarat a British explorer discovered something in the 1920s that is so unbelievable that you could be forgiven for thinking JK Rawling dreamed it up. During the 1980s Saddam Hussein fortified the ancient complex in an apparent attempt to keep out investigators from seeing what was hidden within the complex for thousands of years. Strangely Hussein put an air force base at this location and even developed chemical weapons here. He was clearly trying to keep this ancient place heavily guarded. The three huge staircases you see in the images were put here under Saddam Hussein's orders. They were to take huge ancient objects out of the Great Zigarat but did he succeed? The theory that we are suggesting is that Saddam Hussein got his hands on super weapons from a forgotten age which resulted on a preemptive strike from the U.S. and her allies but why did he not use the technology? Maybe it was undecipherable, maybe it was alien language, maybe cuneiform is in fact an alien language. Imagine this scenario, the U.S. government obtains intelligence that hidden somewhere in central Iraq is an actual Stargate placed there by the Anunake gods of ancient Samaria a.k.a. the aliens. In this scenario when Nibro the hidden planet in our solar system is closest to Earth the Anunake will take the opportunity to travel to the Earth through this Stargate and will set up their base in Iraq and share knowledge with people of the region. The idea that the Anunake were not gods but extraterrestrials that came and bestowed technology upon the Samarians is fascinating. This tech is what made their society so advanced. Could modern Iraq be bracing itself for the same fate, hence the overwhelming agenda? Essentially more and more people are coming forward saying that they have been involved in these classified programs where these technologies are used quite regularly and that they are found all over the planet. Iraq is just one other place that they are found. The strongest available evidence for an historical ET presence in Iraq comes from cuneiform tablets directly recording the beliefs and activities of the ancient Samarians whose civilization began almost overnight. Most of these cuneiform tablets relate to stories of the Samarians interacting with their gods. Most archaeologists initially accepted that these were merely myths and attached little importance to them other than giving insight into the mytho-religious beliefs of the ancient Samarians. That viewpoint received a major challenge in 1976 when the Samarian scholar Zakariah Sitchin published the first of a series of books on his translations of thousands of Samarian tablets. Rather than treating the stories of the gods as myths that had little verifiable relevance, Sitchin's interpreted the tablets as literal descriptions of events as they occurred in the time. These modern viewpoints are emerging from the ashes of a world that was ruled by empires and dictatorships. Have we simply misinterpreted history for thousands of years? We told you the truth, maybe stranger than you would ever even consider believing. What does that tell you? What do you think of the Stargate portal at the Zikarat of Ur in Iraq? The signs are everywhere. The writing is on the wall. Thanks for watching.


All right, everybody, welcome back to theCUBE's studios in Palo Alto. We're live here at Bill Beyond, made possible by Vast in conjunction with theCUBE. I'm excited. Jeff Denworth is back. And we're going to get the customer perspective from Kevin Weiler, who's the head of infrastructure at Aquatic Capital Management. Kevin, thanks for dialing in. Welcome to theCUBE. Thanks guys, excited to be here. So tell us a little bit about Aquatic Capital Management. What's, would you guys get started? How'd you get started? Why'd you get started? Sure thing, sure thing. So Aquatic is a quantitative trading company. It started as just a QTC. And then we just filled some vowels in to make it Aquatic, but it's the former head quant at Citadel, John Graham. And he started this company with the idea of making a purely quantitative trade and having kind of a more, let's say academic sort of erudite culture. And yeah, we got started in, well, I started in 2019. I think the idea started in 2018, got slowed down ever so slightly by COVID, but kind of picked right back up and here we are.  Jeff, how did you guys meet? Oh, we had a sales team in Chicago that had worked with Kevin in the past. And we heard some rumblings about this team that was moving out of Citadel and we were just fortunate to kind of meet Kevin his nickname is Kiwi, so we call him Kiwi. And yeah, they've just been like, it took a little while to convince them that there was like a new architecture approach that made infrastructure simple. And ever since we proved that out, they've just been a great customer. So it's just awesome to have them on the stage too. And I think Kevin, or maybe I should call you Kiwi too. I think on your LinkedIn, I saw you building the world's best prediction engine, I think you called it. So explain that and what you guys are, kind of what's your mission and I'm dying to hear more about your infrastructure and how you decided to sort of take a bet on a small company at the time like vast. Yeah, sure. So my background was in prop trading which is kind of more emblematic of the trading culture in Chicago worked in that for about seven years and then had kind of a small interlude at another company and was very much sold on the cultural, I would say aspect of this particular company. It was an approach to trading that I would say I was hungry for when I was working in prop trading. The charge I would say in prop trading is just kind of keep the money machine printing as best as you possibly can. And it's just a real grind. Anything that you tried to do that was purely research driven was met with a lot of skepticism. And this company was exactly the opposite. This company is very much driven by kind of pure scientific research. And that's kind of the thesis. The thesis is that we can do a better job than anyone by applying kind of scientific computation methods. When I was working with the sales team from prior companies, we were working with products like Hadoop and we at the time were trying to build something that was very research driven. And like I said, it was met with a lot of skepticism. This is kind of what I've always wanted to do is just a pure research trade and the architecture and kind of data engineering they're in. But you asked a little bit about what we do, how does it work? We take in data, a lot of it from various sources. Market data is of course one of them, but that's not everything. And then we try to apply both, I would say very basic prediction analytics to it and all the way up to very cutting edge stuff. So it's a combination of a lot of different modeling techniques. And after we find something that we like as far as a model is concerned, we deploy it and we trade on it and then feed it back into the system and rinse and repeat. So how's it working? How's the approach working? I mean, what kind of history do you share with us? Yeah, yeah, I can't get too into the weeds on anything very specific, but I am more convinced than ever that what we're doing is sticking and working. We're expanding. So that means they're making money. Yeah, good, making money is a good thing. So you're approaching this as presumably a data problem. Explain your data strategy and I'm interested in your infrastructure. Where does vast fit and what are they enabling you to do that you couldn't do before? Yeah, we were very fortunate to kind of start with vast very early on. We needed a place to put these vasts amounts of data. Yeah, and it was really Jeff that actually sold myself and our team on this and their approach. What we have found with the sorts of data processing that we need to do, and it's a multi-step kind of data processing type problem. You begin with structured, semi-structured and unstructured data all the way across the board and then you kind of have to massage it a little bit and then you try to gain insights from it and then you get to massage it a little bit more and then you gain more insights from it and it's this kind of multi-stage approach and all along the way, you are trying things out and making mistakes and the bottleneck, often we talk in high-scale or high performance computing about whether something is CPU bound or memory bound but most of the time in my experience, you're always IO bound. That's really the big limiting factor at least in this particular space. And so any platform that you can leverage that allows that to go faster is going to pay off and indeed that is exactly what happened for us. We were able to move quickly not because we had the fastest CPUs, not because we had the most amount of memory but because we weren't as IO bound as we would have otherwise been. So Jeff, did you pitch this to aquatic as did you pitch your vision or did you pitch it as hey, we can store a whole lot of data and not be IO bound? The only two people that got our vision before six years into the company's history were our first two investors and subsequent to that, we just stopped talking about it because this idea of a thinking machine was just too far out there for anybody to really grok. And so when I met Kevin and his team, like really what we were talking about is a system that could be standards based which makes it easy to deploy and manage. A system that could be self managing in terms of just being like a software appliance that deploys on commodity hardware that's cheap and is always online. And they were the researchers, right? So they always trying to solve different problems using a collection of tools at their disposal and we were up against open source infrastructure that they were trying to couple together. And open source, the whole world's benefited from it. So the key in our case is not to say, well, that's just not the right approach but just to explain what we can do better. And obviously we were successful with these guys. So can you talk about how you're using AI, Kevin, even generally and I don't know how much you dug in to the vast announcements today but I'm curious as to how you see it affecting your infrastructure and your business going forward. Yeah, so whether you, AI is a very kind of general purpose term to look at a lot of different techniques and you can absolutely apply it to many of the things that we do but the most important thing, and I kind of brought this up a second ago is just iteration time. If you're training a model and you're using AI to do that, the most important thing is to be able to do it over and over and over and over again. Or it's not the most important thing but it's one of the big limiting factors. And so you need to kind of throw a lot of stuff against the wall and see what sticks. And the only way to do that is just to have very, very tight iteration. And so that was the kind of obvious value add as far as vast was concerned right off the bat. I mean, we evaluated several platforms. Like Jeff said, we're evaluating, I have a high degree of confidence in my team and their ability to build just about anything. But as one of the members of my team likes to say these things that you can cobble together from open source technologies require a lot of care and feeding and vast does not require that sort of care. Free like a puppy, as they say. Yeah, yeah, that's exactly right. Yeah, free not as in free beer, but as in the free puppy, yeah. And so, could we have built something that moved as fast as the vast platform did right out of the box? I mean, I think if you gave us enough time, probably, but we didn't have time for that in the beginning. We didn't have DNS and email, like really basic things. And so, it seems like a pretty cut and dry case of like this thing will do what we needed to do without us having to mess with it really at all. But then as time has gone on and, I know Jeff kind of, or maybe it was Andy talked about this a little bit earlier, vast has been very good about taking customer feedback or maybe it was, anyway, whatever. The ability for us to move really, really hard on their system and break it in ways that maybe they didn't entirely expect and be really glad about hearing that is a huge value add for us. You know, there are specific features in the vast platform that we requested.  I know that. You're our favorite. Yeah, of course. Don't tell the others, don't tell anybody else. Yeah, yeah, yeah, absolutely. So yeah, I think that's been a huge part of the story too is, it's an extremely collaborative engagement. In fact, I think we've also, we've given you some of our internal tooling as well and you've been able to feed that back into your own platform. Sure. So I had a couple of questions. So what did they break? Oh, I don't even remember. That was like three years ago. Do you remember, Kevin? So it is, researchers have a tendency to use computational systems in interesting ways that you didn't expect them to. And one of the things that has come up in the past is just this idea of creating lots of tiny, teeny, tiny little files. And instead of shying away from that problem, which is a classic problem in storage, the small file problem is a classic problem in storage, Vasli into it and said, yeah, whatever, go ahead, create lots of teeny, tiny small files and deliver the ability to do that. But it's not only that, right? As Aquatic's business has evolved, as they're building these prediction systems, the more different multivariant data sources that they can assemble, the more accurate their models can become. So what we see is all sorts of different types of data now flowing into the system. And the key is like, how do you synthesize it together? How do you build the infrastructure that can kind of put this all together in one complete picture? Yeah, it's often the case, I would say that you architect a system for a particular pool of data and the data has certain characteristics. Like I said, it could be lots of small files, it could be lots of large files, that's just one axis that you might be optimizing against. And what we have found is that you just don't really need to worry about that with Vasli. You can just throw a new data set at it and the system will behave in a performant way, exactly the way that you would hope it might. We had cobbled together our own system, I can assure you that would not be the case. And files are one dimension of it, right? And so Aquatic's also early days working with us on the Vas database. And I went and visited Kevin and his team a few months ago, and I remember we were in the middle of a meeting and as we were explaining this new transactional analytical concept, like rolled into one system that's also his distributed file and object storage system, he just started like fist pumping like Arsenio. It's like, that's the first time I've seen an Arsenio fist pump in a long time. Yeah, it was perhaps showing my age a little bit, but also I have a lot of experience with these kind of SQL query engines. And it was very promising to see Jeff and his team speak in an informed way on some of the kind of deeper aspects of those. Like, for example, Prada could push down on Parquet files. This is something that the Vas data platform at least advertises to do kind of out of the box and without you having to think too much about it. I can assure you that architecting that yourself is a very subtle and nuanced problem. And having a platform kind of, again, take care of that for you in the same way that you would hope that it would take care of your, just basic storage needs, it's a huge value add. We've been writing actually last, George Gilbert and I for the last several months now about the future of data platforms. We've been using Uber as an example, who they've in 2015 wrote this extremely complicated system so that we can put together people, places and things in real time. And so to your point, Kevin, not everybody has the resources of an Uber. So you guys are trying to build that horizontal infrastructure. Kevin, what was your aha moment with Vast? Was it sort of when they showed you the data engine and the database, was it before that when they were sort of breaking bio boundaries? I'd say there's a couple of things. I mean, the first thing very early on is, I was, and I think, I don't remember who it was earlier in the presentation talked about this, but I kind of worked as a data engineer during a time when the philosophy was bring your compute to your data. And Vast came along and was sort of like, nah, don't worry about that. And that was a really big deal. It's like, we have these extremely fast networks. You just don't really need to worry about doing that. That was a huge aha moment for me. But then more recently, this idea of not having kind of file storage and database storage be separate and having it kind of scale in a way that kind of makes sense was sort of just the next iteration of that for me. What did that do for your business? I mean, specifically, is just get other things. Yeah, yeah, I mean, I guess that it's allowing us to examine the possibility of having one view of our data or sorry, one place to put our data, but multiple views. So the original Vast platform, you have object storage and NFS style storage. Okay, now we're just adding another one, which is database. Why is that a big deal for us? Researchers like SQL, that's how they think. It's how a lot of people that work in this space think. And you can express things in a sort of declarative way that's more sensible for the problems that you might be trying to solve. Instead of giving a prescription about how to manipulate data, you're telling the system, here's what I want back. This is what I wanna see. That's a very powerful tool for a researcher. And that's what I'm most excited about kind of going forward is putting these tools in the hands of researchers and seeing what interesting things they do that light the entire system on fire. And that's a common theme we see with a lot of organizations, right? If I take object storage or file storage as an example, in the research space, what you have is a bunch of cheap customers, no offense Kiwi, that ultimately would use a database if you had something that was infinitely scalable and supported the needs of incoming streams and also didn't cost you a king's ransom, right? And so what we're now doing is we're realizing that people that have been building their data into these like specific data containers, like everything from parquet to HDF-5, weather codes, oil and gas discovery codes, all sorts of like physics codes, like all these different codes where people create these constructs and dump everything into file systems or object storage. So why wouldn't you just arrange this in an exabyte scale database? Customers like, well, what's the interface? We say it's a SQL, well, what's the downside? Where can I get one? Right, that's the problem, right? That's right. Was your aha moment before or after you started the company? So I, you know, Renin originally pitched me on the idea of Vast when he was trying to get me to come and he said, well, you know, we're building an interesting storage platform and I told him, absolutely not. I'm not interested in this at all. You ran, you didn't walk, you ran. We ended up closing over a handshake where he finalized basically a five-part progression of the product that he was thinking about that ultimately ended up in what, at the time we were talking about is that we actually had the deal that I kind of engaged and said, okay, I'm in. We were just talking about thinking machines for the rest of the night and it just felt so natural. So that's why I'm here and that's the vision that I want to help bring to the world. Very cool. Well, Kevin, thanks for zooming in from Chicago. Thanks Kiwi. Thanks for your time. Thanks, I appreciate it. Thanks guys. All right, and thank you for watching. Next up, PowerPlay, the power panel with the analysts. We've got Rob Streche and Sanjeev Mohan. So keep it right there, John Furrier will be back. This is Dave Vellante, you're watching Build Beyond, live on theCUBE Studios in Palo Alto.