 Hi everybody, while he's doing the setup, let me just set the stage. So after those intense hours of technical sessions, I think what I'm going to present is something on the business side. I am currently with Dell Global Analytics, but I have been an analytics professional for at least about 5-6 years now. So most of what I'm going to cover is what I did, my experience as an independent consultant in the field of GIS, spanning about 3-4 years. So let me first define my definition of what analytics is. I define analytics as using authentic data either through primary or secondary market research and layering that data on top of technology platforms and most importantly, analyzing them in structured frameworks. So fundamentally, while most of the audience here would start bottoms up from a technology perspective, I start the other way around, I start with frameworks and then look at how do I solve the business problems of my clients. So this was about 4 years or 5 years before the 2007-8th time frame when the US mortgage industry was going through a tough time. That's when I thought we can probably look at frameworks in the realistic space. And technology incidentally happened to be a by-product there. I was trying to see what is the right tool to use and that's how my foray into GIS started. So I started the learning GIS right from scratch during that time frame. Thank you to learn from scratch and how long did it take you to be able to do analysis? It took me about, you know, fairly about 6 months of time. See actually what I did was I went and partnered with a spatial organization and I sat with the technology software engineer there and I used to come up with business problems. He used to help me, you know, these are the ways can be kind of devised. So as you will see in some of the examples that I show, you will relate to, you know, how one can think of business ideas being executed on the GIS platform. Unfortunately, you know, this screen doesn't seem to be up. We have tried all technologies here. I think we have tried my laptop, we have tried his laptop, we have tried the thumb drive and I think with the audience full of geeks, I think this is the right business challenge for everybody. I have to reduce the time for speakers. Is there some problem with that? I have tried turning it off and on again. We say age-old manufacturing. I remember in my first career as a consultant I was talking to a CEO of a tire manufacturing organization and when consultants came, this is what he said, machine chahu nahi aur aayato, there is only one solution, bankardo and restart it. So anyway, thankfully it has come back. I hope I need to just press the left and right. Fantastic. So let me straight away, I thought I would jump into what I tried doing. So this was in 2007 timeframe. Somebody from Dubai wanted to invest some millions of dollars into the real estate space in India and they were looking for somebody to come up with a framework to help them identify where and all those investments had to go into. So I went about looking at who are the market participants in the real estate. Now you know that there is a capital source that is coming from Dubai and USA elsewhere. And I knew there was this developer community, there was this space user community, be it commercial or residential. And there was this service provider who were the middlemen, like some of my friends who spoke earlier, common forex etc, who was providing multiple services to this space. So once I identified the market participants I also looked at, studied, especially in the city of Bangalore, what were some of the drivers during that timeframe which were increasing the real estate. So the first thing was that urbanization was happening at an increasing pace. People from Andhra and Tamil Nadu and Kerala and surrounding areas were all coming into Bangalore. So urbanization was fantastic at that time and that's when I think the ring road actually started, outer ring road and all started developing. Then of course the demographics, because of the ITITS boom also had increased. So the income levels, the crowd was becoming much younger, 25 to 35. So those were the structural drivers for real estate. In terms of cyclical drivers, I distinctly remember one of my friends coming and telling me that he got a loan, home loan from ICIC at 7.25% fixed rate. That was in 2007. And then I was like, wow. So some of the cyclical drivers are the interest rates and how the market is responding. And interestingly, during the 2007, 2009 timeframe, even though the real estate elsewhere in the west slump in Bangalore especially the rates continued to remain flat and inflation. Then there were certain property specific drivers like when I say that some of the factor studios, where is it located, which is the nearest railway station, airport, supermarket kind of example is the location character. Then physical characteristics in terms of amenities in the apartments, et cetera, what are some of the things. And also in the framework is the tenant's creditworthiness, which is, you know, if I'm leasing a property, what is going to be my credit history will I be able to offer them? So this was more like an investment framework. Basically, again, the other drivers in the real estate where whether the property was legal, there were any claims on the property. Then the liquidity position of the tenant going to work with and who was managing the property. So these were fundamentally the drivers and then, you know, I'm going to bore you with one more framework which is, how do I spend the money that I get or whoever is planning to invest? What is the framework that that person uses? So I said, look, you know, some of the decisions should be where should I commit the capital? Should it be Mumbai or Bangalore or Delhi or Chennai or there or not? And asset allocation strategy in terms of how much do I put where? And also look at return objectives. For this person, you know, he was actually looking at immediate short-term return during that time frame. So is the return objective a short-term one? Are you wanting to invest and then pull out or do you have a long-term objective in terms of, you know, parking your money on that property for a long time? Then some of the economic factors which at that time are pretty pathetic actually. Then we were also having done this identify what were the investment program parameters in terms of allocating capital and returns. We came up with the solution which was the investment policy. So how much of money are you actually going and creating an equity or are you going through the debt route which is like you will lend money and then expect a return on that. So we came up with a certain set of investment policies which I leveraged in other sectors related to real estate. So one of the interesting things that I did was I said look, now there is this technology that is available, you know, there is a special platform that is available and what do I do with that? So I went the regular path of, you know, going to all these property guys like Purovankara and, you know, prestige and all those all of them said you know what you have I can also mark the points that you have on a map. I have all the properties I can put attributes. So what more can you do? So I spent about 3-4 months running around the process and realized that there should be some other segment or sector in the market which will be a recipient of these services. Next time I went to a bank and then I was speaking to the stress assets department and the chief of the stress assets in the central part of Bangalore, he said look, you know, I have these land of properties which are stress assets because these people who have taken loan from us haven't been able to return and the bank has taken position of those properties and we are planning to resell. Unfortunately, what is that all of us are centrally located. So how do I reach out to those properties and ban? You know, I knew I had that idea there. So what I did was I asked him a sample property and then said, he said, you know somewhere in this Gubbalala village this is actually on the Kanakapura Road, it's near Uttaravani it's called Gubbalala. So he said near Gubbalala I have a property and that's a stress asset. The grand valuation that I do is a very mechanical way of sending civil engineers there and they do some measurements on the ground and that's how we measure the area's parameters, etc. So I said, you know actually I go down to that place on Kanakapura Road and when I went there I was aghast. Because the whole property was kind of encroached. You know, there were compound laws and there were those dwellers there with hats, etc. When they saw there they were not even letting us get in there My friend and I went with the GPS device we wanted to take some measurements So I realized that there is this additional problem of political pressure there because some people have occupied the property and how do I circumvent that I can't enter into the property that was the challenge So that's when really the special technology came to my rescue. Because all we did was we got the perimeter of the compounded wall we just took the readings around. The next step was you know, I went to the the other thing was about how do I find out the survey number So I actually went and stood in a queue in JP Nagar in the sub-register office paid some 50 rupees or something got some gubbalala revenue survey map Okay, once I got this map the next step was how do I overlay this map on top of you know So I got the revenue survey map of gubbalala. I went to my software engineer friend and said look I have this paper-based map how do you lay it down I said first she said it's not possible about a week or so he came up with this overlaying technique he said I have to use polygons and then he carefully mapped out those polygons on top of gubbalala and whom I have my property identified there I have my survey numbers also 8 and 59 identifiers so ultimately I could get to the location Now the next step was how do I do the valuation of that location that was the next challenge So for that what I did was I again went and went to this BDA office BDA office is near Paras Butahali So at that point in time BDA had come up with this comprehensive development plan 2015 So I said let me take that I got the stamps and registrations and put them So I actually went there to CDP as it is called on the property So that gave me a rough idea of that particular thing is here some Duttala Sundaram So the gubbalala the property was around 900 per SFT in terms of guideline but then that did not solve the problem because I had to get to the market run So again I went around identifying the property guys around that area they did an indicative survey with them which was calling them up and figuring out I want to buy a property and that's when I realized that gubbalala was under around 1400 1600 plus square foot So I went back with these figures which were pretty much the customers were satisfied with the kind of valuation that we came up with So one of the extensions that I did was all that I've done it for you I can create a digital library across the city So that's the potential that is there in this The other thing would be again mind you I'm a guy who can just need a particular demand by aggregating resources Let me put it as simple as that Another urban infrastructure firm that I worked with as a consultant So this firm granted to buy some property near the international airport coming up at that time So again you know they had this problem, how much do I pay for that I actually brought on across this is from Yalahan Karthik all the way to the airport and did a lot of GPS markings the airport complex interesting that I also identified all the railway tracks, the road network there and also those quarries the white things that you see there are a lot of quarries around that area Same thing So layered the CDP on top of it to identify whether the property that they were buying was in a zone which was commercial in nature So that was another interesting thing Then layered the values Now if you look at it when I did the color coding thing Somewhere around the Yalahan Kar area which is you know your Dodha Jalla and Meena Kunte and Tamagraha That's the area which is closer to the cities where you see all the dead which is 450 to 600 Similarly if you go towards Devenahali Closer to the Devenahali town to pay it and for support or something is where again you know you see all the threats So it kind of corroborated the reality on the ground So this was another interesting exercise that happened The idea of this is that while I continue to look at how we can upgrade GIS and also throw the discussion open to the floor in terms of A that's around this and B also I must have used some technology which is fairly outdated How can we fine-tune these exercises, layering exercises from a technology perspective So I'll leave the floor open for discussion Is this 10 years ago? Not 10, 5 Do you have these kind of maps the other cities as well or is this just Bangalore? Bangalore, Chennai are no 5 Can I be working on developing the other cities as well? Like I said I am an analytics consultant So I partnered with an org like one of my friends was saying they had also done a survey They had done a survey of Chennai, Bangalore and Mumbai and they had all their map data available with them so all I had to do was to do and then layer my attributes on top of that So I come more from a structure for example I did another assignment They had actually length loads and they were not able to go after some of those delinquent loads and when I layered them on top of the map I could realize some good spatial patterns there for example I realized that there was a place called Mohammedan colony near Malaysia that had those huge gaps they were not able to attract people from there whereas Bangalore on the other side near Sambigey Road I could see clusters which means that the loans from certain geographic patterns the other interesting pattern I found was all along on Osu Road and on the Old Air Road is where I had lot of dots for the salesman who had gone to few loans that means the salesman has not penetrated he had not penetrated on the Osu Road either the right side which was the Sarjapur area or the left side which was the BTM layout area in terms of selling or in terms of pitching for the loans that was a good insight that they got how does one get those revenue maps? revenue is very easy you have to fill an application see write to information map only thing is you spend half a day there in the sub registrar office fill in the map pay some 20 rupees or 50 rupees you can get those and they only give pay for maps they have any digital form I think we need to do a part is it some way or some way to build essential services on this as well so for example in a certain area there is a lot of scarcity so that could also affect the real estate prices and the roads all kinds of other infrastructure see the number of access routes that one can layer anything that you can think of how do you get the data in this case I was able to get authentic data because I had relevant sources but in terms of water for instance how do you know whether water in whitefield is good or water in Sarjapur road is you know again you have to tie up with BWSS people we actually do another we actually do another because that's what our company does we try to figure out where because we know water supply schedules and we know how many days after which we will receive water and what kind of water scarcity patterns there are so actually that can be done not for Bangalore but for other cities why not for Bangalore because we haven't been able to get water from here