In the Intermediate session, you will be exposed to the load script where we load our data into Qlik Sense.
And also did some of the basic transformation.
Once we have all the tables transformed and saved into qvd formats, we will load all the qvds back into load script.
And finally, we will load the data model into our final application, which is the dashboard layer.
Next, we will go into the Sheets to expose ourselves with visualization expressions, how to create buttons and also the idea of having master dimension, master expressions and master visualizations in the dashboard.
For the Advanced session, we will guide you on how to build our load scripts with Master Calendar and Fiscal Calendar, YTD tables and so on.
Once the load script is completed, we will move on to the sheets to know how do we apply the flags created in the load script into the visualization expression.
A more simplified way to create MTD/YTD logic will be introduced at this session as well.
Functions such as Rank and AGGR are also introduced in the advanced session.
Together with all the knowledge we learned so far, we will create 100% chart which will be an interesting chart to showcase the distribution of the specific dimensions that we are interested of.
Thanks for enrolling and Happy Qliking!