Business Analyst Full Course [2024] | Business Analyst Tutorial For Beginners | Edureka

As organizations increasingly rely on data and technology to drive their operations and make informed decisions, the need has increased for professionals who can help bridge the gap between technology and

business

and then comes the

business

analyst

. which plays a crucial role in helping the organization as a result, the demand for business

analyst

s with the right mix of technical and business skills is high and is likely to remain so in the future. Hello everyone and welcome to this session. You are currently watching a video of the complete

edureka

business analytics

course

at the end of this video.

You will now have a deep understanding of business analysis from theory to practical applications. If you love watching videos like these, please subscribe to

edureka

YouTube channel and click the Bell button so that you don't miss any updates from us, also if you want to get edureka certification

course

. then check the link in the description below. Now it's time to start our agenda, where we will have a brief overview of what we will cover in this complete business analysis course video. We will start with understanding the current trends and how to become a business analyst next we will see what a business analyst does now it is time to delve into the technical concepts of business analysis we will start with predictive analysis using Python after which we will work on data analysis using Excel next we will continue By understanding the agile methodology followed by the scrum methodology, we will also see how to become a bi-analyst.

We really hope this helps you get jobs in the industry to achieve this we will look at some of the important business analysis. interview questions with answers so stay till the end now let's start with a session on how to become a business analyst now starting with why to become a business analyst now the first and most important aspect of becoming a business analyst is to look for job opportunities, so when it comes As for job opportunities, it is not surprising that there are a large number of job opportunities around the world, but having numbers will always help us, so the first number that we are going to consider here is for India which has around 13,000 vacant positions while In the US there are around 100,000 vacant jobs now, this includes both freshers and experienced people, of course, this data has been taken from LinkedIn and Glassdoor and similarly known as Silicon Hub in India.

Bengaluru has around 2,000 vacant jobs just for business analysts, including experienced and entry-level jobs and Silicon Hub of the World, maybe California has around 4,000 vacant jobs again, data taken by LinkedIn and Glassdoor . Now similarly, your next question regarding why you should become a business analyst should be salaries. we have you covered on that basis as well as an average salary from entry level to average experience in India you will earn up to 7 lakh per annum and while in USA you will earn up to 77,000 per annum now this again takes you LinkedIn and Glassdoor now with this kind of aspects and data in your hand, why do you want to wait?

Go ahead and start your preparation now, before you will have hundreds of questions to answer. Now don't worry because we have all your doubts that will be resolved in this video, the next thing you will have are companies that definitely hire, there are a large number of companies that hire from the basic entry level to the experience level, now the companies that They are hiring are even based on products and services, now they could be high-end companies like IBM, Deloitte, Oracle Accenture and any of the startups. These are some of the companies I have mentioned here.

There are many more that are added to this list and tell how to become a company. analyst, well again there are many aspects to consider, first the job description, now in the job description, you can see what exactly a company or a recruiter is looking for in you as a business analyst. First, we have considered a job description of Amazon here. Amazon is looking for a near-entry level Business Analyst with only at least one year of experience. Now with this, you can see from the highlighted parts that Amazon is basically looking for a highly advanced province in SQL Microsoft Excel Statistical Analysis.

You might also be looking for a person who is well versed in data visualization tools like Tableau or even power bi here quick site and should be good at identifying and accessing relevant data with extremely powerful insights into the analysis and drawing conclusions from this. We can take that out to become a company. analyst in Amazon as per this job description, you need to be good in SQL, at least not few Microsoft tools, good in data analysis, use Tableau or any other data analysis tool, statistical analysis and similarly, why Don't we look at each other? descriptions to understand better here I have considered IBM and again in IBM as you can see it predominantly asks SQL, next are the basic programming languages ​​along with again Microsoft tools, data modeling and modeling techniques are something more which has been asked at IBM here to draw conclusions.

From this, again, SQL, Microsoft tools, data modeling programming languages, here now, if you can see from the first statement, daily handling of scrum is also an important job of a company and the list, we will get to that Later in this session today, the next thing we're going to do is look at one more final description of the job to draw another conclusion, so that we have a clear idea of ​​what a business analyst needs to know. I've considered Oracle, where they are looking. for a project, accounting, project setup, maintenance, data analysis, support and working closely with the project team, everything is related to a project, now you can analyze here that a business analyst is a business analyst with respect to a project and with respect to a business that now depends on which company is hiring you?

So here we are considering a project. The skills needed here are project management. Microsoft tools and data analysis are again common: Microsoft tools and data analysis. Now that we have all these skills in mind, we can draw some conclusions about what the skills are. Becoming a business analyst is required now here on this slide, that's what we're going to focus on in the job descriptions that we just saw, we saw that SQL or any other database concept is something very, very important, Now knowing SQL is very important. As SQL itself helps in understanding data writing queries as a business analyst, the following are Microsoft tools now, if you are an experienced candidate and are switching from operator to business analysts, it is an added advantage for you like we, as identification professionals, would have done it.

I come across one or another or three, even Microsoft tools, regularly, so this is an easier aspect for us, so knowing Excel in an advanced way will always help you approach business analysis. Next are analytical skills, which are very important. aspect effect for a business analyst now we saw in one of the job descriptions that programming skills are also needed, of course there is no need to write codes here, it is not a core technical job anyway, so knowing the programming language basics will also help. You know that business analysts don't have to do any basic technical coding here, so knowing the basics of the programming language will also be helpful now, if you have a technical background, if you have a little bit of coding knowledge it will also be helpful, The following is statistical. analysis now knowing statistical analysis is very important as a business analyst, you need to review all the documents related to data or any type of information that involves statistical decision making, next is the program management skills, now all these skills that I am discussing here are In fact, the skills that are trained on our website now, if you visit edureka.com, you will find that there is a course for Microsoft Excel, there is a course for analytical skills, any type of programming language or even project management, there is a certification that I can also enter PMP, so as a business analyst, as I said, project management is one of the basic skills that are needed to know how to manage a project, what is a problem statement , how to satisfy the customer, what exactly the interested parties maintain.

Keep in mind everything, from start to finish, you need to know the following is Scrum management now, when you start a particular project, from the person who is a developer, who is an investor, who is the client, who is the end user, everyone should be on the same page for this scrum is very important, you need to manage what is happening today, what will happen tomorrow, everything and whoever does this is a business analyst, so scrum management is an important skill that a business analyst should need. data visualization tools like Tableau or power bi, similar things with which we must understand the trends we have now in business analysis.

The first thing according to 2020 agile was extremely inevitable now that the agile technique was not even implemented until probably 2020. of course it exists. There were companies that were also using but predominantly they were not implemented so after 2020 they realized that agile It is something that every company or every company that uses business analysts should implement the agile technique and then our main focus is the customers, he also said that customers are the king and therefore our focus should be on the customers, which Next is obviously visual thinking superpowers for product owners. Now, as a product owner, it is important for you to estimate everything related to the product.

Now it is important to have your visual power in the visual aspect. regarding the product, since even the customer needs to understand what his product is about. Now keep in mind that we are also one of the product owners, I mean business analysts who now take a product centric approach, like I said, customer is king, product is queen now. With the customer and the product being the center, any type of business can reach the end where such data moves forward by planning now all the data whose owners, who is the customer or who is the end user, anything should be included in the data and every day our work should be with respect to that and planning should be done with respect to the data that we have and the data that we have in hand and this is where our data-driven approach or planning comes into the picture, finally we must understand that cybersecurity is something that every company, whether large or small, should have a business analyst because this person takes everything into account and will always help you achieve our cybersecurity and keep your data safe.

Now data security is very important whether it is in a sensitive place. business or an open business, in addition to understanding that some of the tools that a business analyst uses to perform his analysis are the modern requirements for devops, click on the smart sheet Adobe Acrobat blueprint jeera core smart draw and many others now, these are the tools that are primarily and predominantly used in most companies, major mainstream companies per se, there are a lot more tools now, if you search the internet you can probably go ahead and learn about any of them, if that interests you, now learn at least one. will help and be useful to you as a business analyst, so a business analyst is someone who bridges the gap between the internal IT team and the business using data analytics to evaluate processes, determine requirements, and offer data-driven recommendations. and finally, present.

It informs executives and stakeholders, so let's dig into that a little. First, a business analyst is a person who comes between the internal IT team and the client and who has certain requirements, so a business analyst understands those requirements whatever it may be to build an application to get an idea of which direction their business should take, whatever it may be, they understand all the requirements of the clients and act as representatives of the clients and help the IT team to develop the results that will be satisfactory for the client that will help the client to make decisions based on data and that is exactly what a business analyst is,so now you might be wondering, that's all well and good, but what do they actually do to achieve this, so let's use an example of Stuart, who is a business analyst working for an app development company, that's the business analyst and Let's take a look at the client, so the client in this example is Martha who is an IT manager in a modern hospital and is tasked with creating a mobile application that allows her clients to schedule appointments, consult doctors, view their reports and medical receipts and make hospital bill payments through your online account, all without having to wait in line, which is a great inconvenience and inconvenience for patients, which is why Martha thinks instead of contracting a

full

service. team to make this app, she will simply approach a company that will help her with this, so Mata approaches Stewart's company to see if they can help her create the app, that is where she meets Stuart who has been assigned to work on Martha's project.

From start to finish, my is the vision behind the app and Stuart tests Martha to get an idea of ​​what the final product should look like. He assures Martha that she will take it from here and deliver the product according to requirements, budget and deadline, but how does she do it? He does all that well, let's find out, so in this section we will try to understand the roles and responsibilities of a business analyst using the same example as Stuart and Martha. Okay, let's get started. The first thing Stuart needs to do is understand the vision behind the app, what Martha and the hospital are trying to achieve with this app.

Here he correctly understands what are the motives behind these applications. He then collects all the requirements from Martha by asking her the right questions about the applications, he does this so that he can understand how the application should look like and how it should work, so he coordinates with Martha to collect all the functional requirements such as features and How customer data works. Automatic security payment system assistant in the app. Etc. and non-functional requirements like the appearance of the application. After documenting all this, he allocates resources. What does that mean? He assigns the various parts of the projects to the respective teams such as the development team, user experience, and user interface. equipment, etc., and finalize all the tools and software they will need for the project taking into account the client's budget, of course, and the deadline so that the project has been delegated to the appropriate parties and everyone is ready to compete.

To finish the project, his next duty is to make sure to track the progress and offer recommendations. So what do I mean by that? As the project develops, monitor its progress to ensure that the client's needs are addressed. She also makes useful suggestions to improve the project and points out corrections to be made if necessary to ensure that the clients' needs are met, but not only does she hold meetings between Martha and the assigned teams to discuss and decide how to rectify problems quickly. . An application is a complex process so errors are likely to occur and problems arise, so to resolve these, hold meetings so that everyone is on the same page, this also ensures that Martha is always informed and knows how to do it. . the project is moving forward so let's say they have worked hard and a prototype is ready so once it is ready you start user testing and after extensive testing you collect their feedback this helps with fixing improvements and the completion of the product.

This also helps in deciding whether the application has met the customer's expectations, gives an idea of ​​the improvements and fixes to be made, which are communicated to the development team and this cycle can continue until a deliverable product is ready, so The prototype has gone through a few iterations of fixes and improvements and now it finally seems to be ready, so now what Stuart does is analyze the data collected from the application and use data visualization tools like Tableau power bi to create reports that provide insights on application performance. These reports could be as simple as graphs in a document explaining the data or could be in the form of a dashboard with multi-dimensional visual reports based on key performance indicators of the application or outside of this example, it could be used to represent sales figures. business, employee performance and a host of other possibilities, but stay with me, let's continue with this example.

After analyzing the data and generating reports and presenting them in a nice visual way, now Stewart can move on to the last part of the project, finally the project is complete. Steward Document as all relevant information about projects, such as application documentation, how to use it and its maintenance. processes, etc., along with the findings and reports after testing, so what do you present all of this to Martha and other hospital stakeholders and give them a tour of the entire application and explain the reports to them and now it's the Stuart's product delivery time? all her roles and responsibilities in Martha's project and is ready to deliver the hospital's Health application to her on time and on budget.

Martha, her CTO, and the hospital are happy with the app; It will greatly help your clients and staff by allowing us to understand what exactly predictive is. Analytics is So, what is predictive analytics? Predictive analytics or analytics encompasses a variety of statistical techniques from data mining, predictive modeling and machine learning that actually analyze current and historical facts to make predictions about future or unknown events, so this is the basic definition of Wikipedia. So we basically use the previously collected data to predict an outcome or an event. Typically, historical data is used to build a mathematical model.

In our case, we can call it a classifier, predictive model or regressor that really captures the important trends and then. current data is used in that model to predict what will happen next or to suggest actions for optimal results, so let's take a look at several applications where we can actually use predictive analytics so we can use predictive analytics for many things first. of all, we have campaign management, so let's say we have a campaign, we have to determine what type of audience will be there or what type of target audiences so that we can analyze the previous data from our previous campaigns that we could have managed previously and Okay with that, we can find some suggestions or you know the course of action that we have to take, so this is a campaign management that we can do using predictive analytics or for recent examples, let's say an election campaign, you know a lot of people .

We are collecting a lot of data from previous elections, like how it happened and what are the main factors that led to the victory of this or that person, this is how we can use predictive analytics in campaign management, then there is the acquisition of clients so we can We look at the entire business and we can figure out different points for you to know, figure out what kind of tasks or events we can actually produce to improve our business so that we can improve customer acquisition and then we have the budget. and forecasting also, similarly by looking at the above data we can finalize some budgets and forecast some related indicators for example we have stock prediction using python or any other language like R and then we have fraud detection so we can know about it. they manage a lot of data, like credit card companies, they use hundreds and hundreds of users and they analyze the data to predict or detect fraudulent transactions in their data and then there are also promotions so we can analyze, you know, Target audience, we can follow the trends like the following, you know the types of content that they are really looking for and then similarly you can do promotions according to that, then there are prices, you can also find out, let's say you have a supermarket. like if you know what Walmart does then you have all the prices and everything so what you can do is calculate the price of a product after several times based on recent purchases and also recent scenario or history data above on which the price was based. has been distributed accordingly and you can also plan demand using predictive analytics so these are some applications that I can think of right now and these are just some applications where you can use predictive analytics to predict e.g. , I' We'll talk about football players, so let's say you have a favorite player and in the next season you want to see how much price he could reach in other clubs so that you can make use of the data on your B and depending on the purchases.

That happens in previous seasons or windows, you can actually estimate a little bit what kind of price your favorite player is going to get, so that's an example that I can think of right now, so these are some applications of predictive analytics. Now let's move on. Let's move on to the next topic of the session guys which is the steps involved in predictive analytics so this is a very important concept in this session guys so you need to

full

y understand what kind of steps are followed while performing a predictive analysis so that the The first step has to be a data exploration, so what you have to do is collect data, load it into your program, then you have to take a look at your data in a perspective that will clarify certain things for you, such as If I had to find out what kind. of data you are dealing with what are the columns what are the characteristics you have within your data what type of data are how many numeric values ​​are there what type of data types are within your data whether it is a CSV file or not so on , you have to discover many things while exploring the data and after that you can find out how to clean your data by cleaning.

I mean, you have to find out the redundancies that could hinder your model, so for that you have to check. for null values ​​you need to check for missing values ​​and then you need to figure out what kind of columns will actually be better if you put them inside your model and what are the redundant variables, like what kind of columns you can actually remove and there is no difference in your model, so it covers the data cleaning part and then there is the modeling where they have to model or select their predictive model so there are many models that they can go for but in this session.

I am going to use linear regression model because it is very simple or basic so

beginners

will also be able to learn it properly after modeling. You must verify the evaluation or verify the accuracy. how your model is actually performing, so let's talk about these steps in a little more detail, so first we will talk about data exploration, as I already told you, data exploration is collecting your data and then taking a look at it . in a perspective that will clarify many things, for example, you will be able to see the number of columns, the number of rows, you will have a description of all the data types, what type of variables there are, you will have the mean values, the average values. minimum values ​​and you can also check the unique values ​​in your columns so all this comes in data exploration and after this the second step is data cleansing and I already told you that data cleansing is basically getting rid of the redundancies in your data including missing values ​​that can get in the way and you need to make sure that your model does not cause overfitting or underfitting due to noise and noise is basically irrelevant data that can be in the form of null values ​​so you need to make sure of getting rid of them or replacing them with average values ​​in the column and then there are redundancies like outliers that are not necessarily needed in your model so you can remove those as well so this is all about data cleaning and then we have The third step is modeling.

For data modeling, first of all, you need to understand the relationship between the variables in your model so you can determine what type of model you are going to choose, for example, if let's say if. you have a target variable in our case which will be the price of certain goods so let's say you have to find out the relationship between the variables so if you are going to do a linear regression you have to make sure that the relationship is continuous and let's say Yes, if you choose logistic regression, it is important that you choose continuous variables, the target variable, although it has to be dichotomous or what you call categorical, which is like let's say that if I am trying to predict something using logistic regression, the concept it would probably be yes or no or be one or zero something like that, but in case of linear regression we have to make sure that there is somecontinuous relationship between the variables, which is my target variable and my independent variables, taking a look at the fourth part or the fourth.

The final step and step is performance analysis, so once you are done making a model, you need to do some analysis, which is to check the accuracy of the model and make sure it is above 70. I mean, if You are a beginner and if you are trying to make your first prediction model any accuracy score above 70 percent is very good, but I would suggest that if you are working on a good model and you want your model to be good, the accuracy should oscillate around 0.9, which is nine more than 90 and if you get it the first time it's great, but it just depends on your data and the type of model selection you do, so let's take a look at the next topic in our session guys so this is basically where I'm going to perform predictive analysis using Python on a data set so I have a problem statement where I have a data set that has certain values ​​or certain variables that has columns like Do you know how many bedrooms a house has and what type? of square feet is uh grabbing and all these things that I'll show you in the data and using that data.

I'm going to predict the price of the house, so let's take it to the Jupiter notebook guys and I'll show you what. I'll do it there, so I have a Jupyter notebook here guys, and if you're not familiar with the Jupyter notebook, I suggest you check out our

tutorial

on YouTube. We have a

tutorial

for the Jupiter notebook, you can learn it. right, I mean there's actually not much to learn in the Jupiter notebook, it's pretty easy, that's why I'm also using it and we also have a cheat sheet so you can do it, so first of all I'm going to import some . dependencies so for the first step which is data exploration I have to get the data, for that I will use pandas library and import some other libraries as well as use c binding to check the relationship between the variables basically for the Eda exploratory data analysis and if you don't know what Eda is, I suggest you check out another tutorial which is exploratory data analysis that we have on our YouTube channel and then I'm going to import numpy as well just in case, okay and you can see boys.

I just have to press shift and enter and that's why I'm using a jupyter notebook because the implementation is very easy and I can segregate my data or code into different cells so I'm importing this and I can do it right. I'll make it a little bigger so it's visible to all of you. What I can do is comment out a part, let's say install dependencies and it's a separate cell. that makes it quite descriptive when you're coding and when you're trying to figure out what's wrong in your code it actually helps, so after this what you have to do is check.

I'll have to import the data for that. I'm going to use the CSV reader module which will basically go to the file. and read my data guys the file name is house.csv we have a truncated error so guys I have to show you something. Usually when they do this, when they copy the file location, they get that Unicode error, but let's see if I change these backslashes to black forward backslashes. What's going on? Do I still get the error or not, okay, we're right, so I was doing something here, so this is an exercise for you guys, like before when I was using the backslashes that I was getting. a Unicode error, but when I change it to backslashes I don't get that error, so this is a question for you guys, tell me why you think it happened in the comment sections below.

Now I will continue. I'll take the first look. my data guys, so I'm going to use the head method to get my first data, so these are the first five rows in my data guys, so I have an id, we have the date, the price is there, rooms, we have bathrooms, living square footage and lot square footage. We also have apartments. The waterfront is zero, okay, it has to be zero and one. I guess there's view and then level square feet above, so these are the columns that I have inside my data, guys, so I'll check the last five rows as well.

I'm using the tail method so as you can see, you can first see your data using the data point head and data point tail method. After that I checked the columns of my data and let's also check the shape guys. that we will know what we are dealing with, okay, it can't be called, so we have 21,613 entries with 21 columns, okay, that's a pretty big data set and let me tell you that this is a data set that I found on Kaggle. it is very easy to find the house data set and I am using this example of house data set because it is very common and to find this data set it is very easy: go to kegel and just search for house protection data sets the house and it will show You have many datasets that you can download there okay so you can find the dataset on Kaggle guys now we have also checked the way okay I will use one more method which is data or describe , everything is fine, this can be called everyone.

Okay, so we have all these numerical values ​​and using the describe method we can get the maximum minimum of 50 and the standard deviation, we can get the mean value and the count as well, so let's say for the bedrooms the mean value is three, the most common entry. in the bedrooms section there is a three bedroom house and then for the bathrooms there is also a two bathroom house the square footage is almost two zero seven nine square feet and then for the maximum values ​​we have even a 33 bedroom house also and we have a house with eight bathrooms and the square footage is 13540 okay so the minimum value is we have a house with zero bedrooms okay that will be something else and square footage is 290.

This is how you use the description method and this is the first step guys what I'm trying. To do the data exploration now, after this, I think I'm pretty sure what type of data I'm dealing with. Now, what am I going to do. I'm going to move on to the next step, which is to verify the relationship. between these variables, for that I will use data visualization and I will use some plot points using cmon library and if you don't know about c bond we have a YouTube Tutorial about c-bond library also so you can discover different types of graphs that you can use for data visualization and data visualization is nothing but a process where you can visualize your data and you can try to find out the relationship. among the above variables I want to check for null values ​​or missing values ​​because I don't want to have any hindrance in my data set while I am modeling so first of all you need to check for null values ​​and let's get a sum too so we have zero almost fine, so we don't have null values ​​in this data set, usually if you find a null value and if it is a large data set, let's say if all these values ​​are, let's say 2000 and if you have 10 missing values, you can remove those 10 values ​​but if there are more null values ​​you just need to replace them with the middle value and to find out the middle value you can go here let's say if you have it let's say if checking in the bedrooms how many null values ​​there are and Let's say there are 500 out of 21,000, so you can replace the zero with this value which is three and similarly for any other column you can do the same using the middle value as there are no null values ​​within this set of data because it is a very clean data set that I downloaded it from Kaggle so we will move to the next step which is visualization and many guys this is the step in my data exploration part and the data cleaning part, no the other steps that we use for predictive analytics, okay, so I don't have null values, but there are some redundancies that I want to get rid of.

I'll talk about that later, first of all, I'm going to use a ratio chart relationship between these variables, so I'll check the bedroom, okay, type equals okay, I won't use type, data equals data, okay, okay, then I think we can like it, there are almost so many, I mean, this is a ratio that I'm getting here, the price is It's not very clear, but we're getting the ratio of the rooms or the most common room, so it's over here, it's zero to five and so Similarly, I can check other variables as well as the bathrooms, see you, so the price is actually increasing with the number of bathrooms, but it is not necessarily the same for everything, so there have to be other dependencies too because, like you can see since the surprising price of the bathroom isn't actually increasing that much okay I'll just copy this for the rooms the price is actually increasing quite a bit with each room I mean not really if we take a look at 10 rooms, also the price is about the same so I can't think of any deal breaker for this so we'll check if there are any others.

Also, we'll check the first query on living square feet, so this is a linear relationship that I'm seeing here guys, so with every square foot that goes up, most of the prices are actually in this area just like 0 to 40,400,000 or 40 million actually, but we can see that it's a linear relationship with every increase in um square feet, the price is actually increasing, so this is something that has to be in there, it's a train game I'll tell you what a train game really is. So there is floor, we can also check if there are floors, okay, so floors are actually quite descriptive here as well because most of the values ​​are in the two-story area and then we can check if there is waterfront as well, okay , we can make one.

I'll tell you a trick, so we'll add the tone here and this is what will be on the front, so the houses that actually have a waterfront are in oranges and the other ones are in blue so you can see. the relationship between them and similarly I can use others okay so let's say latitude and longitude so you can find out the relationship between the variables using visualization so for me I think in this data set to get the price we will have to use bedrooms bathrooms there has to be a lot of square feet there has to be a lot of square feet floors we can also get and then what view front view we will use square feet and we have to use and its construction and you are renovated We can omit it from the train set and the code Postcard.

Also, we don't really need the latitude and longitude to be decisive in the prediction either because we can use it for visualization and we can get the image from there and the square feet of life is. Really important, these are the redundancies that I was talking about within your model, so now we're going to move on to the modeling part, guys, so what I'm going to do now is import some dependencies, guys, from the SK loan, so first . All I have to do is import linear regression from linear models and I'm going to import linear regression correctly so I'm going to import model selection we're going to import ant split so the first thing I have to do is segregate my data into our training set and a test set so I'm going to do one thing right guys so I'm going to get my data in this cell so two things that I don't actually need inside my data is the date because I'm going to get the training data o I'm going to write it as train so it's going to be data and I'm going to delete some columns so I'm going to have to delete so I have to delete some columns so first of all I have to draw the price because it can't be in my set of training since I'm going to predict it and then there has to be an id, we don't actually need that and then I'm going to leave the date in as well, there's not really much to test here, so for now I'm just going to remove all these columns and, for our test set or the dependent variable, let's say I am going to take the variable as test let's say, and for this I will use the data point or what we really need is just one column which is the price method, the objects are not subscriptable .

Sorry, I made a syntax error here, guys, I also have to add the accessor, now it's okay, so now what I'm going to do is use, I'm going. to segregate my data into 3 and we have the random state. equal to let's say 2. Okay, so we've made our additional extension method. Now I'm going to use a variable, let's say our EGR regressor and now I'm going to call my linear regression model. It's done guys, so now I'm going. to use the fit method to fit my Xtreme train data andX and, boys, training data have to adjust properly, we have no mistakes here, boys, after this, I can, okay, I will take a variable, say predict and now the GR DOT predicts x test E Y Test, okay, wait One second, guys.

Sorry, now the modeling part is done, so I'll explain what I did here. I took linear model which is linear regression and then segregated my data into training and test set. I am using train test board before that I segregated the data for my model within which I am using training set which has all values ​​of data set except price id and date so I removed these three columns. because I thought these are redundant for my model right now and the variable I'm going to predict here is price so I'm going to take it alone so then I use the train test split method to separate the data in training. and test set and then I call the linear regression model here using the regression model.

I am fitting the training data and then using it to predict the value, so now comes the way we have to check the efficiency of the model, so for regression models it is very easy guys, you can just check the score for this, you need to provide some values ​​from test That's pretty predictable to get this kind of precision, but you can do a little more to improve the precision. I mean, you can look at the data and remove all the values ​​you find that will help you improve your accuracy, just like you can remove latitude. length, you can remove the zip code, it's renovated, it's built, you can remove the water frontage and the view as well or keep just some values ​​that you really need, which are bedrooms, bathrooms, I think, and it's all related to the square footage that if you maintain your training set then it will be more accurate for you, so now that we are done with the session, I want to give you a type of exercise that you can do to practice this, so I have used the linear regression model. here, so I want you to do one thing guys, check out other classifier and regressor models that you can use to predict a value.

I mean, we have a tutorial on all of them on our YouTube channel and see if you can use the same data to make. a prediction model that uses other classifiers like a random forest classifier, then we have a decision tree, then you can use logistic regression for this as well. I mean, if you have continuous data, then you can go for linear regression, but if you find categorical data, let's say we have Waterfront or not, so you can check that also overseas to start with, let's start with the statistical functions. The first is the average function.

What does the average function do? It is a built-in function in Excel that is categorized with statistics. The average function does exactly what it says and works similarly to addition. It will return the average value of the given series of numbers in Excel. Let's say we need to identify the average salary paid to the employees of the organization, while our salary data is in column H. then what I will do is enter the average function followed by the open bracket in the cell we need the result in our case is J2 so I start with an equal to average income, I open the bracket now I will have to select the cell range for which I need the average and in our case it is the salary column which is h2h now close the parenthesis and press enter.

I get the average salary as 15538 this is the average amount paid to each of the employees in the next organized function in our list is the median function the median function is again a statistical function that returns the median of a given number what is the median is a middle number in the set of numbers, that means if I have 10 12 and 15 Then there are three numbers that I have. I have to identify the middle number of this, so it's equal to. I'll use the median function here, just to identify what the middle number is and then select the range of cells that has numbers, close the square bracket, enter, it will give me the middle number, which in our case is 12 because it's not the most high, is not the lowest, but the middle.

The same thing happens if I want to know what the average value is in the salary column. I'll use the median function in cell L2 equals the median. Open the parenthesis, select our salary column, which is h2h, close the parenthesis and enter 15750. The average value of the salary column next we will see is the mode function, the Excel mode function. Returns the numbers that occur most frequently in the numeric data set. This function only works with numbers, it will identify the amount or the number that occurs the maximum time in the range of cells, for example here we have the basic salary where I can see that the highest number is 49,000 and then there are few employees who earn the same salary, but I want to identify what salary the employees earn during the maximum time so I can use a mode function equal to mode open parenthesis, it's just the mode select mode open parenthesis and then select the h2h column because I want to know about the salary column close the parenthesis 17500 is the quantity that occurs the maximum time in the ranges of this cell moving to the next is the standard deviation function what is the standard deviation? is a formula to identify the standard deviation of the set of numbers the standard deviation function calculates the standard division on the sample set of data the standard deviation is a measure of how much variation there is in a set of numbers compared to the average of the numbers, the point s standard deviation function is intended to estimate the standard split in a sample, if the data represents an entire population, use the point P standard deviation function, so we'll look at our standard deviation sheet here I have a sample of data, so a sample of some students who scored a particular number or a particular score in the different subjects has been selected, so we have taken a sample and we have not collected all the data of the students, so if we are using it only for a sample we will use the standard deviation which is the standard deviation point your estimated standard deviation based on the sample you know the logical value and the text in the sample so it should just be numbers, okay, so it's the standard deviation point.

When you have sample data where you just want to identify how much variance there is compared to the average, you will use the standard deviation points, but if you have an entire population, that means you have all the scores for all the students. in school or university you will have to use standard deviation dot e, which is also there, calculate the weight of standard deviation in the entire population given as argument, but here we are using standard deviation for sample data, so I select that and then what I need a standard deviation for, I'm just going to go and select that particular range.

I close the parenthesis. I press enter. It's giving me 4.89, which is a standard deviation value for those scores. This is how your standard deviation works. The next function is we're going to look at in our list when we're reviewing our list of functions is our big function what does a big function do big function Returns the nth largest value in the sample, for example if I go back to my data where I have the salary data or the list of employee salaries I have to identify what is the highest salary I am paying. I can do it using sort and function but it may be that as of now I have sorted this data but then this person has Asha Trivedi. moved to a different department head, Sheetal, Desai left and Asha Trivedi moved to the board list, not only Asha, we have also identified Bharat to move to the board, so now we have two boards of directors, but both. their salaries will be a little different, let's say I will change the salary of the loaned director to 51000 for Bharat and for Ashra Trivedi it is around sixty thousand, so these are the salaries that we have decided for the director of Deborah, which is now two together directives. in this case if I have to see the first Value First find out what was the largest value in the salary section without changing the two values ​​that I had now so it is equal to large, open the parenthesis, I will select the array which is our salary and K when I say what does K mean k I have to say what highest number does that mean, if I want to know the first highest value or the first largest value in the list I can put the number as one but if not I don't want to know the first largest salary.

I want to know the second largest salary paid to the employee. I'll press number two to close the parenthesis. Enter now. If you see that our largest value is actually 49,000, however, the answer you'll get is twenty-four thousand and five. hundred why, because we are looking at the second largest value in the range of cells, if I am looking at the fifth largest value, I will put it as 5 and press enter, it will give me the fifth largest value in this set of cells, so which is 22750. like in our example where I mentioned that ashwat Trivedi will now move to your board of directors, let's not remove Sheetal Desai for now she is still in the board of directors, we also move Asha Trivedi to the board of directors list and this time the board salary that I am moving to is 60 000.

So when I say that the board salary is 60 000, when I move this salary now and say what is the first largest salary, the first salary budget will be sixty thousand. the second largest salary will be 49,000 instead of twenty-four thousand five hundred because now there is even a larger salary the first largest salary has become asha's salary which was sixty thousand before it was forty-nine thousand it was the largest so that this way if you keep changing the salary of others, let's say I get to 65,000 just to get a general idea of ​​how it works. If you see that before it was 49,000 Watts, the largest, now sixty thousand has become the largest salary or the second largest salary.

The same goes for a little one. I am trying to identify what is the smallest salary I am paying or the lowest salary I am paying the employee. Now again I have to give the K value. Now the K value again as I said, it will be the value of which smallest number you want to know is the first smallest you want to know is the second smallest you want to know or the lowest you want to know is the third party you want to do it as per what is your requirement, you can put the number there, for example if I put 2, it will give me the second lowest salary paid to the employees of the organization which is seven thousand, if I make the lowest salary is even lower, let's see what our lowest salary is 5950, let's make one of them 5500.

What will happen now is that if I go back and see the second lowest salary value, it is now 5950 because the first one now it has changed to 5500 so depending on your value what is your lowest salary it will automatically calculate and give you that number so move on to the next one which is our Coral what is coral or is correlation, you can say that we can use the correlation function in Excel to find the correlation coefficient between the two variables. I'm sure we've all learned coefficient correlations back in our college days, when we were doing math in college.

If you had opted for mathematics in college, you would have done the correlation coefficient; However, if you hadn't, it's no big deal. Excel is already doing it for you. The correlation coefficient formula is used to find out how strong the relationship is between the two data, like here in our case, the relationship between the age and the relationship between the person's glucose level. Is that the age? increases and the raw level increases or is it that age decreases in the glucose level decreases or is it that age increases and the glucose level decreases and vice versa, depending, we are trying to understand what is the relationship formula that always returns a value between - 1 and 1.

What is the ratio of negative one and one? Why does it always give you -1 and how does it branch or split? If your relationship is one or close to one. I would say that 0 to 1 would indicate a strong positive relationship. A correlation coefficient of 1 means that for every positive increase in one variable there is a positive increase of a fixed proportion in the other, for example, true sizes increase in perfect correlation with the foot length, so when your foot line increases your shoe size increases, so it is a proper correlation, that is, when your only correlation is exactly how much your feet size increases, your actual size increases If the correlation coefficient is minus 1, it indicates a strong negative relationship, our correlation coefficient of -1 means that for every positive increase inone variable there is a negative decrease of the fixed proportion in the other, for example the amount of gasoline in the tank decreases in perfect correlation with the speed every time the amount of gasoline in the tank of your car decreases, so when you are racing the car, if you are increasing speed your gas keeps decreasing, because you are increasing speed so gasoline is being used or fuel is being used and that is why fuel is decreasing but your speed is increasing so what there is an opposite reaction the fuel decreases but your speed increases this is how your ship works coefficient correlation if in case of -1 if the result is zero it indicates that there is no relationship zero means that for each increase there is no decrease positive or negative the two are simply not related anything that is zero no relationship at all one where there is a positive relationship which means that with the increase the other part will also increase while with minus 1 it is the opposite side with an increase the other will decrease, that is the three differences that you will see of course you will not get the result as 1 minus 1 or 0 it will be in the middle so we will try to understand that if it is between 0 and 1 then it is positive if it is between minus one to zero then is negative 1 and if it is 0 then there is no relationship so let's look at an example on our sheet where I have the age considered as the x h value of the person and then I have the glucose level of that person considered as y, we are just trying to identify what is the relationship between human age and glucose level in your body, so if you see human age, level does it make sense just by looking at it because we can't identify what the relationship is, is it minus one, is it one or is it zero, so to identify can I use a function called correlation function, which is coral? in Excel, in the cell where I need this result, it is equal to Coral, I open the square bracket and then I will select the different matrices for which I need to identify the relationship, so the first relationship that I have to identify is the age, so I will see that age versus glucose level so age is in B2 to B7 so I will select that as the first matrix the second matrix is ​​c22 C7 so I select that second matrix which is from C2 to C7 and close the bracket , press enter, it is giving me a value like 0.53 if I remove more decimals than I have then our answer is 0.53 which is a positive result which means that there is a close relationship between age and glucose level when it is positive it means that the increase in age does not increase glucose levels in the body if this was a negative point then it would have been the other way around, that increase in age reduces the glucose level in the body, this is how its correlation function works, let's see another example that we have in our sheet that is a correlation function we have the price of the stock that changes or the percentage change in the price of the stock a and then we also have the weekly change of the S P 500 or the percentage change of the SNP 500 the S P 500 is a stock market index that tracks the stocks of 500 large-cap American companies.

It represents stock market performance by reporting the risk and returns of the largest companies. So what we are doing here is identifying if there is any relationship between SNP change and stock change? So if there is a relationship, they will be able to make a proper decision in the future when they make some investments. To start, I'm going to figure out the correlation, so I'll do the same as Coral, open the group now. I have two sets of data which are two way arrays so I will select the first array like this which is comma C5 to c24, the second array will be D Phi to d24.

I close the bracket, press enter and you will see that it is very close to 1, so it is 0.89 or rather 0.9, this means that every time there is a one percent increase in the S P 500, then there is a one percent increase in the stock and the prices are the same similarly, if there is a decline in the S P 500, consequently the stock prices will decrease by one percent, thus is the exact correlation, while In the example above there is a correlation of 0.5, which means that when there is a one year increase in age, five percent increase in glucose level, that is what the correlation is like. identified using the choral function in Ms Excel next we are going to see the graphs in Excel what are the graphs when you want to graphically represent some data it is very difficult to interpret the Excel workbooks that contain a lot of data the graphs allow you to illustrate your workbook data graphically, making it easy to view the comparison sentence Excel has several different types of charts that allow you to choose the one that best fits your data.

In order to use charts effectively, you will need to understand how different charts are used, so we will start with the column. charts, so you're going to see all of these different types of charts that we're going to learn today, so to start, we're going to go back to our example sheet where I have the sheet for the column chart, which means there's data that's already available where I have the region data or rather the sales data of each region which is divided into two years which are 2016 and 2017. This data is in millions so you can see that Mumbai made sales of 65 million in 2016 when it made sales of 70 million in 2017.

The same goes for London, they made 55 million in 2016. while in 2017 they made 65 million in USA, you can see 45 million 52 million, while if you see Nagpur you will see that the sales have reduced from 2016 to 17. This is smaller data here, so you can even identify where it's going. incorrect and how it relates, how the comparison is made, instead of doing that, if you want to send it to your management, you can simply select this data and create a graph that will show the exact comparison on your screen and represent it graphically. How do I do that? I am going to insert in 2016.

A new option has come up which is called recommended chart which means whenever you select some data and then click insert it will give you an option as recommended chart where Excel will recommend the types of charts that will look good with this type of data or rather it will adequately represent the data that you are seeing so I select the data that I want the chart for and then go to the recommended charts when you go to the recommended charts you will see that there is a first chart you recommend: the column chart, this is your column chart but as now we are looking at the column chart we will start with or each type of chart we will start with the column chart from time to time we will come back to the charts recommended for you to see the first, the column chart is your even in the 2016 icon, the first 2D chart you can see is the column chart.

I click on it and If the data is next to each other, when is the column chart actually used? School, the column chart is useful in this type of data where a comparison is required, so column charts use vertical bars to represent the data and can work with many different types of data, but are most often used for compare information like in our case 2016 and 17. So I have this data as column chart and it is compared between 2016 and 17. Now looking at this chart it looks very good however you will see something is missing as when I look at the Mumbai data, if I don't see this table, I won't be able to identify what is the actual sale made by Mumbai.

I will have to mouse over it to get the number when I mouse over it, it says series 2016 Point Mumbai value 65, it gives you all the data; however, if I am outside of this data, I will not be able to see the information in one go, it only shows which hole is the smallest. In Gujarat I can see that in 2017 they have made less sales compared to 2016. But I need the exact number so to get the exact number what I can do is one way to do it I can go and see it by doing a Hover he.

Another way to do it is to simply watch it. I can add the data label. How do I add a data label? There are different ways to add a data tag. One way to do this is to first select where you want to add the data. The label says I want to add the data label for 2016 and 17 to both bars so I can't do it together so what I can do is select one at a time using left click and then right click on that same data and then. click add data label once you do that it will add those numbers in that data.

Secondly, I can do it for 2017 as well by selecting it; however, there is another way to do it if I now want to delete the data table, so I just select and click delete from my keyboard and it will work now if I don't have the data labels here. I want to add them using this plus sign it is only available in 2016. when I select the chart there is an option like plus sign I click on plus and click on data labels it will automatically add data available for both bars. I don't have to select each of the bars, this is how the data labels are added now if you can see there is a Y axis. which is provided here, which has some numbers, why those numbers are there, because before we didn't have data labels and that's the reason we could see with these numbers where our laser sits just above 60, somewhere between 60 and 70, so I'm guessing it's 65 that's how it was displayed, however, now that I have the data labels I won't need this information or I don't need this access on the left side, so how do I remove that excess from the left side that you can see?

Again, there is a way to do it: go to design mode, which is after selecting the chart, go to design mode and then add in Add Chart Element. I'll look at X, which is the X axis that we used to call other. It is the main vertical axis. The vertical axis is the vertical that is on the left side that we are talking about. This is your main vertical and this is the main horizontal, so I want to remove the main vertical from now on. Both are highlighted. It means they are both there. I want to remove the main vertical, so I'll select it to just disappear.

That's one way to do it easier or the quickest way to do it is to just select the B axis, being very careful that only the axis is selected. You'll see that for a small wall it's kind of like something that comes in all four corners of that axis. Once I do that, once I select it, I can press Delete Del from my keyboard and it will disappear. The third thing I can see in this graph. is the title of the graph. I have to add a title to this chart, so how do I add a title?

This is already on the list. I just have to add the title. I select the data there and add the title as sales comparison or sales for two. years and in the parentheses I will put millions so that they are not confused, why is it only shown 50 40 or whatever? This is how I can display my data. One more thing I would recommend doing is removing this. Grid Lines Grid lines will be more useful when you don't have the data labels because then they will give you where exactly your data sets with the axis and you will be able to see the number, but when I don't have them, I don't need these lines. grid at all, so I'll just select the grid lines and then click delete on my keyboard.

That's one way. Another way to do this is to just go to the plus sign and press this grid line. The grid lines are there. default now if you see the data it looks even cleaner or it looks even more presentable because there are no grid lines at the back everything is clean this is how you can modify your data as per your requirement this is how your column chart, but you can also do the same with the other charts. There are other quick things you can do with the chart, such as also changing the chart type if you want or changing the data you have selected to select this data in To get this chart, however, I want to change the data so I can click that design.

In the bottom layout, you will see below data select data. Once I click on that selected data, it will give me an option here to change the data range. the chart, so I can click on this data range to change the chart. A very important part that you will see here is changing rows or columns, so what happens is that from now on my Y axis only contains the numbers and the x axis contains Mumbai, London and everything and the data, which is the colors or the bars that are there, that are in the colors, i.e. 2016 and 17, which is the year, are displayed in two different bars now, when I click on this row and column switch, what will happen is all the region that is there will become the colors of the different bar or bars, while 2016 and 17 will appear in the XXX, let's see how that happens by simply clicking on change rows and columns, once you do that and click OK, You will see that 2016 data is displayed below the x-axis and all bars are now displayed with theaverage of the price row area, which is this part, placing a data field in the row area displays the unique value of that field in the rows. on the left side of the pivot table that means I said I want to do it or the department when I drag it to the rows it will pick up all the unique value so even if the manager appears 10 times in our database like administrator.

It comes many times here, it will only be displayed Once in the pivot table, the same goes for CCD. The same goes for the directive. What does that mean? It will group all the managers and then add the manager's salary in the next cell where it has been added. the values ​​and it will give me the response period, so it will give me the salary only for administrator, then for CCD and then for director, finance, marketing, personnel, assistant and sales. This is what your database will look like if you place the data in the pink area below. is the column area, the column area is made up of headers that extend across the top of the column, which is this, so if you want to give a header other than this, if you want it to be show things like region in the column, if I put column what What will happen is that now it will show me east west north, which will be divided according to east west north south in the column and it is a kind of header that is in the top as for Este and Edwin, this is a total salary.

This is how you are giving the split: Next is the filter column or filter area the filter is an optional set of one or more drop down lists at the top of the pivot table here the filter area contains the field region the pivot table is in set to show the entire region like this if I put it at the top here it's actually an optional area but it will just show me the region at the top and then it won't show in the column. The filter area allows you to apply filters easily. to the pivot table, for example, if I leave my region here and try to put a branch in the filters column, I can select which branch I need the data, for example, if I only need ambala, I can click on ambala and click OK . they only give me data for ambalas same way, if i select the rest of the other data it will give me the list for others, if i want more than one data i will just click on select multiple items and i can select two, three at a time . and then it will filter based on the branch and give me the rest of the data.

This is how your pivot table actually works, as I said, you can use these value field settings to perform the other calculations with this value field settings. this is how your data or pivot table works now. This was a simple part of the pivot table. If you ever want to sort on the pivot table, first let me remove the region to make it look easier so understanding it will be easier. I'm also checking the branch from the filters. I just left the department and the sum of the basic salary. Now what I'm trying to do is filter based on salaries, so I want to know what department I'm in.

When doing the maximum salary, I select the salary column or simply click or hold the cursor on the salary column. I go to data and the same way we do sorting, I'll just click sort there once I do that, it'll give me a wizard where I have to select whether to sort from smallest to largest or largest to smallest. I will do it from highest to lowest and I can see that in sales department I am giving the maximum salary which is 3 lakh 45,075 so this is how its sorting works in the pivot table so there are other things that you can also use in the dynamic table that are really very important and that we are going to see here.

There is something called slicer and pivot table. slicer and pivot table and how that works when you go to analyze data there is an option called insert slicer if you are somewhere outside the pivot you don't keep the cursor on the pivot you won't be able to see the analysis button to go to analyze button you need to click on the pivot table and then click on analyze, once you click on analyze, there will be an option called insert slicer, now insert slicer in the sense that it is a kind of data filtering, of the same way. as i did to put the branch on top or region on top where i could filter the data, i can use slicer to filter this data, so if i click on slicer and select with which field I want to filter them, like I want to filter it with the highest date.

I can select it and hire it and click OK. Now it will give me a slicer or the list of highest dates that I can select from, so if I select only this highest date, it will automatically give me data. only for employees who have been hired on this particular date, so this is Javier's visualizer. However, now you can see that in the slicer, I can only select one data or one date at a time, but if I want to select more dates, then there is this something called multi-select which is in the top right corner and which Is it only available in the 2016 version?

So when I click on Multiple Select, it will give me options to select multiple dates at once in the slicer, so that's not necessary. you just have to do the dates, you can also add more information besides the dates, click analyze. I go to the slicer again and now I can select anything else I want. Now the department is already there. I can select maybe Rama this time. so it will give me another slicer so I can see the other slicer that is here, so now there are two slices, so you don't have to be able to, you just have to work with one slicer, you can work with two slices or multiple slices.

I select Calcutta. and file and it gives me data for replica and ardu link for these true dates, only if I select one more date it will give me data for Kolkata Darjeeling for these three dates, so slicers can be multiple slicers in list and it gives you information as per your requirement how to create chart from pivot table and also it looks same as normal chart so when i click on database from where i want to create pivot table and then click on the pivot chart By going to the Analyze button and then to the pivot chart it will automatically create the chart that I want similar to how we get the column chart in this case so I click ok once I do that it will automatically create the chart where you can do it similarly.

In the normal chart you can name it as the title of the chart we are looking at, add the data labels by clicking this plus sign and click ADD or just add data labels once you do that the data labels are will add to all these fields. where you can see some of the Basic Salary Department if you don't want to show it in the table because it is a pivot table chart it gives you this information and also if you want to hide it you can right click and click hide. all the field buttons in the chart, it will automatically hide those fields now if I add additional information like in this, you can only see that the sum of base salary is given, there is nothing below the row columns, so what can I do is that I can also Add data in the row once I do that it will also automatically update the pivot chart and give me the information based on the column of the row, now also like where we had used or changed the chart type by selecting the data and changing row to column you can use similar function here to change from row to column so here the data will be displayed in a different way all together so as you update your pivot table your pivot chart will also be displayed Keep updating and all the same functionalities that are available in normal mode.

The chart is also available in your pivot chart, the only difference is that it is linked to your pivot chart, the other data is linked to your database, that is the only difference, but the pivot chart when you look at it is very very useful because your dynamic chart graph so on updating based on the new data that is updated there also you are just giving the information or just asking for the information you want in the graph instead of everything that goes into the graph and then you select which routes you want to show, this is how your pivot table and pivot charts work if they are really useful in the daily reports that you do for your companies and they really will be. help you do that now we have also learned how to make pivot table and how to use slicers in pivot table.

There is another important part of the slicer is that you can link two pivot tables to the slicer, for example here I have a pivot table that breaks down the department and gives you these total salaries based on each department. Now I am creating a new pivot table from the same database. Let's say I just copy and paste, that will also give me another pivot table, but I don't want to. Department this time I want to know the salary that is given to employees in different regions, so this is divided according to the region. The slicer that I can add here is by clicking on any pivot table that I can select and then clicking on Cut to analyze and then click on insert slicer, the slicer will be based on region, date or last name, whatever you want from From now.

I am selecting the branch and clicking on OK, once I click on Branch it will give me the branch options. with which I can select and analyze the data, but what I need now is that I want to link this pivot table, which is a pivot table 2, to pivot table one, which means that when I select ambala you will see that only the second pivot table has given me the data for ambala which is a northern region, the first pivot table remains as is because this slicer is only linked to pivot table 2. I want to link this slicer to both pivot tables, how can I do it?

I'll have to click on for slicer, right click on that and then click on report connections. Once you click on report connection, it will give me the list of pivot tables available in your workbook. Now we know that on sheet 1 we have both pivot tables. Sheet 10 is not ours. sheet so both pivot tables are on sheet 1 so I will select both pivot tables from sheet 1 and click ok once I do that now I will be able to link both data and now when I select bangalore or a branch, it will. it automatically gives me data for that branch just like that training will give me data for that branch the same goes with ambala or aligarh and if I select more than one it will give me all the selected ones and it will give me data for those two or three branches that I had selected, so basically what I'm trying to say is that you can connect two or three pivot tables to one slicer so you can get the filters with one slicer for both pivot tables so this is what your pivot table or the Slicers are useful in case you are trying to get the filters for your data, the next topic we will look at today is data analysis using Excel, so how do you do data analysis using Excel? something called analysis tools package in excel through which you can do data analysis.

The Analysis Tools Package is an Excel add-on program that provides data analysis tools for financial and engineering statistical data analysis. To load the data analysis tools package, you need to run some steps in Excel, so how do you do that? Let's go to our Excel in the file tab. I click on the options once I click on the options under the plugins, I select the analysis tools package and click ok, so when you go to plugins under the analysis tools package you see here under the name where you see the add-ons, select the scan tool path and click on the Go button or click on the OK button once you click on the OK button.

What's going on? The new data will open. for you or in the new window, click on the scan tools package and click on Go. Once you click on Go, it will give you the option of scan tools package. Analysis tools package. VBA Euro Currency Tools and Resolution Plugin. I'll add the analysis. tool pack and click ok once you do that now I will be able to see that below the data there is something called data analysis added to my ribbon so now you can click on data analysis to create the different analysis What would you like to do.

From the list you have now, let's see how we can create a data analysis using the Excel data we have. So what do we have here in our Excel sheet? I have a list of data like quantity sold, quantity sold, price. of the product and advertising now this example teaches youhow to perform a regression analysis in Excel and how to interpret the summarized result, so now in the data below we can see here in the list the question of the book is: is there a relationship between the quantity? is sold and the price in the ad, so what is it?

Is there a relationship between this and this and production? So what are they trying to understand? This is the price and this is the type of advertising we are doing? is the amount we are spending on advertising is the quantity sold increasing or decreasing or any relationship we can see so can we predict the quantity sold if we know the price and advertising? So if I only know these two things, can I? predict what will be my quantity sold, that is, to do that type of analysis, we can use this data analysis tool package, so I go to the data tab in an analysis group and click on data analysis, now I select the regression from this list and click Okay, now there is a range that provides some basic regression statistics.

So how is this done? There are two things you need to give: the input range y and the input range be the range? So the first thing we will give to Excel is the Y range, select the Y range from A1 to A8, this is the predictive variable also called the dependent variable so this is something that we have to predict depends on these two things we do not know the quantity sold we are trying to understand what will be the quantity sold if we have the price and the advertising then your dependent variable will be your range Y, which is your A2 to A8, the second one you have is the range X, these are the explanatory variables, they are also called independent variables, these columns must be adjacent to each other, so whichever one I'm selecting, so I'm Selecting all eight, these two must be adjacent to each other.

Now I have to make sure why I'm taking these two things because these are my independent variables, which means this is true. I know and this depends or the quantity sold depends on this tool. reason why quantity console is called as dependent variable while price in ad is called as independent variable now we have to check the labels and click on the output range box and select where we need the output and where I need the output to be shown, so I click on the output range box and then click on where I need the output, I say I need the output at a11, so I select that and then check the residuals, now the residuals are not displayed They will verify, you will have to verify the residuals and click OK, once you click OK, the response will be shown in the summary result box here, what does that say?

If you look at the results here, you can see that there is a range that provides some basic regression statistics including the R square, so what do you do? Gives you basic regression statistics. Regression statistics means that we are trying to find the regression and that is the reason why it gives you the standard error. The number of observations below that information provided by the regression tool. analysis of variance which is Innova which includes information about the degrees of freedom this is called degrees of freedom sum of squares mean square value the F value and the meaning of f now below the information Innova the regression tool provides the information about the line regression calculated from the data now, what is calculated from the data?

So it says that including the coefficient of standard error is the same as we're looking at the standard error here, so you have the T statistic and the probability value for The Intercept, as well as the same thing. information for the independent value, so this was for the dependent, this is for the independent value that you can see and then what is the number of in Excel. It also plots some of the regression data using the simple scatter plot, so you can add the scatter as well. Letter you want according to the details you need from this, this is how your regression analysis works, so this is more of the statistical analysis or the financial analysis that you plan to do when you are in the financial department using Excel. how your Excel helps you do your job when it comes to working on data analysis, in the past there was something called waterfall development or waterfall development model, so when I say waterfall you can think of something like you know a banking application or insurance application or some Police Department application, so the moment I say waterfall model, you can think of a really huge application, which is made up of small pieces of code, for example, this application could have an interface, this application obviously has a backend and then it has some DNS routes and some services that it depends on, so it doesn't really matter how many services are part of this application, but this entire application was shipped as a single application, That's how things used to be.

It happened in the past and this or this development method was referenced, the waterfall method, the application was called monolithic application now it is called monolithic, if I can write it correctly, monolithic application education, now you know everything was fine and great unless I liked it. 2000 and 2002 and that's when things started to get a little extreme because clients would have 10 different requirements that would change almost every day. Now, if you have a single application, you have a single point of failure, so if you change even this small part. of this application and if this part failed, the entire application would stop working, that's when people started thinking about better approaches to software development and how the Millennium requirements of today's world can be met without really affecting the way software is written or any application is written in the first place, that's where the ideas of agile development came into the picture, so that was part of the problem.

The second part of the problem was due to it being a monolithic application, the time it took to push the changes. For example, let's say you have an application running in your production environment and your development team actually created a new feature or they modified the existing feature now that feature is supposed to go into production successfully, but in reality it used to take days and months ago. in the day because you would never really know what is going to happen if you put it into production. Nowadays there are so many moving parts that you're never sure if it's going to break the existing app you have, so people used to schedule maintenance.

I'm pretty sure you would have received those emails correctly since we won't be available during this weekend because there is downtime in the schedule, that's what used to happen now, that you can't fly anymore. Think about companies like Netflix, Uber, Amazon, they can do it. I can't really be down for even a moment because you never really know how many people are accessing the service. That's the second part of the problem that people were trying to solve. That's when Agile came into the picture. Now Agile, put in simple terms, is a philosophy for quickly deploying an application in a much more organized way now, obviously there is a lot more detail than meets the eye, but in a simple sentence, that's what you mean by agile: You want a quick deployment of the software or code you are writing without having to wait longer, at the same time you want to make sure you have small pieces of code that can be sent to the client or whatever application you are working with.

That's why Agile exists today and now let's look at what you mean by agile and how you can actually implement it, so I hope we're pretty clear about why there was a requirement for agile to begin with. This is what is meant by waterfall model. Now, this is the traditional practice of creating software. so you would gather the requirements you would design or you would design what you envision your software to be and then the coding would run, there would be verification and there would be post-deployment maintenance, so this is what has been happening in the past. four decades, but this won't really work in today's world because multiple changes are pushed every day, so you can't spend months planning a small change, so the way applications are developed has changed and so has the way applications are deployed, that's what you mean by waterfall model.

I think I've explained it pretty well. There are many companies that still follow this model, but at the end of the day, they are all trying to migrate to. More agile development is not as easy depending on the size of the company, but you will still see some companies that use waterfall and are in the process of moving away from this model and then agility comes to the rescue, so what is agile have we talked about? the requirement or why agile exists so far now let's see what you mean by Aja then as a kid it is nothing but a chain of rapid development and deployment which means the first section of your software development is always the planning part , but now you obviously know what you're about to build, but you break down the entire application into small pieces of code and then you work on those small Services, one service at a time, making sure that you follow the microservices model in the first place and at the end At the same time, it doesn't really affect the entire application in general, so you plan, design, your architect and you actually develop the application, test it, deploy it and review it if you notice that the release is really outside this circle full, meaning that every time you make a change it could be something as simple as just one line of code changing, just one variable name being changed.

So, no matter how small or big the changes are, the idea is that the moment the change is made, it should be deployed even to a development environment so that you can get constant feedback on what is happening with the code. that you have imagined. If you really had to wait a month or two weeks just to get feedback on whether you really want that change or not, that might be a little annoying or frustrating from a developer's point of view, so that's the first agile thing you plan for. . you design, develop, test, deploy the changes, and then review the changes before releasing them to production.

The other important aspect of Agile is that now instead of working with one big part of the application, you work in iterations, so when I say iterations. What I mean is that you have a specific set of tasks that need to be completed with a specific priority so that you already know what you're supposed to work on and you're not really worried about 10 different microservices at the same time. specific requirement that you need to focus on to have the first iteration, which could be the first part of your app, second iteration, third iteration, so think about it this way if you have amazon.in, if you are working for, you know Amazon.com or amazon.in which is a shopping website, you may visit amazon.com and think yes it is a website, actually it is not a website, it is a website which is divided into various other services e.g. , the website itself could be called the interface. now the moment you go to amazon.com you can right click on a product and then you can see the product details so the service is no longer really a part of the interface that is called from something else called catalog now . once you decide that this is a product that I want to buy, click buy from time to time and then it will take you to something called a shopping cart and after you make payments and all that stuff, you will have email notifications and text messages. text. notifications, the point here is that although all of these things work in Synergy, they are actually completely separate Services, completely separate tasks in the underlying architecture, so if I'm working on something on the front end, I don't really have to worry through the catalogs and purchases because first I receive constant comments even before the launch.

I get feedback on what will happen once we release our code to production at the same time. I really don't have to be afraid of that. It's going to break my entire application because they are all developed as separate microservices. Your single service will never affect another service, of course dependent services could be affected, but the idea is that you never want a single point of failure, that's the idea of ​​a Job Now, let's move on now, what are the terms and values ​​of our work? So the first value is people over processes and tools, working software over comprehensive documentation, customer collaboration over rigid contracts, and responding to change rather than following a plan. to get people through the processand These types of tools give you a development-centric, customer-centric environment, meaning that just because you've been doing something traditionally for the last eight years doesn't mean you don't really explore the options you have.

Now, for example, what you did yesterday with PHP MySQL can also be done with Python and Flask today. I'm not saying change your entire app. What I'm saying is that the model is quite people-centric, as the development team and customers and end users receive more substantial and functional software rather than full documentation. Now, this is something that we would all have noticed at some point, so each application would have an internal document of the length of 100 pages, approximately 150 pages in total. the classes, all the methods, how the application is being built, then why the application is being built, who owns it, and like a host of other details, which you as an individual don't even care about, you care about. what you have to build and to what extent Are you in that development task, so in Agile the functional application is given much more importance than the documentation because if you think about it, the code itself is a documentation?

If you knew how to interpret the code, you could look at the code and stuff. it can also act like in documentation, so I am not saying that there will be no documentation, all I am saying is that more importance is given to the development than the documentation part and then to the client's collaboration on rigid contracts and responding to changes instead of following instructions. Such an agile plan is really dependent on feedback, I mean in the past, managers and product owners would have several meetings, they would come up with the type of software they wanted, everything would be discussed for three four months and then people would come up with it. you would want to stick to the plan because you already spent four months planning this now, if you wanted to change even a small part of this, all the meetings and planning would have to be done again now agile changes than agile They work more in feedback just because it has been worked out The plan doesn't mean that there can't be any changes because you have divided things into smaller parts of tasks, any of the tasks can be modified according to the requirements at any time, so these are the values ​​that Agile brings to the table. table, so there are two parts to the puzzle, you have a profit and then you have a value, so the profit is what you get from the beginning and the value is what you get from it, so what we saw before. were the values ​​where everyone you know at the table receives some other kind of benefit because of our work principles of agility, happy customer, welcome, changing requirements, delivering software that works, frequent iterations with stakeholders, people motivated, face to face, Communications measured by software that works Maintain a constant pace Maintain technical excellence and good design Keep it simple Empower the self-organized theme Continuously reflect and adjust now this might seem more like a textbook as here are the 10 benefits that You know, just go with us, but that's not really the case.

In fact, we'll see how all of this plays out, as you know, in future slides when we talk about how a job can be implemented in the job or in the team that you're working with, so let's move on now. The benefits of agility are quite a lot of you have touched on all of these things by now persistent delivery of software increased stakeholder satisfaction inspect and adapt welcome change at any stage design matters and daily interactions are now at the heart of The whole presentation now has a basic idea for a good job, but the question everyone has at some point is what's in it for me.

Okay, you told me what agile is and how it can help me, but how can it help me as an individual or how can I actually implement a job so that there are multiple? Frameworks or philosophies when it comes to Agile, so scrum extreme programming lean kanban Crystal are some of the examples, the most popular one out there, it's called scrum, now again, these philosophies are not set in stone, not that if you follow scrum, you don't know it's 100 what scrum dictates to you how to do it that way that's not really the case in most of your cases what people do is implement scrum mainly and then they have some ideas of kanban extreme and lean and then They have their own philosophy that works for their organization, but scrum is what most and other people use, so before we even look at the slide, you know, before we go over what we see on the slide, I can explain scrum to you. way I know it well because I have worked with multiple development teams.

I've seen most of them implemented and know how each of them works in a real world example. So what is Scrum? Scrum is basically an iterative philosophy, which means you iterate on changes you iterate on deployments and software development one at a time, so if you wanted to talk about scrum scrum is an iteration of the plan, then build, test and then review now I would be constantly iterating on all these aspects, now what do I do? I even mean by this, so let's first see how or what a team implemented with scrum looks like. In the team implemented with scrum, you have the first person I want to talk about, called the product owner, now when I say product owner, if it comes from you, you know more about a traditional software development environment.

You can think of a product owner as a manager. He is the person who has the responsibility of ensuring that the application is deployed as and when it is committed, at the same time as the application is built. exactly how it should be built, so the product owner is the person with the ideas, they may not necessarily be a technical person, they could also be a management person, they don't necessarily have to know development or technicalities in detail. he is the guy with the idea and the owner of the application that would be developed so pretty much all the responsibility falls on him and then there is someone called the scrum master, now the scrum master is someone you would have traditionally referred to as a team leader . or a project owner, now you can think of scrum master as a team leader in the hierarchical sense, this is the person who is just below the product owner and this is the person who actually does the day to day or handles the operations from day to day how you know how to organize meetings or plan the tasks that need to be done and then you have the team itself, which will be made up of your developers and testers, and you know that, depending on your needs, it may have some more functions, but then you have the actual equipment. who will execute the tasks, so these are the three roles you have, but now that we know the people involved how exactly this works, I mean, this sounds a lot like what you do in your office, they're just fancy names, right ? manager, you have a team leader and you have a team, so how is that different from what you do in your office?

That's what we want to see now. I hope the roles are clear to you now that you have them defined. Let's look at development first, so the first part of development we want to look at is called Product backlogs. This is where things start to be a little different from how you might have been working in a traditional environment now in a In a traditional environment, you have an application that has already been planned for months and you, along with others, have been working in the implementation of the application and you know that the project usually lasts a few months or even a year or two, depending on the size of the project. now in product backlogs you actually have the same app iterated into smaller tasks, so when i say smaller tasks you can think of the same amazon.

In the example we talked about, the first iteration will have a plan, it will have a build, it will have a test. and will be reviewed now. In this case, I'm not actually building the entire application. Obviously I have an idea of ​​what the app is supposed to look like, but for now let's say I'm just concerned with the front-end or what the main or main website would look like, then I have a second iteration where I would know the same build cycle, test and review plan, but this is where I'm really working with the email notification.

I'm actually coding what my email notifications would look like. shipped and you know how to manage the email signals and the rest of the stuff and then you have a third iteration which could just be your payment processing, so in this case again it's the same cycle that you plan, build, test and reviews, but The benefit here is that once you have the product backlog, these are all the product backlogs, these are the things that are supposed to be done over a period of time, so the first thing you do do is define the product backlogs, not you as the developer, but the product owner and the scrum master, these are the people who would actually generate all the backlogs instead of, you know, a single application that says I want this work, they actually break it down into little gems or code, so that's the job of the product owner and the scrum master because like I said, the product owner may not necessarily be a technical person, so the scrum master is the one who You'll always be your tech, so you'll both generate the product backlog once you've done it. a product backlog there is something called user stories so each of those would now be called 2 user stories and your scrum master actually ends up prioritizing them i.e. if you have a front end email payment processor and others 10 backlogs that need to be developed, say over the next five or seven months, in that case the scrum master and product owner would prioritize now, obviously the payment processor is of no use if you don't even have a project, so which logically I would like to prioritize my interface. about my payment processor so that the scrum master and product owner prioritize the user stories that you have and depending on the priorities that have been set, they create something called a sprint backlog.

Now the extended backlog is when your development team really gets into this because now you already have organized and prioritized user stories that you're supposed to be working on, so that you're not getting 10 different things thrown at you at once, you're You are assigned logical and reasonable tasks that need to be executed one at a time. Once you have the Sprint backlog, you can start working on it as a developer. Now I'm going to get rid of this beautiful drawing I made for now and let's now look at the Sprint backlog. Sorry, I can. You don't really know how to type with my mouse, but I hope you realize it's called Sprint.

Now there are different ones, you could call them ceremonies or rituals, but there is something called sprint planning. Now outreach planning is again just a fancy name for meetings. In the discussions you have during sprint planning, the product owner will actually explain what they envision the end goal or the product or the application to look like, so you have something called sprint planning, you have something called daily scrum, now scrum diary is nothing more. From what you know, the 15 minute meeting that happens every day where developers and testers and whatever other roles you have on the team can discuss what happened and where you stand if you need help, are there any roadblocks, and what are you planning? to do today or tomorrow and then there's something called a sprint review, only the print review actually happens at the end of the user's story or the backlog they've been working on, so each and every one of these stories user interfaces are generally designed correctly.

With the two-week schedule in mind, now in some companies Sprints can vary, such as being two to four weeks, but in most cases each Sprint will last two weeks so you know exactly what you are supposed to do. for the next two weeks, now at the end of the two weeks you will know that you are planning your daily meetings, once your sprint is completed you will have a sprint review where you can demonstrate the code that you have or just meet some kind check to make sure. that Sprint actually completes and then you move on to a new Sprint or you move on to a new user story that you have to work on, so that's the idea, that's how things work in general now with that in mind, if we move On the next slide, this is what scrum looks like, so you have a product backlog and then you have a sprint planning.

Now, as I mentioned before, each of these prints, the timeline is usually a couple of weeks, depending on the size of yourorganization, could last. up to a month, but for all the companies I've worked with it's always been between one and three weeks, so you plan what needs to be done over the next two weeks and then you have the user story or the backlog that you have . You're supposed to work and then you have your team actually working on it along with the daily scrumps, so you have the daily meetings at the same time and at the end of the sprint you have the review and then you ship the part you need.

Coded now, when I say you change the part, I don't necessarily mean you put it into production, but you know that the part is ready to be assembled in the application that you have, so the idea is at the end of every two weeks. a shippable part of the app that's ready to deploy, so instead of working on a huge app that would have taken a year anyway, you now break it down into things that can actually be shipped in two weeks depending of the priorities that have been established. set by the product owner and the scrum master that you have, that's the idea of ​​scrum to break everything down into smaller chunks of coal, smaller chunks of tasks so that everyone knows exactly what they're supposed to do, that's the methodical part, right? you have a method, there is a specific set of best practices that you are following along with the technical aspect because you have a quick implementation the moment you write a code, you can test it in the development environment, that's where people like me come, the devops. in the image, but the idea is that you don't really have to wait a month just to see what you coded right now.

If you push the code right now in a matter of minutes, you'll actually see it working in the development environment, so that's the On the technical side, you have instant feedback to determine if you need to move forward or if you need to make some changes to the code that you have now, which is Chrome and agile in general, then there is a second method, so scrum. was one of the philosophies or frameworks, then you have something called extreme programming. Now this was one of the first that a group of developers came up with back in 2001.

I think the guy's name was Kent, so they came up with the idea of ​​agile development, came up with a set of best practices, and then even signed a manifesto, so they actually came up with a manifesto that you know these are the things that we should follow in the industry, these are the best practices and these are the principles and they even signed it, so extreme programming has It's been around for almost a couple of decades and scrum is sort of the next iteration of extreme programming. It's a little different, but like I said before, most organizations use scrim programming, so in They Came Up With Extreme Programming, you know the basic sets of principles, like the human-centered environment discipline, and then you have rapid deployment, so project requirements, stories, test cases, task completion, customer input, iteration planning, now both things are happening in parallel, so you have the project. requirements, you have stories, test cases, tasks and completion, and at the same time, you have input from the customer and at some point you have iterations from the customer in the meeting, for example, you developed twenty percent of the application and your user end or your client came back with a better idea or if they need some modifications then those are the changes then you have your uat testing you have client side uad testing and acceptance at the end so extreme programming the ideas are somewhat similar to scrum , but at the end of the day all of these philosophies are trying to improve the lives of developers and end users and not to compromise on technicalities but to make the deliverable product better and faster is the idea.

Okay, let's move on, so you have lean programming, so lean principles even this has been around for a long time. a while, so eliminate waste amplify learning decide as late as possible decide as quickly as possible empower the team build integrity and see the whole yes, then you could call it a framework, you could call it a philosophy or methodology now it really depends on whether you know the word that you want to use, but at the end of the day it's again about focusing on the developer and people and establishing best practices to make sure that everyone on the team knows exactly what they're supposed to do and that you have cross functionality when I say multifunctional essentially, I am pretty sure that if you are watching this video it is because you have some other development experience and if you have then you would have come across this point just when you are talking to someone.

Have you seen that feature? Have we looked at the code and that guy would say: you know the code doesn't concern me, it's none of my business? I'm working on something completely different now that we're used to that kind of development just where people individually know what they're supposed to do and aren't even worried about what the other person is doing. Now is the time to break down the silos. Just because you're not coding that part doesn't mean the code doesn't do it. refers to the part of the code you are writing, so everyone has to come together and work on the same application, which is what you will call a cross-functional team in the scrum example once you have the user stories and backlogs that you are supposed to work on in the next two weeks, it doesn't really matter what role you play in the team, it is your team's responsibility to make sure that the task has been completed and that the task has also been designed keeping the schedule in mind, so it's not like you're expected to do six weeks of development in two weeks, so the task itself is designed with the schedule in mind and then you have something like kanban, so kanban is similar to scrum, the difference here is in the case of scrum. you know smaller chunks of backlog that you're supposed to work on over the next two or three weeks in the case of kanban, it's a continuous process so there's no such thing as a canvas sprint.

What you do in kanban is have a list. of tasks that are supposed to be done and, for example, you have something like, you know, a whiteboard, you have a build, you have a test queue and you have a submit queue. This is a hypothetical example, obviously you would have a plan and the rest of the selections, but the point is that you may have four things that need to be built or let's say three services that need to be built and once the first service has been created, it happens to the test queue and then this place is occupied by another. service and once this is done it is passed to the test and is occupied by another service, meanwhile if this test is done it will go to the submit queue and will eventually be submitted, so the idea is that any task that is achieved will be replaced. for a new item in the queue, so if you have a build queue, a test queue and a submit queue, these would all be moving parts, so if your job is to build this and let's say your job Colleague is to try this the moment you press this first. element in the test queue, another element will replace this first element so you know what's next you're supposed to work on, so kanban is more like a continuous deployment of software development, so that's what What do you mean by agility in In general, even if you think about it, the English word agility means to be really fast, right, agility would mean that whatever you are doing is happening in quick successions, right, that's what you mean by agility in general, so in case of development, bring agility to your team.

You're making sure everyone is happy at the end of the day and you still have a technically smarter team that can get instant feedback. Now I'll give you a quick example of this. I'm pretty sure all of us or at least most of us. We all know Netflix now, you would be surprised to know that Netflix is ​​pushing more than 1000 changes every day in their productions. If you actually worked on a Netflix development team, you'd know that these guys are driving a thousand changes in production every day. Nowadays, how do you think that is possible? They're always not pushing it to production without reviewing it or testing it, even with all those things in place.

How can they implement 1000+ changes every day? Now these could be very small changes. as you know, some UI fixes some databases, some checkout processes and fixes, so we're not really worried about what the changes are, but I know for a fact that that's the number, the amount of changes that really drive all days, that's possible because you I'm talking about rapid implementation through agility or becoming agile, so that's the level of agility that you can really get the moment you have an organized team that is working on the principles of agility. Now, obviously, there are external factors, like knowing how your infrastructure is, how your development pipeline is. but it is possible at the end of the day and then there is one more framework called Crystal, so these are the ideas of a work now.

I hope I've been clear about how Agile can help your team become a better development team, so there are three right philosophical aspects Technical and how software is built are just as philosophical best practices as how they are defined. teams Moses scrum Master who is the product owner what is the team what is a Sprint what are the tasks it is supposed to perform Then you have the technical side, like if you build a code, how exactly can you deploy the code automatically, how can you review the code, how you can test the code automatically and then there's a software development aspect that you have to have.

We are moving away from a monolithic application towards the idea of ​​microservices, so these are the three aspects that move in parallel and at the end of the day, it gives peace of mind to your product manager and the end user. mentally with better deployment ideas so you don't have to run around on 10 different desktops confirming whether your changes were actually deployed or not, thanks, it's a wash now to understand the importance of scrum, let's see how scrum compares For the most alternative old, which is waterfall development, the waterfall model consists of a lot of time involved in planning, and again by a lot of time, I mean a couple of weeks, maybe a couple of months, and then it could take about the same amount of time to build. the product says a couple more months, then testing followed by review and finally the implementation of the product.

At this point, you might end up bringing the wrong product to the market according to the market demands because when you started planning this product it was almost a year ago and now the market demand might have changed. I am sure that many of you have already guessed what the problem is with such a model. First of all, the entire plan must be complete before you start building or testing your product. Obviously, if you are doing this in a full iteration, it means that most of the planning is done without understanding the project or the difficulties you might face while building the project, the drawbacks, the loopholes, and most of the time, after start building the project, it is submitted.

Back to the planning phase again, which takes you back to Square One, in which case your project has to start over or the developers are simply criticized for not understanding the plan properly. This process can be repeated many times, which is time-consuming. when the product is thrown over the fence for testing, where in case it encounters problems the project is returned to the construction process or sometimes back to the planning process and the same thing can happen. This happens in the following steps, which includes many steps back, and doing it again can lead to delays and many months or several years in getting a product to market.

Scrum solves this problem by breaking the project into smaller parts first you start. with enough planning to start the project, then you build a project with the minimum number of features which are like your basic features and then you test the same and revise the same and once the cycle is completed you have in your hands a product potentially Deliverable Now This process takes about two to four weeks and is repeated over and over again, reducing the time it takes for the planning, testing, and review cycle of a given product. This way you end up with several different versions or several different incremental releases. each one takes less time than the last or about the same time and by the time you have five iterations of these, you will already have five vividly improved versions of the same product, each of which keeps up with market developments happening outside of your company and this is called exfoliation, so scrum isa framework within which people can address complex adaptive problems while productively and creatively delivering products of the highest possible value.

Now you need to understand three things about scrum: firstly, scrum is lightweight, secondly, it is easy to understand and thirdly, it is very difficult to master scrum itself is a simple framework for effective team-based collaboration. in agile and is the opposite of a large collection of interlocking mandatory components that are part of the waterfall alternative discussed above. Now scrum promotes product development through process techniques and practices. with various iterations and increments to deliver maximum value, as I mentioned before, that way the first planning build test review cycle will be called your first iteration, the second will be your second iteration, the third time you plan the test and construction review. be its third iteration followed by the fourth and finally the fifth.

Now these iterations are called Sprints and at the end of each Sprint you have the release of potentially shippable software. Each software version is much better than the previous one. Each Sprint takes about one to four weeks and you keep repeating these prints until your product is fully featured. Sometimes you may even end up shipping your product after the second sprint but sometimes it may also take three or four or five or even more sprints but in the end you have a good product and that's what matters now scrum follows an agile approach to address complex problems now agile is not a methodology, framework or process now agile promotes self-learning and self-organization instead of a lot of planning and a large collection of interlocking mandatory components implements a scientific method that replaces a programmed algorithmic approach with a more heuristic one with respect for people and self-organization to deal with the unpredictability of complex problems.

This approach basically means not planning the entire process to create a potentially shippable system. product, but just plan enough to get started and then react to the answers you get with each sprint or each iteration. Now there are three roles in scrum, firstly, you have the person with the bright ideas, who is the product owner, by your side. have the scrum master who is basically the one who implements agile and prepares the team to follow the agile approach and make them more efficient and finally you have the team, mainly the team consists of developers, testers, writers, it can be anything from that each of them can be replaceable. any of them, so on certain days you might find that developers are testing, testers are writing etc., the main goal here is to build the product in the best way possible, there are many reversible roles being played in the team now to make them understand the scrum master approach or the agile approach, let me raise a problem.

Take for example, there are several people in the room and they have to queue according to their respective heights, which takes less time. as possible, then there are as many people in the room, now for this problem, there can be two solutions. First, we have the supervisor approach. Here we have a traditional supervisor or a manager and basically what they do is organize people one by one, taking time for each person to line up, which basically takes a lot of time and also, as a team, you don't learn anything about organization, but then you have what you call the agile approach.

Here we gather the same number of people and we have their scrum Master now what the scrum Master does is allow the team to organize and at the end he makes the changes that he considers necessary and, my friends, it is the agile approach, now the agile approach that mainly used for software development is an approach. under which the requirements in Solutions evolve through the collaborative effort of self-organizing and cross-functional teams, so basically people here are self-organizing which consumes less time under the continuous guidance of their scrum master, so what it is is a set of practices. which promotes continuous iteration of development and testing throughout the project development cycle, as I mentioned before, it promotes self-organizations and helps teams respond to the unpredictability of the problem at hand and the person who promotes such an approach is called scrum . master he or she is a person who allows the team to self-organize and manages the process of how information is exchanged now there are some anti-patterns when it comes to the scrum master first the scrum master is not a supervisor now this problem is quite common with people who are generally old project managers.

Being a Scrum Master is a completely different role than a project manager and therefore the way people act needs to be completely different. Typical project managers tend to organize people's work rather than enable them. To self-organize, they tend to tell how, who, and when work should be done, without giving the team much room to think on their own. The result of this is basically a team full of robots instead of people who have the minds to think. On his own, a scrum master must be aware of his behavior in order to correct it. It's not easy, usually these people have worked for several years in a typical project management position and simply eliminating this behavior will take some time, but being aware is the first step is to let people grow, let the people have their own space to breathe and not try to be a supervisor, this is not a control situation here.

Second, the Scrum Master is not just a secretary. Now many people think this way. In such a situation, I worry a lot. because it means that people don't know what a scrum master should do when people think that the scrum master is just a guy who schedules meetings, compliments journals, and serves coffee to his colleagues. This is where things get very dark and unfortunately this is very common with the scrum master. You have dozens of different roles and hats, but this is a far cry from the secretarial job where most companies associate master positions with scrum Masters teach recruiting and training people to become true leaders and work cohesively. as a team and finally, self-organization does not mean that the absence of management, as I mentioned before, a scrum Master is there to constantly monitor the growth of the team, let the team self-organize, it does not mean that there is no one to supervise them, let's move on to the scrum framework, now scrum. is a simple and lightweight framework, it is not a scrum methodology implements the scientific method of empiricism that replaces a programmed algorithmic approach with a more heuristic or self-learning approach with respect for people and self-organization to deal with unpredictability and solve complex problems however possible.

You can see in the chart in front of you that it starts with input from stakeholders and then the product owner with the bright ideas all the way to the finished products, which are then reviewed in the Sprint Retrospective. Now most of you may be wondering what empiricism is. Now empiricism basically means that you are working in a way based on facts, experience and evidence. Scrum implements an empirical process where progress is based on observations of reality and not on fictitious plans. Scrum also places great emphasis on mindset and cultural change to achieve this. business and organizational agility, so basically empiricism has three pillars: firstly, you have transparency, now this means you are presenting facts, just like everyone involved, the customer, the CEO, the individual contributors are transparent in their daily relationships with others.

Everyone trusts each other and has the courage to stay abreast of both the good and bad news. Everyone collectively strives and collaborates to achieve the common organizational goal and no one has a hidden agenda. The next pillar of empiricism is inspection, now inspection in this context is not an inspection carried out by the inspector, auditor or supervisor, but rather it is an inspection carried out by all members of a scrum team. Inspection can be performed for product processes, people aspects, practices and continuous improvements, for example, the team displays the product openly and transparently. at the end of each Sprint to the customer to gather valuable feedback.

If the customer changes the requirements during the inspection, the team does not complain but adapts by taking this as an opportunity to collaborate with the customer to clarify the requirements and test the new hypothesis. and finally, as I just mentioned, adaptation is the third and final pillar of empiricism. adaptation is this context that is about continuous improvement, the ability to adapt based on inspection results, everyone in the organization should ask this question regularly, are we better? that yesterday for for-profit organizations the value is represented in terms of profits the adaptation should eventually refer to one of the reasons for adapting agile, for example, a faster time to market greater return on investment through delivering value based on reduced total cost of ownership through better software quality and greater customer and employee satisfaction, so these were the three pillars of empiricism.

Now let's go ahead and look at the scrum life cycle. Now this slide is a graphical representation of an agile project using scrum starting at the far left. see the product owner own the backlog and develop user stories with the team or requirements for the project or product. The product backlog is prioritized with higher priority items at the top of the backlog. The team with the product owner then decides to group the user. stories into releases based on the product roadmap, once release plans have been completed, user stories are selected for a Sprint. The Sprint can last two to four weeks or sometimes one to three weeks.

The team then disaggregates each user story into tasks and then in each Sprint the product is developed and as the code is written it is integrated into the system and daily scrums are done. At the end of a Sprint there is a Sprint Review where the working software is demonstrated and presented and then presented to the customer. For acceptance, the team conducts a Sprint Retrospective to ask what could be done better. Team statistics are then updated, as are information radiators that transparently display the team's status and again return to user stories. and then the whole cycle begins again.

Next, let's discuss what a Sprint is now, as I mentioned above. Sprint is basically an iteration of planning, testing and reviewing. A Sprint has consistent durations throughout the development phase and this is primarily between two and four weeks. It cannot be more than four weeks in length, as described in the scrum guide. A Sprint is an iteration, as I mentioned before, it has a period of time of two to four weeks during which a product becomes usable or potentially releaseable and by product I mean an increment. of a product as a version of a product now Sprints have consistent durations that are generally limited to One calendar month now during this printing no changes are made that could jeopardize the goal of the Sprint the quality of the goals does not decrease and is possible that the scope should be Clarified now, each Sprint can be considered a project with a Horizon of no more than a month in which you have to achieve something.

Each impression has its own objective, a design and a flexible plan that would guide its construction with the resulting increase in product. Now the thing with the Sprint is if the Sprint time frame is too long then the definition of what is being built can change, complexities can arise and risks can increase, therefore Sprints allow for predictability by ensuring Inspecting and adapting progress toward a Sprint goal at least every calendar month. Now there are some factors that affect the duration of the Sprint, first of all, the stability of the backlog. Now, obviously, if the backlog continues to increase, that can take data out of the Sprint, and secondly, you now have overhead costs.

Sprints also limit the risk to one calendar month of cost if the cost increases then it can affect the duration of a sprint now overhead costs now each sprint will have a sprint that will meet the testing phase a review and a retrospective now these are overhead costs now If the overall cost can be reduced through automation planning and integration, etc., these costs can be absorbed. Now by reducing these costs, the overhead costs, you can reduce the duration of the Sprint. Now it's the job of the scrum masterensure that product development goes according to sprint planning.

Now there are a few other Sprint terminologies that I want to tell you about: First of all, you now have your Sprint Goal, as the name suggests, what you want to achieve at the end of the Sprint, your product with the feature sets that you have decided with the owner. of your product. and your customer is your Sprint target, then you have your Sprint cancellation now once the sprint duration has been determined and the user stories have been selected, neither the sprint duration nor any user stories can be modified; However, a Sprint cancellation occurs if there is a significant change in priorities or mid-course correction in the middle of the Sprint.

Considering that we are only talking about two to four weeks of work, it is very unlikely that a Sprint will be canceled a Next, let's look at scrum artifacts now scrum has three artifacts in the product backlog Sprint backlog and product increment first has a product backlog. Now the product backlog, as described in the scrum guide, is an ordered list of everything known to be needed in a product, it is the only source of requirements for any changes made to the product and the Owner is responsible for the product backlog, including the availability of its content and placing orders now, a product backlog is never complete.

Its earliest development establishes the known and best understood initial requirements. The product portfolio evolves as the product and the environment in which it is to be used. continually evolves is dynamic and constantly changing to identify what the product needs to be appropriate is competitive and useful if a product exists the product backlog also exists now since backlog refinement is the act of adding detailed estimates and ordering two items in the Backlog This is a continuous process in which the product owner and the development team collaborate on the details of the product backlog items during this process the product backlog refinement items are reviewed and revised often by multiple scrum teams. they work together on the same product for which a product backlog is used Describe upcoming work on this particular product.

Next, you have something known as the Sprint Backlog. Now the Sprint Backlog is a set of Sprint Backlog items that are selected for the Sprint plus a plan to deliver the product increment and achieve the Sprint goal. Sprint Backlog. is a forecast from the development team about what functionality will be in the next increment and the work required to deliver the functionality in a full increment. Now the Sprint Backlog makes visible all the work that the development team identifies as necessary to achieve the Sprint Goal. To ensure continuous improvement, include at least one high priority process.

Improvement identified in the previous retrospective meeting. The sprint backlog is a plan with enough detail so that changes in progress can be understood in the daily scrum. The development team modifies the Sprint backlog only during the entire Sprint. The development team can change its print backlog during a sprint the sprint backlog is a highly visible real-time image of the work the development team plans to do during a sprint next has the increment now the increment is the sum of all print backlog items completed during a Sprint and the value of increments of all previous prints at the end of a Sprint, the new increment must be done and done in scrum has a different meaning done in scrum or agile basically means that the product must be in a usable condition and meets the scrum team's definition of finished now you might think your product is finished but if that differs from my definition of finished and we are both on the same scrum team then your product is not considered finished, an increment is a body of fact inspectable work that supports empiricism at the end of the Sprint now the increment is a step toward a vision or goal and must be in usable condition regardless of whether the product owner decides to do so or not. launch it with that let's move on to the ceremonies or events in scrum now scrum has four ceremonies first you have sprint planning then you have the daily scrum then you have sprint review and finally you have sprint retrospective now i'm going to touch up each of these one by one first you have sprint planning now Sprint planning is basically the work plan that will be done during this print.

Time is limited to a maximum of eight hours for a month or two hours a week for shorter prints. The event is usually shorter and the scrum Master ensures that the event takes place. and attendees understand its purpose, the scrum Master teaches the scrum team to keep it within the time frame now. Sprint planning answers three main questions. First, what can be delivered in the increment resulting from the next Sprint. This basically looks at the set of advanced features you are going to implement. to deliver in your next version of your product, then how the work required to deliver the increment will be accomplished.

This is where you plan what you do in the week and the following week there is a scrum master who teaches the scrum team to keep their work within the time box and three, when is their work considered done, as we discussed, the definition of done It is very important for the entire scrum team, everyone must agree on a checklist upon completion of which their work should be considered finished. Next, we have the diary. scrum now the daily scrum is an internal meeting for the development team. It's a 15-minute long event to sync your activities and create a plan for the next 24 hours.

It takes place every day of the Sprint and the development team plans the work. today and tomorrow this optimizes team collaboration and performance by inspecting work since the last daily scrum and forecasting upcoming sprint work. The daily scrum takes place at the same time and place every day to reduce complexity and fundamentally answers three questions: What did I do yesterday? what am I going to do today and what are my impediments my impediments I mean challenges and requirements that you have in completing your work it is very important that your scrum master knows the challenges that you are facing and why you could not complete your work yesterday or why it could be difficult to complete your work today the scrum master makes sure that the development team has the meeting, but the development team is responsible for performing the daily scrum the scrum master teaches the team to maintain the daily scrum within the 15 time box minutes and he or she also makes sure that if there are other people present they do not interrupt the meeting, below we have this review printed now The sprint review is an event to inspect the increment and adapt the product backlog, if necessary , there could have been a single implementation or Many implementations during a Sprint that lead to that increment should be inspected during a review, the scrum team and stakeholders collaborate on what was done in the Sprint and, based on that, any changes in the product backlog during the Sprint, attendees collaborate on the following things.

What could be done to optimize value and this comes in the form of an informal meeting and not a status meeting. The increase presentation is intended to obtain feedback and encourage collaboration. Time is limited to one hour per week and includes Sprint Review. first, the product owner explains which elements of the product backlog have been done and which have not, and two, the development team demonstrates the work that has been done, and finally, the entire group collaborates on what to do next. This is a four-hour maximum meeting for a month. impressions and for shorter Sprints, as I mentioned, it's one hour a week.

Finally, the goal here is for a Sprint Review to provide valuable information for subsequent Sprint Planning. Reviewing how the market or potential use of the product might have changed will obviously affect it. You also discuss what is the most valuable thing to do next and review the timeline, potential budget and market capabilities, and competition for anticipated upcoming releases of product functionality and capability. The result of this print review is a revised backlog that defines the likely backlog items for the next print run now this backlog can also be adjusted overall to take advantage of new opportunities finally you have the sprint retrospective now this is basically an opportunity for the scrum team to inspect themselves and create a plan for improvements to be implemented during the next print, this occurs after the Sprint review process and before the planning of the next print, this is a meeting of almost three hours for Prince of a month and it is a time of 45 minutes per week, this is an opportunity for the scrum team to improve and all Members must be present now, each team member has to answer three questions: first, what went well.

This basically helps you tell your scrum Master what went well in your previous print and those practices should also be applied in your next Sprints. Then, what not. works well what were the impedances difficulties and requirements that were not met in the previous printing and finally what should be done differently here you introduce the changes you want in your work process or in terms of the software you are using and these are the differences with the that must be committed to improve in the next print The scrum Master encourages the scrum team to improve its development process and practices to make it more effective and enjoyable in the next print during each Sprint Retrospective the scrum team plans ways to increase product quality improving work processes or adapting to the definition of done if it is appropriate or does not conflict with the product or organizational standards at the end of the retrospective, the scrum team should have identified improvements that it will implement in the next print and implement these improvements .

In the next impression is the adaptation to the inspection of the scrum team itself, although improvements can be implemented at any time, the Sprint Retrospective provides a formal opportunity to focus on the inspection and adaptation with that we have reached the end of all the ceremonies of scrum. which I had to discuss to understand why one should become a business analyst, there should be several aspects that one should consider first like job opportunities, talking about job opportunities, in India there are as many as 6,000 jobs vacant so far and This includes both experienced and freshers, while in the US there are up to 43,000 unfilled jobs.

Now this data is based on the data available on LinkedIn Glassdoor or even similarly, we must take a look at the Silicon Valleys because the Silicon Valleys always offers a lot of jobs, now talking about Silicon Valley of India, Bangalore offers around 2000 job vacancies, includes new and experienced, while California offers up to 4,300 jobs now again, this includes data collected through Linkedin and Glassdoor, the next aspect that comes into the picture. when you are starting your preparation to become a bi analyst, salaries we definitely have you covered here and the average salary in India reaches 6 lakh per year while in the US it reaches 91,000 dollars per year now again these Data is collected through Linkedin and Glassdoor now through this you can understand that this is an average salary which includes even for

beginners

and till they have experience so the salary can go up to 10 lakh if ​​you have experience or even more Beyond that, having said that, I hope this has satisfied you. that you start well your preparations to be a bianalyst, if not yet, we will continue in today's session and understand who is a bianalyst, why one should become a bianalyst and, furthermore, we will ask ourselves well, the next thing you will have in your mind is who . is hiring, what are the companies that I should apply to well, these are the companies that you should apply to now, as you can see from the data collected here, most of the product based companies are hiring bi analysts, now you can tell With this being said that every predominantly product based company is looking for a head of business intelligence now, what does business intelligence mean?

As I said at the beginning of today's session, bi is basically applying intelligence to one's business, Now already established service based companies would definitely need a bi analyst but they would not need such proficiency because they have already established themselves so they need asomeone who can manage and move forward to move forward, but while the company is product based, they always need to think outside the box, think outside the box, this is where a business intelligence analyst comes into play. image and therefore applying to a product based company is always an option, I hope that is clear, let's move on to our next session which covers who is a business analyst now basically as I said at the beginning of the session Today, the business intelligence analyst is someone who applies his knowledge or his experience or perhaps his intelligence in creating businesses, in creating projects and in establishing new aspects in his business, so the analyst business intelligence, which is also known as bi-analyst, as I said, uses data and other information to help the organization do sound business. decisions now, of course, there are various aspects that one must consider to become a business analyst, now some of these aspects include data mining, reporting, descriptive analysis, statistical analysis, data visualization, visualization analysis, querying, preparation of data, now through all these processes you realize that these are the tasks that need to be covered as an analyst so data mining is very important as you get reports or when you get raw data from your clients , maybe or even your end customers, you have to clean them, you have to analyze them. it has to inform, make reports, provide descriptive analysis, statistical graphs and give a visualization.

We will now address how we can visualize this data later in today's session, so acquiring is important. Visual analysis is important for these. These are the common tasks that a bi analyst must perform, so I hope it is clear and you know what a busy eye analyst does on a skeleton. With that we will understand exactly how an organization benefits from the bi analyst, now that there are several ways an organization can benefit from some of the points that I have covered here, which is to identify ways to increase profits, as I said, apply intelligence to any work will always benefit you.

Now imagine you have a protocol that has been followed, what if something comes up? Out of the boxWhat if something happens that you didn't anticipate? That is where a business intelligence analyst comes into the picture and he will think about how this particular situation can be handled. This is where he can increase the profits from him. The next thing is to analyze the client's behavior in the same way. I said that a customer may feel dissatisfied or dissatisfied at any given time, there could simply change his requirement and these things should be analyzed before by someone because these things are the time consuming ones now if they have been analyzed.

Before, it would consume time and money, also efforts, perhaps, so this is where a bianalyst will come into the picture. The next thing is to compare the data with competitors. Now who will do it, if there is a developer and tester, they will just work on that particular product or. deliver that particular product to the team, but how can you know if this product is performing well in the market? How can you tell if you are outperforming someone else in the market? This is where a bi-analyst will collect all the data and put together a report.

From this, the next thing is to track the performance, not only is it important to maintain your records or meet the clients' requirements, sometimes the performance is interrupted from time to time, it is important for us to track and maintain that balance , this is where The bi analyst will help you do the next thing which is to optimize the operations, of course the final operations will be maintained by the person who created them now to optimize or to meet the optimization requirements, they will be done by a bi analyst that you need to predict. success without seeing what the result is or at least writing the result, no one can really work on a final product, you need to detect the market trends now without analyzing the market values, as we just discussed about the competitors, maybe you don't know where stop. what product would you make now without knowing the market trends, you will not know what product you should make and what customization, the next thing is to discover problems and problems definitely with every business, every project you encounter, there will be certain problems, whether it is big. or small, now this has to be documented beforehand with good intelligence.

Once understood, we will move on to the next session that tells how to become a pianist. Now we have a good understanding of who a bisexual analyst is, what he does and how this will benefit him. an organization, so we must understand how we should become one, because all these things can be answered only when you know how to become a bianalyst. This is where our job description will come into the picture now, if you review various job descriptions you will be able to know and understand what we should learn for, so by reviewing these job descriptions we will come to a conclusion about the skills we should learn or even the tools we should learn as a bianalyst, so let's review the job description here.

Again, a very popular online platform that is Disney Plus Hot Star, they are hiring a bisexual analyst. Now, what are the requirements that you see? So I took a job description here where I highlighted some points which summarizes the requirements of the person who has to be working as a bi analyst now it says he should be well versed in power bi Tableau prepare and analyze data data analysis maybe there is R SQL python good communication skills analytical skills well through this I have summarized all the points that go like power bi and Tableau are a must have tool, you must have good data analysis, good communication skills, which is general for everything, there is SQL , there is Python or ARP.

Now, if this is not enough, we will go ahead and look at one more job description, which is Dell now Dell is also a popular service and product based company. Here I have summarized it in project management. Yes, project management is an important skill too. Of course, this will not be requested in all companies, but in most companies or in several companies this could. We will be asked why not be prepared, let's be prepared for all the possible skills that will be requested in each type of company as a bi analyst, again there is power bi project management Python and SQL, as you can see as we go through various descriptions of jobs here. bi Python and SQL remain constant, let's see one more which is Puma again, another product based company and here again we have power bi Excel, SQL and Python data analysis, so from this we can conclude some of the skills we need to become a bi analyst.

As we have come across, we need some SQL database concepts, predominantly SQL, must be known by everyone who applies for the position of bi analyst in Excel. Now Excel is also a more important tool that a bi analyst must know if he has a good Excel. skills with which you can actually analyze data now, sometimes there are cases where people don't know any kind of data visualization tools. Did you know that this type of data visualization can even be done in Excel? Therefore, knowing Excel is an added advantage. Analytical skills, of course, are a The analytical skill of the analyst is imperative and should turn on bi now here.

I can go ahead and add Tableau. Also, next up is Python. Python is where you use it. It is a programming language that you use for data visualization, now to plot graphs or even to make. your data analysis is easy you can use python so using python is very important so make sure you know python now. Project management skills here. I should mention most of the skills I mentioned here or maybe even all the skills I just mentioned here. courses for everything on our channel. I'll talk about it towards the end of today's session, but here I had to mention that whether it's SQL or Microsoft Excel or even analytical skills, project management power bi python, we also have courses on our website now if you think you don't want do the course, you're good enough and you just want to review, you can follow along on our YouTube channel.

Also, as I said, I will talk about it at the end of today's session and now we will move on. we have our language also R again is predominantly used when you have to clean data you have to process data or even plot some visualizations you need to use R Tableau again one of the data visualization tools like power bi at this point I would have done so to mention here no it's just about these skills you need to be aware of certain tools as a bianalyst now in the job descriptions if you are an experienced person there are chances that you will be asked for tools based experience now talking about we will address some of tools here companies use different tools now here i have talked about sap pine business object data micro strategy SAS bi intelligence this sense of click there is zoho analytics license and even power bi is a tool now these are some of the tools that companies predominantly use some of them are free some are on a trial basis so you can go ahead and choose any of them or you can even search the web and you will find several bi tools so we will move on to Our roles and responsibilities now As a bi-analyst it is very important for you to know certain roles and responsibilities before starting your preparation, so the first thing you need to know is that you need to learn and fully understand the data landscape in databases and applications. data is your king now all you have to work is in and around the data so make sure you understand and study the data completely, next is to use and develop the data collection process again, surround the data in yes, so the next one will be to understand the data.

Next will be data collection, so everything will revolve around the data itself. The next thing is to review and validate. Here you can understand that there is a sequence or a step of responsibility that a bianalyst must follow. Next is to collect end-user reports and dashboards. Finally, you need to review the requirements, validate the core customer data as it is collected, and maintenance is very, very important. Make sure you always keep good data and also your projects abroad. Here you should talk about your educational specialization if it is related to your experience in it. your professional experience with it and if yes, you mentioned the field of business intelligence you specialize in, then describe the beauty of your career.

The trip also remember to show a strong interest in the business sphere of the company, then you may be asked your opinion on a joint software development for First of all, you should define the bi project as agile, a giant software development, it will be refers to software development methodologies that involve iterative development where requirements contributions evolved through collaboration among a self-organized cross-functional team. It advocates adaptive planning, evolutionary development, early delivery and continuous improvement. The benefits of agile. The law that it is more collaborative saves time and since the teams work directly with the client, they provide a clear result incrementally, so it will give record these days, but many companies still prefer to use the waterfall methodology, especially for projects with specific and well-structured schedules. defined your liberator if you have worked in Agile talk about your experience you may be asked about your experience in sdlc LCL refers to the software development life cycle you need to define The software development life cycle lplc is a process used by the software industry to design, develop and test high-quality software consists of a detailed plan that describes how to develop maintain replace alternative software you should talk about your experience in fplc if you have no experience in it you can talk about your interest in working better now let's have a Look at some examples of technical questions you might be asked, the first one you might be asked to define business intelligence.

Business intelligence is the field that aims to extract meaningful and useful information from data analysis, analyze data sets and represent its information in the form of draft reports Map summary cards and other similar formats helped me make strategic business decisions and tactics. Next, you may be asked about the uses of business intelligence. The uses of business intelligence include that it helps improve decision making by gathering inside. Helps study market trends. what weak points in the business operation and helps improve the internal efficiency of the organizationnext question what is the date option the data flow consists of the sources from which we extract the data and the destination where we load the data consists of Transformations that modify and extend the data and the paths that link the sources Transformations and destination the three categories Important in data flow are data sources transformation and destination next question what is control The view for control flow consists of the tasks and containers that are executed when the target is executed to control the order or define the condition to execute the next task for the container in the package control flow we use Precision constraints that connect tasks and containers in a package SQL Server Integration Services provides three different types of control flow elements that include containers that provide structures and task packages that provide functionality constraints and principles that connect executable containers and tasks in an orderly flow of control.

What is wave olap? It is online analytical processing. is a computing method that allows users to easily and selectively extract and query data to analyze it from different points of view Ola's smart business queries that offer native insurance analysis, financial reports, sales forecasts, budgets and other purposes planning. You may then be asked to differentiate between olap and epl2. ETL can extract transformations using various transformations that are available in the tool and add the data that the output can generate. used as input for the olap ETL tool is the initial part of the data we have, while Olaf supports online reporting after performing certain join operations and creating some cubes reporting dashboard consolidation planning analysis Management workspace master data and foundation, you may be asked about the tools used in msdi there are three tools exercises or server integration services excel is useful for integrating data coming from different data sources into a database it is generally responsible for the sscs reverse transactions or SQL Server analysis which is an online analytical processing tool online analytical processing Data Mining and Report Query User in business intelligence required to create reports to better understand the data below what is the workflow in ss5 a workflow is a set of instructions program executors how to run tasks and containers within exercise packages below what is the difference between where and have clause on the real server now there can be three differences: first, the where clause have can be used with Group by clone, while weightloss is used with constructs like select, update, delete, etc., the have clause is applied as a filter until the runner clone gets us weightloss. applies to each row in the construction of selection, update, delete, etc. when clauses that have and where will have fabrics are applied after the weight loss to further filter the rare clone output, while the where clause is applied before the having clause to each row in the select statement below , what is the difference between View and materialized view?

First, the view definition displays query output as a table, while a materialized view or schema object that can be used to summarize, replicate, and distribute pre-computation data, for example to build a database, all Operations performed on the view will affect the data in the base table and the source, subject to integrity constraints and base table triggers, provides Internet access to the data table by storing the query results in a separate schema object A view can be used to simplify SQL statements for the user or to isolate an application from any future changes to the base table definition.

A view can also be used to improve security by restricting access to the default set of roles or columns. SQL Server first.truncate is a higher definition language command, while delete is a DML which is a data manipulation language command. Delete all records from a table without making a log entry for Revolution individual, while need delete all selected records from a table making a log entry for Revolution individual is truncated as much as possible, while deletion is purely truncated deletes all records from a table in which flowers or filter conditions cannot be used, while in case of delivery you can delete the selected record or all records seen from the robots weight loss, which is optional uses or is not effective kit cannot be used on a table if it is referenced by one or more foreign key constraints or is marked as enabled for replication while the need can be used in these conditions finally truncate the research identity in any of the columns in a table, while delete does not reset the identity in any of the columns in a table, next we have the intermediate level question, name the components of the exercise now Associates has five components, first is the Olaf engine, it is used to provide adverb queries by Then the user drills down, which is the process of exploring the details of the data.

Rotation is the process of changing categories of data between rows and columns. Slicing is the process of placing the data into the closing columns and the fifth component between the dimensional database is used in Ola. You will be asked to describe the sscs architecture. The architectural view of SQL Server Analytics Services is based on a key Tire architecture which, of course, consists of the rbbnf. Data from different sources like text from Excel database and others can be extracted with the help of ETL tools. The second RDP SSA, which aggregates data from rdbms aggregate data, is sent to the sfas queue by parsing this project, so SSS iterated over a parsing database and once the parsing was recognizes, can be used for many purposes, line of code client and access details using the four card board. portal etc.

Moving on to the next question, describe the errors in ssis. Errors typically occur due to unexpected data values ​​when a data flow component applies the transformation to the column data. Extract data from sources. A load. Keep an eye on the destination. Types of errors that occur when The Connection Manager. connections cannot be neutralized in case data meets data restore and controller flows that use the connection string a data transformation error occurs when detecting the transformation through a data pipeline from the source to destination, while an expression evaluation error occurs if the expressions are not evaluated at run time it is not realized what languages ​​are used in SSH, the use language in SSA or SQL, which is structured in any language, explains and manipulates databases.

Next is NBA, which is a multidimensional expression certificate language for online analytical processing using a database management system, as well as a query. language There is also a calculation language that behaves similarly to a spreadsheet formula. next dma for data mining extension is a language that you can use to create and work with data mining models in Excel. Fields that DMS can use to create the structure of new data mining modules to train these models and explore, manage, and predict against them. Next, we have the Analysis Services scripting language which adds an object definition language and a command language to create Management Services structures directly on the server.

You may use constantly applied ASL to communicate with the Analytics Services. Moving on to the exam protocol, what follows is the ability to update source systems, such as databases, to maintain systems of records while staying within the context of a bi application. This is essential to the concept of integrated bi. A good bi application will allow this data. securely and managedly update external settings and dimensions in the back, you may also be prompted to write an SQL query. Let's take an example to write a SQL query to extract Apple post from a cell. The SQL query for this will be to select the point calendar. points calendar your points member points element 0 in 0 of the adventure book your adventure table is the database that will give the result of the first pair of the set, as you can see below, which is the wrong header now, Under normal circumstances, each level in a Microsoft SQL Server Analysis Services hierarchy has the same number of top members as any other member in the same year in the right hierarchy.

The logical parent member of at least one member is not at the level immediately above the number; When this occurs, the hierarchy descends to different ones. levels for different detour routes expanding through each level for each small town road has been unnecessarily complicated now let's first move to the advanced level question what is the difference between DTS and ssis DDS stands for data transformation services while SSI stands for SQL Server integration program in TDL there is limited error handling while ssis provides more complex error handling the method in BTS the use of message book is active while in ssis in DPS there is no reserved implementation while in the exercises we always provide an interactive implementation wizard the entire data set from the specified search location as a result, the data stream in which the internal local transformation will not begin processing any data for the code until all rows in the query search have been captured in ssia.

Next, we have partial caution mode when using this search. The values ​​will be cached, but only on each distinct value found in the data stream. Initially, each distinct value will be retrieved individually from the specified code and then cached for clarity. This is a Roper Road Looper for each distinct electronic value next to no. cache mode will not add any value to the appearance of capturing the SSI Observatory. Each row in the pipeline data set will require a query against the lookup code, since there is no data flashing it is possible to save a small amount of ssis memory overhead in cases. where key value is not a fashion mode, it is not used much, but can be used in the following, when the reference data is too large to be reasonably loaded into exercise memory, the pipeline data set is small and it is not expected to grow, it is expected to be very few or no duplicates of key versions in the pipeline data how to log ssis execution ssis includes the login function the unit log entry when events occur runtime we can also write custom materials everything that is not enabled by default Integration Services support a diverse set of laws providers giving you the ability to create custom lock providers, Integration Services loss providers can writing log entries to text files SQL Server Profiler Skills Server Windows event law or HTML files can be enabled for logging even if the package itself is not how it is implemented ssis packages now there are two ways in which that ssis packages can be deployed.

The first is that the ssis project will provide the deployment manifest file. After running this file, you can deploy it to the file system or to SQL Server. The second method is to import the package from SAS Ms from the file system or SQL Server below to create a calculated member that crosses all the measurements, where do you put it and why now in MDX you can create a calculated number which is the member based in another member, you can create two. different types of calculated members that are measured and once they are nodes remember that a measure is considered a member of the measures valuation to create a calculated member that intersects all the measures, you would place it on a non-measure dimension because the member in a dimension cannot interpret its own relatives in that Dimension.

Next, what is the use of the property called Non-Emptive Behavior when creating the new member in a queue? Non-emptive behavior is used for the calculation of proportions and the MDF expression will generate an error if the denominator is empty just as it would if the denominator were equal to 0 when selecting one or more measures for the non-empty behavior problem, they are setting the requirement ofthat each selected measure is evaluated first before the calculated equation is evaluated if each selected measure is empty then the expression is also treated as and there is no error this is incorrect how are cubes implemented in SSA plus cube or dimensional hypercube of several months?

It is data structured in the SQL server at Alpha Services, which is built using zero-abatement databases to allow near-instant analysis. of data, the useful feature of an olap cube is that the data in the cube can be in aggregate form. SSAS cubes are created in a step-by-step CMS process using Tube Builder. This brings us to the end of today's session. I hope you now have a better understanding of reduced intelligence analysis and the interview questions you may be asked. I hope you enjoyed listening to this video, kindly like it and you can comment any of your doubts and queries and we will answer them as soon as possible.

Find more videos in our playlist and subscribe to edureka channel to learn more, happy learning.