The first day of the
Power BI training focuses primarily on data transformation, modeling, and visualization. It includes an introduction to the ETL tool Power Query and data transformation in the Power Query Editor. Using this connector tool, participants are enabled to query data from Excel, merge it in Power BI, and ultimately process it.
Furthermore, employees learn about various data models as well as relationships, filters, and formatting. The first training session concludes with visualization exercises, enabling participants to independently create their first reports.
The second training day covers the formula language DAX (Data Analysis eXpressions). With DAX, participants can create analytical models—especially in the context of Excel and Power BI—without requiring extensive technical knowledge, particularly where standard application functions and tables are no longer sufficient. Since Coca-Cola works with extensive data sets in Excel, this topic is given significant attention. Using just a few DAX commands, for example, existing tables can be copied or new tables created, allowing them to be used subsequently as filters or additional dimensions. In addition, key performance indicators are defined together, which can then be used to make comparisons and forecasts.
