Algorithm to Compilation Co-design: An Integrated View of Neural Network Sparsity