In this chapter, we will create a sales analysis application to explore and analyze the data model that we created in Chapter 2, Loading Data in Qlik Sense.
While developing the application, we will apply the Dashboard, Analysis, Reporting (DAR) methodology that we explained in Chapter 4, Working with Application Structures.
We will create create four sheets, each with a very specific purpose, as follows:
- The dashboard sheet will give us a quick overview of the key performance indicators of sales amounts, average discount percentages, and the number of orders. It will also show us the sales share by category, the sales by top 10 customers, and a map showing the sales statistics for each country.
- The customer analysis sheet will help our users to understand how the sales are performing based on the customer, and which customers are the best ones, creating a combination chart for Pareto analysis (80/20).
- The product analysis sheet will help our users to understand how sales are performing by product, and to point out the products that are currently the best by using a scatter plot chart.
- The reporting sheet will help us to see the data in a more granular form. Using a table visualization, we will be able to see the detailed data by order transaction.
The chapter is organized as:
- Creating the dashboard sheet
- Creating the analysis sheet
- Creating the report sheet