Data Analytics
Which of the following SQL syntax can be used to insert 'Naruto' in 'FirstName' column within 'Name' table?
Think logically and then answer; eliminate the wrong option if got stuck 😄
😁6👍4
Which of the following is an aggregate function in SQL?
Anonymous Quiz
10%
SUM
5%
COUNT
9%
AVERAGE
77%
All of the above
👍12👏6❤4😢4🥰2🤔2🔥1
Which of the following keyword is used to disregard duplicates in SQL?
Anonymous Quiz
20%
DUPLICATE
65%
DISTINCT
13%
DISREGARD
2%
MAX
👍19❤5🔥1🥰1👏1🤩1
Which tool is used to combine two different tables with same headers in Alteryx?
Anonymous Quiz
15%
SELECT
85%
UNION
👍13❤3🔥2
Which of the following is not a python library?
Anonymous Quiz
5%
Pandas
4%
Numpy
73%
Jupyter
19%
Matplotlib
👍15🔥5👏1
Which of the following is not a connection type in tableau?
Anonymous Quiz
25%
Live
25%
Extract
50%
Network
👍9🔥2
Which of the following is not a type of statistical analysis?
Anonymous Quiz
11%
Denoscriptive
29%
Inferential
20%
Predictive
41%
None of the above
🤔18👍13🤯11🥰5😐3
Which of the following is one of the 3 Vs of big data?
Anonymous Quiz
11%
Video
52%
Volume
19%
Version
17%
Vikings
👍16🥰9👏2
Which of the following is a framework to solve bigdata problems?
Anonymous Quiz
5%
Java
51%
Hadoop
16%
MongoDB
29%
Python
👍16😁6👏2❤1
Ways to improve the performance of Tableau
👉🏻 Use an Extract to make workbooks run faster.
👉🏻 Reduce the number of marks on the view to avoid information overload.
👉🏻 Hide unused fields.
👉🏻 Use Context filters.
👉🏻 Use indexing in tables and use the same fields for filtering.
👉🏻 Remove unnecessary calculations and sheets.
👉🏻 Use an Extract to make workbooks run faster.
👉🏻 Reduce the number of marks on the view to avoid information overload.
👉🏻 Hide unused fields.
👉🏻 Use Context filters.
👉🏻 Use indexing in tables and use the same fields for filtering.
👉🏻 Remove unnecessary calculations and sheets.
👍26🤩4👏1
What is the full form of DML in database management system?
Anonymous Quiz
14%
Data Markup Language
3%
Decision Makeup Language
1%
Distorted Making Language
82%
Data Manipulation Language
👍14⚡7😁7❤1🔥1👏1
Which of the following is not a DML command in SQL?
Anonymous Quiz
79%
REVOKE
9%
INSERT
6%
DELETE
7%
UPDATE
👍23🔥4👏4😁3🥰1
In Hypothesis testing, a Type I error occurs when the null hypothesis is rejected even if it is true. It is also known as
Anonymous Quiz
68%
False Positive
32%
False Negative
👍9🥰5
Which of the following data types is not available in SQL?
Anonymous Quiz
6%
CHAR
4%
INT
5%
DATE
85%
ALPHABET
👍22👏3❤1
Requirements for data analyst based on some job profiles from @getjobss channel
👉 Strong data handling, data modeling & data flow understanding
👉 Ability to write complex queries on SQL to manipulate, consolidate multiple data sources for the purpose of dashboarding and analysis
👉 Intuition for data and ability to handle big data sources
👉 Strong working knowledge in Excel and visualization tools like PowerBI, Tableau, QlikView
👉 Ability to work on ambiguous tasks, find suitable solutions, and seek help/advice where appropriate.
👉 Strong data handling, data modeling & data flow understanding
👉 Ability to write complex queries on SQL to manipulate, consolidate multiple data sources for the purpose of dashboarding and analysis
👉 Intuition for data and ability to handle big data sources
👉 Strong working knowledge in Excel and visualization tools like PowerBI, Tableau, QlikView
👉 Ability to work on ambiguous tasks, find suitable solutions, and seek help/advice where appropriate.
👍61😁2❤1
What is the ful form of TCL in SQL?
Anonymous Quiz
89%
Transaction Control Language
11%
Total Control Level
👍11🔥9❤1
Which of the following is not available in marks card of tableau?
Anonymous Quiz
6%
Size
6%
Color
28%
Tooltip
8%
Label
52%
Query
👍21🥰1
Which of the following clause is used to sort data in SQL?
Anonymous Quiz
13%
where
66%
order by
5%
having
16%
group by
👍26🔥8😢3❤2👏1
Which of the following clause is not available in SQL?
Anonymous Quiz
3%
SELECT
3%
ORDER BY
4%
GROUP BY
5%
WHERE
85%
INPUT
👍13❤3🔥1