Resources for Advanced Excel:
Datacamp course:
https://learn.datacamp.com/skill-tracks/spreadsheet-fundamentals?version=1
Chandoo’s youtube channel:
https://www.youtube.com/channel/UC8uU_wruBMHeeRma49dtZKA
Free Excel Book
https://t.iss.one/learndataanalysis
Data Visualization in Excel
https://bit.ly/3JDEs6A
Datacamp course:
https://learn.datacamp.com/skill-tracks/spreadsheet-fundamentals?version=1
Chandoo’s youtube channel:
https://www.youtube.com/channel/UC8uU_wruBMHeeRma49dtZKA
Free Excel Book
https://t.iss.one/learndataanalysis
Data Visualization in Excel
https://bit.ly/3JDEs6A
❤20👍15🥰1👏1
Free Resources to learn BI tools:
Abhishek Agarwal: https://www.youtube.com/playlist?list=PL6_D9USWkG1C4raCOTlTf_oq4XnNNNtm9
Bharti consultancy: https://www.youtube.com/playlist?list=PLyD1XCIRA3gQmN73dHwQWr4R08ABZFMtZ
Tableau Book
https://t.iss.one/sqlspecialist/51
Power BI Book
https://t.iss.one/sqlspecialist/85
Abhishek Agarwal: https://www.youtube.com/playlist?list=PL6_D9USWkG1C4raCOTlTf_oq4XnNNNtm9
Bharti consultancy: https://www.youtube.com/playlist?list=PLyD1XCIRA3gQmN73dHwQWr4R08ABZFMtZ
Tableau Book
https://t.iss.one/sqlspecialist/51
Power BI Book
https://t.iss.one/sqlspecialist/85
👍24❤3👏2
Don't focus on learning too many things from multiple resources at a time. That's why i am sharing only limited resources
Quality>Quantity
Quality>Quantity
❤71👍28👏6🥰2
Free Resources for Python
Codebasics python tutorials (first 16) —
https://www.youtube.com/playlist?list=PLeo1K3hjS3uv5U-Lmlnucd7gqF-3ehIh0
Practice Python course
https://dabeaz-course.github.io/practical-python/Notes/Contents.html
Codebasics python HINDI tutorials —
https://www.youtube.com/playlist?list=PLPbgcxheSpE1DJKfdko58_AIZRIT0TjpO
Useful Python resources for beginners
https://t.iss.one/programming_guide/8
Python 3 Book for beginners
https://t.iss.one/pythondevelopersindia/272?single
Codebasics python tutorials (first 16) —
https://www.youtube.com/playlist?list=PLeo1K3hjS3uv5U-Lmlnucd7gqF-3ehIh0
Practice Python course
https://dabeaz-course.github.io/practical-python/Notes/Contents.html
Codebasics python HINDI tutorials —
https://www.youtube.com/playlist?list=PLPbgcxheSpE1DJKfdko58_AIZRIT0TjpO
Useful Python resources for beginners
https://t.iss.one/programming_guide/8
Python 3 Book for beginners
https://t.iss.one/pythondevelopersindia/272?single
👍22❤9👏2🔥1
Now that you have gained all the right skills, you need to showcase your skills and stand out from others to land a job. Projects and Portfolios will do that for you, so invest an ample amount of time in preparing these. You can find enough and more datasets in Kaggle for doing projects. Do a bit research and start working on it. Once its done, prepare an insightful resume and start applying for jobs and internships.
❤46👍21🔥6
Data Analyst Resume Template-
https://www.dayjob.com/downloads/CV_examples/data_analyst_CV_template.pdf
Kaggle exploratory data analysis
* Notebooks:
https://www.kaggle.com/notebooks
* Datasets:
https://www.kaggle.com/datasets
Project ideas:
Alex the Analyst Portfolio Project Series:
https://www.youtube.com/watch?v=qfyynHBFOsM&list=PLUaB-1hjhk8H48Pj32z4GZgGWyylqv85f&t=0s
https://www.dayjob.com/downloads/CV_examples/data_analyst_CV_template.pdf
Kaggle exploratory data analysis
* Notebooks:
https://www.kaggle.com/notebooks
* Datasets:
https://www.kaggle.com/datasets
Project ideas:
Alex the Analyst Portfolio Project Series:
https://www.youtube.com/watch?v=qfyynHBFOsM&list=PLUaB-1hjhk8H48Pj32z4GZgGWyylqv85f&t=0s
👍29❤13🔥5👏2😁1😢1
Which situation is perfect to use bar chart?
Anonymous Quiz
19%
Viewing trends in data over time.
56%
Comparing data across categories.
17%
Showing hierarchical data as a proportion of a whole.
9%
Showing duration over time.
👍8❤2
Full form of KPIs in analytics domain?
Anonymous Quiz
9%
Key Problem Indexes
75%
Key Performance Indicators
7%
Key Problem Indicators
9%
Key Processing Indexes
👍20😁9
Which of the following statement is true about KPIs and metrics?
Anonymous Quiz
68%
Every KPI is a metric, but not every metric is a KPI.
32%
Every metric is a KPI, but not every KPI is a metric.
👍14🤔9😁8
Which chart type is perfect for showing Project timeline?
Anonymous Quiz
24%
Bar chart
39%
Gantt chart
17%
Scatter plot
20%
Histogram
👍29
When should you use histogram?
Anonymous Quiz
75%
Understanding the distribution of your data.
25%
Showing duration over time
👍18
👏12❤1👍1
👍11🥰1
👍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
36%
Color
12%
Size
41%
Label
10%
Detail
👍13❤4🤯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 😄👍
👍44❤6🥰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😢3❤1👏1