, creating formulas, pivot tables) and PowerBI Prior knowledge of data modelling and processing techniques for big data systems Solid understanding of BI and data solutions, including Power-pivots, cubes, and datamarts