CloudyML - Data Science & Analytics
46.6K subscribers
260 photos
54 videos
33 files
1.1K links
My Assignment Driven Data Science Courses
https://linktr.ee/cloudyml

My LinkedIn profile
https://www.linkedin.com/in/akashraj001

My Instagram
https://www.instagram.com/cloudyml.akash
Download Telegram
πŸ”΅ Interview QnA Explained Video

Python interview question asked in Meta Company, by Instagram team.

Check explained solution on our YouTube channel, link below.


πŸ‘‰πŸ»https://youtu.be/jdQEjf3cdbQ
Today's Interview QnAs

Company- Wipro

Role: Data Scientist


1. List the most popular distribution curves along with scenarios where you will use them in an algorithm.

Ans: The most popular distribution curves are as follows- Bernoulli Distribution, Uniform Distribution, Binomial Distribution, Normal Distribution, Poisson Distribution, and Exponential Distribution.
Each of these distribution curves is used in various scenarios.

Bernoulli Distribution can be used to check if a team will win a championship or not, a newborn child is either male or female, you either pass an exam or not, etc.

Uniform distribution is a probability distribution that has a constant probability. Rolling a single dice is one example because it has a fixed number of outcomes.

Binomial distribution is a probability with only two possible outcomes, the prefix β€˜bi’ means two or twice. An example of this would be a coin toss. The outcome will either be heads or tails.

Normal distribution describes how the values of a variable are distributed. It is typically a symmetric distribution where most of the observations cluster around the central peak. The values further away from the mean taper off equally in both directions. An example would be the height of students in a classroom.

Poisson distribution helps predict the probability of certain events happening when you know how often that event has occurred. It can be used by businessmen to make forecasts about the number of customers on certain days and allows them to adjust supply according to the demand.

Exponential distribution is concerned with the amount of time until a specific event occurs. For example, how long a car battery would last, in months.


2.Why is logistic regression a type of classification technique and not a regression? Name the function it is derived from?

Ans: Since the target column is categorical, it uses linear regression to create an odd function that is wrapped with a log function to use regression as a classifier. Hence, it is a type of classification technique and not a regression. It is derived from cost function.


3. What is OOB error and how does it occur?

Ans: For each bootstrap sample, there is one-third of data that was not used in the creation of the tree, i.e., it was out of the sample. This data is referred to as out of bag data. In order to get an unbiased measure of the accuracy of the model over test data, out of bag error is used. The out of bag data is passed for each tree is passed through that tree and the outputs are aggregated to give out of bag error. This percentage error is quite effective in estimating the error in the testing set and does not require further cross-validation.


4. State the limitations of Fixed Basis Function.

Ans: Linear separability in feature space doesn’t imply linear separability in input space. So, Inputs are non-linearly transformed using vectors of basic functions with increased dimensionality. Limitations of Fixed basis functions are:

Non-Linear transformations cannot remove overlap between two classes but they can increase overlap.
Often it is not clear which basis functions are the best fit for a given task. So, learning the basic functions can be useful over using fixed basis functions.
If we want to use only fixed ones, we can use a lot of them and let the model figure out the best fit but that would lead to overfitting the model thereby making it unstable.
πŸ‘1
If you are someone, who wanna make your career in Data Analytics from scratch, we have a special dedicated course for YOU.

CloudyML Data Analytics/Business Analytics Combo Course
which covers everything which is important for you from scratch.

Visit Course NowπŸ‘‰πŸ» https://ai.cloudyml.com/analytics

Course Contains
βœ… Python (Worth Price: β‚Ή1499)
βœ… SQL (Worth Price: β‚Ή1499)
βœ… Maths & Statistics (Worth Price: β‚Ή1499)
βœ… Ms Excel (Worth Price: β‚Ή1499)
βœ… Tableau (Worth Price: β‚Ή2499)
βœ… PowerBi (Worth Price: β‚Ή2499)

Total worth price of our Analytics Combo Course is 10994 but today, we are offering this course at 3999/- only.

With all that, you are getting 1-1 Live Doubt Clearance support, 100% Internship Opportunity, Job Referral Mails, Sample resumes, Resume Review, Job Opening Mails etc.

Visit Course Now
πŸ‘‰πŸ» https://ai.cloudyml.com/analytics
πŸ”΅ Interview QnA Explained Video

Python interview question asked in GOOGLE, AMAZON, FACEBOOK

Check explained solution on our YouTube channel, link below.

πŸ‘‰πŸ» https://youtu.be/1TO7MdxC4oM
πŸ”΄JOB OPENING ALERTπŸ”΄


Role: Data Scientist
Company: Talentify
Exp: 0 - 5 years
Link: https://ai.cloudyml.com/3PaBREH


Role: Machine Learning Engineer
Company: 2Coms
Exp: 0 - 5 years
Link: https://ai.cloudyml.com/3srz40i


Role: Data Analyst
Company: Lemniscate Technologies
Exp: 0 - 1 years
Link: https://ai.cloudyml.com/399KC16


Role: Data Analyst
Company: A & M Supplies India Private Limited
Exp: 0 - 2 years
Link: https://ai.cloudyml.com/396RYm2
πŸ”΅Top 5 Python Functions YOU MUST KNOW !!!

Check our explained video on our YouTube channel. Link Below.

➑️ https://youtu.be/D9TVCmUxVNg
#quiz

Which of the query below is used to put a value in a variable we need to define for our SQL query?
Anonymous Quiz
16%
Id = 6;
29%
SET @id = 6;
45%
SET id = 6;
πŸ”΅ Interview QnA Explained Video

Python Interview Question asked in MICROSOFT

Check explained solution on our YouTube channel, link below.

πŸ‘‰πŸ» https://youtu.be/cdUCV4j9guo
Get hands-on learning experience and become master in Python, SQL, Statistics, Tableau, Excel, PowerBi with 10+ analytics Case Studies😎

πŸ”΄Visit our Data Analytics/ Business Analytics Combo Course Now

LinkπŸ‘‰πŸ» https://ai.cloudyml.com/analytics
"Hello World" of Data Science !

Check our latest video on YouTube in which we have worked on Kaggle Titanic Datatset that you should check before working on any other challenge.

Video LinkπŸ‘‰πŸ» https://youtu.be/Mlq41Wd61nc
Today's Interview QnAs

Company- Tiger Analytics

Role - Data Analyst


1.How to create sets in tableau?

Sets are custom fields used to compare and ask questions about a subset of data. For creating a set on dimension, right-click on a dimension in data pane and select create -> set. In general tab select the fields that will be considered for computing the set. Specify the conditions to create set in conditions tab and you also have the option to select top N members in dataset based on any field in the top tab. When a set is created it divides the measure into two parts namely in and out of the set based on the conditions applied by the user.


2. What is live and extract in tableau?

Extract is a snapshot of the data optimized for aggregation. Extracts are loaded into the system and hence improve the performance of tableau. Whereas extracts won’t help in situations where data is updated continuously because then we manually need to refresh the data for all the updates but using a live connection might slow the processing but will definitely update the data source itself. So, live connection should be used only when data is continuously updating otherwise extract file is preferred.


3.Differentiate between K-Means and KNN algorithms?

KNN algorithms is Supervised Learning where-as K-Means is Unsupervised Learning. With KNN, we predict the label of the unidentified element based on its nearest neighbour and further extend this approach for solving classification/regression-based problems.

K-Means is Unsupervised Learning, where we don’t have any Labels present, in other words, no Target Variables and thus we try to cluster the data based upon their coordinates and try to establish the nature of the cluster based on the elements filtered for that cluster.


4.What is absolute cell reference in excel?

Absolute cell reference is a locked reference and ensures that the rows and columns will not change on copying the cell. We add a '$' symbol in front of the row and column number. When the cell is $A$2, both rows and columns remain unchanged on copying. But if it is $A2, it means that the column remains unchanged, but the row changes on copying. Similarly, for A$2, the column changes, but the row remains unchanged on copying.

β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”

πŸ”΄Become a Pro in Tableau, PowerBi and Excel. Check our Data Visualization Course Package Now. Link Below

πŸ‘‰πŸ» https://ai.cloudyml.com/data-visualization
If you want to understand how recursion works with examples then Click on the link below and check our latest video on YouTube in which we have Decoded Recursion in python😎

Link
πŸ‘‰πŸ» https://youtu.be/8d_YAW9l1QQ
Today's Interview QnAs

Company - Mindtree

Role : Data Analyst


1. What are the different data types of Tableau.

Ans: There are 7 data types in Tableau

-Boolean (True/False)
-Date (Individual Value)
-Date and Time
-Geography
-Text or String
-Decimal Number
-Whole Number


2.What is a dual-axis?

Ans: It is a function in Tableau that showcases two scales of two measures in a single graph. This is very similar to the function found on Microsoft Office products where a single graph has line and bar elements. In most cases, it has either two X or two Y axes.

A dual-axis is typically used to show trend lines and historical data. An example would be total revenue vs profit across 12 months.

3. What is the shortcut to add a filter to a table?

Ans: The filter mechanism is used when you want to display only specific data from the entire dataset. By doing so, there is no change being made to the data. The shortcut to add a filter to a table is Ctrl+Shift+L.


4. What are the wildcards available in Excel?

Ans: Wildcards only work with text data. Excel has three wildcards.

1. * (Asterisk)
This refers to any number of characters.
2.? (Question mark)
It represents one single character.
3.~ (Tilde)
It is used to identify a wildcard character (~, *, ?) in the text

β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”

πŸ”΄If you wanna switch your career from any domain to Data Analytics OR Business Analytics then check our DATA ANALYTICS/ BUSINESS ANALYTICS COMBO COURSE.

In this course, you will get complete roadmap towards your goal from scratch and it will make you technically strong enough so you can crack any Data Analyst OR Business Analyst Job Interview.

This course covers Python, SQL, Statistics, Tableau, PowerBi, Excel, Case studies with 1-1 Live Doubt Clearance Support over Skype chat everyday. Check the course NOW!

Course LinkπŸ‘‰πŸ» https://ai.cloudyml.com/analytics
#Quiz

We can compute the coefficient of linear regression by using
Anonymous Quiz
42%
Gradient descent
19%
Normal Equation
35%
Both
4%
None of the above
πŸ‘1
Media is too big
VIEW IN TELEGRAM
Check out our Data Science and Analytics Mega Combo Course Now.

Link
➑️ https://ai.cloudyml.com/Mega-Combo
Wanna know about career in Data Science and company wise salaries ?🧐

Check out our new YouTube Video in which we have shared all the details of Highly Paying Companies in Data Science Domain🀩

Video Link
πŸ‘‰πŸ» https://youtu.be/xJCYWnc7l5w
Today's Interview QnAs

Company- United Breweries

Role- Data Analyst


1. What is analysis in tableau?

Tableau comes with inbuilt features to analyze the data plotted on a chart. We have various tools such as adding an average line to the chart which tableau calculates itself after we drop the tool on the chart. Some other features include clustering, percentages, forming bands of a particular range and various other tools to explore and inspect data. All these tools are available in analyze tab on each sheet used to create any chart. The features become visible only when they are applicable to the worksheet.


2. What is quick filter in tableau?

Whenever using a filter in Tableau, it comes with some options to change the functionality of filter very easily, such as using it as a single value drop down or single value list or multiple value list or multiple value drop down and various other options. After we set a filter to a sheet just right click on the sheet and there you can see all the quick filter options. Changes made to these options will also change the aesthetics of filter shown on the sheet.


3.How do you apply a single format to all the sheets present in a workbook?

To apply the same format to all the sheets of a workbook, follow the given steps:

-Right-click on any sheet present in that workbook
-Then, click on the Select All Sheets option
-Format any of the sheets and you will see that the format has been applied to all the other sheets as well


4.Explain SUM and SUMIF functions.

SUM: The SUM function is used to calculate the sum of all the values that are specified as a parameter to it. The syntax of this function is as follows:

SUM(number1, number2, …)

SUMIF: This function is used to calculate the sum of values that comply with a given condition.

SYNTAX:

SUMIF(range, criteria, [sum_range])

where,

range specifies the range of cells to be evaluated
criteria provides the condition to be met
sum_range is optional and provides the actual cells to be summed up

β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”-

πŸ”΄If you wanna switch your career from any domain to Data Science OR Data Analytics OR Business Analytics then check our MEGA COMBO COURSE PACKAGE.

This course package, you are getting Python, SQL, Statistics, Machine Learning, Deep Learning, AWS Sagemaker, Model Deployment, Tableau, PowerBi, Excel, Case studies, Capstone End-to-End Projects of ML and DL with 1-1 Live Doubt Clearance Support over Skype chat everyday. Check the course NOW!

Course LinkπŸ‘‰πŸ» https://ai.cloudyml.com/Mega-Combo
Top Pandas commands you must know before going for Data Science interviews.

Watch our new YouTube video in which we have explained all the important Pandas commands in depth.

Link
πŸ‘‰πŸ» https://youtu.be/pKhajRGb_Ug
If you wanna become Job-Ready Data Scientist, Data Analyst OR Business Analyst then you should check our Data Science and Analytics MEGA COMBO COURSE. Link Below.

Course Link - https://www.cloudyml.com/mega-combo-package/

You gonna get complete Hands-on Practical Learning Experience from scratch.

In this package you are getting the topics mentioned below

βœ…Python
βœ…Machine Learning
βœ…SQL
βœ…Maths and Statistics
βœ…Deep Learning
βœ…AWS Sagemaker
βœ…Tableau
βœ…PowerBi
βœ…MS Excel
βœ…Model Deployment
βœ…Capstone End-to-End ML and DL Projects
βœ…Data Analytics Case Studies

With all these topics, you are also getting

βœ…1-1 Live Doubt Clearance Support
βœ…100% Internship Opportunity after course completion
βœ…Job referrals and job opening mails
βœ…Sample Resume and Resume Review Feature
βœ…Course Completion Certificate

So start your journey today and become technically strong enough so you can crack any Data Science OR Analytics Interview.

Join Now - https://www.cloudyml.com/mega-combo-package/

Trusted by 5500+ Happy Learners !