Data Analytics – Telegram
Data Analytics
108K subscribers
126 photos
2 files
791 links
Perfect channel to learn Data Analytics

Learn SQL, Python, Alteryx, Tableau, Power BI and many more

For Promotions: @coderfun @love_data
Download Telegram
Which of the following is a measure?
Anonymous Quiz
88%
Sales
12%
Country
👍11🥰1
Customer ID is a?
Anonymous Quiz
35%
Measure
65%
Dimension
👍15👏4🔥2
Which function is used to calculate difference between two dates in tableau?
Anonymous Quiz
7%
DATEADD
69%
DATEDIFF
17%
DTESDIFFERENCE
7%
None of these
👍15👏4
Which of the following field typically hold categorical data such as product types and dates?
Anonymous Quiz
75%
Dimension
25%
Measure
👍24
Placing a dimension on which shelf separates the marks according to the members in the dimension, and assigns a unique color to each member?
Anonymous Quiz
37%
Color
12%
Size
41%
Label
10%
Detail
👍134🤯4
Data Analytics
Which one you want to learn?
Good to see 500+ subscribers interested in learning SQL and Python. These are very useful skills if you are aiming for data analytics domain 😄👍
👍446🥰4😁2
In SQL, Group by allows us to group data for use in which functions?
Anonymous Quiz
24%
Discrete
76%
Aggregate
👍11😁4🎉4
If 2 runners finish in equal 3rd position, then what's the next runner's place based on dense_rank function in SQL?
Anonymous Quiz
22%
3rd
50%
4th
26%
5th
2%
6th
🤯25😁12👍4🎉4🔥3
Data Analytics
If 2 runners finish in equal 3rd position, then what's the next runner's place based on dense_rank function in SQL?
Tricky question, lets see how many of you are able to answer it correctly 😁
😁27👍10🔥6🎉5🥰4😢31👏1
Which of the following is a constraint in SQL?
Anonymous Quiz
16%
PRIMARY KEY
11%
UNIQUE
6%
FOREIGN KEY
67%
All of the above
👍16🔥52🥰2👏1😁1
Which of the following function remove all data in a table in SQL?
Anonymous Quiz
32%
REMOVE
59%
TRUNCATE
1%
WITH
7%
ALTER
👍158😁5🤯4👏2🔥1
Well done guys 1100+ answered it correctly
Keep it up 😄👍
👍32👏76
Which of the following is not a LOD expression in Tableau?
Anonymous Quiz
24%
FIXED
17%
INCLUDE
19%
EXCLUDE
39%
CONSTANT
👍16👏21
Numpy, Pandas and essential material required for performing data analysis with Python
👇👇
👍48
Which of the following cannot be used for data visualization?
Anonymous Quiz
4%
Tableau
5%
Power BI
84%
Javanoscript
8%
Matplotlib
4👍4
Which chart type will give better Visualization with large amount of dataset Pie chart or Scatter plot?
Anonymous Quiz
38%
Pie chart
62%
Scatter plot
👍10🔥92👎2😁2🥰1
Which chart type to choose for continuous dataset that changes over time?
Anonymous Quiz
13%
Bubble chart
55%
Line chart
6%
Pie chart
25%
Histogram
🔥10👍85🤔5😁4
Useful tips to select Chart Type

👉 If you have categorical data,then either use a bar chart if you have more than 5 categories or a pie chart for less than 5 categories.

👉 If you have nominal data, use bar charts ; histograms if your data is discrete,; line/ area charts if it is continuous.

👉 If you want to show the relationship between values in your dataset, use a scatter plot, bubble chart, or line charts.

👉 If you want to compare values, use a pie chart — for relative comparison — or bar charts — for precise comparison.

👉 If you want to compare volumes, use an area chart or a bubble chart.

👉 If you want to show trends and patterns in your data, use a line chart, bar chart, or scatter plot.
👍5415🥰2👏2
We are 6k+ now 💪
I haven't thought will achieve it when I started the channel this year
You guys are amazing
Thanks for sharing and supporting the channel ❤️❤️
👍5443
Which of the following advanced visualization is possible to create within Tableau?
Anonymous Quiz
12%
Waterfall Charts
4%
Bump Charts
7%
Funnel Charts
6%
Pareto Charts
72%
All of the above
👍152🔥1
🔥15👍4😁4🥰1