What is DAX?
According to Google, the data analysis process consists of six phases. In the first phase, we identify the problem, generating a series of questions that will likely be answered through our analysis. In the second phase, we prepare the data we will analyze, determining what we will measure, what factors we need to consider, and where the data is located. The third phase involves data processing, where we make the data useful. This is essentially the transformation phase in the ETL process. The fourth phase is the analysis phase, where we start creating all the measures and indicators that will help us answer the questions we posed in the first phase. The fifth phase is the sharing phase, where we create our reports by choosing the best visual object for each of the indicators we will present. Lastly, there is the acting phase. In this sixth phase, we provide recommendations based on the analysis we have conducted on our model.