Resources

There are tons of great resources all over the internet. I've bookmarked hundreds of URLs and this page is my categorized collection of the references and free tools I've found to be helpful. If you're reading this and have something to add or find a dead link please send me a note. I'm continuing to add to this over time.

Analytics/Data Visualization | API Services | Career Management | Cloud Computing | Computer Science/Programming | Data Engineering | DataOps | Data Science/Machine Learning | Datasets | Website Tools


Analytics/Data Visualization


Apache Superset

Apache Superset is a modern data exploration and visualization platform that is fast, lightweight, intuitive, and loaded with options.
superset.apache.org

Google Charts

Google Charts is a JavaScript-based tool that lets people easily create a chart from some data and embed it in a web page. It’s free and has a solid library of interactive charts and data tools available for use.
developers.google.com/chart

Google Data Studio

Free product lets you connect to all your marketing data and turn that data into beautiful, informative reports that are easy to understand, share, and fully customizable.
datastudio.google.com

HyperQuery

Hyperquery is a collaborative workspace for analytics. Yuo can write SQL queries and consolidate your data context, automatically mapped from your favorite data tools such as Snowflake, Looker, Fivetran, Segment, and dbt. With Hyperquery, you can keep your documentation and business metadata in one place, so you can do your best work in analytics.
dataframe.ai

VisiData

VisiData is an interactive multitool for tabular data. It combines the clarity of a spreadsheet, the efficiency of the terminal, and the power of Python, into a lightweight utility which can handle millions of rows with ease.
www.visidata.org


API Services

 [return to top]

ConvertAPI

Add high performance files and documents conversion to your website, web, or desktop application.
convertapi.com

Google Analytics Query Explorer

This tool lets you play with the Core Reporting API by building queries to get data from your Google Analytics views (profiles). You can use these queries with any of the client libraries to build your own tools.
ga-dev-tools.appspot.com/query-explorer

GraphQL Introduction

GraphQL is a query language for your API, and a server-side runtime for executing queries by using a type system you define for your data. Learn about GraphQL, how it works, and how to use it in this series of articles.
graphql.org/learn

How to design a RESTful API architecture from a human-language spec

A three-post series that teaches RESTful API design to solve users’ needs with simplicity, reliability, and performance.
oreilly.com/learning/how-to-design-a-restful-api-architecture-from-a-human-language-spec

OpenWeatherMap

API for accessing current weather data for any location including over 200,000 cities.
openweathermap.org/api

Postman

This free Chrome extension allows developers to explore, test, and build APIs using a powerful collaborative testing and development suite.
getpostman.com

Public APIs

Categorizes different APIs scoured from the web which make their resources available for public consumption.
https://github.com/public-apis/public-apis | or | github.com/abhishekbanthia/Public-APIs

RapidAPI

Enables developers to find, test, and manage API integrations from one place and provides real-time performance metrics.
rapidapi.com

RESTful Architecture

Technical documentation for RESTful web services with references and language-specific examples.
smartsheet-platform.github.io/api-docs

What is a REST API?

Thorough overview on what REST APIs are and how to use them.
idratherbewriting.com/all-about-rest-apis


Career Management

 [return to top]

3 Data Career Paths Decoded

Helpful article that compares and contrasts the role of a data analyst vs. data scientist vs. data engineer.
blog.udacity.com/data-analyst-vs-data-scientist-vs-data-engineer

CodeFights - Practice for Technical Interviews

Technical interviews are tough. CodeFights, which is best known as a competitive coding and skill-based recruiting platform, helps developers practice for these interviews through a free platform that offers study topics and practice questions.
codefights.com/interview-practice

Coding Interview University

At a time where technology is outpacing the ability of many universities to update their course curriculum, many aspiring software engineers are seeking alternative forms of the education required to get a job. This is a popular complete computer science multi-month study plan to become a software engineer.
github.com/jwasham/coding-interview-university

Data Flair Interview Questions

Frequently asked interview questions, by category. Each question is accompanied by answers shared by industry experts.
data-flair.training/interview-questions

Developer Roadmap

This repository contains a set of charts demonstrating different paths to take and technologies to adopt in order to become a front-end, back-end, or dev-ops engineer. While it seems a bit overwhelming in the beginning, it is a useful guide for what’s possible and needed in this fast-changing industry. The repo gets updated every year to reflect changes in the ecosystem.
roadmap.sh

GeeksforGeeks

A Computer Science portal for geeks. It contains computer science and programming articles, quizzes, and practice/competitive programming questions. It also has a large database of company-specific interview questions.
www.geeksforgeeks.org

Git Showcase

Free portfolio site that allows developers to easily feature projects from their GitHub repositories.
gitshowcase.com

Google Cloud Certification - Data Engineer

A Google Certified Professional - Data Engineer enables data-driven decision making by collecting, transforming, and visualizing data. To earn this certification you must pass the in-person exam. This webpage offers a collection of useful training resources and reference materials aimed at achieving this certification.
cloud.google.com/certification/data-engineer

HackerEarth

HackerEarth is a network of top developers across the world. Developers participate in online coding challenges and hackathons, solve problems and discover the best jobs.
www.hackerearth.com

HackerRank

Join over 2 million developers in solving code challenges on HackerRank, one of the best ways to prepare for programming interviews.
www.hackerrank.com

Hackterms

At some point in your professional coding career, you’re going to feel stupid when you forgot some simple term. Hackterms is a crowdsourced dictionary of coding terms and serves as a sort of wiki for coding language. Programming is full of jargon and self-inflicted nomenclature wounds. Hackterms helps by returning plain-speak explanations for these.
www.hackterms.com

IBM Certified Data Engineer - Big Data

This certification is intended for big data engineers. To attain IBM Certified Big Data Engineer status, candidates must pass one test.
ibm.com/certify/certs/50001501

InterviewBit

Learn and Practice on almost all coding interview questions asked historically and get referred to the best tech companies.
www.interviewbit.com

Interview Cake

Free practice programming interview questions. Interview Cake helps you prep for interviews to land offers from your dream companies.
interviewcake.com

Interviewing.io

Interviewing.io is a platform where people can practice technical interviewing anonymously with engineers from top companies.
interviewing.io

Learn To Code

Programming and computer science are becoming more popular than ever. As a result, there are an increasingly huge number of resources and tutorials being produced for beginners who want to learn to code, ranging from books to online tutorials to interactive websites to massive open online courses (MOOCS). This can be overwhelming for beginners – there are almost too many resources available, and it’s difficult to figure out where to start. This page offers a curated list of resources for both new developers and developers looking to advance their skills and learn a new language/framework.
ashleymcnamara.github.io/learn_to_code

LeetCode

Level up your coding skills and quickly land a job. This is a good place to expand your knowledge and get prepared for your next interview.
leetcode.com

Mastering SQL Queries

Practice easy, medium, and hard SQL interview questions.
analytics-vidhya/mastering-sql-queries

Pramp

Practice mock interviews and coding questions online, with peers, for free. Great practice for preparing for interviews and ultimately landing your dream tech job.
www.pramp.com

Skills Index

Undoubtedly you’ve heard about the skills gap challenges in the U.S. economy. Using select data from LinkedIn and [email protected]’s proprietary analysis, the [email protected] Skills Index takes a look at supply vs. demand around specific skill sets across top industries and provides actionable recommendations for getting up to speed.
skillsindex.com

StackShare

StackShare provides online software for displaying and sharing your technology stack, which is made up of the software that you use. It’s an online community that features comparisons, ratings, reviews, recommendations, and discussions of the best software tools and software infrastructure services.
stackshare.io

TestDome

For developers, this site offers public technical tests and practice interview questions. If you score well you can get free certificates to display on your online profiles.
testdome.com

Things You Need to Know in a Programming Interview

This article cover general tips on how you, the interviewee, can impress your interviewer during a coding session and land your dream job.
medium.freecodecamp.org/most-important-things-to-know-programming-interview


Cloud Computing

 [return to top]

AWS Explained: The Basics

A nice introductory primer for getting started in AWS and cloud computing in general.
inqdo.com/aws-explained-the-basics

AWS Tutorial for Beginners

AWS (Amazon Web Service) is a cloud computing platform that enables users to access on demand computing services like database storage, virtual cloud server, etc. This online course will give an in-depth knowledge on EC2 instance as well as useful strategy on how to build and modify instance for your own applications.
www.guru99.com/aws-tutorial.html


Computer Science/Programming

 [return to top]

awesome-vscode

A curated list of delightful VS Code packages and resources.
viatsko.github.io/awesome-vscode

Beginner’s Resources to Learn Programming Languages

This blog post details some important programming languages and offers numerous links for learning more about each.
blog.vodien.com/beginners-resources-to-learn-programming-languages

Bento

A curated collection of tutorials and free learning resources for learning to code in new languages.
bento.io

Big-O Notation Cheat Sheet

This webpage covers the space and time Big-O complexities of common algorithms used in Computer Science.
bigocheatsheet.com

CodeEnv

Free site lets you share your code with others in CodeEnv online environments. Good for teaching, prototyping, and sharing fiddles.
codeenv.com

Codility

Offers programming problems and lessons for challenging yourself to get to become a better coder.
codility.com/programmers

ComputerScience.org

Great collection of resources for exploring different careers in tech.
computerscience.org

CS Algorithm Notes

Set of CS lecture notes, which you can use to teach yourself algorithms.
web.stanford.edu/class/archive/cs/cs161

CS Playground React

A simple in-browser JavaScript sandbox for learning and practicing algorithms and data structures.
cs-playground-react.surge.sh

Fiddles.io

Offers sandbox environments for developers to play around with and modify live sample code for all kinds of languages. It’s also easy to share or demonstrate solutions to problems.
fiddles.io

Git Branching Model

This post outlines a development model for git branching strategy and release management.
nvie.com/git-branching-model

Git Cheat Sheet

Handy visual reference for commonly used git version control commands.
jan-krueger.net/git-cheat-sheet-extended-edition

Gitignore: A Collection of .gitignore Templates

This repository is exactly what the name suggests: a collection of useful .gitignore templates. For every new project you set up as a GitHub repository, it becomes mandatory to have a .gitignore file to filter what gets uploaded. The repo contains templates for almost any language or framework.
github.com/github/gitignore

Intro to Computer Science Terminology

A complex definition: Computer Science is the study of information technology, processes, and their interactions with the world.
codeburst.io/intro-to-computer-science-terminology

Kite

Code faster in Python with intelligent snippets - Kite is a plugin for your IDE that uses machine learning to give you useful code completions for Python.
kite.com

Learn Code The Hard Way

Learn Code The Hard Way courses are an effective system for learning the basics of computer programming, designed specifically for complete beginners.
learncodethehardway.org

Learn to Code From Home

Learning to code can be daunting, but you can do it at your own pace from the comfort of your own home. Thanks to dedicated programmers who have put time and energy into creating free online walkthroughs and guides to various programming languages, there are plenty of free resources right at your fingertips that offer hands-on activities and general overviews for beginner coding projects and advanced tasks.
couponfollow.com/research/learn-to-code-from-home

OverAPI

A huge selection of cheat sheets for almost any current programming language and other technologies.
overapi.com

Project Euler

Project Euler is a series of challenging mathematical/computer programming problems that will require more than just mathematical insights to solve. Although mathematics will help you arrive at elegant and efficient methods, the use of a computer and programming skills will be required to solve most problems.
projecteuler.net

Python Challenge

Python Challenge is a game in which each level can be solved by a bit of (Python) programming. It’s a good way to practice through solving riddles.
pythonchallenge.com

Python Cheat Sheet

A single cheatsheet for all basic Python functions.
python_cheat_sheet.png

Python Datetime Conversion Cheat Sheet

Python cheat sheet for converting values using the datetime module.
python_datetime_conversion_cheat_sheet.pdf

Python Tutor

This is a free tool that helps people overcome a fundamental barrier to learning programming: understanding what happens as the computer runs each line of source code. With it, you can write Python, Java, JavaScript, TypeScript, Ruby, C, and C++ code in your web browser and visualize what the computer is doing step-by-step as it runs your code.
pythontutor.com

Real Python: Python Tutorials

Learn Python online: Python tutorials for developers of all skill levels, Python books and courses, Python news, code examples, articles, and more.
realpython.com

Rosetta Code Programming Tasks

Offers over 800 problems that can be solved through programming in different languages. Great for practice.
rosettacode.org/wiki/Category:Programming_Tasks

Software Literacy: Programming Learning Guide

Programmers have to know how to work within systems and networks, using different programming languages to create and adapt software that helps their employers get things done. This post offers helpful links to online tutorials and tools for learning how to code in some of the most popular programming languages.
smartadvocate.com/blog

Teach Yourself Computer Science

If you’re a self-taught engineer or bootcamp grad, you owe it to yourself to learn computer science. This guide offers the nine subjects you should learn with the best book or video lecture series for each subject. Ideally this list can be revisited throughout your career.
teachyourselfcs.com

Topcoder

Topcoder is a company that administers contests in computer programming, through which prize money can be won. Competition aside, this site also offers regular challenges and matches through which you can learn new skills and hone skills you already have.
topcoder.com


Data Engineering

 [return to top]

5 Data Engineering Projects To Add To Your Resume

One of the best ways to develop and refine data engineering skills is through real-world portfolio projects. In this article, SeattleDataGuy reviews five potential project ideas with accompanying data sources.
seattledataguy.substack.com/p/5-data-engineering-projects-to-add

7 Steps to Understanding NoSQL Databases

The term NoSQL has come to be synonymous with schema-less, non-relational data storage schemes. NoSQL is an umbrella term, one which encompasses a number of different technologies. This article provides newcomers an overview of NoSQL technologies and architectures it includes.
kdnuggets.com/seven-steps-understanding-nosql-databases.html

Airflow for Beginners

Introduced by Airbnb, Airflow is a platform to schedule and monitor data pipelines. This article overviews the basic setup to run Airflow including an example use-case.
medium.com/airflow-for-beginners

Around Data Engineering

This actively-maintained GitHub repository details the never-ending journey of learning around data engineering and machine learning.
github.com/abhishek-ch/around-dataengineering

Awesome Data Engineering

A curated list of data engineering tools for software developers.
github.com/igorbarinov/awesome-data-engineering

Beginner’s Guide to Big Data Terminology

Walkthrough on some of the common lingo of big data, such as DaaS and Neural Networking.
dataconomy.com

Complete Data Engineer’s Vocabulary

Comprehensive A-Z list of different data engineering concepts and technologies with brief summaries and embedded links to learn more information.
towardsdatascience.com/complete-data-engineers-vocabulary

Conduktor

Conduktor is the ultimate Apache Kafka desktop client for performing regular Kafka administration and development tasks.
conduktor.io

Data Engineering Cookbook

The Data Engineering Cookbook (124 pages) - Mastering The Plumbing Of Data Science - Andreas Kretz.
github.com/andkret/Cookbook
The_Data_Engineering_Cookbook.pdf

Data Engineering Open Source Coursework

UC Berkeley published its spring 2021 data engineering course slides and resources. It is excellent learning material for data engineering practitioners.
cal-data-eng.github.io

DBeaver

Free multi-platform database tool for developers, SQL programmers, database administrators, and analysts. Supports all popular databases: MySQL, PostgreSQL, MariaDB, SQLite, Oracle, DB2, SQL Server, Sybase, MS Access, Teradata, Firebird, Derby, etc.
dbeaver.io

How to Become a Data Engineer

This article outlines helpful considerations if you’re interested in pursuing a career as a data engineer such as required skills, typical responsibilities, and career outlook.
mastersindatascience.org/careers/data-engineer

Introduction to Apache Airflow

Apache Airflow is hot right now and if you’re interested in learning about it from a high-level, this a nice ‘intro’ guide.
astronomer.io/guides/intro-to-airflow

Kafka for Beginners

Apache Kafka is used for enabling communication between producers and consumers using message-based topics. Apache Kafka is a fast, scalable, fault-tolerant, publish-subscribe messaging system.
medium.com/kafka-for-beginners

OLAP Cubes

A nice intro guide on what these are and why they are used.
olap.com/learn-bi-olap/olap-bi-definitions/olap-cube

Parserator

Working with some messy address or name data? It helps to split each one into separate components. Parserator is a framework for making parsers using natural language processing (NLP) methods.
parserator.datamade.us

Queues

This page tries to collect the libraries for the queueing systems (job, messaging, etc.) that are widely popular and have a successful record of running on (big) production systems.
queues.io

Self-Study List for Data Engineers and Aspiring Data Architects

With the explosion of “Big Data” over the last few years, the need for people who know how to build and manage data-pipelines has grown. This article takes a look at the sought after job skills for these areas and how you can go about learning these.
blog.treasuredata.com

SQL Cheat Sheet

In this guide, you’ll find a useful cheat sheet that documents some of the more commonly used elements of SQL, and even a few of the less common.
websitesetup.org/sql-cheat-sheet

SQL Query Optimization Techniques

Tips for writing faster and more efficient SQL queries
sql_query_optimization_techniques.pdf

SQL vs NoSQL — What is better for you?

Important considerations when choosing a relational (SQL) or non-relational (NoSQL) data structure for your project architecture.
hackernoon.com/sql-vs-nosql-what-is-better-for-you

SqlDBM - SQL Database Modeler

SqlDBM offers you an easy, convenient way to design your database absolutely anywhere on any browser, working away without need for any extra database engine or database modelling tools or apps.
sqldbm.com

Stream Processing 101: From SQL to Streaming SQL in 10 Minutes

We have entered an era where competitive advantage comes from analyzing, understanding, and responding to an organization’s data. When doing this, time is of the essence, and speed will decide the winners and losers. This blog post introduces technologies we can use for stream processing.
wso2.com

Three Questions to Help You Prepare for a Data Engineering Interview

Data engineering requires a combination of knowledge, from data warehousing to programming, in order to ensure the data systems are designed well and are as automated as possible. The question is: How do you prepare for an interview for a data engineering position?
medium.com

Transactional vs. Analytical Processing

Good cross-comparison between OLTP and OLAP systems.
datawarehouse4u.info/OLTP-vs-OLAP

What Does a Data Engineer / Data Architect Do?

This post explores the path of becoming a data engineer / big data architect.
edvancer.in/engineering-fresher-get-into-analyticspart-2

What Is Big Data?

Analyzing lots of data is only part of what makes big data analytics different from previous data analytics. This article delves into what those other aspects are.
infoworld.com/article/what-is-big-data-everything-you-need-to-know.html

What Is ETL?

ETL is shorthand for the extraction, transformation, and loading process used in most data movement operations. This article provides a nice overview for those wanting to understand the basics around these phases.
timmitchell.net/what-is-etl


DataOps

 [return to top]

DataOps Manifesto

Through firsthand experience working with data across organizations, tools, and industries a group of professionals have uncovered a better way to develop and deliver analytics through an emerging practice called DataOps.
dataopsmanifesto.org/dataops-manifesto.html

Dolt for Data Version Control

Dolt is the true Git for data experience in a SQL database, providing version control for schema and cell-wise for data, all optimized for collaboration. With Dolt, you can view a human-readable diff of the data you received last time versus the data you received this time. You can easily see updates you did not expect and fix the problem before you deploy the new data.
towardsdatascience.com

Monte Carlo for Data Observability

Monte Carlo is on a mission to accelerate the world’s adoption of data by minimizing data downtime. The platform brings full observability to data teams by monitoring, alerting, resolving, and preventing data quality issues, helping them achieve data reliability.
www.montecarlodata.com


Data Science/Machine Learning

 [return to top]

Best Practices for ML Engineering

This guide is intended to help those with a basic knowledge of machine learning get the benefit of best practices in machine learning. If you have taken a class in machine learning, built, or worked on a machine-learned model, then you have the necessary background to read this document.
martin.zinkevich.org/rules_of_ml.pdf

Data Mining in Python: A Guide

Data mining is the process of discovering predictive information from the analysis of large databases. This guide provides an example-filled introduction to data mining using Python, one of the most widely used data mining tools - from cleaning and data organization to applying machine learning algorithms.
springboard.com/blog/data-mining-python-tutorial

Efficient Python Tricks and Tools for Data Scientists

Interactive web book written by Khuyen Tran that teaches readers efficient methods of coding in Python to solve common problems in data science.
khuyentran1401.github.io/Efficient_Python_tricks_and_tools_for_data_scientists/README.html

Foundations of Machine Learning

This training course offered through Bloomberg covers a wide variety of topics in machine learning and statistical modeling. The primary goal of the class is to help participants gain a deep understanding of the concepts, techniques and mathematical frameworks used by experts in machine learning. It is designed to make valuable machine learning skills more accessible to individuals with a strong math background, including software developers, experimental scientists, engineers, and financial professionals.
bloomberg.github.io/foml

Handy Python Libraries for Formatting and Cleaning Data

Data scientists spend a lot of time cleaning messy data. This is a list of Python libraries that help make data more orderly and legible - from styling DataFrames to anonymizing datasets.
blog.modeanalytics.com/python-data-cleaning-libraries

Kaggle

Offers a means of learning data science through both public and private competitions.
kaggle.com

KDnuggets

This website looks like its design hasn’t changed since the 90s, but it is home to lots of great content on business analytics, big data, data mining, and data science.
kdnuggets.com

R or Python for Data Science?

This is a nice blog post on opendatascience.com that digs into the differences/advantages of using either R or Python for performing data science tasks.
opendatascience.com/blog/r-or-python-for-data-science

RegexOne

Regular expressions are extremely useful in extracting information from text such as code, log files, spreadsheets, or even documents. This site offers an interactive tutorial and practice exercises to help you learn them.
regexone.com

rOpenSci

Open source R packages that allow access to data repositories and provide programmatic access to a variety of scientific data and other real-time metrics of scholarly impact.
ropensci.org

TensorFlow Playground

TensorFlow is a machine learning library that underlies many of Google’s products. With this playground site, you can tinker with a neural network right in your browser.
playground.tensorflow.org


Datasets

 [return to top]

Appen AI Resource Center

Collection of free, downloadable, and categorized datasets that have been created and curated for teams working on world-class AI applications.
appen.com/resources/datasets

awesome-public-datasets

This GitHub repo contains a list of a topic-centric public data sources in high quality. They are collected and tidied from blogs, answers, and user responses.
github.com/awesomedata/awesome-public-datasets

AWS Registry of Open Data

This registry exists to help people discover and share datasets that are publicly available via AWS resources.
registry.opendata.aws

Data.World: The Social Network for Data People

Discover and share cool data, connect with interesting people, and work together to solve problems faster. Users can find and use a vast array of high-quality open data.
data.world

Gapminder

Gapminder fights devastating misconceptions and promotes a fact-based worldview everyone can understand. Many of their datasets around how the world lives have been many publicly available for download.
www.gapminder.org/data

Free tool for searching over 25 million publicly available datasets. The search tool includes filters to limit results based on their license (free or paid), format (csv, images, etc), and update time. The results also include descriptions of the dataset’s contents as well as author citations.
datasetsearch.research.google.com

Google’s My Activity Page

This portal reveals everything Google knows about you - every search you’ve made, the apps you’ve used, the videos you’ve watched, and everything in between. Visit to see how your data is being collected, modify activity settings, and delete data that you prefer not retained.
myactivity.google.com


Website Tools

 [return to top]

BuiltWith

Enter the URL of a website and quickly find a list of the technologies used to support that site including email services, nameserver providers, JavaScript libraries, widgets, server information, and more.
builtwith.com

Font Awesome

Font Awesome makes it easy to add vector icons and social logos to your website.
fontawesome.com

Google Design: Resizer

An interactive viewer to see and test how digital products respond to material design breakpoints across desktop, mobile, and tablet.
design.google.com/resizer

How To Use GitHub Pages To Make Websites

Step-by-step tutorial to getting started with building a website hosted on Github Pages.
readwrite.com/github-pages

How to Host Your Static Site with HTTPS on GitHub Pages and CloudFlare

While GitHub offers free static website hosting and custom domain support, it is currently not possible to configure HTTPS for custom domains directly through GitHub Pages. This is where CloudFlare comes in.
developer.ubuntu.com/static-site-https-github-pages-and-cloudflare/

Lighthouse

Lighthouse is an open-source, automated tool for improving the quality of web pages. You can run it against any web page, public or requiring authentication. It has audits for performance, accessibility, progressive web apps, and more.
developers.google.com/web/tools/lighthouse

Mobile Website Speed Testing Tool

Another great Google product. Find out how well your site works across mobile and desktop devices by simply entering the URL.
testmysite.thinkwithgoogle.com

Static Site Generators

A leaderboard of the top open-source static site generators based on Github stars.
staticgen.com

Website Grader

Free online tool that grades any website against key metrics such as performance, mobile readiness, SEO, and security.
website.grader.com

Who Is Hosting This

Allows a user to simply enter the domain name of any site and instantly uncover the identity of the company that is hosting the site.
whoishostingthis.com