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.