The first training day of the
Power BI training focuses on the topics of data transformation, modelling and visualization. There will be an introduction to the ETL tool Power Query and data transformation in the Power Query Editor. This connector tool enables participants to query data from Excel, merge it in Power BI and then process it.
Employees will also learn about various data models as well as relations, filters and formatting. The first training unit concludes with exercises in visualizations to enable participants to create their first reports independently.
The second training day focuses on the formula language DAX (Data Analysis eXpressions). With DAX, participants can create analytical models without extensive technical knowledge, particularly in the context of Excel and Power BI, where standard functions
and tables from applications are no longer sufficient. As Coca Cola works with extensive data resources in Excel, this topic is given particular attention. With just a few DAX commands, for example, existing tables are copied or new tables are created so that the tables can then be used as filters or additional dimensions. In addition, key figures are defined together, which can be used to make comparisons and forecasts.
