
Let's plan the complex P&L
Finish P&L measures by finalizing expressions for discount percent, mapping to the PNL row, and applying set analysis with gross sales, expenses to sales, and net profit margin.
Prepare load layers for department, scenario, and organization dimensions, build hierarchical organization data, and store the dimension tables for use in a Qlik data model.
Create a calendar load and an accumulation calendar for the pnl app, generating date fields and year-to-date logic with filters and data loading.
Finish styling the PNL report in the PNL app by creating and applying styles (hero, header, bold, yellow, blue, green, red), mapping fields, and setting current and year-to-date measure groups.
Celebrate completing Qlik finance course part 2 by applying new techniques to real-life projects, following a system approach and the three-layer architecture.
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 2 of the course. Please, finish part 1, before sign up.
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.