Tilemaps are a invaluable tool for 2d game design where individual wall/floor segments and other level features need to be repeated.
Note: Some of the tech demos mentioned in the video are now accessible in the Package Manager. The GitHub repository is only useful for the most up to date Unity packages.
Making a Tileset in Photoshop