Below is a list of cool Realtime VFX Tutorials and articles, some by me some by others.
General Breakdowns / Techniques:
Stylized Fire Blast by Nicola, Super Rich Info
Driving Niagara with Flowmaps and Baked Fluidsim Data
NPR(Anime) Rendering Techniques
UE4 Grass & Foliage Type Setup
Rapid Realtime VFX Iterations using Houdini
Dynamic Snow using Runtime Virtual Texturing
Niagara Force/Noise based Alien Particle System
Mesh Creation:
How to make emission planes from fractured mesh
How to make sword swipe / soulcoaster / curvemesh
Materials & Shaders:
Texturing:
Get the most out of Noise in UE4
Visual Reference
Niagara: