Name: From data to decision: Winning innovations from the Spotfire® Energy Forum Hackathon
Uploaded: 2025-09-03T16:18:13.249Z
Duration: 40 min 7 s
Description: From data to decision: Winning innovations from the Spotfire® Energy Forum Hackathon

Transcript for "From data to decision: Winning innovations from the Spotfire® Energy Forum Hackathon": Hello, everyone, and welcome to today's webinar from data to decision, winning innovations from the Spotfire Energy Forum Hackathon. We're thrilled to have you with us. I'm JP Richard Charman, and I'll be your host for the session. Now before we get started, I wanted to cover a few housekeeping items to ensure that you have the best experience during this webinar. The webinar will last for up to forty five minutes with a ten to fifteen minute q and a segment that will be held at the end. If you have any questions during the presentation, please use the q and a panel located on the right hand side of your screen, and we'll address as many questions as we can during the q and a segment at the end. We've also made a few assets available linked to today's webinar in the dot section of our webinar platform. So that section is located between chat and q and a on the right hand side, so please do feel free to access these. After today's session, a recording of today's webinar will be available on demand, and we'll email you a link to that shortly after the event. Now with that, let's dive in. I'm excited to hand it over to Jose Leviaguirre from Spotfire who will be driving this session, and we'll be introducing our speakers and the submissions for the Spotfire energy Forum Hackathon event was held earlier this year. With that, over to you, Jose. Alright. Thank you, everyone. Thank you for joining this, this webinar. Winning innovation forum, the Spotfire Energy Forum Hackathon. So we are gonna go over those winners and their submissions. We'll go over them. We'll let them they talk about them and and all and all of that. So before before that, I have a quick, confidentiality and disclaimer. You can pause. I think this webinar is gonna be recorded for those who are not able to stay for the full session or happen to want to watch it later. So this is the agenda for today. We are going to, get a overview of what the hackathon, was, and then we're gonna go over the winners and speakers, followed by showcase and demos. And then we're gonna wrap it up with a call to action for those who wants to participate in future hackathons or or maybe this vast hackathon you still, you want to put your your test your skills and submit, we're happy to do so. Okay. So the Spotfire Hackathon or it was held during the Spotfire Energy Forum in 2025, last May. It was held live in Houston, and we showcased how visual data science and AI transforms the energy industry, featuring discussions on Spotfire solutions and couple complex data challenges. I'm going to put the link also whenever this video is available for you guys. I can also paste it in the in the q and a so you can, have a feel of what the Energy Forum 2025 was. You can also watch, the the presentations that were held. They are recorded online and available for you to watch them. And then the hackathon the hackathon, challenged participants to find the optimal geothermal well location using the Utah Forge project using the Spotfire. Again, although all those results, I'm gonna be providing them through the link later on. So how the excuse me. How the hackathon winning criteria was? Well, it's twenty five percent on each category. We have innovation and creativity where we we assess the innovative dashboard design, use of data visualization, the impact on end users. And then another 25% was in the visual story telling quality of execution and presentation. So we were looking for clear and insightful visualizations and effective presentations of ideas. Then we have the interactivity, functionality, and user experience, the ease of use, navigation, and interactive features like, filtering and drill down. And finally, we have the impact and real work detail. So even if you don't understand the data, you can still have a a a go with these other categories and testing your skills. But when we when we were also, assessing this impact and and real world vitality to address high impact problems with feasible solutions. So I'm happy to to share with you the winners of the hackathons, the winners and the speakers that they're gonna go through their demos in a in a little bit. Third place, we have Jolene Robertson, software developer currently working at Forecast. She's an independent consultant. Then Martin Lozano. Sorry that Martin Lozano was unable to make it to this session, but he was, I have some videos that we're gonna present over his work during the demo. And finally, we have the first place, Martin Lozano, production engineer at Oxy. So with that, Jolene, you wanna step in and share your screen, see what you have? Let me just, stop sharing. Yeah. Sorry. I'm just getting it up here. Yeah. It was it was an interesting challenge. I didn't have a whole lot of time to work on it. So that was my biggest challenge is not having enough time. There was a pretty large dataset, and trying to put it all together was was fun to say the least. There is data everywhere I found. Sorry. My I'm having some technical issues at the moment. But it was it was a hunt to find like, I tried to bring in all the data for all of the locations to have it in one central place and try to to centralize everything, which was a bit of a challenge because the the data was different for for different locations. Like, it was collected differently. So, I just have a few different tabs for the different areas. And, I tried to yeah. Like I mentioned, I tried to bring in all of the data for all of the locations so that you can plot it, altogether nicely. Some some of the data didn't have some of the required, logs, for an example, or either that or I didn't have time to, like, locate them all. But, you can just mark through the different wells here to kind of get an idea of the the different logs. And, you can also, like, scroll into them as well with the zoom slider. It's reactive to the other plots. So wherever you are on this main temperature profile, you'll be able to see the same on, on the logs. And then, then I also have, I tried to bring in one of the the oh, yes. I have some temperature contours here where you can slide, and they they will change based on what your selections are there. And, yeah, added a bunch of different layers, showed the, like, the study area and the actual eForged site. And then here, I tried to do the the, three d scatterplot to kinda show what they look like, subsurface for the, the injector producer and then the the monitoring and seismic wells. Mhmm. For the groundwater, I actually created this in one of the GIS tools, to kind of align what I was seeing on the uForge site. So I I created this layer here. That's, yeah. Over here, you have the, the joints, the fractures, and the I have a oh, yeah. So here you can, view the different attributes, the different, chemistry attributes here Yeah. Depending on what it is that you wanna look at. Like, I know that. Okay. So you have a drop downs and this is changing. Is it running at that function to create those layers on that map those map visualizations? I believe I just had it all in the table and it's filtering. Okay. Yeah. The dataset that I put together was, quite large. And I think there was but I had another drop down that changed it from chemistry to, one of the other one of the other. Is that wrong here? For Seismic, I never really this is just something that I was playing around with. I didn't I didn't have time to finish it. Mhmm. I'm just gonna actually check something. Yeah. You said that you would did very quickly. It seems that you use the templates to Oh. Just taking information like the header and the and the bottom, those tabs. Are those tabs, the the part of the Spotfire? I don't think so. It's just a big screen area. These are just, like, HTML and CSS. The curves I put a tab here for the curve depth because there's so many of them. So if you wanted to look and see, like, what they were and and, like, where they came from. So when I was, building it, I have a function that runs, that basically dumps or ex like, gets the LAS file and and dumps it into the table so I can have this information. Yeah. No. I could've swore I had something else here that made this dynamic unless I sent the wrong file. But anyway, yeah, not a not a whole on show, you know, this is just your details on demand. So if you Yeah. Wanted to mark something more. It looks pretty clean. It looks very sharp, your visualizations. I know your styles from from years working together. And I noticed that you used the fixed canvas. So I also use the fixed canvas to make sure that sometimes when when to make sure that the visualization is available on any different screen size. So it doesn't matter if your screen is larger. It's gonna keep always the same, this aspect ratio. And if your screen is smaller, maybe a mobile device, you can always scroll and pin with those big two scroll bars. But there are other tools in the Spotfire recently well, not not that recently. There for a while that you can accommodate, by defining which visualizations you want to see when you have a larger screen or which ones to hide when you have a smaller screen and and whatnot. And how to if you want to responsive design so the the visualization will stack on top of each other. So there are different ways. But, yeah, overall, it's very clean, very nice. I like the colors that you put together and and the the way that it's visually appealing to tell a story. And I also noticed in your first tab that among other submissions that one of the wells or what these three wells seems to have been the optimal places to to drill. Mhmm. Yeah. Do you remember how you find figure out those, how it came out with them? These wells? I just sifted through the data and, like, built it into a table. Interesting. When I went to go and look to see how much data I saved during this project, I think it was, like it's actually 22.2 gigs. There's tons of data. What I found, like, so frustrating about it was on that, Utah Forge site Yeah. Sometimes you would download something, and then when when when you open it, it'd be, like, all PDFs or or something like that you can't really use. Yeah. I I I found that pretty pretty frustrating. So that's the your biggest challenge was going through the data and try to find or maybe parts, put together all the data together. Will you say that that will take what percentage of your time? Most of it. Yeah. Basically, for the, the layout and the way that it looks, I just kind of because I wasn't didn't have a whole lot of time, I kinda just reused something that I already had. Yeah. And, yeah, it's, it it I don't so, unfortunately, I don't have a lot of more cool things to show. Yeah. Just hoping for. So I guess my recommendation would be to if you're going to do the hackathon, is to maybe, like, build a template beforehand and just have it ready. And that and, like, that would be, like, a benefit to have anyways for your, like, real life applications. Just kinda have a blank template with, like, the, the types of, script that you would use. That way, it's it's readily available. Okay. That this this here actually this when I select this drop down here, it is running a, data function in the background to to create the, heat map. Okay. Yeah. For this visualization. Yeah. Yeah. Pretty cool. Yeah. Well, I guess the most of the real life project will require a lot of effort to put the data, clean the data together, and do data wrangling, and and just make sure that, what you're seeing, the numbers that you're seeing, reflect the actual data, whatever you want to convey. Well, if there's anything else, any other questions from the audience, if not, we can always wait until the end. But if not, we can continue with the second place. Yeah. Martin Losano. So thank you, Jolene. Yep. I am going to share my screen now or to share Martin. So, unfortunately, he was not able to make it, so I'm gonna cover, his submission. And one of the cool things about, what Mario did was that he provided some in line help or videos that we'll walk you through. So let me let me share that link for the second place. And also well, this I I don't want you to get distracted with the with the link. So I'll go send those links at the end. So I'm doing put them there already. And okay. So what he did was create videos, and he explains on these videos. We can see the videos he created, a YouTube video, and then put a placeholder with a little JavaScript you cannot able to. I don't know if you are able to see it, but he's explaining that, this select control plane will select a different depths for each, for each for each location. So that this is how it works like this. You can see the different depths of and, of course, if you if you select all, you will see everything. I thought it was the data function at first, but it's just filtering the data. You can see here at the bottom right the that's filtering the data so you can see the different maps. And then the other part is the temperature. So when you select a couple of of of, locations, you can see the the different different depth and, and it's covered by temperature. So I don't know if you're able to hear the video. Let's go through. Let me know if you can hear the the video. No? Okay. So okay. Hold on. So yeah. You can see where the work are. Okay. Hopefully, that works. Now let's go to the next tab. And, this is pretty cool because you can also select the depth. This is the contour, and then you can slide the claim matrix. And you can see different different temperature. This is high temperature. This is probably something, that you want to avoid. But, see how this lane is is is moving. You can see the cross through the cross section and see the the depth, different temperatures. Let me just run a portable video real quick and see. Okay. And last one is the well organized well, we have another one, but this is pretty cool. Okay. And finally, we have the the profile the final profile for the well. So it's pretty much what Jolene came up with as well. Thank you, Mario. So you wanna share your screen and walk us over? What do you think about the experience? How long did it take you? What's the biggest challenge and so forth? Sure. I think it was an interesting challenge. To be honest, this is, I've been using Spotify for about a year now. So it was a it was a good learning experience, and now most of my experience come from more like an operations background, more like that analytics. So I probably took a very, simple approach to some other things. So, there was a lot of information as you mentioned. So, I think if you were to look at, like, the whole all the links that you did, it's very easy to get lost. So I wanna start looking at seismic logs and everything. So I think I'm a little bit extra steps, so I went to their website. I actually found a few town hall meetings that they had, and and and and that kinda helped. Right? Like, some of the main things to me that were, like, a big moments is that, they can only be, like, a press release where they mentioned that, okay, they have been trying to push the limits of the temperature. So they they were trying to get up to 500 degrees Fahrenheit. Right. And they also had additional, additional funding. So that kind of helped on on how to approach the project because one of the main things is they really actually have a very limited area where you can drill wells. So and we already had some of the wells drilled. Right? So it's like, okay. So how are you gonna place the next one? We can you can drill east to west or west to east, north to south. So most annex, you see, I hear a little bit of echo. Can you hear me fine? So you're fine. You're fine. Okay. Great. So yeah. I mean, if you compare probably my project to some of the other ones, I just have one tab. It's actually quite simple. And the main thing I was trying to show here is, okay, what is the optimum location. Right? Because that's anyway, what's the purpose of this? I do have a little bit of a templates, and, I know you already mentioned this earlier. And I actually do it for a lot of my projects. So kinda like my process, it normally involves, developing text areas through Versus code. I have a, I have an extension that I can just as I do changes, it updates the HTML or CSS on on, on it, and that's come this is a different project, but it kinda, like, shows, like, my process. So it helps a lot. I I do, like when I when I can, I do things in Spotfire directly, but sometimes being able to see the color coding, even, like, the color team directly, it's, I think it's a big help? So usually starting here, develop my text area, and just kinda modify. Yeah. So if you look at my, my Spotfire report, I'm using, like, a general template, but another important thing is that I did go to the website of your default, and I see the color team. I still like the main colors, the contrast, and then I mean, you can see these two are, like, the main colors, and that's basically what I use in my project. In terms of developing this, I actually use a lot of JavaScript. So I was trying to make this kind of an interactive report. So you have a a little pop up window, which, again, the main things, they have a $80,000,000 funding targeting 500 degrees Fahrenheit. They're gonna do some extended testing, as well as kinda, like, giving a little bit of the, technical aspects of it. And yeah. And they are defining what the surface location was, the world trajectory, target depth. And then, then finally, I have, like, a little guide on how to use all these little pop ups. And to be honest, most of them, usually, my starting point is a lot of the information that is on the spot for our website. So, that's usually where I start, and then I do a little bit of modification just to kind of fit my purpose. But, anyway, so the whole point up here and I think the thing that I was trying to prove as mentioned, okay. So where are we gonna drill the next well, which happens to be this one? And the main the main thing for this, for me, and I was trying to not to get lost with all the logs is temperature counters and temperature profiles. So I knew that from the, again, from the what they what they were trying to do from the webinar, that they were trying to do deeper and hotter. Right? So I was like, okay. Where can you get the most back for the box? So it is a u-turn well. So you wanna have you wanna get reach the highest temperature possible at the lowest depth. So I think the main thing on this, and it can get tricky, is, like, if you look at the contour, like, at 9,400 feet, you can kinda see, this is, like, the hotter this is the hotter region. But then when we start doing a 13,000, there's a little bit of a shift. So now and this is kinda what's, like, the main decision. You can start seeing the hottest part of the, let's say, the reservoir. It starts being where the this target bottom hole is. So that was the main thing for me. Right? Just you're seeing how the the contour map starts changing. And, I mean, to me, that was the main decision. Right? Because then, yeah, you can go maybe west to east or east to west, but you will never be able to reach the same temperature at that depth. So and then the next thing was just trying to figure out, okay, what is gonna be the temperature gradient? So I added all the gradients that we had. I do the very simple linear relationship. And then, again, like, their target temperature was against the 500 Fahrenheit, so we can get there about 10,300, 200. So that's actually quite reasonable. And then, yeah, there was, like, different options. So you can, you can show all the wells. You can filter them. This is very standard stuff. So, again, very I I think I took a very simple approach, but just trying to hit the main points of of what the challenge was. Main thing, trying to get lost to you a lost to you also. Very nice. Very nice, Mario. I love how you were able to fit everything in one single tab, one single page. It's almost like an applications with pop ups to help you save real estate and all of that. So what was your biggest discovery or moment during the hackathon? Do you have do you have any or your maybe little small ones as you were doing it? I I think for me, it was, I mean, there was a lot of information provided already, but not just getting too hung up on that specific information. So I'm trying to do extra research or going to their website, kinda reading what their plans were. I'm trying to fit reality because I think sometimes we can get lost on, like we we can do dashboards, but we lose touch of reality. So I was trying to ground myself onto, okay, what makes the most sense. And that helps. Right? Because when you have all the information, you can okay. I can I can look at the mineral at the mineral composition and segment, but does it really matter? Right? At the at the end, what really matters was temperature, so that's kinda what I focused on. Okay. Perfect. Yeah. That sounds sounds good. And will you agree that also, the biggest challenge was to or hurdle was to put all the data together, finding the right data? And then once you have the data, then then you can, yeah, put everything together. Yep. And it was a big help that, I have already had different projects. I may have a little bit of the templates that I could use. So that helps a lot with development. Right? So you just change certain color teams. And if you are organized enough, that makes it so. Now I think I'm in a good spot for the next hackathon because I already have all my templates saved. So let's see. Hopefully, you you won't throw at, CorVel next year. Oh, good. Okay. So, I think it's about to to wrap up. We're out of time. So let's, let me share my screen. And, also, I'm gonna share some links here in the chat if you're I don't know if there are too many, but, those oh, maybe well, I don't know. I'll I'll send them one by one. Anyways, there's also here a QR codes that you can scan and and go through the to access to the hackathon. So this this will provide you with the guidelines. If you want to participate, you wanna take that challenge, you can go. You have now already some tips on what type of data you wanna focus on, and then showcase your Spotfire skills. Test the Spotfire and see how what you can come up with. And, so well, unfortunately, there's not gonna be a pricing, but there's not deadline either. So just see if you're unable to scan the QRC code, you search for Spotfire community hackathon champions, and you will see all the links that you need that that we were showcasing today's webinar, and you can also take a stay tuned to the hackathon. Alright. Well, thank you very much, and and, I'll let, Jan, Philippe, JP wrap up. Beautiful. Thank you very much, Jose. If you don't mind going to the next slide. And, I just wanna take the opportunity to thank our speakers today. So thank you very much, Charlene and Mario, and also for Martin's submission. And thank you again to everyone who joined us today. Now before we get on to our q and a segment, a few things that we wanted to share. In terms of webinars, we have two great series are being added to on a regular basis. So whether you find out more about Spotfire and different capabilities or you're looking to learn about the latest in terms of what's new, don't hesitate to register to both full series. In terms of on demand access, I mentioned this at the very start of the webinar, but a recording of today's webinar will be made available soon. So please do keep an eye out on your inbox for the link. In terms of next steps, if you're interested in learning more, please do feel free to visit our website at Spotfire.com or contact us directly. There are lots of ways to interact with us. If you wouldn't mind going to the next slide, Jose. So whether it is via our socials, through our community, additionally, our blog site has lots of great content where we share the latest on visual data science, dive into Spotfire data science in more detail, our latest offering. And last but not least, if there are any enhancements that you would like to see or have ideas that you would like to share with us, please don't hesitate to visit our ideas portal. With that, we will close the event. And as mentioned, you'll receive a on demand link to this recording very shortly via email. Thank you again for joining us, and have a great day. Take care.