π¨Check our latest YouTube video in which we have covered Aptitude Problems asked in Data Science Interview Round of Acrotrend Company
ππ» https://youtu.be/uxuhccC9C3A
ππ» https://youtu.be/uxuhccC9C3A
Date: 09th August, 2022
Company - HSBC
Role - Data scientist
Topic: Statistics, ML, Linear algebra
1. What are exploding gradients?
Exploding Gradients is the problematic scenario where large error gradients accumulate to result in very large updates to the weights of neural network models in the training stage. In an extreme case, the value of weights can overflow and result in NaN values. Hence the model becomes unstable and is unable to learn from the training data.
2.Explain the Law of Large Numbers.
The βLaw of Large Numbersβ states that if an experiment is repeated independently a large number of times, the average of the individual results is close to the expected value.
There are two forms of the law of large numbers, but the differences are primarily theoretical.
The weak law of large numbers states that as n increases, the sample statistic of the sequence converges in probability to the population value.
The strong law of large numbers describes how a sample statistic converges on the population value as the sample size or the number of trials increases. For example, the sample mean will converge on the population mean as the sample size increases.
3. What is the importance of A/B testing.
The goal of A/B testing is to pick the best variant among two hypotheses, the use cases of this kind of testing could be a web page or application responsiveness, landing page redesign, banner testing, marketing campaign performance etc.
The first step is to confirm a conversion goal, and then statistical analysis is used to understand which alternative performs better for the given conversion goal.
4. Explain Eigenvectors and Eigenvalues.
Eigenvectors depict the direction in which a linear transformation moves and acts by compressing, flipping, or stretching. They are used to understand linear transformations and are generally calculated for a correlation or covariance matrix.
The eigenvalue is the strength of the transformation in the direction of the eigenvector.
An eigenvectorβs direction remains unchanged when a linear transformation is applied to it.
ββββββββββββββββββββ-
π¨MAKE YOUR CAREER IN DATA SCIENCE AND ANALYTICS WITH CLOUDYML FROM SCRATCH. TRUSTED BY 7000+ HAPPY LEARNERS
This course package, you are getting Python, SQL, Statistics, Machine Learning, Deep Learning, AWS Sagemaker, Model Deployment, Tableau, PowerBi, Amazon QuickSight, Google Data Studio, Excel, Case studies, Interview QnAs PDF, 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
Company - HSBC
Role - Data scientist
Topic: Statistics, ML, Linear algebra
1. What are exploding gradients?
Exploding Gradients is the problematic scenario where large error gradients accumulate to result in very large updates to the weights of neural network models in the training stage. In an extreme case, the value of weights can overflow and result in NaN values. Hence the model becomes unstable and is unable to learn from the training data.
2.Explain the Law of Large Numbers.
The βLaw of Large Numbersβ states that if an experiment is repeated independently a large number of times, the average of the individual results is close to the expected value.
There are two forms of the law of large numbers, but the differences are primarily theoretical.
The weak law of large numbers states that as n increases, the sample statistic of the sequence converges in probability to the population value.
The strong law of large numbers describes how a sample statistic converges on the population value as the sample size or the number of trials increases. For example, the sample mean will converge on the population mean as the sample size increases.
3. What is the importance of A/B testing.
The goal of A/B testing is to pick the best variant among two hypotheses, the use cases of this kind of testing could be a web page or application responsiveness, landing page redesign, banner testing, marketing campaign performance etc.
The first step is to confirm a conversion goal, and then statistical analysis is used to understand which alternative performs better for the given conversion goal.
4. Explain Eigenvectors and Eigenvalues.
Eigenvectors depict the direction in which a linear transformation moves and acts by compressing, flipping, or stretching. They are used to understand linear transformations and are generally calculated for a correlation or covariance matrix.
The eigenvalue is the strength of the transformation in the direction of the eigenvector.
An eigenvectorβs direction remains unchanged when a linear transformation is applied to it.
ββββββββββββββββββββ-
π¨MAKE YOUR CAREER IN DATA SCIENCE AND ANALYTICS WITH CLOUDYML FROM SCRATCH. TRUSTED BY 7000+ HAPPY LEARNERS
This course package, you are getting Python, SQL, Statistics, Machine Learning, Deep Learning, AWS Sagemaker, Model Deployment, Tableau, PowerBi, Amazon QuickSight, Google Data Studio, Excel, Case studies, Interview QnAs PDF, 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
#Quizzzz
Observe the following code and identify what will be the outcome?
import numpy as np
x = np.array([[0, 1], [2, 3]])
np.transpose(x)
Observe the following code and identify what will be the outcome?
import numpy as np
x = np.array([[0, 1], [2, 3]])
np.transpose(x)
Choose the correct answer:
Anonymous Quiz
36%
array([[0, 2], [1, 3]])
30%
array([[0, 2], [1, 3]])
18%
array([[2, 3], [0, 1]])
15%
None of the above
Learn MS Excel in less than an Hour. Watch our latest MS Excel Crash Course video on YouTube for Data Analytics. Link given below
ππ»https://youtu.be/K_akKVHJ4Zs
ππ»https://youtu.be/K_akKVHJ4Zs
Date: 10th August, 2022
Company β Infosys
Role- Data Analyst
Topics: SQL, Tableau, PowerBi
1. What is the difference between SQL and MySQL?
SQL is a standard language for retrieving and manipulating structured databases. On the contrary, MySQL is a relational database management system, like SQL Server, Oracle or IBM DB2, that is used to manage SQL databases.
2. What is Data Integrity?
Data Integrity is the assurance of accuracy and consistency of data over its entire life-cycle and is a critical aspect of the design, implementation, and usage of any system which stores, processes, or retrieves data.
3. What is the Use of Dual-axis in Tableau?
Dual Axis allows you to compare measures, and this is useful when you want to compare two measures that have different scales.
4. How Can You Embed a Webpage in a Dashboard?
Follow these simple steps to embed a webpage in a dashboard:
1. Go to dashboard
2. Double click the βWebpageβ option available under βObjects.β
3. Enter the URL (here https://www.cloudyml.com) of the webpage in the dialog box that appears
You can see the webpage appears on the dashboard.
5. What is x-velocity in Power Pivot?
X-Velocity is the in-memory analytics engine behind Power Pivot that loads and handles huge data in Power BI. It stores data in columnar storage that results in faster processing.
ββββββββββββββββββββ-
π¨MAKE YOUR CAREER IN DATA SCIENCE AND ANALYTICS WITH CLOUDYML FROM SCRATCH. TRUSTED BY 7000+ HAPPY LEARNERS
This course package, you are getting Python, SQL, Statistics, Machine Learning, Deep Learning, AWS Sagemaker, Model Deployment, Tableau, PowerBi, Amazon QuickSight, Google Data Studio, Excel, Case studies, Interview QnAs PDF, 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
Company β Infosys
Role- Data Analyst
Topics: SQL, Tableau, PowerBi
1. What is the difference between SQL and MySQL?
SQL is a standard language for retrieving and manipulating structured databases. On the contrary, MySQL is a relational database management system, like SQL Server, Oracle or IBM DB2, that is used to manage SQL databases.
2. What is Data Integrity?
Data Integrity is the assurance of accuracy and consistency of data over its entire life-cycle and is a critical aspect of the design, implementation, and usage of any system which stores, processes, or retrieves data.
3. What is the Use of Dual-axis in Tableau?
Dual Axis allows you to compare measures, and this is useful when you want to compare two measures that have different scales.
4. How Can You Embed a Webpage in a Dashboard?
Follow these simple steps to embed a webpage in a dashboard:
1. Go to dashboard
2. Double click the βWebpageβ option available under βObjects.β
3. Enter the URL (here https://www.cloudyml.com) of the webpage in the dialog box that appears
You can see the webpage appears on the dashboard.
5. What is x-velocity in Power Pivot?
X-Velocity is the in-memory analytics engine behind Power Pivot that loads and handles huge data in Power BI. It stores data in columnar storage that results in faster processing.
ββββββββββββββββββββ-
π¨MAKE YOUR CAREER IN DATA SCIENCE AND ANALYTICS WITH CLOUDYML FROM SCRATCH. TRUSTED BY 7000+ HAPPY LEARNERS
This course package, you are getting Python, SQL, Statistics, Machine Learning, Deep Learning, AWS Sagemaker, Model Deployment, Tableau, PowerBi, Amazon QuickSight, Google Data Studio, Excel, Case studies, Interview QnAs PDF, 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
DSA Hand Written Notes by CloudyML.pdf
3.7 MB
Data Structure & Algorithms Hand Written Notes. Download Nowβ¬οΈ
Date: 11th August, 2022
Company - Capgemini
Role- ML Engineer
Topic: Statistics, Machine Learning
1. Why Is Re-sampling Done?
Ans. Resampling is done to:
- Estimate the accuracy of sample statistics with the subsets of accessible data at hand.
- Substitute data point labels while performing significance tests.
- Validate models by using random subsets.
2. What is systematic sampling and cluster sampling ?
Systematic sampling is a type of probability sampling method. The sample members are selected from a larger population with a random starting point but a fixed periodic interval. This interval is known as the sampling interval. The sampling interval is calculated by dividing the population size by the desired sample size.
Cluster sampling involves dividing the sample population into separate groups, called clusters. Then, a simple random sample of clusters is selected from the population. Analysis is conducted on data from the sampled clusters.
3. What are Autoencoders?
An autoencoder is a kind of artificial neural network. It is used to learn efficient data codings in an unsupervised manner. It is utilised for learning a representation (encoding) for a set of data, mostly for dimensionality reduction, by training the network to ignore signal βnoiseβ. Autoencoder also tries to generate a representation as close as possible to its original input from the reduced encoding.
4. What are the steps to build a Random Forest Model?
A Random Forest is essentially a build up of a number of decision trees. The steps to build a random forest model include:
Step1: Select βkβ features from a total of βmβ features, randomly. Here k << m
Step2: Calculate node D using the best split point β along the βkβ features
Step 3: Split the node into daughter nodes using best splitStep 4: Repeat Steps 2 and 3 until the leaf nodes are finalised
Step5: Build a Random forest by repeating steps 1-4 for βnβ times to create βnβ number of trees.
Company - Capgemini
Role- ML Engineer
Topic: Statistics, Machine Learning
1. Why Is Re-sampling Done?
Ans. Resampling is done to:
- Estimate the accuracy of sample statistics with the subsets of accessible data at hand.
- Substitute data point labels while performing significance tests.
- Validate models by using random subsets.
2. What is systematic sampling and cluster sampling ?
Systematic sampling is a type of probability sampling method. The sample members are selected from a larger population with a random starting point but a fixed periodic interval. This interval is known as the sampling interval. The sampling interval is calculated by dividing the population size by the desired sample size.
Cluster sampling involves dividing the sample population into separate groups, called clusters. Then, a simple random sample of clusters is selected from the population. Analysis is conducted on data from the sampled clusters.
3. What are Autoencoders?
An autoencoder is a kind of artificial neural network. It is used to learn efficient data codings in an unsupervised manner. It is utilised for learning a representation (encoding) for a set of data, mostly for dimensionality reduction, by training the network to ignore signal βnoiseβ. Autoencoder also tries to generate a representation as close as possible to its original input from the reduced encoding.
4. What are the steps to build a Random Forest Model?
A Random Forest is essentially a build up of a number of decision trees. The steps to build a random forest model include:
Step1: Select βkβ features from a total of βmβ features, randomly. Here k << m
Step2: Calculate node D using the best split point β along the βkβ features
Step 3: Split the node into daughter nodes using best splitStep 4: Repeat Steps 2 and 3 until the leaf nodes are finalised
Step5: Build a Random forest by repeating steps 1-4 for βnβ times to create βnβ number of trees.
If you wanna be a ML Engineer then we have something special for youπ€©
A course which will make your Job Interview Ready for the role of ML Engineer from Scratch.
π₯ML Engineer Combo Courseπ₯
Course covers
β Python
β Advanced SQL
β Statistics and Maths
β Machine Learning
β Deep Learning
β Data Structure and Algorithm
β Capstone End-to-End projects.
β 100% Internship Opportunity
More features and complete details you can check on our website. Link belowππ»
β‘οΈ https://www.cloudyml.com/ml-engineer-course
A course which will make your Job Interview Ready for the role of ML Engineer from Scratch.
π₯ML Engineer Combo Courseπ₯
Course covers
β Python
β Advanced SQL
β Statistics and Maths
β Machine Learning
β Deep Learning
β Data Structure and Algorithm
β Capstone End-to-End projects.
β 100% Internship Opportunity
More features and complete details you can check on our website. Link belowππ»
β‘οΈ https://www.cloudyml.com/ml-engineer-course
#Quiz
Observe the following code and solve it using pen and paper for logic building.
a = [1, 2, 3, 4, 5]
sum = 0
for ele in a:
sum -= ele
print(sum)
Observe the following code and solve it using pen and paper for logic building.
a = [1, 2, 3, 4, 5]
sum = 0
for ele in a:
sum -= ele
print(sum)
Date: 12th August, 2022
Company: PWC
Role: Data Scientist
Topic: Statistics
1. What is p-value in hypothesis testing?
If the p-value is more than then critical value, then we fail to reject the H0
If p-value = 0.015 (critical value = 0.05) β strong evidence
If p-value = 0.055 (critical value = 0.05) β weak evidence
If the p-value is less than the critical value, then we reject the H0
If p-value = 0.055 (critical value = 0.05) β weak evidence
If p-value = 0.005 (critical value = 0.05) β strong evidence
2. What is the difference between one tail and two tail hypothesis testing?
2-tail test: Critical region is on both sides of the distribution
H0: x = Β΅
H1: x <> Β΅
1-tail test: Critical region is on one side of the distribution
H1: x <= Β΅
H1: x > Β΅
3. What is the Six sigma in statistic?
In quality control, an error-free data set is generated using six sigma statistics. Ο is known as standard deviation. The lower the standard deviation, the less likely that a process performs accurately and commits errors. If a process delivers 99.99966% error-free results, it is said to be six sigma. A six sigma model is one that outperforms 1Ο, 2Ο, 3Ο, 4Ο, and 5Ο processes and is sufficiently reliable to deliver defect-free work.
4. What does KPI stand for in statistics?
A KPI is a quantifiable measure to evaluate whether the objectives are being met or not.
It is a reliable metric to measure the performance level of an organisation or individual.
An example of a KPI in an organisation such as the expense ratio.
In terms of performance, KPIs are an effective way of measuring whether an organisation or individual is meeting expectations.
ββββββββββββββββββββ-
π¨MAKE YOUR CAREER IN DATA SCIENCE AND ANALYTICS WITH CLOUDYML FROM SCRATCH. TRUSTED BY 7000+ HAPPY LEARNERS
This course package, you are getting Python, SQL, Statistics, Machine Learning, Deep Learning, AWS Sagemaker, Model Deployment, Tableau, PowerBi, Amazon QuickSight, Google Data Studio, Excel, Case studies, Interview QnAs PDF, 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
Company: PWC
Role: Data Scientist
Topic: Statistics
1. What is p-value in hypothesis testing?
If the p-value is more than then critical value, then we fail to reject the H0
If p-value = 0.015 (critical value = 0.05) β strong evidence
If p-value = 0.055 (critical value = 0.05) β weak evidence
If the p-value is less than the critical value, then we reject the H0
If p-value = 0.055 (critical value = 0.05) β weak evidence
If p-value = 0.005 (critical value = 0.05) β strong evidence
2. What is the difference between one tail and two tail hypothesis testing?
2-tail test: Critical region is on both sides of the distribution
H0: x = Β΅
H1: x <> Β΅
1-tail test: Critical region is on one side of the distribution
H1: x <= Β΅
H1: x > Β΅
3. What is the Six sigma in statistic?
In quality control, an error-free data set is generated using six sigma statistics. Ο is known as standard deviation. The lower the standard deviation, the less likely that a process performs accurately and commits errors. If a process delivers 99.99966% error-free results, it is said to be six sigma. A six sigma model is one that outperforms 1Ο, 2Ο, 3Ο, 4Ο, and 5Ο processes and is sufficiently reliable to deliver defect-free work.
4. What does KPI stand for in statistics?
A KPI is a quantifiable measure to evaluate whether the objectives are being met or not.
It is a reliable metric to measure the performance level of an organisation or individual.
An example of a KPI in an organisation such as the expense ratio.
In terms of performance, KPIs are an effective way of measuring whether an organisation or individual is meeting expectations.
ββββββββββββββββββββ-
π¨MAKE YOUR CAREER IN DATA SCIENCE AND ANALYTICS WITH CLOUDYML FROM SCRATCH. TRUSTED BY 7000+ HAPPY LEARNERS
This course package, you are getting Python, SQL, Statistics, Machine Learning, Deep Learning, AWS Sagemaker, Model Deployment, Tableau, PowerBi, Amazon QuickSight, Google Data Studio, Excel, Case studies, Interview QnAs PDF, 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
#Quiz
Given a normal distribution, what percentage of scores fall within one standard deviation of the mean?
Given a normal distribution, what percentage of scores fall within one standard deviation of the mean?
Anonymous Quiz
23%
50% of scores
47%
68% of scores
17%
95% of scores
13%
99.7% of scores
π₯TABLEAU CRASH COURSEπ₯
Learn OR Revise your concepts of Tableau in 1 Hour. Watch our latest YouTube Video. Link given below
β‘οΈ https://youtu.be/uwuEFHwf3U0
Learn OR Revise your concepts of Tableau in 1 Hour. Watch our latest YouTube Video. Link given below
β‘οΈ https://youtu.be/uwuEFHwf3U0
Date: 13th August, 2022
Company: LTI
Role: Data Analyst
Topic: Excel
1. How to use excel formulas?
Formulas in Excel are expressions that can make the calculation based on the information in your spreadsheet. The formula can be used in Excel by first selecting an empty cell where you want to enter the formula. The way to add formula syntax is by typing the β=β equal sign and then followed by operators to be used in the calculation.
The relevant operators used in the formula should be kept between opening and closing parenthesis. Press Enter to get the results.
2. What is macro in excel?
Macro refers to an algorithm or a set of actions that help automate a task in Excel by recording and playing back the steps taken to complete that task. Once the steps are stored, you create a Macro, and it can be edited and played back as many times as the user wants.
Macro is great for repetitive tasks and also eliminates errors. For example, suppose an account manager has to share reports regarding the company employees for non-payment of dues. In that case, it can be automated using a Macro and doing minor changes every month, as needed.
3. How to maintain accounts in excel sheet format?
You can maintain accounts in an Excel sheet by using its rows and columns for record-keeping and keep track of account-related information such as account numbers, invoicing, and receipt of payments.
The cells can be used to input client or account holder information. The expenses can be calculated using the formula =SUM (F3:F6). You can also use tools such as expense tracking tools and contract tools for auto-invoicing, performing tracking, and billing of expenses.
4. How to create a serial number generator in excel?
You can create serial numbers in Excel using the Autofill method. Here are the steps β
Insert value (letβs say 1) in a row and select it as the active cell.
You will notice that a small box or filler icon at the bottom right of the active cell will appear.
Double click on that box icon to drag to the desired cell.
Now go back to the second row and insert another value (letβs say 2).
Now select both the cells at once, and the box or filler icon will appear again.
Drag down the icon to the desired row, and you will notice that this time it shows serial numbers starting with the first value we inserted (1).
ββββββββββββββββββββ-
π¨MAKE YOUR CAREER IN DATA SCIENCE AND ANALYTICS WITH CLOUDYML FROM SCRATCH. TRUSTED BY 7500+ HAPPY LEARNERS
This course package, you are getting Python, SQL, Statistics, Machine Learning, Deep Learning, AWS Sagemaker, Model Deployment, Tableau, PowerBi, Amazon QuickSight, Google Data Studio, Excel, Case studies, Interview QnAs PDF, 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
Company: LTI
Role: Data Analyst
Topic: Excel
1. How to use excel formulas?
Formulas in Excel are expressions that can make the calculation based on the information in your spreadsheet. The formula can be used in Excel by first selecting an empty cell where you want to enter the formula. The way to add formula syntax is by typing the β=β equal sign and then followed by operators to be used in the calculation.
The relevant operators used in the formula should be kept between opening and closing parenthesis. Press Enter to get the results.
2. What is macro in excel?
Macro refers to an algorithm or a set of actions that help automate a task in Excel by recording and playing back the steps taken to complete that task. Once the steps are stored, you create a Macro, and it can be edited and played back as many times as the user wants.
Macro is great for repetitive tasks and also eliminates errors. For example, suppose an account manager has to share reports regarding the company employees for non-payment of dues. In that case, it can be automated using a Macro and doing minor changes every month, as needed.
3. How to maintain accounts in excel sheet format?
You can maintain accounts in an Excel sheet by using its rows and columns for record-keeping and keep track of account-related information such as account numbers, invoicing, and receipt of payments.
The cells can be used to input client or account holder information. The expenses can be calculated using the formula =SUM (F3:F6). You can also use tools such as expense tracking tools and contract tools for auto-invoicing, performing tracking, and billing of expenses.
4. How to create a serial number generator in excel?
You can create serial numbers in Excel using the Autofill method. Here are the steps β
Insert value (letβs say 1) in a row and select it as the active cell.
You will notice that a small box or filler icon at the bottom right of the active cell will appear.
Double click on that box icon to drag to the desired cell.
Now go back to the second row and insert another value (letβs say 2).
Now select both the cells at once, and the box or filler icon will appear again.
Drag down the icon to the desired row, and you will notice that this time it shows serial numbers starting with the first value we inserted (1).
ββββββββββββββββββββ-
π¨MAKE YOUR CAREER IN DATA SCIENCE AND ANALYTICS WITH CLOUDYML FROM SCRATCH. TRUSTED BY 7500+ HAPPY LEARNERS
This course package, you are getting Python, SQL, Statistics, Machine Learning, Deep Learning, AWS Sagemaker, Model Deployment, Tableau, PowerBi, Amazon QuickSight, Google Data Studio, Excel, Case studies, Interview QnAs PDF, 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
Our course reviews are our motivation, and we work devotedly to provide the best learning experience in Data Science and Analytics to our learnersπ
P.S.: If you are someone who is searching for a Roadmap to switch your career in Data Science and Analytics domain then you should also check our Mega Combo Course.
β‘οΈCourse Link - https://ai.cloudyml.com/Mega-Combo
Key Points You Should Know
β We provide Hands on Practical Learning Experience to our learners through structured tutorial videos and practice assignments.
β We Provide Capstone End-to-End projects and case studies that you can add in your resume.
β You will get 1-1 Live Doubt Clearance Support over Skype Chat everyday
β You can get 1 Month Internship Opportunity at CloudyML
β After completing the course, you will get course completion certificate
β Job Opening Mails and Interview QnA Mails you will get everyday
β We provide lifetime course content access
β We also provide sample resume and resume review feature in our course.
Topics Covered in this course
β Python
β Advanced SQL
β Statistics and Maths
β Machine Learning
β Deep Learning
β AWS Sagemaker
β Model Deployment
β Tableau
β PowerBi
β Excel
β Google Data Studio
β Amazon QuickSight
You are getting everything at the cheapest marketing price in this course.
Trusted by 7500+ Happy Learners, you also can complete a part of this learning community and start your Journey today.
β‘οΈCourse Link- https://ai.cloudyml.com/Mega-Combo
Visit Our Website Now
P.S.: If you are someone who is searching for a Roadmap to switch your career in Data Science and Analytics domain then you should also check our Mega Combo Course.
β‘οΈCourse Link - https://ai.cloudyml.com/Mega-Combo
Key Points You Should Know
β We provide Hands on Practical Learning Experience to our learners through structured tutorial videos and practice assignments.
β We Provide Capstone End-to-End projects and case studies that you can add in your resume.
β You will get 1-1 Live Doubt Clearance Support over Skype Chat everyday
β You can get 1 Month Internship Opportunity at CloudyML
β After completing the course, you will get course completion certificate
β Job Opening Mails and Interview QnA Mails you will get everyday
β We provide lifetime course content access
β We also provide sample resume and resume review feature in our course.
Topics Covered in this course
β Python
β Advanced SQL
β Statistics and Maths
β Machine Learning
β Deep Learning
β AWS Sagemaker
β Model Deployment
β Tableau
β PowerBi
β Excel
β Google Data Studio
β Amazon QuickSight
You are getting everything at the cheapest marketing price in this course.
Trusted by 7500+ Happy Learners, you also can complete a part of this learning community and start your Journey today.
β‘οΈCourse Link- https://ai.cloudyml.com/Mega-Combo
Visit Our Website Now
Date: 14th August, 2022
Company: Hitachi
Role - Data Analyst
Topic: Tableau
1. Explain dashboard lifecycle?
Dashboard lifecycle in Tableau:
Functional Knowledge: Business Analysts give a current functional knowledge of the organization.
Requirement Analysis: Requirements that are kept in consideration are:
The requirement of the dashboard.
How is data flowing in the current system?
Blueprint or layout of the system.
Dashboard scope.
The value that is added to the business
required tools for the development of the project and its costs.
Planning Phase: It includes:
Timeline and needed resources.
Work and leave plan.
Dependencies and future challenges.
Methodologies to follow: Scrum, Agile, Waterfall, etc.
Technical Specs: It includes:
Technical details.
SQL, relations, and Joins.
Credentials for database access.
Business logic.
Development: It includes:
Query generation.
Connecting databases and creating dimension model
Publish it to the server.
Unit testing.
Q&A Testing: It includes:
Functionality and UI testing.
SQL testing and data validation
Security testing
Testing of applied customization.
Performance testing: Report opening time, with or without any webpage.
User Acceptance Testing (UAT): User validates data and functionality.
Production and Support: System is produced, and support is given once it goes live.
2. State some ways to improve the performance of Tableau?
Use an Extract to make workbooks run faster
Reduce the scope of data to decrease the volume of data
Reduce the number of marks on the view to avoid information overload
Try to use integers or Booleans in calculations as they are much faster than strings
Hide unused fields
Use Context filters
Reduce filter usage and use some alternative way to achieve the same result
Use indexing in tables and use the same fields for filtering
Remove unnecessary calculations and sheets.
3. What is VIZQL in Tableau?
VIZQL is Visual Inquiry Language. It is a combination of VIZ and SQL. It is similar to SQL language. But instead of SQL commands, the VIZQL language converts data queries into visual images.
4. What is the difference between .twb and .twbx extensions?
.twb: .twb means Tableau workbook. .twb is an XML sheet, it stores the data about your documents, stories, and dashboards. This file is the reference to the source file such as Excel or tde. This file will be linked to your source file when you save the TWB file. If you want to share your workbook you need to send both the workbook and data source file.
.twbx: It is a compressed file, where you have all files. It includes data source files, twb, and other files to produce the workbook. TWBX is obsolete for sharing because it will share the copy of the file instead of an original source file. .twbx is used for reports and we can view using the tableau viewer.
ββββββββββββββββββββ-
π¨MAKE YOUR CAREER IN DATA SCIENCE AND ANALYTICS WITH CLOUDYML FROM SCRATCH. TRUSTED BY 7500+ HAPPY LEARNERS
This course package, you are getting Python, SQL, Statistics, Machine Learning, Deep Learning, AWS Sagemaker, Model Deployment, Tableau, PowerBi, Amazon QuickSight, Google Data Studio, Excel, Case studies, Interview QnAs PDF, 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
Company: Hitachi
Role - Data Analyst
Topic: Tableau
1. Explain dashboard lifecycle?
Dashboard lifecycle in Tableau:
Functional Knowledge: Business Analysts give a current functional knowledge of the organization.
Requirement Analysis: Requirements that are kept in consideration are:
The requirement of the dashboard.
How is data flowing in the current system?
Blueprint or layout of the system.
Dashboard scope.
The value that is added to the business
required tools for the development of the project and its costs.
Planning Phase: It includes:
Timeline and needed resources.
Work and leave plan.
Dependencies and future challenges.
Methodologies to follow: Scrum, Agile, Waterfall, etc.
Technical Specs: It includes:
Technical details.
SQL, relations, and Joins.
Credentials for database access.
Business logic.
Development: It includes:
Query generation.
Connecting databases and creating dimension model
Publish it to the server.
Unit testing.
Q&A Testing: It includes:
Functionality and UI testing.
SQL testing and data validation
Security testing
Testing of applied customization.
Performance testing: Report opening time, with or without any webpage.
User Acceptance Testing (UAT): User validates data and functionality.
Production and Support: System is produced, and support is given once it goes live.
2. State some ways to improve the performance of Tableau?
Use an Extract to make workbooks run faster
Reduce the scope of data to decrease the volume of data
Reduce the number of marks on the view to avoid information overload
Try to use integers or Booleans in calculations as they are much faster than strings
Hide unused fields
Use Context filters
Reduce filter usage and use some alternative way to achieve the same result
Use indexing in tables and use the same fields for filtering
Remove unnecessary calculations and sheets.
3. What is VIZQL in Tableau?
VIZQL is Visual Inquiry Language. It is a combination of VIZ and SQL. It is similar to SQL language. But instead of SQL commands, the VIZQL language converts data queries into visual images.
4. What is the difference between .twb and .twbx extensions?
.twb: .twb means Tableau workbook. .twb is an XML sheet, it stores the data about your documents, stories, and dashboards. This file is the reference to the source file such as Excel or tde. This file will be linked to your source file when you save the TWB file. If you want to share your workbook you need to send both the workbook and data source file.
.twbx: It is a compressed file, where you have all files. It includes data source files, twb, and other files to produce the workbook. TWBX is obsolete for sharing because it will share the copy of the file instead of an original source file. .twbx is used for reports and we can view using the tableau viewer.
ββββββββββββββββββββ-
π¨MAKE YOUR CAREER IN DATA SCIENCE AND ANALYTICS WITH CLOUDYML FROM SCRATCH. TRUSTED BY 7500+ HAPPY LEARNERS
This course package, you are getting Python, SQL, Statistics, Machine Learning, Deep Learning, AWS Sagemaker, Model Deployment, Tableau, PowerBi, Amazon QuickSight, Google Data Studio, Excel, Case studies, Interview QnAs PDF, 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
Check SQL Interview questions asked by Cloudfare company. Full Explanation Video. Watch Now. Link given below
β‘οΈ https://youtu.be/OSmZ5Ul1XvE
β‘οΈ https://youtu.be/OSmZ5Ul1XvE