Ana Maria Bisbe York
amby.net
Business Intelligence Consultant and Trainer.
Microsoft Data Platform MVP. Microsoft Partner in Power BI. LinkedIn Learning Trainer.
Speaker at Power Platform and SQL Saturdays events in Europe, USA, and LATAM.
SQLBits 2020
Lets play with a date field & Time Intelligence 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
In analytical models, the evolution of data over time is critical to identify patterns and anomalies in order to detect and prevent present and future problems. In Power BI, the Time Intelligence questions are handled by Power Query, M, DAX, tabular modeling and several visualizations integrated option.
This session aims to cover how to deal with Date values in the Query Editor, identifying format issues and guarantying data quality using parameters, variables, and functions.
The session will cover how to design the Tabular Model and visualization tasks taking into account scenarios and modeling reports that are commonly presented.