Freelance Business Intelligence Consultant with Microsoft technology. Author of Curso Power BI (Spanish) Microsoft Partner in Power BI. Data Platform MVP LinkedIn Learning Trainer Lic. in Economic Cybernetics with Master in Economics, Moscow; 1988. Speaker at international events and Summits


To build analytical models, we need to start by extracting, transforming, cleaning, preparing and loading the data. This session analyzes a set of scenarios that may happen during the ETL step using the Power Query in Power BI.
Date fields play an important role in virtually all cases of advanced analytics. The "problem & solution" style session can be very useful given the large number and variety of scenarios that may arise
This short session will cover some scenarios of cleansing data in Power Query using M, Python, or both languages.