Defining approach and solution architecture

For Jim to define the solution and the data architecture, he needs access to the database system. He approaches Jean Trenary for getting access to the data warehouse and gets the access.

Once Jim gets the access to the system, he starts exploring every table related to sales available in the warehouse. This helps him to understand the nature of the data stored in the table and how it is linked to other tables in the warehouse.

He lists the dimensions and fact tables in the data warehouse which he would need to cater to all the sales related requirements.

Dimension tables are as follows:

Table Name

Description

DimCustomer

This table stores all customer related data. The customer data ...

Get Implementing Qlik Sense now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.