Hey guys, welcome to SSNETech, so till this side and this is continuation of Power BI project. So today we are going to see one more real time project which is related to the Power BI dataset refresh history. For example, if we design any report inside the Power BI desktop, after that we need to do the publish. So once we publish then all those reports will be available inside the Power BI service. And inside the Power BI service either we need to do the scheduled refresh of those reports and those could be on the timely basis. For example, some of those reports may be going to refresh on the weekly basis or the monthly basis may be on the daily basis or the early basis. Here we are having the dataset which is containing all the reports those are available inside the Power BI service and along with the refresh status. Here we could check like how many reports got failed while refreshing and how many got succeed. And I will record a separate session how you can download this dataset from your publish reports inside the Power BI service. So let's get started. So in this report mainly we are having four slicers, first for the time period, second for the workspace from where we are getting the report, third for the dataset and fourth for the report name. So these slicers could be used to filter out the data. Now in the left top side you could see we are having Power BI dataset report in this text box. And below that we are having this text box with the report failed while last run. So it is indicating on this seven days period. So in the last run total seven reports got failed. Four times capacity planning dashboard got failed and rest of these only one times. So that information we can get it from here directly. So here you could see report failed count in last seven days because in the time period we have selected for last seven days. So total report got failed is 40. In this visualization you could see on the date basis. So for example in this date you could see total report got failed which is 24 on the 19th of July and in this failed count by report. So on the report basis we can get it like from last seven days how many report dataset got failed while refreshing. So eight times of this capacity planning dashboard and rest you can see all those counts. So these counts would be 40 as you can see right here. So the detailed information of this available right here. And below that you could see the dataset name then what is the start date and end date of the refresh. Then what is the status then what was the runtime then what is the refresh type. So here it is the scheduled refresh that you could see what is the owner of that report and in this so failed report day hour and slot wise. So basically here you could see the daily basis we are having the report count. If we are going to right click on any one of this chart and go to on the drill down. So here that will be going to have the information on the early basis for that particular day which is 19. So that information that you could see from here. Now we can right click on this and drill upside and below that you could see the average runtime in minute. So this is in the red and this is in the yellow and this is in the green color because this report is going to take very less time while refreshing. And these reports are going to take too much time while refreshing. Now go to on the dataset and we can look into that. So basically we are having this main dataset which is Power BI Refresh dataset. So let me open that. So here we are having the ID then the refresh type which is scheduled. What was the start date then end time after that you can see this service exception. We can ignore that column then what is the status that is completed. And going forward we can see the request ID then from which work space we are getting that report and what is the dataset ID. So that information we can get it directly from here and what is the name of the report that is also available right here. Let me close that and here we are having the work space related information. And then we are having this Power BI report related information and dataset related information. So I am not going to open all these. Let me open only one of these. So let me open this Power BI Workspace. So inside the Power BI Workspace we are having this name then ID then what is the value of that workspace that is read only. So after that we can see other columns like capacity ID description and other columns but those are not required. So we can ignore only the ID and name will be going to use while checking the workspace. Let me close that go to on the Power BI Desktop. So let's get started and how we can get the data from the source and after that how we can design this beautiful dashboard. So here we are having this blank Power BI Desktop. So first we want to get the data so we can directly click on the Excel. Actually this data was available inside the SQL but for the training purpose I have put that data inside the Excel. So we are required to have this Power BI Refresh dataset. We can open that it will take few seconds we can wait. Now we can select the seat one because all the data is available on the seat one only. So here we can see we are having the ID, schedule type, start time all the columns those we were seen. Now we can directly click on load. So here this is loaded successfully. We can rename this seat one name with the Power BI Refresh. Now let me try to get another data source which is for the second file for the Power BI report. We can click on open. We can select seat one. Now we can click on load. So that is loaded successfully. Now let me try to rename this with the Power BI reports. Now go to on the data view and we can check the data. So for this Power BI Refresh everything looks good and inside the Power BI reports we can see the column names those are not the correct one. So for that we need to go on the query editor mode and where the first row should be the column names. Now we can go on the transform data. So we can click on here and in this go to on the Power BI report. Here we could see the first row that should be the column name. So here you could see use first row as header. So we can click on that. So it will jump over there and now we can close and apply. So this chain should be applied and available inside the Power BI desktop. Go to on visualization mode and here go to on the existing one. So that we could see we are having this image. So I am going to copy this image directly from here and trying to paste that image right there. So that you could see let me try to adjust this a little bit. So we can make it a little bit smaller and put it right there. Now it looks good. Now first thing that we need to use the text box. So let me go here and I am not going to take too much time to do the formatting on all these. Let me try to directly copy this and paste that over there. We need to create the calculated columns on the Power BI refresh data set. So go to on the data view and here the first thing that you could see inside the start date and end date. So go to on the Power BI refresh first and here the start time you could see an end time. So by using this start time and end time we want to calculate the completion time. So for that let me add a new column by clicking over here and we need to write the DAX formula for the same. And here let me try to call this column as completion time. Now inside the formula we need to subtract with the start date of this table minus end date from this table. And we can directly put the enter and let me try to change the data type of this as time only. So that we could see over here and next we want to check the last executed status. So what it means we need to check for the particular data set what was the last execution according to the time. So that we need to calculate. So for that I want to have one more column where we will be going to have only two status for that particular data set 0 and 1. Next we want to calculate the last execution. So we can do that we will see in a bit as of now we need to concentrate what it means. So basically we need to pick one data set and on that particular data set we need to check when the last time it was refreshed. That particular value will be 1 otherwise we need to have the value as 0. So that we want to achieve by using the last status. Let me try to add one more column on this table and let me call this column as last execution status. Here first I want to declare a variable and on that particular variable we want to check the current data set. Now let me try to expand this little bit here on the current data set we can directly get the data set ID. Next we want to return and here we need to write the formula that you need to concentrate. First I want to check if that value is last execution or not. So how we can check that? So let me try to use the calculate function and inside the calculate function we want to have the max ID from this table. Now put comma so here we want to get the max ID of this particular C data set. So here we need to do the filter on this refresh data set. Let me put comma and inside the expression what we need to do? We need to check if the data set ID is equal to current data set. Now close the bracket. Now let me put comma and we will have one more filter on this particular refresh now put comma. Here we need to check the status. So the status of this that should not be equals to unknown because we are also having the status with this unknown. Now let me close the bracket. So here we are going to get the maximum ID of the selected data set. If that value is equals to the ID then we want to return as one otherwise zero and let me close the bracket and put enter. Here we need to close a return as well. Now let me put enter. So this is very straightforward formula. First we are going to get the data set of the current row and after that we are checking the max ID of that particular data set from overall table. If that value is equals to the current data set value then we are going to return one otherwise zero. So here in this column you could see the value of the zero and one only the second thing that you need to focus like the end time. So somewhere the end time value will be the blank that you could see directly here. So I want to have one more column that will be going to have the value for the time and that time value will be like the current date for the three days then seven days then 15 days like that in the filter that you have the time period. Now go to the training one and here let me try to add one more column and let me call this column as time. This is the time. Now and here let me add a variable and let me call this variable as x equals to here we want to get the date if and the difference that we want to calculate with the end date and the current date. So for that we will be like end date is here and for the current date either we can use the now or we can have one more column for the current date. But here I am going to use as now and we want to get the difference on the hours only. Let me close the bracket. So here we are going to get the difference when last was executed and the today's date. Now we want to use the return keyword. Now here first we want to check if the value of this x is less than or equals to 24. It means this is the current date. So you could say like current date put comma and let me check for the second value if x is less or equals to 72. It means it is for the three days. Let me put comma and check for the another value if x value is less or equals to 168. It means this is for the seven days. Now let me put comma and we will use one more if condition if x value is less or equals to 720. It means this is for the 15 days. Now let me put comma and check one more condition that is x value should be less or equals to for the 15 it should not be 720 it should be 360. And for the 30 days that should be 720. Let me put comma and it should be 30 days. And on the else part we want to have like all. Now let me close all these if conditions along with the return. Let me put it here. Now we can see here we are having the problem with the data type. So let me check on this. So this 72 should not be inside the single code other than everything looks good. So that you could see the values. So now this part is done. Now I want to have one more column that will be going to indicate the status. So the status if that is the field then 0 if the completion then 2 otherwise we want to return as 1. So let me add one more column on this table and where we will be going to use the DAX formula simply with the if condition. And this will be going to have the status icon. Here we need to check if the status is equals to field. Then we want to return as 0 if status that is completed then 2 otherwise 1 we can close the bracket and put enter. So this will be going to use inside the icon in the table. I will show you later. So 0, 1, 2 that we are having right here. Next I want to have one more column that will be the Rs. So Rs of the start date that will be going to use later on this dashboard. But here let me add that column and for that particular let me call this as Rs. And we want to extract the Rs from the start time. Now we can close the bracket and put enter. So this will be going to return the integer value in the Rs. But we want to see the complete time Rs second like that. So how we can do that? So for that I would suggest we can use the concatenate function. The first test will be like that. And second test we can add like this and we can close the bracket and put enter. So this will be going to have the Rs like this and we can convert this data type as time. So you can click on OK. Now it looks good. So now we are OK with this. Now go to on the visualization view. First I want to add this report field while last one. So let me try to copy this rectangle directly from here and go to on the training one and put it there. So it will save time and we can set it right there. Now go to on the existing one and second I just want to copy the text which is written right here and copy that and go to the training one and paste it there. Now we can scroll it little bit on the top side. So these two rectangles we have completed. Now go to on the existing one and the text that we can see let me copy this text box and paste it here. Let me scroll it little bit. So now everything looks good. Now go to on the existing one. So here the first thing that you could see the total failed report while last run. So for that we need to create one measure. So let me add a measure and on that particular measure we need to calculate. So go to on the modeling and here we need to click on the new measure and that measure will be going to calculate the count of the report while failed on the last run. So we have to wait few seconds. Let me call this failed in last run. Let me maximize this and here first we need to check calculate counting the rows. So we can use the count rows formula and table that is power bear refresh and we can close the bracket then put comma. First we need to do the filter of the execution status that we had created a new column on the power bear refresh table. So that is the execution status if that value is equals to 1. It means we are filtering for the last execution. Second filter we want to check for the status that should be the failed status. So here we have the status that is failed. If that value is blank then we want to return 0. Otherwise we will be going to use the same formula for the calculating of this. So we can paste it there and close the bracket for the if and let me put enter. So this is very straightforward formula. So here first we are checking if the value of the last execution is failed. Then we are counting the rows if that is blank then returning 0. Otherwise 1 we can go here. Let me add a card so we can directly click on the card and we can put like that like this and put it here. And let me try to drag and drop this last execution right here. So that is 80 now go to on the format of this and here in the background we can off and in the data level we can have this as white. So that we could see 80. Next we are going to check about the failed count by report. So for that let me try to complete this rectangle from here and let me try to paste it right there and we can set this like that. Now go to on the existing one and here we are having a text box that containing like the failed count by report. So let me try to complete this and paste it there like this and we can adjust this a little bit and inside the rectangle we can also decrease like that. Now go to on the existing one and here basically we are having this horizontal bar chart. So this horizontal bar chart is not available directly on this visualization pane. So for that we can get it from the marketplace. So how we can get it so for that we should have login with your credentials and after that you can directly click on this marketplace. And here you can search for the bar chart. So the first that you should see the horizontal bar chart so you can directly add I have already added that so I'm not going to add that again. Now go to on the existing one. So here first you could see we are having the report name and after that the failed count by report. So here what we need to do we need to add one more measure that will be going to contain how many failed reports we have. So go to on the modeling click on the new measure. Let me call this measure as report failed. And here we need to use the calculate again with the count rows and we want to count the rows from this power by refresh. And in the filter we want to filter the status from this power by refresh with the field only. So that we can do close the bracket close the bracket and put it now. And try to click on this horizontal bar chart and after that we can put this below of that failed count by report like that and increase this. Now here inside the power by refresh data set we are having the name so we can drag and drop name inside the category and inside the measure the new measure that we have created for the report failed. So that you could see right here so capacity planning dashboard so it got failed on 582 times so that information we can directly check right here. I am not going to do the formatting of this that you can do on your own but on the existing one. So next we are having this failed report day hours and slot wise. So before going to do that go to on this table and we need to create this table. So for that let me copy this rectangle from here and trying to paste that rectangle right there. And here we can decrease the width of this like this and here like that. Now go to on the existing one. So here if you could see this table so this table is containing like data set then the start time and time status so such type of information it is having. So now go to on the new one and here let me try to add a visual that is the table we can click on this table and let me try to put this above that particular rectangle. Now the first column that we have seen for the name so we can directly drag and drop this name inside the value. Second is the start date so here we are having the start time mainly so we can drag and drop the start time and it should have the value not the hierarchy. The same thing for the end time we can do and we don't want to see the hierarchy that should be a particular value. Next we are having the status and runtime so here we could see the status so we can drag and drop the status below that. And inside the runtime that is the completion time mainly so we can drag and drop the completion time. Next we can see the refresh type and owner so here we need to add two more columns first is the refresh type so here we should have the refresh type. So first we need to select the table and after that we can drag and drop this refresh type on this values. The last column that is the owner so owner information is not available on this particular data set so owner information is available inside the Power BI data set. So here in this source you could see by using this workspace ID or ID we can get the owner. So let me grab this inside the Power BI desktop and let me click on open we need to wait few seconds it is connecting. Now we can click on the seat one and after that we can directly click on the load so we need to wait few seconds until this will not be loaded successfully. So it is loaded successfully now so we need to get the owner name from this seat one. So we can rename this seat one as Power BI data set info and let me drag and drop this owner to the values. So this visual is not having anything because inside the relationship we do not have any relationship between this data set along with this Power BI refresh. So that we need to make. So here we are having the ID and here we should have the data set ID so we can map with the data set ID along with the ID between Power BI data set and Power BI refresh. So it looks good one too many relationship has been created. Now go to on the visualization and now we are having all the values as per our expectation. Now everything looks good. Now go to on the next visualization. Here again I am not going to do the formatting of this you can do on your own. Next we want to calculate the average runtime in a minute. So how we can do that? So first let me try to copy this rectangle and paste it over here. Let me try to adjust this like that. Next we want to have the text which is average runtime. Now let me try to copy this and paste it there. We can adjust this on the top side like that. Second here we are having this visualization that is directly available inside the visualization pane and which is clustered column chart. So we can drag and drop the clustered column chart in the training one. So here cluster column chart we can click and we can put above that particular rectangle and below of the average runtime. Now inside the axis we want to drag and drop the name. So here we can directly get it from the data set or from the refresh table. So let me have this from the refresh table. So this axis will be going to contain the name. And after that average runtime in the minute. So for that again we need to create one more measure. So we can click on the new measure. Let me call this measure as average runtime. So this is average runtime. And here first we want to calculate the average. So average of the completion time that we have created a new column. Here we want to see this in the minutes. So we can use the minute formula. Now let me click on enter on this. So that measure is available right there. But it is having the error because we need to use the complete minute name. Now let me click on enter. After selecting this visualization we can drag and drop inside the witness. Now we can wait few seconds. So here we can see the values of this. So the formatting part you can do. I have already explained the formatting in multiple previous videos. So here we can go on the format and we can do the custom format of this color. So that you can do on your own. Now go to on the next visualization. So here we could see we are having this report failed count in last seven days. So what it means let me click on that. Let me copy this and paste it there. If we are going to adjust this and after that let me adjust this as well like that. So now before going to add this text let me add all these slices. Those are available on the top side. So first is the time period. So for the time period we have created a calculated column. So that is for the time. So here let me find the time inside the Power BI refresh. So we can drag and drop this time inside the fields. So here you could see the value. Let me use this as drop down and put it on the top side. You can do the formatting on your own. So if you are going to select this as 15 days then this should be going to refresh. If 30 days then that should be going to refresh accordingly. If seven days if all if current date. Now here we can see this dynamic text. So it is having like report failed count in last 15 days or 20 days or what was the selected value that we have. So for this we need to create one more measure. So go to on the modeling and click on the new measure. We need to wait a few seconds. Let me call this as dynamic text. So this will have like dynamic text. Now here we need to use the concatenate and inside the concatenate first report failed count in last. In the second text we need to use the selected value. And inside the selected value we need to use the particular time that we had for a refresh data set as time. We can close the bracket again close the bracket and put in there. So this dynamic test should be going to use on that particular header side. So let me try to copy this and let me paste it here. As of now it is going to reflect an error. Now let me try to put this on the top side. And here let me remove that and drag and drop this dynamic text. So it is having a value like that. If we are going to select 15 so last 15 days if it is 30 then 30 days. If we select all then that should be all. So now it looks good. We can do little bit decrease the size. Here first we need to display the total count so that we can do like we can add a card directly over here. And we can decrease the size of that particular card and put it right here. And after that here we have created one measure that measure is going to have the total field. So this is the report we can drag and drop it here. So this is the total field. So the count that is 4358. Let me have for 15 days only. So this count is 176. Now we can decrease the size and we can adjust this like so that you can do on your own. Next we need to use a line chart and on that particular line chart we can add the days along with this count. So that we can decrease the size put it on the left side of this. And in the axis we want to have the date. So here we have the start date so we can drag and drop it here. And after that inside the value that should be the report field. So that we could see seems very less in the size. So this should be like that. You can do the formatting. So after that it will be going to looks good. Now go to on the new one. So here basically you can see the field report days are slot wise. So this particular visualization which is the stack column chart. So inside the stack column chart we are having the count and in the lesion we are having the names. So that information we are having. But let me try to copy this and go to on the training one and paste it here. Let me adjust this like that. After that let me have the stack column chart. Let me put right there right here. Now we have the failed report day hours and slot wise. So that text we can copy from here and paste it there. And we can adjust this and inside the visualization we can adjust this as well. Now go to on the field side. Inside the lesion we want to see the names and inside the values we want to see the report field and inside the axis we want to see the date start. So that is available right here. That is the start date. And after that we can have this as start date. And after that we want to see in the hours so that we can have like that. So this visualization is not looking very good. But while we are going to select only for 15 days or only for the 7 days. So that will be going to have more sense. Now the last thing is remaining which is report failed while last run. So here we should have horizontal bar chart. And let me try to adjust this. Now inside the categories we want to drag and drop the name. And inside the measure we need to drag and drop the last execution that we have created. So last execution status that we could see. And inside the filters we can add the filters. Those are available like workspace data set and report that you can do on your own. If you have still doubt any part of this visualization or in this dashboard. Then you can drop your comment in the comment box and I will try to response over there. And if you need the data set of this dashboard then I will provide a link on the description of that video. So you can directly click on that particular link and you can download the source. And after that you can create this beautiful dashboard on your own. And in the other video I will record a separate session where I will show you how we can download the source data that is available over here for your organization. So thank you so much for watching this video. If you like this video please subscribe our channel to get many more videos. Don't forget to press the bell icon to get the notification of our newly uploaded videos. See you in the next video.


You have been asking about diabetic medications because most of you are on one or more diabetic medications And yet 90% of you do not know how they work, the benefits, the risks, etc. Hi, I am Dr. Ahmad Ergin. I specialize in endocrinology, diabetes and metabolism. I practice in Florida But I'm passionate enough to help everyone in the world who struggle with diabetes and weight problems After you leave the doctor's office Sometimes you are more confused than ever before because your doctor just threw two new diabetic medications Which could be pills or even injections. First reaction most people have is anxiety, fear and that leads to frantic Google search and Absorbing anything and everything without questioning their validity. Half of the time information is above your head And you end up being more confused or scared. No more This video will tell you everything you need to know about every diabetic medication Watch the entire video so that you know all of your options thoroughly Yes, this is a long video due to all the content that we need to cover But don't worry, I created chapters for you So you can click to jump to a medication class or section that is more of an interest to you But watching the entire video will make you understand the entire diabetes treatment spectrum So if you have time stick with the entire video Let's start with metformin because this is the most commonly prescribed medication worldwide I have many metformin videos So please refer to them for in-depth or specific issues about metformin Today, I will only summarize what it does the benefits and risks of metformin Now metformin is one of the most well-established and successful treatment for time-to-diametries It has the effect of lowering the quantity of glucose in your blood You can tell by your finger sticks your blood sugar numbers It accomplishes this by decreasing the amount of glucose released by your liver and Decreasing the amount of glucose absorbed by your intestines from the food you eat, right? Metformin is also thought to improve your body's response to its own insulin Now metformin is beneficial for almost everyone who has type 2 diabetes It is also a smart option if you're overweight because metformin does not promote weight gain like other diabetic medications or some other diabetic medications Now the efficiency with which it operates is that it reduces the hemoglobin A1c by around 1.5% which is quite significant Now let's talk about the risks or the side effects of metformin That is the thing that sometimes you don't want to hear, right? Well in a lot of cases metformin might cause quite a bit of stomach irritation, can cause diarrhea, bloating, abdominal pain Not so much fun It is possible that you will require a lower dose if you are suffering from kidney difficulties Now some brand names that have metformin in it are Glucophage, GlucophagexR, Rheomet, Fortometh, Glumezza These are some of the branded medications But most people are on generic medications for metformin Metformin was found to lower the risk of death as well in a study of adults with type 2 diabetes Which is good news So overall it is not a bad medication unless you have chronic kidney disease then you have to be careful Now on the other side of the coin There is a natural component called dehydra berberine that works just like metformin That can be used with or without metformin And when used with metformin it actually increases the effect of the metformin As a reminder, our super berberine product has dehydra berberine in it and saline cinnamon at a high concentration So it is a great addition to your metformin or an alternative to metformin if you cannot tolerate metformin at all Next is one of the most popular diabetic medicines so far But my least favorite, Sulfonylureas or megalithonides These medications are like Amaryl or known as Glymopryde Gullicotrol also known as Glypozide, Glynase or Glyboride, the other name Are examples of Sulfonylureas Now the primedin is the generic name Rhepegulonide and starlix is Nathegulonide Are also examples of megalithonides which work similar to Sulfonylureas but they are a little shorter acting After taking these medications, the Sulfonylureas and megalithonides, your pancreas produces more insulin Which in turn lowers the level of Glycozine in your blood Now the problem with them is that they constantly stimulate your pancreas to make insulin Without taking a break, which ends up killing your beta cells Wouldn't you die if you worked 25 hours without taking rest or sleep? These drugs may be beneficial for people using metformin Who cannot afford any other medications or supplements And are not concerned about the possibility of gaining weight and severe low blood sugars I mean it is better than nothing but in my opinion these meds are at the bottom of my preferred medications I said it is better than nothing because just because you cannot afford anything Does not mean that you need to let it go and drop everything and let your blood sugars run high Because high blood sugar as you know can cause much worse diabetes complications So if that is the only thing you can afford, please stick to it But it is good to know your options So that's why we will keep talking about other diabetic medications Tyazolidin deons, a mouthful name right? Well the only medication left in this group is actually Pyoglutazone Also known as octos because the rest of them were banned by the FDA either permanently or temporarily For example Rosiglutazone in 2010 the most widely prescribed medication in this family The other name is called Avandia was linked to an elevated risk of heart attack and stroke Which severely damaged the safety reputation of Tyazolidin deons overall Nowadays its cousin Pyoglutazone also known as octos is still in the market These drugs lower the level of glucose in your blood by slowing down the amount of glucose Produced by your liver and by assisting your body in responding more effectively to its own insulin Tyazolidin deons or Pyoglutazone in this case particularly beneficial for those who are suffering from insulin resistance They have the potential to reduce Avansi by around 1 percent Which is less than metformin but works in a similar way to metformin and it can be an alternative to metformin Now the biggest problem with these medications the Pyoglutazone especially our fluid retention and possible worsening of heart failure If you already have heart failure And increased risk of bone fractures, especially if used longer than two years There are possible but not confirmed risk of bladder cancer as well FDA has warnings about these that you can find on FDA's website Now our sugar MD super berberine and advanced glucose support are designed to help your body become more insulin sensitive And only produce insulin when you eat which works similar to DPP for inhibitors and glp1 agonists that I will be talking about next And yes, you can take sugar MD super berberine and advanced glucose support together to get the maximum results Our supplements also do not interact with other medications since they are made with natural food ingredients That do not interfere with medications now inhibitors of DPP for And these drugs is a group like some of you are on it like genuvia or known as stagliptin or Tragenta The generic name is lanagliptin or alloglyptin which is the only real generic one in this group They are okay drugs, but they're less effective than most The only advantage to them is that they do not cause low blood sugar unless you also take sulfonylurea that we discussed Or the insulin along with these medications these drugs work by preventing the breakdown of a certain hormone called glp1 or glucagon like peptide 1 So glp1 hormones are like postal service They're producing the intestines and informs your pancreas that there is food and blood sugar is rising So maintaining a higher level of glp1 in the bloodstream allows the body or your pancreas to make more insulin While also slowing the release of glucose from the liver now an important note that these medications are not near as strong Compared to real glp1 agonists, which are synthetic and stronger version of the dpp4 inhibitors And this is similar to what your body naturally produces Now normally increased glp1 levels also help with the weight reduction and reduction in your appetite and slows rate of your stomach Ampidine which keeps you full or longer and they're all beneficial for weight loss However dpp4 inhibitors like genuvia or Tragenta They're not strong enough to produce the weight loss results that you get with the glp1 agonists Which we will talk in a second now dpp4 inhibitors may be beneficial for those who like a little more support with the blood sugar control But do not want the risk of gaining weight by taking the medication such as alternative to sulfonylureas So it's a fair alternative to sulfonylurea But really for mostly for frail and elderly patients who cannot tolerate glp1 agents like ozampic trilocidine Rebalsus orbitoza they have the potential to reduce the hemoglobin a1c by around 0.5 Which is very small as we compared you know as we talk about the efficacy of metformin or pyagilthazone So for the price tag they have around, you know 500 a month I'm not a big prescriber of these medications except for this small specific group of elderly and frail patients Now what are the side effects of these dpp4 inhibitors like genuvia, Tragenta, etc Well, some people experience nausea still and vomiting after taking these drugs Although they are not as strong as glp1 agents, but they also have the potential to cause inflammation of the pancreas On some very rare occasions. We call this pancreatitis It is well known that this family of drugs can actually cause joint pain too in some people And sometimes even congestion in the airway and sometimes upper respiratory infection Now fda warned and issued a warning saying that onglaiza and nesina that I didn't tell you about because I don't even prescribe them But they're also associated with increased risk of heart failure So I do not prescribe them at all and the insurance coverage is very poor. So In the united states, we don't even see people on these medications anymore. Now glp1 agonist is next Now glp1 agonist or glp1 is a hormone as we discussed and these are Trying to attempt or mimic the glp1 activity in your body These medications cause the body to produce more insulin when blood sugar levels rise following a meal Now blood sugar levels drop as a result of more insulin in the body after a meal on the other hand Beauty of these medications is that they will not continue to force your pancreas to make insulin like the sulfonylureas do And they are three times stronger than dpp4 inhibitors Some examples are ozampic, victosa, rebalsis and biterian. The disadvantage of glp1 medications is that all but one Which is rebalsis. They all must be administered to reinjection except rebalsis is the only pill in this group As with any prescription, there is a chance of adverse events some of which may be serious After you have been taking the drug for a while the more typical side effects such as Diarrhea, abdominal pain, some cramps or nausea and vomiting sometimes even headaches tend to happen But they go away in weeks or months. Now low blood sugar hypoglycemia is a risk of glp1 agents Only if you are taking sulfonylureas or insulin along with them Typically when I prescribe a glp1 agonist like ozampic I slowly start lowering the insulin or sulfonylurea pills Same thing applies to our advanced glucosupport and superbure brain. So you should watch your blood sugars And the moment your blood sugar go below 100 milligram per deciliter or 5.6 millimore per liter You should start cutting on your insulin by 10 to 20 percent and every time you see a blood sugar less than that Start taking half a tabular of sulfonylurea for example and eventually stop it again Monitoring your response to these medications or supplements is the key to prevent a low blood sugar especially due to insulin and sulfonylurea Also, if you have a personal or family history of medallary thyroid cancer or multiple endocrine neoplasia You should avoid glp1 medications. These medications have been associated to thyroid cancers in rats in laboratory research But the risk to humans is unknown until more long term studies are done So far studies do not indicate any human harm. If you have had pancreatitis these medications are also not a good idea Well, thankfully you have other pharmaceutical or herbal options Even if you cannot take glp1 agents for one or the other reason next in my list is Sglt2 inhibitors. These medications have been fairly popular Especially recently some of them are you may remember the names jarnians or farciga or stegilatro Or even in mochana they work by making your kidneys to excrete glucose into your urine Lowering the level of glucose in your blood They are popular because some studies indicated that they lower the risk of hospitalization due to heart failure And possible reduction in the risk of overall death due to cardiovascular reasons After participating in a trial involving individuals with type 2 diabetes and chronic renal disease Researchers also discovered that in mochana, jarnians, and farciga lowered the risk of Progression of chronic kidney disease to end stage kidney disease And they also lowered the risk of heart attacks Researchers found that the jarnians could lower the likelihood of dying from any cause and in that research People with type 3 diabetes, especially who had high risk for cardiovascular disease benefited the most as a result People who want to lose weight people with heart failure or history of heart attacks may benefit extra from taking SGLT2 inhibitors while also improving their blood sugar control They have the potential to reduce hemoglobin a1c by around 0.8 percent or 0.8 percent As you can see they are not the most effective diabetic medications either but you know due to extra perks Many physicians prescribe them a lot nowadays. Now, how about risks and side effects of SGLT2 inhibitors? Well, they have the potential to cause vaginal use infections That's fairly common you know retract infections in men and women as well as dehydration related symptoms Because you will be urinating way more often than before and if you do not replace the flu loss It can cause dehydration and that low blood pressure can happen Even kidney failure or acute kidney failure happen if you become dehydrated FDA also has warnings about SGLT2 inhibitors And for this class of drugs FDA has issued a number of warnings now because they have the potential to cause rare But significant problems such as acute kidney injury the acid built up in the blood Which we call ketoacidosis infections in your groin that can sometimes be severe particularly with regard to invocana It has been observed to increase the incidence of bone fractures as well And even the danger of losing a limb or increase risk of food amputations in patients who take a moccana The advantages of these medications frequently outweigh the risks associated with them So it is still worthwhile to discuss them with your healthcare professional if you are considering taking them But for example these meds won't be good for someone who already has Frequent urinary tract infections or someone with advanced kidney disease who have high risk of dehydration Or someone with history of diabetic ketoacidosis. The next on my list is alpha glucosidase inhibitors Now these medications lower the level of glucose in your blood by reducing the absorption of simple sugars By your stomach and intestinal tract some brand names are precoz, glycet But most frequently we use the generic precoz, which is acarbose if you use them at all They have the potential to reduce hemoglobin a1c by only 0.5% So yes, they are also a weak agent. What are the risks of these? Well, they have the potential to produce gas a lot of gas and bloating also due to the possibility of elevated liver enzyme function You need to get your liver enzyme tested regularly if you are taking acarbose On dopamine agonists now when I say dopamine agonists, I don't mean a dope Although name implies that sorry for the disappointment But these medications although they are weaker agents which again lower a1c by 0.5% At best they lower glucose levels in the blood through enhancing the body's reaction to its own insulin Basically improving the insulin resistance nevertheless exact mechanism is really not known which is interesting that FDA approved a medication That we don't even know how it works, but it is there So they have the potential to cause nausea as well as dizziness headaches and drowsiness Now the only medicine in this group is cycloset and it is still branded still very expensive. The coverage is poor And if you issued warnings on this medication as well because they have the potential to create low blood pressure and perhaps cause of or perhaps a loss of consciousness Next is bile acid sequesterance, which are substances that prevent the absorption of bile acid Although it is unclear again how these medications lower the amount of blood glucose in your blood We still use them. We don't know how they work, but they do lower your blood sugar somewhat Studies show that they can actually improve the blood sugar when used in conjunction with other diabetic treatments as well Which is encouraging again better than nothing when combined with other diabetes drugs They have been shown to reduce the havency by around 0.5 percent Again, not your strongest medicine now when you combine a lot of medications, although they are weak They can get you to your goal, especially along with lifestyle changes Also, they have the potential to reduce also nausea constipation and upset stomach But also when combined with some other medications, these medications can actually raise the triglyceride levels So if you already have high triglyceride in your blood, you have to be careful and keep an eye on your cholesterol level If you are taking these medications and well-cold is the most well-known medication in this group Last in my list is inhaled insulin Now I will not talk about injectable insulins in this video except this one because insulin is insulin, right? It's harder to understand and they're more complex and most insulins are tailored to specific needs of patients So I would let your doctor to handle that preferably an endocrinologist I am talking about inhaled insulin today because most people are not aware of that option My goal is to increase awareness and show you your options that may not have been presented to you before Now the only brand out there for this purpose is called afreza Most people haven't even heard about inhaled insulin But it can be a very good alternative to short acting insulins Most important features of this type of insulin is that you do not have to inject But inhale and afreza work immediately, which means that it shows up in your blood immediately While the regular injectable insulins may take up to 30 minutes to even show up and start showing any effect Afreza does not stay in your system more than three hours either Compared to five to six hours of shorter acting insulins Which can lead to low blood sugar at three to five hour mark Using an inhaler This medication is inhale insulin lowers the level of glucose in your blood pretty much immediately And it may be beneficial for people who require typically less than 12 Units or less per meal because the largest cartridge unfortunately that they come in is 12 units Although some of my patients will take like two of the 12 units back to back Or they will combine for eight and 12 unit cartridges depending on their needs I see this insulin being popular among type 1 diabetics, especially young type 1 diabetics People can see how fast it gets in their blood also Especially when they are using dexcom or libre that allows you to see a minute to minute changes in your blood sugars Problems with afreza include number one sore throat number two coughing fits Especially in the beginning while you are getting used to it FDA also issued warnings about afreza This medication should not be taken by anyone who have lung problems People who use a drug must have their lung function tested on a regular basis and at the start of the treatment Which includes breathing examinations that are fairly quick to do We do FEV1 testing in our clinic, which is a quick test if you are planning to use afreza But it can lower your lung function in time. So we sometimes you know, we not sometimes every six months We need to check your lung function now keep this in mind Due to the fact that diabetes continues to be a rising concern throughout the world There is a constant demand for new treatments to assist in blood sugar control Remember medications are not to replace lifestyle improvements But rather to support you if your lifestyle changes are not enough Also, remember there are some supplements that you can rely on and some you cannot Unfortunately supplements just like medications differ in their efficacy and potency Give a try to our advanced glucose support and super berberine and let us know how they worked for you Advanced glucose support is stronger, but super berberine can be used with it as well If you only need to lower your blood sugar 10 to 20 points I would say go for the super berberine first If your blood sugar is in the 200s or 11 millimole or more I would suggest going for advanced glucose support first and then adding super berberine if the effect is not enough Again, thank you for watching everyone I hope you are now more knowledgeable about the diabetic medications that you are taking or you are planning to take And I hope it will help you achieve diabetes control and even get you in remission Remember to check our diabetes reversal program as well If you are a motivated individual that will greatly help you to reverse your diabetes. Have a great day Hey guys, I hope you're enjoying this channel so far and I hope you subscribed already If you didn't do it and if you did watch this video right there, I think that will help you too


I'm going to talk about how to fill in a basic truth table. If you can get the rhythm down or the pattern down, it makes it much easier to when you're starting a truth table to fill in the P and Q statements correctly so you don't have to worry about that. To guarantee that you have every combination possible, P will, you'll always set it up to be P is true and true or the first statement whether it's P or some other letter. It's true, true, and then false, false. Then for the second statement, you'll always set it up true, then false, alternating, true and false. That's how you set up a basic truth table.


And I think builders today are going to be challenged obviously with interest rates. Like you said, it's a it's a cycle. But how do we get more eyes on assets? Welcome to the Smarter Building Materials Marketing Podcast, helping you find better ways to grow leads, sales, and outperform your competition. All right, everybody, welcome to Smarter Building Materials Marketing, where we believe your online presence should be your best salesperson. I am Zach Williams, alongside my co-host, Beth Mopiklav. And we are talking about the future of the builders. Specifically, what are the challenges that builders are facing today? We're not just talking about the demand in the market. We're actually talking even more macro about changes that are happening and how they sell and market their end product, the home. So I'm really excited to introduce our guest. His name is Craig Foy. He's the president of Ali VR, and he's going to help us with this conversation where we're going to turn the tables a little bit. We often talk about the pressure that is put on manufacturers and how they need to rise to the expectations of technology and digital as we go into the future. But today we're talking about builders and the expectation that their consumers have and how virtual reality and technology is getting them closer to the customer and to the sale. So Craig, I don't want to give too much away, but thank you so much for your time and welcome to the show. Sure, thank you all both. Thank you, Zach, and thank you, Beth. So Craig, before we dive in, why don't you give us a 30,000-foot view on who you are and what exactly Ali VR is and how it helps with the industry. My name is Craig Foy, and I'm the president of Ali VR. And we've really created a fun environment for product providers, home builders, multi-family, many different facets of decision-making and tried to make it where anyone on any device with no app and no software can be a contributor on the design schematics that are being looked at on any project or end user capability where normally you had to wait for an architect to do a rendering or you had to wait for your designer to get some swatches. And this really just brings to peace and quickly gets you to see your assets in application is kind of the 30,000-foot view. OK, so my question here is why is this a big issue? Because, you know, we've seen a lot of advances over the last 10 years and how people find source material, how they visualize it. We've seen things like visualizers come out. We've seen things like Pinterest, which are great tools. Why is what you're talking about something that manufacturers should be paying attention to, Craig? The top things that I see happening today is people want to see the assets in application and they want to share it with someone and collaborate and look at schematics as a team in private. They don't always have to have an architect or designer involved with pushing big GPU or CPU around to manipulate the file. So it makes it where it's really fun and relaxed for people to jump in and contribute on. I love that. I love this. And more importantly, that it can be shared so quickly. And today, with software, a lot of times you get into a very complicated process just to share a file. And then after the driver of that software is gone, then the person on the cell phone or an iPad is kind of dead in the water. So this technology kind of revolutionizes how easy you can share files with coworkers, family, friends, et cetera, and get a decision made quick on a project. So if I could take Zach's question one step further, we use visualizers. We've built visualizers. But that typically stops with the manufacturer. And sometimes manufacturers do cross branding, where if you're a paint manufacturer, you've partnered with a surface manufacturer to be able to see how the countertop looks with the backsplash, looks with the flooring, or something like that. But again, typically, that's really at the manufacturer. Or at most, it's at the dealer, distributor, showroom level. Can you speak, Craig, to where the builder is coming in and how that has now been shifted and what builders need to be able to have, and really even what that responses? And there is really what the demand that drove that responses? Yes, I think today, if you look at the design time from you pick your lot and pick your house, and normally today they're driving you to some type of a design center, or a lot of times they'll have the garage converted to a little kind of make fab design center with a counter and some swatches and some carpet. And I think towards the future, if you don't want to have the model home and you want a total virtual experience, this really opens up the eyes and gets more eyes on the assets quicker. The other thing is, as we all get older and the millennials come in to sync, you don't always need a model home built and the doors open. And I think today, how many cars drive through a subdivision or a new development and they never get out of their car. And so, you never got them in the asset. And I think with QR codes and some of our technology on the background, it just gets more eyes on assets and it really changes the builder's perspective because people then have seen what he's building and they're automatically corresponding with that builder from that experience. And today, I think people want a quick reaction. They go into a house and go in through it, some people are gonna like it. But I think more and more you're gonna see less model homes built and more technology delivering what the choices are, what the asset looks like, what the tiles look like, the plumbing fixtures, all in application. So I think it's really gonna push people away from the design side. So what you're making a bet on, if I can say that, Craig, is that the way that we as people are changing the way that technology is moving is that there's gonna be more and more demand for visualization at a higher fidelity of the actual state. Instead of like, let me look at a visualization, flip through some colors, and then I connect the dots in my head. People are gonna wanna look in some sort of virtual reality or some sort of tool like that to let me see the product in real time as it's being designed or architect or whatever it might be so that I can make a purchase decision more quickly easily, is that the problem that you think that you're solving or that we're up against? Yeah, and I think today if you took, let's just say textiles or even tile for a second, they'll mail out a 12 by 12 sample, they'll mail a tip card, and you're back to this kind of trying to storyboard what everything's gonna look like. And when you can punch one button on any device and see all your options quickly, it just changes the game. And I think it creates a level of excitement that when people can see the white tile and the dark wood, I love the way that looks. And they can't picture it when they're looking at individual samples. And it facilitates what I think a fun energy on a project. And how many times has everyone heard, hey, I'd love for my wife to see this or my husband to see this, well, he's out of town. And let me try to get him down to the design center or down to the model home.  And so that's what really facilitates quicker decisions and helps the home builder, the product provider, anyone involved, because everything is right there at your fingertips, easily shareable. So if you think of like logistically, gotta go back to the design center, gotta get this other swatch. And so all that delays the closing for the builder. This speeds up that process. And so that would be, I think the main thing people want is a quick, easy way to look at what's gonna be built and all of what we're really focused on is pre-construction. So when there's cranes in the sky and they're building a multifamily high rise with one click, you're inside the building.  Yeah, you know, here's kind of what the kitchen, so it just really clears up unknowns. It's really what we're after. You said so many key words there, Craig, which is you're speeding up decision-making and we say all the time to manufacturers who target homeowners that homeowners are famous or not being able to visualize what this much of a product looks like at scale. Even if it's a generous sample size, you give them, you know, like a 12 by 12 carpet square, they have no ability to really know what that carpet square is going to look like next to their baseboard, next to their pink color, next to the other flooring in their home. I think, and the tipper for me was you were like, this replaces model homes. And I'm like, oh yeah, I'm never driving to a model home. Like millennials are not going to drive to a model home, but what they do want to do is share what they're thinking about with everyone in their network and for builders to understand that the more that they get positive feedback from those in their community, the more that they're going to be convinced to buy. So now I can get all of my friends, plus my spouse and whomever else to say this place looks great and I would never be able to get all of this people to go to a physical location. So you're building consumer confidence and increasing speed of purchase. I mean, it really starts to make sense. Yeah, and I think just a little out on there is, you know, it's more eyes on assets. And you know, if you have a home, you send me a link and I like it and I send it to 10 friends. Those 10 friends would have never seen that home. Exactly. So I'm a type of technology. And so I think the builders today, a lot of them need to be, I think very open to all types of technologies and what is that IT roadmap for the close, the quicker close, and potentially if someone sees a change order in person, then all of a sudden the money doesn't matter. But if you're at the design center looking at a change order from white to black or whatever you're doing, there's, it's more of an accounting thing because you don't get the love from seeing it in application. And so when they can see that change order and application then all of a sudden the money's not as irrelevant and the builder made more money because the change order was a more expensive option for the home. So whether it be refrigerators, backsplash tile, it really opens things up for the consumer. What I hear you saying here, Craig, is that the challenge that builders are facing is how do they get their customer closer to the end product? Like we talk about that a lot on our show is whoever gets closest to the customer wins. And the challenge that builders are facing is that the way that they sold homes in the past is not the way that people will necessarily want to buy moving forward. Is that right? Yeah, and to add some color to that, Zach, I think if you have a nice subdivision and let's say there's three builders in it and these are nice homes and two of the builders have the signs in the yard with vacant lots. They just put the streets and everything in and the other builder has a QR code with technology behind it. He's way ahead of the curve because now he's inside that house. And so, you know, as you use technology, I just think it opens up so many doors as far as cultivating the sales process, cultivating the decision-making process, and at the same time, it's easily shareable. And people, if you kind of look at gamifying it a little bit, it's not to go off in that direction, but it really makes it more fun. If I'm in the same room with Beth, she's in London, I'm in Spain, and let's say, Zach, you're in New York and we want to show it to you, we just text you a link and you're in the room with us live time and we're all looking at schematical changes. So it's really just a fun experience. It's a fun way to look at a home and when you're not in front of a salesperson, it really just, you get down to some decisions and you're not kind of pushed away or pulled that way. You just get down to some really good decisions because everyone can see it in application. And I think one thing to add is the most important thing about any kind of rendering is lighting, is what is the lighting doing, the shadows doing, if you have a red wall and the ceiling's white, it's gonna put a pink hue on that ceiling. And you can't see that when you're looking at a static rendering. It's very difficult to move around a room when you change a wall or a couch color or a floor color or a cabinet color, it changes the whole space with some degree of a lighting change. And that's the most important thing when you're looking at renderings today is the lighting aspect of what did that change do to the space? And we really work hard at that. Have you seen that? I mean, you may not have seen this, correct? Beth, I would venture to say you maybe have. I went to the Lego store because I've got kids and it's like a magnet for them.  So if you're like looking at, let's say, a Marvel comic, it's like the Marvel characters are like battling each other. And you can look at it on your phone and you spin it around, you see the whole thing. And as you're talking, you're talking about gamification when we were prepping for the show, I was like, I don't really, I didn't quite understand it, but like as you're explaining, I'm like the light bulb was starting to go off that there's something to be said about creating like a more immersive experience that gets people excited and delight them. It's not just simply about speed, it's also about the buyer experience, which for builders is really what they're having to adapt. And so I'm going from Legos to buyer experience to builders, but here, but my question for you is a lot of builders today, the biggest problem that they're facing is, gosh, how do I sell on the current climate? And so what I wanna hear from you is what are you hearing from builders and developers that you're talking to? Are they seeing that like, hey, I know that this is probably not something today that I need to be thinking about, but I know it's gonna change as the market changes or are you hearing a different conversation from them? I guess the best way I'd answer that is to say that the builders that let's just say are accruing for a new way to look at things, and I would say have been smart about things are gonna change, they're definitely wanting to embrace technology, they're extremely open to it. And I think that just relying on traditional sales methods and paths, if you look at it, you're gonna get a smarter salesperson if you have some technology. And as you look at buildings and you look at changes, and I'm just gonna give you an example, if you build 16 floor plans and you lose a supplier and two of the rooms and all these floor plans have this tile, you know, how do you change that out quickly and move on down the road and show your customer base that here's the new innovative products that are going into these properties. And so I think you kinda gotta look at like as things change, you gotta have an IT roadmap for the future. And I think builders today are gonna be challenged obviously with interest rates, like you said, it's a cycle, but how do we get more eyes on assets? And if the builders have great selections, why waste your customer's time with kind of a traditional sales path, and you get to close the property quicker. So we really work not just on the home, but on the street, on the surroundings, when you kinda move around the view, we really work at showing you what the whole complete property is gonna look like, trees, driveways, we can change landscaping now and really focus on the overall experience, not just inside the front door. So hopefully that kinda helps that it opens to builders' eyes to capabilities that were not there in the past. Yeah, I think Craig, if I could take that one step further, part of what you're talking about really is the scalability of what happens online or in digital or through technology versus traditional methods. So I mean, it is the greatest example to think about a literal physical built model home versus a virtual model of a home that looks very real and is tangible, touchable and customizable, but if you built a home five years ago, that home design in and of itself is outdated. And I think manufacturers can resonate with that because they feel that pain of I put tens of thousands of dollars into a photo shoot and then a printed brochure and a booth that I took to a trade show and now suddenly, kitchen design is a great example, suddenly nobody wants top cabinets and everybody only wants bottom cabinets and they want a completely open kitchen, which five or six years ago was just absolutely unthinkable and if you're a builder and you put tens of thousands of dollars into a built home that has this beautiful kitchen but has no island and all top cabinets, the homeowners are gonna go in there and be like, nope, this isn't for me and they're gonna go someplace else that has a design that matches what they want, even though if it's silly and like builders could just build you a home without those cabinets and that's fine, but you're just knocking down hurdles and overcoming objections simply by having the ability to be nimble and agile and respond to what the current environment has in a very scalable way. And that is really where doing something with a digital perspective helps you be able to sell quicker, sell more and get that competitive advantage because it saves you a conversation. You don't have to somebody have somebody standing in the kitchen being like, we know, we know, we know, you want a giant island and you want it to be marble and you want to sink in it and like, don't worry, we can do it. This is just like an example, right? Where you could have a virtual model of that spun up very quickly and then continue to respond and expand and you're not constantly playing catch up. I think that's really worth noting for sure. Yeah, and I think the other thing to consider is, you know, how many homes do you go in and they said, well, this home, yeah, this model home, it doesn't have a pool. But we do offer a pool. And so they can't get that experience of opening the front door and seeing the glass and seeing this beautiful pool in the backyard. But the builders taken the capital to build a model home, but he didn't finish the pool out. And so this gives them, and there's a reason, there's a cost, someone may not like the color. This makes it very liquid for the experience to be elevated intrinsically. And I think once you look at the fun that people have sharing the files and collaborating with friends and family, decisions get made. And that helps a consumer. It helps the builder. And I think mostly what's missing today when you look at it out there, a lot of them are just doing the same old thing and they're not really investing towards the future. And putting an IT roadmap with their assets. And one other thing I'll add is, if someone calls a model home sign they saw and they call in, a lot of the multifamily groups are just sending them a text right away. Say thanks for calling while I have you on the phone I wanna let you know if we get disconnected. I've already sent you a text of exactly what we're building. And so when that millennial gets off the phone whether it be a model home or a multifamily or anything they're immediately sharing it with friends and family. And so that's the value is that it's fun, it's a new experience. And if a sales person markets someone, that's gonna go the way it always has. But if I'm a friend and Beth and I know each other and I said, Beth, have you seen what they're building? Then you get a link from a friend. You're gonna open it because it's been endorsed by a friend. And that's what I think really helps give this whole space compression. That's great. Craig, man, I can't thank you enough for coming to the show. This has been super valuable. Before you go, I'd love to ask you, I'm a manufacturer, I'm listening to this. What's the one piece of advice that you would give them to make sure that they are staying ahead of the trend of how products are marketed, found, and sold? The main thing is make sure any image enhances your asset, doesn't depreciate it, really enhances the product. And make sure you're not sharing a printed file that you actually can share an immersive experience. It's gonna create a whole new level of excitement. Love it. Craig, this has been awesome. If someone wants to connect with you, what's the best way for them to do that? Just my email is craigatallyvi.com. It's probably the quickest way. And I gotta say one thing. I've been very, very impressed with the Venvio team. It's been a really good experience. And I would tell you, we talked briefly a while back, but the mentality of the people there, they really care. It's not just another customer. They don't want a customer for a week or two. They want a customer for a long time. And I wanna compliment you and Beth on the team of people that I've been exposed to have been, I would say, extremely refreshing. So I wanna say thanks to y'all too. Gosh, that means a lot to Craig. Thank you, Craig. Thank you. It's awesome. Yeah, that's the best compliment we can get. Thank you. Sure. Well, that's the best rap to any show I've ever been a part of. I know. For our listeners, I really hope you enjoyed the show. And Craig, thank you so much again for coming on. This has been awesome. And we'll link to your website and the show notes for AliVR as well. If you enjoyed this content, make sure you check out venvio.com slash podcast to subscribe to get more. Again, thanks, everybody. Talk to you soon.


Hey everybody, it's Hari Swaminathan Thursday, Jan 25th. We are looking at our swing trades, you can see ES futures up about 4 points quite tentative because GDP numbers are expected this morning and then of course the personal consumption expenditure which is the PCE number that the Fed looks at. But we've got very good news, all our trades are doing fantastic, JP Morgan is the only one. So what we're going to do, look at this, we have Nvidia up about and it's going to go up another $10, we have $4,300 already, Netflix we have $4,300 already and it's going to go up some more. Same thing with Microsoft, Microsoft up about $3,300, JP Morgan will have to work on that one but Goldman Sachs and Costco both of them are up. So now what we want to do today is given that today and tomorrow our data heavy numbers, we want to protect our good trades. So that is the Microsoft trade, the Netflix as well as the Nvidia and we are down about $1,200 on the SPX trade, remember we've already booked about $14,200 on this trade. So overall not bad at all, we've got over $12,000, $13,000 in profits right here. So it's tempting to take them off but since Nvidia, Microsoft and Netflix are just running higher, we just want to protect them. So this is not a bad performance in January at all to start off the year, we've got about $13,000 in profits here but let's take a look at our adjustments for today. First Nvidia, so what I want to do with all of these is to put a bear call in the same expiry much, much further away. So Nvidia is going to open around $623, I'm going to put a bear call at $680, 700. So you can see that that's quite a bit of distance away and what that does is that gives us something like this. So you can see even if it goes higher, it doesn't matter, it's probably going to expire somewhere here but we won't wait for it to expire, I just don't want some negative views between today and tomorrow to come and mess around with these trades. So what we can do is just put these bear calls. So similarly, what I have for Microsoft as well is the same thing. So we're going to go to 16th February and put $420, $440. So it's going to open around $404. So we're going to put this and get this premium right here and of course Netflix also, Netflix reported very well yesterday and our trade is rocking. So once again we'll go much further away, Netflix is going to open around $549, we're going to go to $580, $600. So in these cases, since we have a bull call over here, you can see that the margin effect is nil because it's the same $20 spread in the same expiry. So this is what we're going to do for today and I think it's best if we close out Costco and Goldman Sachs. We don't need to wait for tomorrow. Let's just close this out. On Costco, we booked a loss of 700. So this will be a $1,000 profit, maybe a little more today and Goldman Sachs will also be a $1,000 trade. So let's close out these two. We'll keep JP Morgan, we're going to hedge Microsoft, Netflix and Nvidia and SPX will just leave it as is for today. So that's it folks, no new trade today. Thanks.


Everybody forced here ripping two boxes for Amane S. Amane's got a 2022 leaf exotic multi sport and a 2022 top Star Wars finest We'll start with finest and exotic Good luck Amane. We'll save you that empty box and wrapper like I asked for From exotic I guess not no idea Boba Fett insert refractor thin Koska Reeves There's all the color this is all here. Oh, that's a super fractor coming up Fractor Chewbacca Super fractor K2s. Oh There you nice K2s. Oh super fractor Grats Amane Best jointed Rogue one for sure purple refractor auto Adi Gallia numbered 32 of 199 32 of 299. Excuse me and Jaleek Perrin That's right Kyle. Super refractor Darth Vader Short print refractor there. That was the extended base refractor Kato Kocanix Let's say blue refractor Zory Bliss 81 of 150 and last pack of finest refractor Grand Moff Tarkin and a refractor auto of general Draven. It is Alastair Petrie is general Draven. All right. Well, congrats on the super fractor Here's that exotic. Good luck Amane. Oh, wow This person's actually in the room with us right now Shaquille O'Neal you guys thought it was Sean didn't you? Number two one out of five Shaquille O'Neal Thank you very much for the card Check diesel there you go Amane congrats on the shack one of five Get right out to you


Live from Orlando, Florida. It's theCUBE, covering ServiceNow, Knowledge 17. Brought to you by ServiceNow. Welcome back to Orlando, everybody. This is theCUBE, the leader in live tech coverage. I'm Dave Vellante with my co-host, Jeff Frick. Mark Toledo is here with Patrick Stone Lake, co-founders of fruition partners, now a DXC company. Welcome to theCUBE. Mark, you were one of the first SIs that we ever met in the ServiceNow ecosystem, acquired by CSC and now the Spin Merge with HPE. Explain it all. How'd you get here? Well, that's great. So, you know, we really grew up in the ServiceNow ecosystem, right? That's where really fruition became really what it was and is. CSC came about 2015. So they came, acquired us, who became fruition partners at CSC brand. CSC then did an acquisition of UXC, a very large SI out of Australia. And with that was Keystone, probably the largest ServiceNow system integrator in Australia. So they came into our practice as the fruition partners Australia brand. We then went out under CSC and did another acquisition in mainland Europe of Spideons. They covered Switzerland, France, Germany and Spain. And so now they're the fruition Europe brand. So we still have this fruition practice inside of CSC at the time. And then HP Enterprise Services. So that's only the EDS group, the services group, not the hardware, the software group. So then they choose to spin merge with CSC and form DXC. So we're still the ServiceNow practice fruition partners, a DXC technologies company. So all this service now, everything you're seeing, that's what we're enabling for customers. Now Patrick, how did that all affect the go to market? Well, it enables us to be more global, right? Part of what we need, part of the reasons why we acquired these companies and continue to look to do so is that our customers are demanding from us a very consistent boots on the ground experience, multiple languages, but all kind of running the same methodologies, running the same accelerators and getting them to the finish line at the same time. So DXC and the kind of checkbook and influence of DXC has really helped us do our part in consolidating that market. But what I think we've really just started to scratch the surface of is how we can empower DXC as kind of become the engine that runs the nine major offerings of DXC and start to get ServiceNow into support of those offerings, modernize them, make them more efficient and make them more attractive to customers. You guys were early on. We've talked about this in the past.  Is this sort of workflow automation the next big thing? I mean, it seems like now everybody's glomming on to it. Yes, sir. And why now? And where do you see it going? You know, so we see this, as Patrick mentioned, DXC has nine service offering families, right? And that includes like big data, cyber, vertical applications. Certainly the outsourcing business is still significant. But what we're seeing is ServiceNow is this workflow backbone middleware that kind of connects us all. So we have the DXC offering family leads coming to us and saying, listen, we understand that ServiceNow can do ITOM for a business process orchestration. We understand it has a SecOps component. So now we have an iSecOps offering. So they're seeing that ServiceNow is kind of the glue to bring together these various offerings and it helps us go from our traditional relationship with the IT department to now branching out into HR, into security, into that CSM space. Even in the business process automation space, that could be claims processing. They have total business functions that are automated by this workflow, but it's not just the workflow itself. It's the fact that the workflow ties in to the other silos so that it's not just email. It's actually intelligent email and intelligent routing. So we see it as the glue to keep all these offerings together. And then you guys are starting to build solutions on top of ServiceNow platform and go to market with the solution versus you already have ServiceNow. We're going to be kind of typical consultant and help you do best practices, et cetera. Exactly, it's kind of a combination of the two. But I think the best way to think about it is that ServiceNow is doing its best to be as horizontal across the enterprise as possible, right? Security is a really excellent example of a place where ServiceNow is a natural fit. You connect the cycle with security and IT. And, but one of the things that we're looking to do is to bring the industry expertise of DXC to some of these ServiceNow enabled solutions. We just talked about, Mark talked about our ISEC Ops solution, which is horizontal managed security services. We debuted yesterday that we're going to be working with ServiceNow and their catalyst program around a healthcare splinter of ISEC Ops because there are all kinds of uniquely healthcare provider oriented security concerns that the actual thought leadership and the knowledge of the cyber consultants at DXC really bring a lot to the table. So we could build a solution in conjunction with ServiceNow. They rely on us for the industry expertise and they just keep that security piece humming and up to date and locked in with the rest of the platform. You only had another offering just to add to that is out of Europe, one of the consulting groups said, environmental health, employee health and safety and manufacturing plants. They said, listen, there's a product out there in the marketplace. Can you do something better or different using the ServiceNow platform? So we actually took that subject matter expertise from DXC, consulting experience. We married that with our ServiceNow expertise and we actually have another product that we're going to market with. It is an employee health and safety for manufacturing plants for slip and fall for any environmental concerns, any of the safety issues that they have. But that's really combining industry and vertical expertise with ServiceNow. And that's, somebody might not even know they're buying ServiceNow, right? It's just that, yeah. You're essentially OEM-ing. That's what we would like to get to, is that right? They're not there yet. I think there's a lot of, we have a lot of kind of, we sell a standalone on top of the ServiceNow platform and it gets built. Tony Beller, who's the new VP Alliance is coming in with a lot of force environment experience and I think he's really charging with some of the bigger partners like us to really lock down that OEM because I think that's where we get a lot of leverage for ServiceNow and our customers essentially want to consume as they need it and that makes a lot of sense. And are you reselling ServiceNow in that solution offering? So they don't have a separate relationship with ServiceNow, it's all integrated into that which they're purchasing from you. And you guys use ServiceNow internally? We do, yeah. As ourselves, we've been big drinkers of the champagne as they say for a really long time. We have a number of systems we use to run our professional services organization. But DXC, particularly in the area of asset management and some of the real ROI driven pieces of IT is taking a very hard look at the successes they've had there and trying to figure out how we can enable that success in the rest of the organization. Purchasing, project management, these are things that I think we're going to do internally and then start to share those results with our customers. We also have something called MyWorkStyle. So there actually is how we do managed service provider outsourcing relationship that's built on ServiceNow and we do that internally as well. So basically when we get support, we need support for our equipment, and whatever worldwide, that's being logged and tracked in ServiceNow. And the ServiceNow, you can clearly very strong messaging around, we start with IT, IT service management and ITOM, and then we're moving into the lines of business. How rapidly are you seeing that in your customer base and maybe add a little color to that? I think we're trying to accelerate that. I think what we're seeing is a shift as infrastructure goes to the cloud, as the IT department moves away from being the T of technology and more the information side, that they're starting to realize this role as more of a service management organization, because often times the applications that they're supporting are coming from a third party, if it's ServiceNow, if it's Workday, if it's Salesforce, but they can be the glue that holds it together. They can worry about the releases, the data hierarchy, but it's that IT as they're reinventing themselves, they see themselves going out towards those other departments, towards HR, towards CSM, towards field services, saying we actually have a solution we want to bring to you. I got to ask you guys, now as a consultancy, your complexity is your friend, right? Things are chaotic. It's like call you guys and solve the problem. But at the same time, you hear from a lot of ServiceNow customers, we're trying to minimize the customization, custom modifications. Is that antithetical to the way you guys typically do things? It shouldn't be, I don't think. I mean, we don't want to do as much work as possible in one project. We want to deliver value over the course of many, many transactions that are shorter in duration. And so the more we can stick to the configurable aspect of ServiceNow, the better off we're going to be and the better off our customers are going to be. They'll take releases more smoothly and so forth. And what you can do with configuration and app scoping is really, it's a whole other level than what it was five years ago. So we actually are starting to fulfill that promise. Okay. And so if you can build value on top of the platform using the platform, that's the point, man. Those functions get the advantage of the upgrade. Yeah, I would look at this and say when fruition really got going, it's when we really embraced ServiceNow, not just the technology, but the methodology because we knew a lot of other service providers, they'd want a two year project, right? They'd want that SAP three year, whatever it was. But we embraced the methodology and said, if we can't show results in four to five months using this technology, we're not going to be invited back. But look at today, we have 400 customers worldwide, about 70% of those make up our annual bookings. Again, for the next project and the next project because they see value in these increments and we're delivering that. So I would rather not elongate projects. They need to see things very fast. Awesome, guys, congratulations. I love the story, Mark. You got to present to the financial analyst group yesterday. So well done. Thanks for coming on theCUBE. Thank you for having us. You're welcome. Keep right there, everybody. We'll be back with our next guest right after this short break.