
Indroduction to the course
In that lesson we duscuss 3 layer architecture and how we can apply it in our project
In that lesson we download the date for the cource and also create folder structure
In that lesson we download and install table inspector and qliquid table
We create extraction script for finance table
We create extraction script for master tables
Plan the next steps for the panel report in qlik finance course part 1 by loading finance tables and reference data, using account dimensions as rows, and building the pnl.
Develop and load the finance fact table by duplicating the ETL template, applying sign transformations, and creating mapping rules for accounts and account alternate.
Create a basic pnl report by loading fact and dimension finance tables, linking on the account key, and displaying a sum amount across account dimensions with a custom liquid table.
Conclude the first part of the Qlik finance course and build a basic pnl report, then invite learners to enroll in part two to continue.
Hello! I am Nikita Potapov , I am certified QlikView and Qlik Sense architector with a 9 years experience. In Qlik Finance course you will learn how to apply three layers architercture to your projects, we create ETL from Aventure works data warehouse and build P&L report: first with basic account dimensions and than with the complex measures. Also we play with styling of the report using the qliquid table.
I recommend that cource for developers and consulant:
1. With more than 6 monthes experience of scripting to fully apply concept you will learn.
2. Who understand how data modeling works in Qlik Sense
3. Anyone with high motivation, who wants to up their Qlik skills and don't scare of advanced things.
We use some advanced scripting functions, so you can learn about them in Qlik documentation and play with them apart from the course. This is part 1 of the course. So after finish, please sign up for part 2.
You need to have Qlik Sense Desktop, Qlik Sense Entreprise or Qlik Cloud installed. In the course I use Qlik Sense Desktop, but you can use it in any system even in QlikView.
I am super excited to see you on the course.