Posts

Showing posts from July, 2025

What is Mean? Median? Mode? why they are used?

Image
Mean: Its nothing but Average.  Well, what is Average? When you see some scoring Not Higher, Not Lower, but medium marks like 50, 60 etc.. we call them average student. Example : Now, I have 5 Students Marks: 10,40,51,68,98 What is the Average mark of this 5 Students? 53.4 is the Average score of 5 students. How this is calculated? (10+40+51+68+98) / Number of values. How many values I have? 10,40,51,68,98 - I have 5 Values. So,  (10+40+51+68+98) / 5 267 / 5 = 53. 4 Mode: It is the number that is repeating more times in the group of numbers. Example:  I have money in my Pocket. 1 - 500 rupees Note, 3 - 100 Rupees Note, 7 - 20 Rupees Note. Now, tell me which Note I have the Most? 20 Rupees Right? because I have 7 20 rupees Notes.  Exactly, that is how we check Mode. If you are given data with numbers (1,2,3,4,5,5,5,5,5,5,6,7,8,9) You know which is Mode. It is 5, because it is the most available number in this group. Median: It is the central Point of data.  You a...

Basic & Commonly used Chart Types for Data Professionals

Image
As a Data Professional, Instead of showing data in a sentence or table, which is hard to read, You can show Data using suitable graph in Excel, Power BI, Tableau Etc. for better understanding  Column Chart Column Chart is made of Vertical Bars. Each Bar shows Each value.  Column Chart is mostly used to show the performance of an Employee every year, every month, etc... You can also use this chart to show Sales, Quantity, Improvement by time period. It works best if you have X axis = Timeline & Y axis = Quantity / Value. Bar Chart: Bar Chart is made of Horizontal Bars. Each Bar shows Value of Each Category. You can use this Chart to show Data by Category Like Products: TV, Mobile, Fridge. It helps analyze which is a Top Category and which is a Lowest Category. It works best if you have X axis = Value & Y axis = Category. Line Chart: It is used to show Trends over time. Internet Service provider Companies can check how the Internet speed in your area changes every Second...

What is a Chart? Why is it used by Data Professionals?

Image
 A Chart is a Visual Representation of Data Trends, Patterns and Insights.  Its like you are looking at a picture and understanding what is happening with the data. Same like watching a Movie instead of reading the Movie story. Why? Chart gives Fast, Better and Simple Understanding of a Big Complex Data. When you become a Data Analyst or Data Scientist in future. You will present your Data with Charts. Your Manager, Program Head, Clients, Directors.. they don't have time to read the entire data from a excel file or PowerPoint file.  A Chart will make it easier for them to understand the Situation, Progress, Profit, Loss, Improvement, Danger etc.. within few seconds of looking at the Charts. There are around 100 Charts available in Data Science World. Each has its own purpose. When you create Multiple Charts in a single page, it is called Report. When you build Multiple pages of report, it is called Dashboards.  If you create Best Quality & Easy to Understand Char...

Commonly used Prediction Models in Machine Learning? Explain Each Model and How it Works?

Image
Regression models are a type of machine learning model used to predict. It tries to find a relationship between columns.  Regression Models are ready-made mathematical formulas created to make life easier . 1. Linear Regression: Linear Regression is a model that checks whether there is a relationship between two or more columns. The relationship means: if one column value increases, will the other column value also increase or decrease. If you study more hours, your marks will increase. If you have more work experience, your salary will increase. These are called positive relationships. Example: Students Mark - It can change over time, It is a Numerical score. Sales - It can change over time, It is a Numerical Count. Temperature - It can change over time. It is Number based. Here is a Simple Linear Regression Graph: If you have a Students Marks & Study time data for past 1 year, you can predict future marks using Linear Regression. 2. Logistic Regression: It is used for Pr...

What is Prediction in Machine Learning? Why is it Useful?

Image
Prediction - Finding out what will happen in Future. It may not be 100% Exact. But At least you know something is more likely to happen, with the help of prediction Analysis. This is called Predictive Analysis . One of the four important Types of Analysis. If you have last 10 months of students mark data, you can do predictive analysis and find future marks of the students. Why Predictive Analysis is Useful in Real Jobs? Sales Department : To Predict next month’s Profit, Sales, Product preference. Marketing Department : To Predict which customer is likely to buy a product. HR Department : To Predict which employee may leave the company in upcoming months. Education Sector : To Predict student performance and give early support before exams. Healthcare : To Predict patient risk level or future disease based on historic records. Government: To Predict Future Population Growth, Future Economy Level, Future Demands, Future Employment and business growth. Military: To Predict threats, Ear...

What is Artificial Intelligence? What is Machine Learning? What is Data Science? how they are related to each other?

Image
Artificial Intelligence means making Computers think like Human Brain, choosing correct & realistic decisions, answers based on the Current circumstance and importance. Personal Example: Data Science = What is Actually Happening in your Life. Machine Learning = What you are learning and experiencing in your Life. Artificial Intelligence = Taking Correct Decisions based on your Life Experience Another Example: You are AI Engineer & you created a Personal AI Friend using Python. Now, You give all information about your Financial Status, Economic Status, Emotional Status, Social Status, Current Situation in your Life, Current Situation in your Family, Current Situation in your Country etc etc... and your Current problems in an Excel file or SQL Database. Now you are giving this data to your AI tool which you created. 1. It will analyze the information, choose which is important and which is useless based on your current situation. 2. Now, it sends that important Information to Mac...