Visualizing the orders

The company management already asked you for the first report: monthly level of orders! You are itching to prove your skills and analyze the new dataset, but you notice that some data preparation is still needed as we don't even have a proper date field in our dataset! Let's calculate it before we provide our colleagues with the report they need.

We do not recommend doing so, but if you lost progress you can load the solution workbook of the previous exercise 1_1_setting_up_the_data_model_solution.twbx from the Workbooks folder.