There’s an often-quoted statistic that says that data analysts spend 80% of their time preparing data and only 20% actually analyzing it. There’s a lot that we as data engineers can do to help our analytics teams be more productive and spend less time worrying about data preparation. I’ll discuss common problems in data warehousing infrastructure from the point of view of analytics teams and suggest practical solutions.