Resources

KO | EN

gitlite — search

#javascript #python #hacktoberfest #react #ai #typescript #llm #go #golang #android #machine-learning #rust #deep-learning #linux

(★ 48)

Resources and Courses for Data Analytics and more

Resources Latest Version Download

Download Latest Version (.zip)

// repository documentation

Was this content helpful?

★ 0 (0 ratings)

# Resources
Here are tons of resources I have found or have been recommended to me as I have taught myself Data Analytics.

Anything that I highly recommend is highlighted with a :star:

# Sections

:mortar_board: [Courses and Free Resources by Topic](https://github.com/tchristensen77/Resources/blob/main/README.md#courses-and-free-resources)

:tada: [Helpful Resources](https://github.com/tchristensen77/Resources#helpful-resources)

:books: [Books](https://github.com/tchristensen77/Resources#books)

:pencil: [Practice](https://github.com/tchristensen77/Resources/blob/main/README.md#practice)

# :mortar_board: Courses and Free Resources

## Data Analytics
Courses to give you a foundation in Data Analytics

:star: [Google Data Analytics Cerfiticate](https://www.coursera.org/professional-certificates/google-data-analytics)
Obviously this has to be first because it is the course I took. It provided a good foundation for the rest of my journey.
This course teaches data analytics theory then goes into technical skills- excel, SQL, Tableau and R.

[IBM Data Analyst Professional Certificate](https://www.coursera.org/professional-certificates/ibm-data-analyst?utm_source=gg&utm_medium=sem&campaignid=11706203036&utm_campaign=10-IBM-Data-Analyst-US&utm_content=B2C&adgroupid=113140262545&device=c&keyword=ibm%20data%20analyst%20certification&matchtype=b&network=g&devicemodel=&adpostion=&creativeid=482282125396&hide_mobile_promo&gclid=Cj0KCQjw2_OWBhDqARIsAAUNTTFQ1QGKyE64f4oLEJahL7tI493ohZQ7VR7phmQX4gQR0WAvnhenv3caAiaqEALw_wcB)
IBM's Data Analytics Course also available on Coursera. This course teaches SQL, Congos and Python. Most of the course is focused on Python, and they expect learners to have a base level of Python before starting the certificate.

### :free: Free Resources

[Intro to Data Analysis](https://www.udacity.com/course/intro-to-data-analysis--ud170)
  Free Course on Udacity- Intro course to data analytics with a focus on Python.

## SQL :file_folder:

[Learn SQL Basics for Data Science Specialization](https://www.coursera.org/specializations/learn-sql-basics-data-science?irclickid=XkyWLhS2SxyIW6yU3HRusxaqUkDzBPVpRx90RY0&irgwc=1&utm_medium=partners&utm_source=impact&utm_campaign=2624140&utm_content=b2c)
Paid course on Coursera- This course will teach you SQL in relation to Data Science. It is taught in the SQLlite dialect.

[The Ultimate MySQL Bootcamp: Go from SQL Beginner to Expert](https://www.udemy.com/course/the-ultimate-mysql-bootcamp-go-from-sql-beginner-to-expert/)
Paid course on Udemy- This course teaches you SQL from beginner level to expert. It is taught in the MySQL dialect.

### :free: Free Resources

[Mike Dane's SQL Course](https://www.mikedane.com/databases/sql/)
  Free course- This course will teach you beginner to intermediate level SQL. Course is also available on YouTube from FreeCodeCamp.

:star: [W3Schools](https://www.w3schools.com/sql/default.asp)
  Free tutorial- This tutorial walks through every function and keyword in SQL and the different dialects. 
  Strongly recommend going through this tutorial or at least bookmarking it when you have questions.
  
  [Data with Danny](https://github.com/DataWithDanny/sql-masterclass)
  Free course from Danny Ma- This course will teach you SQL in a mix of readings, videos and practice exercises. 
  
  [Select*SQL](https://selectstarsql.com/)
  Free course on Select * SQL- This course will teach you beginner and intermediate SQL through an interactive tutorial.

[SQL for Data Analysis](https://www.udacity.com/course/sql-for-data-analysis--ud198)
  Free course on Udacity- Course is by Mode and teaches you beginner to intermediate level SQL.
  
  [Khan Academy SQL Course](https://www.khanacademy.org/computing/computer-programming/sql/sql-basics/v/welcome-to-sql)
  Free course on Khan Academy- Learn beginner to intermediate level SQL with an interactive course.

## R :chart_with_upwards_trend:

[Data Science: Foundations using R Specialization](https://www.coursera.org/specializations/data-science-foundations-r?irclickid=XkyWLhS2SxyIW6yU3HRusxaqUkDzBb21Rx90RY0&irgwc=1&utm_medium=partners&utm_source=impact&utm_campaign=2946137&utm_content=b2c)
Paid course on Coursera- This specialization is through IBM and focuses on R for data science.

[R Programming](https://www.coursera.org/learn/r-programming)
Paid course on Coursera- This course is by John Hopkins and will teach you beginner to intermediate level R.

### :free: Free Resources

[Intro to R](http://statseducation.com/Introduction-to-R/)
  Free course from Stats Education- Self paced course will teach you the basics of R.
  
  :star: [Swirl](https://swirlstats.com/)
  Free course- Swirl is a package you can install in R/R Studio that will teach you R in an interactive environment. There is a couple different course you can add to the library.

## Python :snake:

[Python for Everybody Specialization by University of Michigan](https://www.coursera.org/specializations/python)
Paid course on Coursera- Highly recommended course for beginners wanting to learn Python.

[100 Days of Code: The Complete Python Pro Bootcamp for 2022](https://www.udemy.com/course/100-days-of-code/?utm_source=adwords&utm_medium=udemyads&utm_campaign=LongTail_la.EN_cc.US&utm_content=deal4584&utm_term=_._ag_81829991707_._ad_532193666393_._kw__._de_c_._dm__._pl__._ti_aud-720389363895%3Adsa-1007766171312_._li_9008464_._pd__._&matchtype=&gclid=Cj0KCQjw2_OWBhDqARIsAAUNTTEYW1fluX80zbc4e9_eN5yQ8W1gP9UFzT3-pPPcRafKcwLiJ3pkEqEaAml3EALw_wcB)
Paid course on Udemy- Project based course to help beginners learn Python, over the 100 classes you will build different projects in Python to help practice the skills as you learn them.

[Data Analysis with Python](https://www.coursera.org/learn/data-analysis-with-python)
Paid course on Coursera- This course is from the IBM Data Analytics certificate and will teach you how to use Python for data analysis.

### :free: Free Resources

[Real Python](https://realpython.com)
  Free website that offers tutorials, learning paths and more to help you learn Python.

## Visualizations :bar_chart:

Learn how to create visualizations to share your work.

[Data Visualization with Tableau Specialization](https://www.coursera.org/specializations/data-visualization?irclickid=XkyWLhS2SxyIW6yU3HRusxaqUkDzBNXpRx90RY0&irgwc=1&utm_medium=partners&utm_source=impact&utm_campaign=2624140&utm_content=b2c)
Paid course on Coursera- This course focuses on teaching data visualization specifically in Tableau.

[Tableau 2022 A-Z: Hands-On Tableau Training for Data Science](https://www.udemy.com/course/tableau10/)
Paid course on Udemy- This course will teach you the basics of Tableau.

### :free: Free Resources

[Getting Started with Power BI Desktop](https://www.coursera.org/projects/power-bi-desktop)
  Free project on Coursera- This project will teach you the basics of using Power BI Desktop software.
  
  [Microsoft Training Library](https://docs.microsoft.com/en-us/learn/browse/?products=power-bi&WT.mc_id=sitertzn_learntab_mslearn-banner-powerbi)
  Microsoft offers free training modules and videos on Power BI

[Tableau's Training Library](https://public.tableau.com/en-us/s/resources)
  Tableau offers how to videos and resources on how to learn and use Tableau.

## Statistics :heavy_division_sign:

Having a base knowledge of statistics with be have helpful for analysis.

[Statistics for Data Science and Business Analysis](https://www.udemy.com/course/statistics-for-data-science-and-business-analysis/?src=sac&kw=statistics)
Paid course on Udemy- Learn the statistics in relation to Data Science and Business

### :free: Free Resources

[Intro to Inferential Statistics](https://www.udacity.com/course/intro-to-inferential-statistics--ud201)
  Free course on Udacity- Taught by Facebook, this will teach you how to draw conclusions and make predictions using data.

## Excel :floppy_disk:

Every company will use Excel in one way or another.

[Excel Skills for Data Analytics and Visualization Specialization](https://www.coursera.org/specializations/excel-data-analytics-visualization?irclickid=U4hQB4SWVxyIW6yU3HRusxaqUkDzqwwJRx90RY0&irgwc=1&utm_medium=partners&utm_source=impact&utm_campaign=1359989&utm_content=b2c)
Paid course on Coursera- This specialization focuses on advanced Excel functions, creative visualizations, and powerful automation features.

### :free: Free Resources

[Microsofts Training Library](https://support.microsoft.com/en-us/office/excel-video-training-9bc05390-e94c-46af-a5b3-d7c22f6990bb)
  Microsoft offers free training videos on how to do almost anything in Excel. Great resource if you get stuck and need to see how to do something.

[Analyzing Data with Excel](https://www.edx.org/course/analyzing-data-with-excel)
  Free course on edX- This course will taught you about the fundamentals of Excel and data analysis.

# :tada: Helpful Resources

:star: [Data Storyteller's Weekly Round Up](https://datastoryteller.substack.com)
Highly recommend this one! If you don't follow her on TikTok, you should. She sends out a weekly email with helpful or interesting resources she has found each week.

:star: [Learn How to Learn](https://www.coursera.org/learn/learning-how-to-learn)
Free course on Coursera- This course will teach you learning techniques to utilize in any field.

## Websites/Learning Platforms
Here is a list of other learning platforms that have courses in data analytics or other fields that will be helpful.

:star: [W3Schools](https://www.w3schools.com)
W3Schools has tutorials on a ton of topics including SQL, python, excel, statistics, etc.

[LinkedIn Learning](https://www.googleadservices.com/pagead/aclk?sa=L&ai=DChcSEwimpo_N5JH5AhXhklsKHZF5CTQYABADGgJ5bQ&ohost=www.google.com&cid=CAESaeD2dRYtAzit2nldFIG08QuCMoI5PP_LHD-Vr0XP3oGJ1kDnojC-SKjdI2T-uBALvspUoSUo5O_GojMXIDk6gy4HHya1zwcYrCsAdZQc1oXDGvi6etFIAW9TeXdduoUATs_Y-CvnzfgrYg&sig=AOD64_1xnsrOzCv9j9ojbN5xDY9BwkPDcw&ved=2ahUKEwiR5IbN5JH5AhXhMVkFHSi0BJoQqyQoAHoECAQQBQ&nis=8&adurl=)
LinkedIn Learning offers a ton of courses and the certificates will be added to your LinkedIn account. This is a paid subscription but you can get a 1 month free trial and some local libraries will also give you free access.

[Free Courses on Udacity](https://www.udacity.com/courses/all?price=Free)
Udacity offers a ton of free courses in SQL, python, excel, statistics, etc. that you can explore.

[FreeCodeCamp](https://www.freecodecamp.org)
FreeCodeCamp has free courses on a ton of different programing languages and software. Plus check out their YouTube channel for free full courses.

[Udemy](https://www.udemy.com/?utm_source=adwords-brand&utm_medium=udemyads&utm_campaign=Brand-Udemy_la.EN_cc.US_dev.Desktop.Tablet&utm_term=_._ag_137319648178_._ad_595310984146_._de_c_._dm__._pl__._ti_aud-1279170979662:kwd-310556426868_._li_9008464_._pd__._&utm_term=_._pd__._kw_udemy_._&matchtype=e&gclid=Cj0KCQjw2_OWBhDqARIsAAUNTTGbS3M40S8y6f0tRdPZ7VcUC2DMG03oUr6T0UeBhTC_G_qv8Rmi2uwaAtxSEALw_wcB)
Udemy offers a ton of courses on different subjects. Anyone can create a course and sell it, so be sure to read the reviews. They regularly have sales so don't buy anything full price.

# :books: Books

If you are like me and want to learn new concepts by reading, here are books that will help.

## Python :snake:

[Python for Data Science](https://jakevdp.github.io/PythonDataScienceHandbook/)
Learn how to use Python for Data Science. Online version is free, physical copy needs to be bought.

[Automate the Boring Stuff](https://automatetheboringstuff.com)
Learn how to automate tasks with Python. Online version is free, physical copy needs to be bought.

## R :chart_with_upwards_trend:

[Hands-On Programming with R](https://rstudio-education.github.io/hopr/)
This book will teach you how to program with hand on examples. It's recommended you read this before R for Data Science. Online version is free, physical copy needs to be bought.

[R for Data Science](https://r4ds.had.co.nz/)
R for Data Science, the title is pretty self explanatory. Online version is free, physical copy needs to be bought.

## Visualizations :bar_chart:

[Fundamentals of Data Visualization](https://clauswilke.com/dataviz/)
This book is a guide for creating professional and effective visualizations. Online version is free, physical copy needs to be bought.

:star: [Storytelling With Data](https://www.storytellingwithdata.com/books)
Storytelling with Data is highly recommended by multiple people. Teachs you the fundamentals of visualization and how to commmunicate your findings.

# :pencil: Practice 
I've included a bunch of great resources and learning tools but if you don't want to get stuck in tutorial hell, you need to practice!
Here are some helpful resources or websites to help you practice what you have learned.

[Kaggle](https://www.kaggle.com)
Great resource for finding datasets and practicing R or Python. You can check out what others have done or compete in the competitions.

[Maven Analytics Data Playground](https://www.mavenanalytics.io/data-playground?pageSize=10)
Free datasets and practice case studies, great for practicing real world case studies.

[Danny Ma's SQL Challenge](https://8weeksqlchallenge.com)
Danny Ma's 8 Week SQL Challenge will help you learn SQL and practice on example case studies.

[TidyTuesday](https://github.com/rfordatascience/tidytuesday)
TidyTuesday has weekly data science challenges aimmed for learning and practicing R.

[DataCamp](https://www.datacamp.com)
DataCamp has free and paid courses, as well as, projects to help you practice. Set up as fill in the blanks so not great depending on your learning style.

## Interview Prep

[HackerRank](https://www.hackerrank.com)
Practice coding questions with real world examples. Great to practice for coding skills tests. Free and paid subscriptions.

[LeetCode](https://leetcode.com/problemset/database/)
Coding and interview practice. Free and paid subscriptions.

Resources

Resources Latest Version Download

Today's picks

Was this content helpful?

Recent Feedback

Resources

Resources Latest Version Download

Today's picks

Was this content helpful?

Recent Feedback

Download README