Q-Expert Distributors, episode 6: Ready for the app
============================================================

What you build: the star schema the app loads: keys, a master calendar, facts and dimensions stored as QVDs.

Video, step-by-step manual (English and Spanish) and every download: https://qfabrica.com/real-cases.html#ep06

In this package
- data/: the files this episode reads.
- start.qep: the project as episode 5 left it. Import it with Import QEP in the top bar.
- end.qep: the project at the end of this episode, to compare with yours.
- script/: the generated script: _Main.qvs (paste it into Qlik) and the .qvs files it includes.

Set up once
- In Qlik, create a folder data connection called QXDistributors that points to the data/ folder.
  Inside data/, create Transform/_QVS (and Model/ for episode 6): the .qvs files and the QVDs go there.
- In Q-Expert, Project Settings > Source Paths maps lib://QXDistributors/ to the variable vPathRaw;
  the projects in this package already have it.
- The 14-day free trial of Q-Expert includes every feature this episode uses.

Before you model
- Open the files in Q-Explorator to see their content and quality first: https://qfabrica.com/q-explorator.html

The Q-Fábrica team
https://qfabrica.com
