How He Became a Data Analyst after Spending 1 Year on Bench ( Step by Step ) In 6 Months

How He Became a Data Analyst after Spending 1 Year on Bench ( Step by Step ) In 6 Months

Show Video

Please tell us honestly, the online learning that you took & the work that you're doing in the company how much is the difference between the two By the way guys, there's an interesting thing that All the work in the data profile is of data set. Your system will be created according to the type of data set you'll get and you'll be getting the output accordingly If the data set is messed up, it'll ruin everything. So, Lokesh I would like to understand your project more that what was your project exactly doing & which questions were asked from you in the interview Please tell us about it. Okay! So, I had a project that - how much loan amount can I assign to a particular person What is his Age, marital status or income Tell us one thing Lokesh - Working in Cognizant without salary for a year how did you keep yourself motivated at that time? Without the salary Like, for 6 months I thought that I'll get after graduation, so Welcome to a new podcast. Today, we got to know about Business Intelligence Analyst. There's a BI profile in companies as well.

And this profile is very close to Data Analyst. So today, there's such a guest along with me whose name is Lokesh who is from Non-IT & worked 1 year in Cognizant without a salary he stayed in bench and he shared all the stories. And today he's working in a good company in a BI profile. Guys, The BI profile is very interesting. He gave wonderful examples of his own projects Normally, you might've seen when you place your order in a food ordering app accordingly from the next day or after a week, you start receiving similar suggestions you get coupons discount.

If you're taking credit card as an example, why do credit card employees call you you'll get to know about it today in this video. Alright! Watch this entire podcast and he has shared lot of good examples that keep in happening with our real life. What is behind it? Data Science So, like this podcast, share, comment you'll get to learn lot of things. Just watch this entire podcast. Like aim is 5000. Accomplish it for more such interesting podcasts. Let's talk with Lokesh.

And know his entire journey. So, Lokesh! Welcome to our Youtube channel. And I would like to know your journey but first I want to know about you Firstly, where do you belong to? Where did you do engineering from? And currently, which company are you working for? Please tell us about yourself, then we'll ask questions from you.

Please, over to you. Sure! And firstly, thank you Ajay for including me in the podcast. I basically belong to Karnataka, Kolar. So, I have done engineering in aeronautical. I did a franchise in Core domain. After that, I was placed in Cognizant as well.

But according to plan it didn't work out, instead other plan worked out, therefore I'm working as a BI analyst in Blend360. So, this was my small introduction. Okay! So, tell us Lokesh as you mentioned Cognizant, then were you placed through college? Yes! I was placed through college. And how much time did you spend in Cognizant? It has a whole different story means What happened was - as Cognizant is a mass recruiter so, in the beginning my final year started while I was in Cognizant but they kept on delaying for almost 1 year. They told me that they would start my training. They'll take me as a full time employee after training.

They told that the market was down.... This-that.... with one or the reason they kept on delaying and they kept on delaying until the end. So, I shifted from there. You were on bench for one year.

Yes, I mean you can say it as 'Bench' but they weren't giving salary, I was there in Cognizant for name's sake. Oh! So, I didn't join. So, as you told that you didn't do B. Tech in CS. Right! So, was there any coding culture in your college & did you explore such technology did you have interest since the beginning that you want to come into data profile were all these things there in college or not? I didn't do in College means I didn't even knew that there's such a domain. Students of CS were doing, we had other case but we don't have so much technical. Python is there but

that's a completely different path. So, I hadn't learned according to IT. I hadn't done anything as well, I knew just for the name's sake that there'a a language named Python, so I had explored atleast that much. I didn't do much. So, as you told that you're a Business Intelligence Analyst in your current company.

You're an analyst Yeah! So, what does a Business Intelligence Analyst in a company do? Business Intelligence analyst as the name suggests, our work is to suggest a particular business how to grow their business, so we analyze their available data we help them in doing business in such a way that it'll grow. So, consider any food delivery app or Amazon, Flipkart they run ad campaigns, like you receive notifications, email from them so, this is of a particular type for a particular person these things are customized. In Zomato & Swiggy you get customized pop-ups. That at this time, this is being sold in your area therefore order this. So, if this is being sold at this time, why are you receiving this? So, we analyze these things and tell the businesses to do this means there's opportunity, you can cater that customer through this pop-up so, it works this way.

So, basically guys, he's trying to tell for example, he told us about food ordering app About Zomato, Swiggy what happens is - the activities on the app, our interest that is there on the basis of that interest, they pick and give you suggestions that you can try this food, you'll get this much discount on it. So that, the business grows. This is called Business Intelligence. Right! You understand the business, the previous data, user data and after that, the pop up that you see on UI comes from here. Okay! Very interesting! So, what tool do you normally use? To achieve those things, Lokesh. Usually, in case of technology, I use Python & it depends on client which dashboard they're using means sometimes Power BI, Tableau, some internal tools as well so, we use that as well.

And apart from that SQL is basic, that's the most important thing. So, normally we work on these things. But, before doing the podcast with you, I knew only about Data Analyst they only do these things. Today I got the opportunity to know about another profile through you.

Business intelligence Analyst ! Very Interesting! Means, I can understand what future the data profile holds. There're lot of things means its in huge demand. And how important the data of the company is! If there's no data, there's no company. So, Lokesh tell us how did you prepare? As you told that you were on bench for around a year in Cognizant. And the training didn't even start. Then how did it occur in your mind that you need to go into the data profile? What happened was - I was recruited in January, so my academic finishes until June.

I didn't do anything until June, no research. My entire focus was on my academics. After that, as soon as I completed my exam, I thought that I cannot trust Cognizant with it because they already delayed it for 6 months, I didn't have any idea how much they would delay. So, I thought of shifting for which I need a proper structured manual. Means, I get all the course in Youtube but in a proper structure manual, you get all the things necessary to study, which isn't available anywhere on any open source So, I was just casually researching for job. I came across an online course of OdinSchool. I completed their course, so I was placed from their side.

So, I took the course in the data domain. So, what did you learn there? Which topics did you cover there through which you could crack this job? Okay! So, basically as I told SQL is basic & most important in any profile of data. SQL is basic. On top of that, Python wasn't that much needed for me but for other data profiles python comes handy. Above it ML, there're lot of dashboard tools as well which comes handy. Its not that, market only has Power BI or Tableau.

There're lot of tools in the company, there're some internal tools which you might've not heard of. You can get anything. So, When I was working I hadn't even heard of it before going in the company. It happnes. But basic of how does dashboarding tools works, they'll teach you the basic. After that, you build the scope.

So, usually this is how it works in companies that you're evaluated in such a way that whatever they teach, you should be able to learn it. So, it happens this way. Apart from Power BI & Tableau in market, my company has other dashboarding tools that I didn't even knew. So, I had to learn it.

So, it goes on like this. Guys, as he told that he learnt Python during the course He leant Sequel, Power BI, so when you enter into a company you work on all the things, sometimes you work on SQL sometimes you'll be working on Power BI but it all depends on the company's requirement you're assigned accordingly. So, this is what Lokesh is trying to tell.

Okay! But, tell us honestly, why did you join a data profile? There's full stack, front-end, back-end Its fine, you got the online course and completed it. Its fine you did from Odin but why did you choose a data profile? Why not front-end, full stack or back-end development? As soon as I got out of college, I had two ways. As you told- full stack, back-end. There was a full stack developer & a data profile. So, I was in dilemma as which one to choose.

But when I researched a little, you need hardcore knowledge of coding in full stack compared to data profile. As I was from NON-IT, I didn't knew core coding. So, I thought of going into data profile as you don't require core knowledge & you can call data profile as fun profile because if you go for full stack in IT, you're only focused on technology when you come in data, you need domain knowledge along with technology. As you work in different market places, like Pharma, Retail market, like mechanical companies, so you keep on working for different domains. You get to learn a lot in this domain.

I think like this. I haven't gone to full stack, so I don't want to comment on it. But I find a lot of fun in this domain. I understood your point. As I'm a front-end developer & work for a company, we do development so maybe , at that time you felt that you don't even have the background, I didn't do coding in college as well and this is a very quick time, quick decision, so I think I should go into data base. So, Lokesh I would like to understand more about your project that What exactly was your project doing? And which questions were asked from you while the interview? Please tell us about it. Okay! So, I had a project that - how much loan amount can we assign to a particular person, so what is his age, marital status or income so, we had to predict that because you know, banks can assign a particular loan amount after looking through these things.

So, I had done this project. I had a data set which contains that person's data, which job is he doing means how many phones does he have? I had the data of these things & the output was that he's eligible for this particular amount. So, what I did was, I explored into the data set- how it works, which insights can we extract. After that, I trained a model a 4-5 ML model and ML model also has an evaluation tool, like Accuracy & so on. So, evaluating those we see that this particular model works fine for this data set.

Means its giving almost 90% accuracy. So, if I've the details of that particular person then I don't have that amount, suppose. I'm going to the bank now bank will look at my previous data sheet, what am I working as, what's my status, what do I earn? They'll look into it.

So, it'll train this into ML model. ML model will say that he is eligible for this particular amount, so he can repay. So, in this way it'll give the output. So, my project was similar. I trained on different models

and the particular model which is working for that particular data set. So, I was trained it and showed the output. This was one of my project. Guys, we're trying to understand one thing. He did a wonderful project.

As you notice, we get calls suggesting us to take loan, you've this much limit you can take this amount of loan. You'll get it quickly. The science behind it is Data Science. So, this is not the example of credit card for any use case, you get a data set as a data engineer and data analyst or business intelligence profile and on the basis of that data set, you understand & train a system you build that system on Python & use ML to understand the data and you give results accordingly, like, offer this much loan to this person. So, its very interesting means Yeah, yeah ! Please, Please! As we call the data - Gold Mine.

Data is the asset of every company. Lot of things work on it. You can establish an entire business on it. So, we call data as a gold asset. That's correct! Guys, there's a interesting thing that the entire work in data profile is of the data set. Your system would be created according to the dataset you get and you get output accordingly.

If the data set is messed up, then everything is ruined. Correct! Because data set is the basement for everything. we build everything on top of it. If the basement is messed up then building won't be able to stand up. Absolutely! Its simple! I agree! There're different data sets. Its totally different in the company from what you learn because there're some standards, null values because the raw data you get from the company contains a lot of chaos in it.

Editing it is sometimes a very hectic job. In the time being data comes, your mindeset should eb such that why is it like this. Problem solving skills are very important. That how can I break down and solve any probelm so, it should be like that.

Because nobody can teach you everything. You need to build yourself somethings. If you keep this attitude, you can easily sustain in IT. What challenges did you face in coming into BI analyst profile? Did you to face any challenges or did you get it very easily? I won't say easily because when I started the course I was at NIL means I didn't had any idea. I only new basic queries in Python I didn't know anything else. I didn't know about SQL. So, initially I faced lot of difficulties that the new technology I'm learning. What was the scope? So, I slowly started practicing, learnt it So, If you keep consistency, things get done on their own.

Just, keep on practicing. If you think that you won't be able to do it, then you won't progress. So, keep on trying. It'll happen someday, if you keep consistency in your practice then it'll happen. After joining a new company, what new things did you get to learn? There're lot of new things I got to learn. Whatever they teach in market is different from the company that as I told that in the market they're telling about Power BI & Tableau.

But the tool I'm using is completely different. Otherwise, basics are the same but the toll interface or operating the tool and making a dashboard things get completely different there. So, I get to learn these things. We work in different databases, we work collaboratively. There's a data science team and data engineer team in my company and BI team as well. So, in some projects all the 3 teams work collaboratively.

We work on cloud as well, so, how do they work collaboratively in team work and new technologies in dashboarding, therefore lot of things go on. So, you get to learn lot of things. It'll differ from company to company. But yes, you'll get to learn lot of things, that is for sure. Tell us one thing honestly, the difference between the online learning and the work in company? There's a lot of difference. There's a lot of difference.

Because you don't need to know each & every tool when you go for an interview you should atleast have the basement ready that this toll works in this way. I know this much. So, after that the company builds you. They train you. They evaluate on the basis that if you're able to learn or not

I'm telling this as a fresher, for experience they obviously ask for technical knowledge. But as a fresher, every company has a different tool accordingly and you don't even know that tool in market, actually to be honest. So, they teach you something else in market, online or offline sometimes in companies you work in totally different tools. The common thing is that, the work that you do in analysis that analysis is common but the tool that is working on it, tool that we're analyzing in- is different. Tell us one thing Lokesh, staying in Cognizant for a year without salary how could you keep yourself motivated that time without a salary? But for 6 months I thought that I'll get after graduation so, the time passed on after that the problem started when I completed my graduation.

So, the job was just for name's sake, there wasn't any salary they didn't give any proper response, it was very hectic that time. That time, due to this I thought of shifting to data so, it was very hectic that time. Means even after the course, there wasn't any response from them the course was going on simultaneously but there was a period of time 6-7 months where I didn't have any work, I was sitting ideally at home.

I was just studying, but there's pressure form everyone that you've done graduation, you don't have a job yet what're you doing? Exactly! Right! So, It was nice talking to you! You told about your journey very nicely. The ups and downs of life & through you, I got to know the data profile more closely That BI analyst is also a profile and what does a BI Analyst do, Guys, I think you all've also known from this podcast. If you liked this podcast, then do like it, share, comment down. Like aim is 5000. Accomplish it for more such interesting podcasts. Rest, all the useful links have been given in the description.

You can go & check out. I'll meet you very soon in another interesting podcast. Till then! Take care of yourself.

Thank you so much! Thank you Lokesh! Thank you Ajay!

2023-05-26 11:01

Show Video

Other news