Analytical Calendar The Story | The Index Page
Analytical Calendar
Introduction
In
the realm of data analytics, a calendar is very important to help us to ana2023-05-08s different periods. This is very common to be found in all the
dashboards. You might hear things like Master Calendar, As-Of Calendar, etc. Data
analysts pick the required date filters and then analyze the results in the charts
to find out the insights.
Everyone
knows very well what a calendar is and how to use it. The meanings of day,
week, month, quarter and year seem intuitive. However, in fact, when dealing
with a calendar in analytics, there is a lot of confusion and indeed, a lot of
considerations are required.
This
includes both for developer to develop the calendar and the calculation
mechanism as well as for data analyst to use the calendar. For example, how to
deal with week. A week should be 7 days but in a year, there are only 365 or
366 days, which is not a multiple of 7. How to deal with the cross-year week? These are questions to both developer and data analysts.
The coming sections discuss the riddles within a calendar and aims at providing an in-depth understanding and concepts on how date and calendar work. Based on all the findings, it concludes some essential elements on how to design an analytical calendar. And further, it works out a real solution with Qlik as an example.
The following sections cover the concepts, design principles and solutions in action. It creates a new way of data analytics.
It provides basic understanding of a calendar and date like date component, date uniqueness, date granularity and date hierarchy. It reveals how complicated date is.
It describes how date range works in a calendar. And this summarizes the different date range representations. They are all commonly used in everyday life.
It describes how date comparison works. It has comparison unit and custom date.
It illustrates how complicated the date conversion and calculation are. And there is a lot of considerations to apply all the date scenarios.
It provides more in-depth discussion on how to consider and standardize the date representation and calendar design.
It introduces the analytical calendar design that consists of analysis calendar and comparison calendar
It provides the example how the analytical calendar design can be applied into Qlik associative data model and how it works out the front-end for data analysts to use it easily with all-perspective of date for analysis and comparison
No comments:
Post a Comment